Why Participate

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.

Workout Leaders

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.

Schedule

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.