Mastering USERELATIONSHIP() in DAX: A Deep, Practical, and Engaging Guide
How to unlock alternate relationships and take full control of your data model’s behavior Power BI’s data model is built on relationships—those invisible highways that let filters flow from one table to another. Most of the time, the model’s active relationship does exactly what you need. But real-world data is messy, multi‑dimensional, and full of […]
Continue readingWhy DAX Exists: Measures as Templates and Windows as Context
Do you struggle with DAX? If so, you’re not alone. The hardest part with DAX isn’t the syntax. It’s conceptualizing it mentally. What does “filter context” really mean? Why does a measure give different results in different visuals? When people first encounter DAX, they often ask: “Why do we need a whole new formula language? […]
Continue readingData Sources
Helpful Data SourcesUse resources (below) to find datasets or data sources. The plan is to update this whenever I come across new sources. Be sure to check back or bookmark the page.Please Note: Use these data sources at your own risk. You should verify the sources. I took every measure to include data sources that […]
Continue readingCreate Stock Charts in Two Lines of Code
Creating stock charts requires expensive software, or at least it used to. Now, you can simply create it right from a programming languages. Even better, you can do it all in two lines of code. Nice! What’s the Catch? There really isn’t a catch. Of course, if you are expecting these charts to have all […]
Continue readingGrasping Loc and iLoc in Pandas
Are you struggling with loc[] and iloc[] in Pandas? If so, you are in the right place. Read about grasping loc[] and iloc[].
Continue readingWhat Skills Do You Need for Data Analysis?
You know already that data is everywhere. But do you know how to use it? You’ll learn about a resource that will help you learn.
Continue readingThe Four Core DAX Measures
When I first started working with Power BI, I often heard that you could get by with just four core DAX measures: Total Sales, Total Cost, Total Profit, and Profit Margin. At the time, that advice felt empowering—keep it simple and you’ll cover most reporting needs. But as I gained experience, I realized that framing is […]
Continue readingCreate Lookup Tables from Fact Tables Using Merge in Power BI
When analyzing data, analysts should adhere to best practices. Once such best practice is to use a star schema for the data. At its basic level, a star schema contains one or more fact tables, and several lookup tables. But data often doesn’t come to the analyst as a star schema, which means the analyst […]
Continue readingHow to Get Familiar with Your Data
Let’s face it. Looking at data sometimes can be a nightmare. It never seems to conform to the neatly laid out samples from training modules. Often, the data you obtain is a scattered mess. How do you make sense of it all? This article will help learn how to get familiar with your data.The variety […]
Continue readingWhy Data Analysts Need a Data Transformation Process
Do you know what clean data looks like? Learn why data analysts need a data transformation process.
Continue reading