You have data, and you have Power BI.
So why can't you glean any real insights into the information? Or maybe you're dealing with a different problem: as you examine your data, you're struggling to write the formula that provides the numbers you need.
Either way, your problem is most likely with the data model.
The easiest way to create a data model in Power BI and Power Pivot is to gather the data “as is” from a data source, define relationships, and then start designing reports. But this approach raises several issues when you have too many tables, or different levels of granularity.
Benefits of a proper data model include:
We have created a three-day training course on data models, teaching you how to solve business scenarios in Power BI, Power Pivot and Analysis Services by adjusting your data model. Your DAX code becomes easier, faster and more robust.
This course introduces the basic techniques of shaping data models in Power BI, making no assumptions on previous knowledge of data modeling. If you want to use Power BI to analyze data, this course offers many real-world examples that will help you look at your reports in a different way – like experienced data modelers do. As you’ll soon see, with the correct data model, the correct answer is always a simple one!
Sign up for one of our live classroom courses below, or visit this page if you prefer to organize a course in a custom location or at your company (on-site, private training).
|Amsterdam, NL||Apr 9-11 Amsterdam|
|Seattle, WA, US||Apr 23-25 Seattle||
|Sydney, AU||Aug 7-9 Sydney||
If you learn better by reading, here is the book for you: Analyzing Data with Power BI and Power Pivot for Excel, written by our senior trainers, Marco Russo and Alberto Ferrari, and published by Microsoft Press.