Weekly practice exercise is posted every Monday.
Data Modelling is the “make or break” stage of Power BI development. If you build a strong dimensional data model (usually a star schema), your DAX will be much simpler, more performant and will produce accurate results. Conversely, get your data model wrong and even expert DAX skills may not be sufficient to overcome the problems created. In addition, good data models are easier and cheaper to maintain and document.
Greg Philps is a senior BI consultant to the Canadian government, a long-time Enterprise DNA expert, a multi-time eDNA Challenge winner, an internationally recognized expert in the use of Deneb, and the author of multiple eDNA courses including the only current full-length course available on the Deneb visual.
Brian Julius is the eDNA Chief Content Officer and the Project Manager for the Workout Center initiative. He is also a long time Enterprise DNA expert, a four-time eDNA Challenge winner, eDNA YouTube channel contributor, and the author of a popular daily LinkedIn feed covering Power BI (including data modeling), R, data analysis and career tips.
Data modeling workouts will be posted weekly – We will post a new workout every Monday before midnight UTC. We will post our solution on the following Sunday.
How to submit your solution
Each workout will provide instructions as to what you will need to submit. Depending on the nature of the workout, it likely will be some combination of a screenshot of your data model, your PBIX file and/or Power Query or DAX code.
What our Students Say
What’s the difference between a free account and a paid plan?
Do I need to know anything about data science or data analytics to get started with Enterprise DNA?
How will I be charged?
Can I get an invoice for my company?
Are refunds available?
Will AI take over the world and make data skills worthless?
Get full access to unparalleled
training & skill-building Workouts
Empowering the most valuable data analysts to expand their analytical thinking and insight generation possibilities.Learn More
Training, tools, and guidance to unify and upskill the data analysts in your workplace.Learn More