Aymen Elloumi

💡Power BI [Fabric] tip of the day ➡️Monitoring Power BI/ Fabric Service with Notebook and Lakehouse! Thanks Gilbert Quevauvilliers for the nice Blog regarding Monitoring 😉 🔗Link: https://lnkd.in/dyTD2VXT ➡️After playing around with the data I got a really nice first draft 🤩 #Microsoft #Fabric #Monitoring #Admin

35

7 commentaires

If you've heard about Semantic Models & wondered "Is this a new feature in Power BI?", Don't worry. It's just a bit of rebranding. Ever since I started learning Microsoft Fabric, I came the term Semantic Models In Power BI. Since I hadn't been in touch with Power BI for some time, I thought it was a brand new feature introduced by the platform. It felt like the platform left me behind. However, it's the same as the data model you'd create. 𝗪𝗵𝗮𝘁 𝗶𝘀 𝗮 𝗦𝗲𝗺𝗮𝗻𝘁𝗶𝗰 𝗠𝗼𝗱𝗲𝗹 ? A semantic model in Power BI is essentially a sophisticated layer that sits between your raw data and the stunning reports you generate. It includes all the necessary transformations, calculations, and relationships, acting as the single source of truth for your reporting needs. Unlike traditional data models that primarily focus on structural integrity and data storage, semantic models are about making data comprehensible and usable for end-users. 𝗪𝗵𝘆 "𝗦𝗲𝗺𝗮𝗻𝘁𝗶𝗰 𝗠𝗼𝗱𝗲𝗹" 𝗢𝘃𝗲𝗿 "𝗗𝗮𝘁𝗮 𝗠𝗼𝗱𝗲𝗹𝘀"? The shift from data models to semantic models in Power BI marks a shift towards more user-friendly data handling. Semantic models not only manage data interactions but also simplify them, enabling both technical & non-technical users to focus on deriving insights rather than navigating complex data relationships. 𝗞𝗲𝘆 𝗙𝗲𝗮𝘁𝘂𝗿𝗲𝘀 𝗼𝗳 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗦𝗲𝗺𝗮𝗻𝘁𝗶𝗰 𝗠𝗼𝗱𝗲𝗹𝘀: → 𝗗𝗮𝘁𝗮 𝗰𝗼𝗻𝗻𝗲𝗰𝘁𝗶𝗼𝗻𝘀 to one or more data sources, either imported, through DirectQuery, or as part of a composite model. → 𝗧𝗿𝗮𝗻𝘀𝗳𝗼𝗿𝗺𝗮𝘁𝗶𝗼𝗻𝘀 that clean and prepare the data for reporting. → 𝗗𝗲𝗳𝗶𝗻𝗲𝗱 𝗰𝗮𝗹𝗰𝘂𝗹𝗮𝘁𝗶𝗼𝗻𝘀 based on business rules to ensure consistent reports built from the semantic model. → 𝗗𝗲𝗳𝗶𝗻𝗲𝗱 𝗿𝗲𝗹𝗮𝘁𝗶𝗼𝗻𝘀𝗵𝗶𝗽𝘀 between tables allow users to focus on designing reports without knowing the underlying database structures and data models beforehand. 𝗧𝗵𝗲 𝟯 𝗦𝗲𝗺𝗮𝗻𝘁𝗶𝗰 𝗠𝗼𝗱𝗲𝗹 𝗠𝗼𝗱𝗲𝘀: → 𝗜𝗺𝗽𝗼𝗿𝘁 𝗠𝗼𝗱𝗲: Data is fully loaded into Power BI, optimized for quick access and complex querying. → 𝗗𝗶𝗿𝗲𝗰𝘁𝗤𝘂𝗲𝗿𝘆 𝗠𝗼𝗱𝗲: Maintains a live connection to source data, ideal for up-to-the-minute reporting. → 𝗖𝗼𝗺𝗽𝗼𝘀𝗶𝘁𝗲 𝗠𝗼𝗱𝗲: Combines the benefits of both import and DirectQuery, providing flexibility depending on query requirements. I learned one important lesson from this - KEEP IN TOUCH WITH THE TOOL! #datamodel #semanticmodel #powerbi #dataanalytics #dataanalyst #dataanalysis

11

2 commentaires

Write both DG & DQ CDMP Specialist exams after 1 week of training and become a Fully Certified CDMP Professional. Join both courses and get a combo discount price of $70! Data Governance for Certification - Preparation for the CDMP Specialist exams Cost: R9,640 incl. Vat / $760  Date: 3 - 5 June 2024 Duration: 3 days - 9 am to 4 pm SAST Format: Facilitated by a CDMP Master Includes: Case Study and working templates Data Quality for Certification - Preparation for the CDMP Specialist exams Cost: R6,760 incl. Vat / $540  Date: 6 - 7 June 2024 Duration: 2 days - 9 am to 4 pm SAST Format: Facilitated by a CDMP Master Includes: Case Study and working templates Don't miss out on this opportunity to complete your CDMP certification before your Fundamentals (Assosciate) expires! Comment below and the Modelware Systems team will contact you with more information. #modelwaresystems #datamanagement #datagovernance #dataquality #cdmp

42

12 commentaires

Write both DG & DQ CDMP Specialist exams after 1 week of training and become a Fully Certified CDMP Professional. Join both courses and get a combo discount price of $70! Data Governance for Certification - Preparation for the CDMP Specialist exams Cost: R9,640 incl. Vat / $760 Date: 10 - 12 June 2024 Duration: 3 days - 9 am to 4 pm SAST Format: Facilitated by a CDMP Master Includes: Case Study and working templates Data Quality for Certification - Preparation for the CDMP Specialist exams Cost: R6,760 incl. Vat / $540 Date: 13 - 14 June 2024 Duration: 2 days - 9 am to 4 pm SAST Format: Facilitated by a CDMP Master Includes: Case Study and working templates Don't miss out on this opportunity to complete your CDMP certification before your Fundamentals (Assosciate) expires! Comment below, and the Modelware Systems team will contact you with more information. #modelwaresystems #datamanagement #datagovernance #dataquality #cdmp

