Newsletter
Join our blog
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.


-1.png)
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 Classes
Private deliveries of courses for groups
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.
Cheat Sheets
Quick references for when you need a little guidance.
Prag Guides
Explore our knowledge base for quick tips on syntax, functions, and more!
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.
Nerd Guides
Summaries developed in conjunction with our Learn with the Nerds sessions.
Quickstarts
Hands-on training with expert-led collaborative development.
Private Training
Personalized approach for your specific training requirements
Hackathons
Use your own data to take your team's skills to the next level.
Virtual mentoring
Get there faster with your personal trainer.
Enablement
Comprehensive enterprise enablement training for your team.
Admin Hackathon
Tame your power platform environment.
Pragmatic Works new course, Data Modeling, is designed for individuals who are in the process of designing new databases, particularly transactional databases and data warehouse systems. This course is taught by one of our experts on data modeling, Mitchell Pearson. Here, Mitchell answers a few questions about the course:
Data modeling is important to learn so you will know about consequences that you may run into when designing both transactional systems and dimensional warehouses. For example, maybe the dimensional model doesn’t provide all the answers to questions you wanted to ask the data when you had the design in mind.
This course will specifically go through the 4 steps of dimensional modeling, so you’ll know how to avoid these problems and not have to go back and redesign the model.
This six-and-a-half-hour course will start with the basics and then dive deep into more advanced concepts by the end.
Most people struggle with defining the granularity at the start of the design phase. When you don’t design the granularity properly from the beginning, then you realize it’s not correct as you get to the next steps. This will send you back to the drawing board.
As with all Pragmatic Works courses, the Data Modeling course offers a depth that most courses do not. This course runs over 6 hours; allowing time to go into more detail and more in depth into concepts.
If data modeling is new to you or maybe you’re self-taught and need to affirm the concepts you’re implementing are correct, then this course is for you. Click below to sign up for a free trial.
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