Workout

Data Modeling

Weekly practice exercise is posted every Monday.

Let’s create your free account

OR

By continuing, you accept our Enterprise DNA Terms & Conditions , our Privacy & Cookie Policy and that your data is stored.

If you have an account Login here

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.

What our Students Say
Your Instructor

Brian Julius

Over 30 years of experience performing complex analysis of economic and business operations data. Specialty in the application of data analytics to improve the effectiveness and efficiency of public sector processes. Particular interests in addressing DAX-related challenges and applying innovative techniques to improve the Power BI user experience. 

Frequently Asked

Questions

add

What’s the difference between a free account and a paid plan?

add

Do I need to know anything about data science or data analytics to get started with Enterprise DNA?

add

How will I be charged?

add

Can I get an invoice for my company?

add

Are refunds available?

add

Will AI take over the world and make data skills worthless?

Get full access to unparalleled

training & skill-building Workouts

power-bi-custom-visuals

FOR INDIVIDUALS

Enterprise DNA

For Individuals

Empowering the most valuable data analysts to expand their analytical thinking and insight generation possibilities.

Learn More chevron_right

FOR BUSINESS

Enterprise DNA

For Business

Training, tools, and guidance to unify and upskill the data analysts in your workplace.

Learn More chevron_right
power-bi-custom-visuals
Latest Workouts