Newsletter
Join our blog
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.
Start with the FREE community plan and get your lifetime access to 20+ courses. Get Instant Access Now!
Need help? Talk to an expert: (904) 638-5743
Private Training
Customized training to master new skills and grow your business.
On-Demand Learning
Beginner to advanced classes taught by Microsoft MVPs and Authors.
Bootcamps
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.
Certification Training
Prepare and ace your next certification with CertXP.
Private Training
Cheat Sheets
Quick references for when you need a little guidance.
Nerd Guides
Summaries developed in conjunction with our Learn with the Nerds sessions.
Downloads
Digital goodies - code samples, student files, and other must have files.
Blog
Stay up-to-date on all things Power BI, Power Apps, Microsoft 365 and Azure.
Community Discord Server
Start here for technology questions to get answers from the community.
Career Guides
Breaking into the field? Let these guides help get you started with a plan.
Affiliate Program
Earn money by driving sales through the Pragmatic Works' Training Affiliate Program.
Reseller Partner
It's time to address your client's training needs.
Foundation
Learn how to get into IT with free training and mentorship.
Management Team
Discover the faces behind our success: Meet our dedicated team
Contact Us
How can we help? Connect with Our Team Today!
FAQs
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.
ABOUT THE AUTHOR
Free Trial
private training
Newsletter
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.
Leave a comment