Data Modeling

In this video, I explore the Contoso database, a fictional retail company model created by Microsoft for demo and learning purposes. Using a detailed cheat sheet, I explain its business context, technical architecture, and how its data model supports analytics. From understanding key processes like order fulfillment and sales transactions to breaking down tables, relationships, […]

Are you struggling to find a test environment for Power BI, or do you want to enhance your skills with Direct Query mode? Look no further! In my latest YouTube video, I guide you through the process of setting up your own local SQL Server, complete with a database of up to 10 million rows.