Sign-up now and get instant access
Leave a comment
Customized training to master new skills and grow your business.
Beginner to advanced classes taught by Microsoft MVPs and Authors.
In-depth boot camps take you from a novice to mastery in less than a week.
Season Learning Pass
Get access to our very best training offerings for successful up-skilling.
Stream Pro Plus
Combine On-Demand Learning platform with face-to-face Virtual Mentoring.
A new horizon in technical exam preparation
Quick references for when you need a little guidance.
Summaries developed in conjunction with our Learn with the Nerds sessions.
Digital goodies - code samples, student files, and other must have files.
Stay up-to-date on all things Power BI, Power Apps, Microsoft 365 and Azure.
Earn money by driving sales through the Pragmatic Works' Training Affiliate Program.
It's time to address your client's training needs.
Learn how to get into IT with free training and mentorship.
Discover the faces behind our success: Meet our dedicated team
How can we help? Connect with Our Team Today!
Find all the information you’re looking for. We’re happy to help.
Do your Power BI models suffer from “ambiguous relationships”? Have you expanded your vocabulary while encountering errors trying to relate multiple tables in a data model?
Data modeling is an essential skill in Power BI design and hard problems require creative solutions. In a recent webinar Lead Consultant Paul Turley identifies common challenges and demonstrates modeling techniques to resolve them.
Over the past five or so years, we’ve seen a surge in self-service BI. This means that the business intelligence tools are no longer only in the hands of IT, developers, and analysts, but also in the hands of business users. Sure, importing data and throwing it into a chart is easy to do in many of these tools including Power BI, Excel, and Power Query, but is this type of reporting enough?
For the casual business user these tools promote the idea of importing data, mashing it together into a single flat table like in Excel and maybe bring this into a spreadsheet where we can filter, group and aggregate columns; this is referred to this as flat spreadsheet based reporting.
This reporting has its place but when dealing with a large volume of data and more complex data structures, this will not meet all your business needs. This is where the dimensional model comes in and this is the first key to understand in your data modeling journey. Dimensional modeling is the go-to modeling approach 95% of the time for business intelligence data.
This demo heavy webinar will teach you all you need to know about building a data model with examples. Paul will discuss:
So, if you want to learn about data modeling in Power BI, this webinar is for you. Watch the complete presentation below. To view Paul’s slides, click here.
If you have more questions about data modeling or about Power BI, we are here to help. With our Power BI Remote Services, we can extend your team to build the reports and dashboards you need. Whether through part-time developers, full-time staff augmentation, architecture advisory, or our fully managed services, we can centralize your Power BI management, removing the burden from your team so you can focus on growing your business. Click below to learn more.
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.