Mohammed Djaballah

Mastering Power BI: Essential Interview Questions and Answers Dive into the world of Power BI with this comprehensive guide to common interview questions and expert answers. Whether you're a beginner or an experienced user, this article equips you with the knowledge and insights needed to ace your next Power BI service interview. Explore key concepts, best practices, and practical tips to showcase your proficiency and land your dream job in the dynamic field of data analysis and visualization. Pdf credit goes to respective owner Follow for more resources #data #analytics #powerbi #service

29

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 Comments

Ever tried filtering coffee without a proper funnel? In Power BI, filter direction is your funnel! Understanding table relationships & filter directions in Power BI Is crucial to avoid misleading analytics. Each relationship has a direction that determines how filters and calculations propagate through your data model Filter context passes from one table to another specified direction or between tables bidirectionally. Getting this direction right is crucial to avoid mistakes compounding across reports and dashboards, which could result in flawed decision making. 𝗙𝗼𝗿 𝗘𝘅𝗮𝗺𝗽𝗹𝗲 - - We want to extract sales for "Cat-A" products in CY2018 𝗜𝗺𝗽𝗼𝗿𝘁𝗮𝗻𝗰𝗲 𝗼𝗳 𝗥𝗲𝗹𝗮𝘁𝗶𝗼𝗻𝘀𝗵𝗶𝗽 𝗗𝗶𝗿𝗲𝗰𝘁𝗶𝗼𝗻: - Filters move from Category ⮕ Product ⮕ Sales. - Similarly, filters also move from Year ⮕ Sales - Filters apply as an AND condition, isolating sales to those meeting all specified criteria. - Selecting 'Cat-A' and 'CY2018' from the correct tables filters to sales of 11 units. 𝗜𝗺𝗽𝗮𝗰𝘁 𝗼𝗳 𝗜𝗻𝗰𝗼𝗿𝗿𝗲𝗰𝘁 𝗙𝗶𝗹𝘁𝗲𝗿 𝗗𝗶𝗿𝗲𝗰𝘁𝗶𝗼𝗻: - Incorrect settings can lead to data retrieval errors. - In case you try to filter using fields in Sales table, no data will get filtered as filter context can only flow based on table relationship and filter direction setup indicated by arrow. In summary, Mastering table relationships and filter directions Isn’t just about making your Power BI reports run correctly; It’s about ensuring that they reflect true insights And support sound decision-making. #powerbi #dataanalytics #dataanalysis #filterdirection #tablerelationship

7

Changing the SharePoint folder connection from ".Files" to ".Contents" gives you an easily navigatable option to your folder structure in SharePoint for those using SharePoint connections in #PowerBI

1

1 Comment

If you use a Mac OS, you fully understand the struggle it takes to figure out how to run Power BI and Microsoft SQL server on your operating system. For a while I couldn’t be bothered, I used DB browser to run SQL queries and was content with creating Tableau dashboards till I got super frustrated with DB browser freezing while running queries. So, of course, I needed to figure out what to do, if you’re in the same boat as I was, please see the comment section for links to YouTube tutorials from Matt Mike and other YouTube creators (I can't find them on LinkedIn yet) that were super helpful and straight forward. Software you need Parallel Desktop Azure Data Studio Docker Microsoft SQL Server To install Azure Data Studio & Docker https://lnkd.in/eKKWA_fM To install Parallel Desktop, Docker and SQL Server  https://lnkd.in/e_Zv7vhF To install Power BI via Parallels Desktop  https://lnkd.in/eYYRpizZ #dataanalyst #microsoftsqlserver #powerbi #macos

13

2 Comments

[Tip] Rank and Sort Data Based on Multiple Columns in Power BI with DAX This article describes two approaches to allow you to rank and sort data based on multiple columns in Power BI. Author: Kenneth A. Omorodion >>> https://lnkd.in/euUr28Zx #sql #sqlserver #microsoftsqlserver #mssql #mssqlserver #powerbi #dax #rank #sort

1

How does ETL work in #PowerBI with #powerquery. I created this slide for use in my Power BI training courses.

222

24 Comments

🔆 May 2024 Power BI Update ⤵️ 1️⃣ Reporting >Modern Tooltip now on by Default >Matrix Layouts >Line Updates >On-Object Interaction Updates >Publish to folders >You can now ask Copilot questions about data in your model 2️⃣ Modeling <Announcing general availability of DAX query view <Copilot to write and explain DAX queries in DAX query view updates <New Manage relationships dialog Refreshing calculated columns and calculated tables referencing <DirectQuery sources with single sign-on <Announcing general availability of model explorer and authoring calculation groups in Power BI Desktop 3️⃣ Data connectivity +Microsoft Entra ID SSO support for Oracle database +Certified connector updates +View reports in OneDrive and SharePoint with live connected semantic models 4️⃣ Service /Storytelling in PowerPoint – Image mode in the Power BI add-in for PowerPoint /Storytelling in PowerPoint – Data updated notification 5️⃣ Developers ♤ Git Integration support for Direct Lake semantic models 6️⃣ Visualizations 》Editor’s pick of the quarter 》New visuals in AppSource 》Financial Reporting Matrix by Profitbase 》Horizon Chart by Powerviz 》Sunburst Chart by Powerviz 》Stacked Bar Chart with Line by JTA #powerbi #pbi #powerbimay2024update

6

3 Comments

Preparing for the CDMP Data Modeling Specialist exams? Join Modelware Systems How to Model Data (Steve Hoberman, DMC's Masterclass) CDMP Specialist training and write your exam with confidence! Includes: Steve Hoberman Data Modelling Masterclass Training Manual Facilitated by a CDMP Master, Veronica Diesel. Date: 15 - 19 July 2024 Register now! Comment below or contact me, and I'll gladly share more information. #modelwaresystems #cdmp #cdmpspecialist #datamodeling #certification #dmbok

17

8 Comments

Learn how to create pivot tables in SQL for enhanced data analysis — Jack Chang's comprehensive guide covers all the nitty-gritty details you should be aware of.

19

Here is the source code for my recent article for those interested: https://lnkd.in/gcDJXNVJ Below is an updated function for cleaning and transforming the dataset that I used - 2008 South Sudan census data.

16

🌟 Enhancing Data Security with Power BI: Row Level Security (RLS) 🌟 In today's data-driven world, ensuring that sensitive information is only accessible to authorized users is crucial. That's where Power BI's Row Level Security (RLS) comes into play. 🔐 What is RLS? Row Level Security (RLS) allows you to control access to data at the row level in Power BI. By implementing RLS, you can ensure that users only see the data that is relevant to them, based on their roles and permissions. 🚀 Why Use RLS? ✅️Data Confidentiality: Protect sensitive information by restricting access to specific rows of data. ✅️Improved Performance: By filtering data at the source, you can enhance report performance. ✅️User-Specific Insights: Deliver personalized reports and dashboards tailored to individual users or groups. 🔍 Example Use Case: Imagine a sales dashboard where you want regional managers to see only their respective region's data. By setting up RLS, you can restrict each manager’s access to only their region's sales data, ensuring confidentiality and relevance. 💬 Have you implemented RLS in your Power BI reports? Share your experiences and tips in the comments! #powerbi #DataSecurity #BusinessIntelligence #RowLevelSecurity #DataAnalytics

1

Lately, I see a lot about using SQL over Python and have to pick one over the other... do we need to? the answer is NO.... Python and SQL go hand by hand and they have some common area... to perform at the highest performance, learn and use both.

4