This is the complete series of Data modeling in Power BI. In this series, you will learn complete data modeling techniques in Power BI with the strength of Power BI, introduction to data modeling, how to create calculated columns, how to optimize data models, how to create measures, how to create calculated tables, explore time-based data, how to manage your data relationship and in the end, there is a quiz to check your knowledge. 00:00 - Introduction 00:49 - Learning Objectives 01:41 - Strength of Power BI 02:07 - Practical Approach 04:42 - Adding and Removing Relationships 07:50 - What is the cardinality of Relationships? 09:09 - Cross filter Direction 10:06 - Calculated Columns 13:34 - Explaining DAX 15:50 - Optimize Data Model 17:21 - Sort Visulization data by another field 18:07 - Setting data type 18:35 - Measures in Power BI 19:11 - Sales agent Example 24:15 - Create calculated tables 26:25 - Explore time based data - Drill 29:52 - Conclusion 30:17 - Quiz - check your knowledge 30:26 - Congratulations Quiz https://kodegems.com/data-modeling-quiz/ Subscribe https://bit.ly/2Vlf7dC Power BI Desktop is a free application you install on the local computer that lets you connect to, transform, and visualize your data. This data model lets you build visuals, and collections of visuals you can share as reports, with other people inside your organization. Data Analysis Expressions (DAX) is a programming language used throughout Microsoft Power BI to create calculated columns, measures, and custom tables. It is a collection of functions, operators, and constants that can be used in a formula, or expression, to calculate and return one or more values. Data Modeling is one of the features of Power BI that is used to connect multiple data sources in the BI tool using a relationship. A relationship defines how data sources are connected and can create interactive data visualizations on multiple data sources. With this feature, you can build your own custom calculations on the existing tables and these columns can be directly presented into Power BI visualizations. This allows businesses to define new metrics and perform custom calculations for those metrics. My Website https://kodegems.com/ Checkout My Udemy Profile https://www.udemy.com/user/ameen-khan-30/ Udemy Data Modeling Course https://www.udemy.com/course/data-modeling-power-bi/?referralCode=9AC5DA7B9F9423CE686F How To Write Most Successful Blogs Using WordPress https://kodegems.com/successful-blogs-using-wordpress/ How To Get Upwork Profile Approved In Less Than 12 Hours – 2019 https://kodegems.com/upwork-profile-approved-12-hours/ Complete folder consisting of the dataset, files, and a thumbnail image ------------- https://kodegems.com/get-data-excel-sheet/ Desktop Access Database Errors https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-access-database-errors Slides for Presentation https://slides.com/kodegems/data-modeling Contact kodegems@gmail.com https://pk.linkedin.com/in/ameen-khan UPWORK Profile https://www.upwork.com/freelancers/~017ad81d7e69e09700 #PowerBIdesktop #DataModeling #PowerBI