40

14 commentaires

How to show data in #TabularEditor2 using C# scripting together with how to filter your data by any object type and any name using #RegEx #PowerBI #Fabric #TabularEditor #data #community #dataceili As requested Paul O'Sullivan with special thanks to David L. Bojsen.. (I listen, learn and share 😊 ) https://lnkd.in/e86mh4Bt

25

1 commentaire

💡Power BI tip of the day ➡️Did you know that Power BI allows you to use dynamic format strings for measures, enabling you to adjust the formatting of data based on specific conditions or user interactions, thus enhancing your data visualizations and insights? 🔗https://lnkd.in/d9XU6dPX #PowerBI #Desktop #Visuals #Dynamic

44

2 commentaires

💡Power BI tip of the day [AI Insights] ➡️Did you know you have the possibility to analyse pictures in Power BI? 🤯It is really mindblowing if you see that you only need a URL of a picture and #PowerBI analysis the picture. ➡️The Vision feature in Power BI (Power Query) enables AI-supported analysis and recognition of visual content in images, including object recognition, text extraction and image description. ❓Did you already know this feature? #PowerBI #PowerQuery #AI #Insights

28

✴ 𝗗𝗔𝗫 𝗾𝘂𝗲𝗿𝘆 𝘃𝗶𝗲𝘄 𝗶𝗻 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜. With the DAX query view, you can employ a quick query to preview data or show summary statistics to help you better understand the data without creating visuals or writing a DAX query. #powerbi #dax #Microsoft https://lnkd.in/gFvcdNMH

61

# Quiztime How many *non-Null counts* in the column of holiday in Project Heavy Traffic Analysis *Must click your right answer* 👇👇👇 https://lnkd.in/dSQXpbZx #MicrosoftPowerBI #dataanalysis #PowerBI #datascience #dataanalyst #GenAI #machinelearning #AI #artificialintelligence #QuizTime

3

8 commentaires

There is now the possibility to get the root cause for the capacity throttling or optimization of queries or refreshes using the new "ExecutionMatrics" event in Azure Log Analytics for #PowerBI Semantic models.

15

Tabular Editor 2 is a fantastic tool for working with tabular data models at scale. We’ll explore how to use this powerful tool and how to set best practice rules that automatically flag errors. #PowerBI #TE2 #TabularEditor #DataModeling https://hubs.la/Q02FHYbf0

2

[FREE WEBINAR] Mastering Product Portfolio Analysis in #PowerBI Understand how to systematically analyze all key elements of your business environment, such as market trends, market share, competitor actions, and key performance metrics.  You will learn how product portfolio analysis enables organizations to:  ✅ Gain deep insights into market trends and dynamics. ✅ Benchmark performance against the competition. ✅ Evaluate price and revenue performance for optimized profitability. ✅ Identify potential opportunities and threats. ✅ Make informed decisions based on data-driven insights. 🔥Save your spot now: https://bit.ly/4biIYVO ———— Like what you’ve read? Click the 🔔 on our page and follow #ZebraBI; we talk about: #BusinessInsights #BusinessAnalysis #ActionableReporting #DataVisualization #DataStorytelling #WinOnReporting

31

Here's how I put backgrounds into my Power BI Themes This is a video I made in 2022, but I still use this trick for my JSON Themes links: 🔥 https://lnkd.in/dZj9b-zC 🔥 https://lnkd.in/d8snEsbp #PowerBI #BusinessIntelligence #DataAnalyst

446

26 commentaires

Highlights from the Power BI Weekly Newsletter for 19th November 2024: - Line Animation in Power BI Map Visual (Bas Dohmen) - Finding The Size Of All Of The Columns Touched By A DAX Query (Chris Webb) - Azure Maps Path Layer in Power BI (Parul Rani Sagar) - Unlocking the Power of Power BI Goals (Metrics): A Hidden Gem (Tharun kumar Ravikrindhi) Read the full issue, subscribe to the email newsletter or RSS feed 👇 https://lnkd.in/ezxT98Rr

4

🚀 Boosting Power BI Performance with DAX Optimization! 🚀 As a Power BI user, I recently tackled a challenging project: optimizing a complex Power BI report brimming with DAX measures. The initial performance was far from ideal, but with determination and the right tools, I managed to significantly improve the refresh speed. Here’s a glimpse into my process: 1️⃣ Performance Analysis: I utilized Power BI’s Performance Analyzer function to identify bottlenecks in the report. 2️⃣ In-Depth Query Inspection: By leveraging DAX Studio’s Query Plan and Server Timings functions, I was able to run and scrutinize each DAX measure individually. 3️⃣ Step-by-Step Optimization: Focusing on one measure at a time, I meticulously optimized the DAX queries, enhancing their efficiency and reducing execution time. The result? A much faster and more responsive Power BI report that delivers insights more swiftly and effectively. 💡 If you’re looking to enhance your Power BI reports, I highly recommend diving into these powerful tools. The effort is well worth it when you see the performance improvements! Below is a great video for you to get familiar with these tools. https://lnkd.in/g3MB8jsQ

1

Deprecation of AutoML in Power BI using Dataflows V1 https://lnkd.in/geNeB_CJ #PowerBI #Microsoft

17