Mastering Dax And Data Models In Power Bi Desktop
Date: 10 June 2022 | Posted by: voska89
Last updated 5/2020
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.42 GB | Duration: 5h 45m
Build your foundation for Data Modelling, Relationhsip, DAX language in Power BI
What you'll learn
Building foundation about Data Models, Relationships and DAX formulas in Power BI
Various foundational concepts of Data Models and relationship not covered in any other course
Normalized and de-normalized datasets – advantages and difference
Three fundamentals rules for normalizing your dataset for better performance
Star Schema, Snowflakes Schema, Top Down schema for Data Models
One to Many, Many to One, Many to One relationship
Simple and easy to understand approach explaining complex concepts of Power BI DAX
DAX Studio, DAX Variables, Time intelligence and other complex DAX formulas
Requirements
Person should know Power BI Query editor – how to import and transform data inside Power BI
This course is next step after completing my Power BI Query Editor course
Person is keen to learn more concepts about Power BI DAX
Ensure that you have latest version of Power BI Desktop installed
Description
**** Life time access to course materials and practice activities. Money back guarantee ****If you are planning to get started with Power BI and your data analytics journey it is very important that you follow a proper path to learn various concepts about data analytics.Gathering the data- Perform your Extract > Transform >В Load (ETL) activities.Model your data - Normalizing your data is one of the critical stepRelationship between data tables - To understand the flow of informationDAX - Perform your data crunching and analysisVisual analytics - Not just numbers and but pictorial presentationI have covered ETL activities in my course titled - Power Bi Query Editor - Master Data Transformation. It have more than 6+ hours video content explaining all the concepts related to Power Query and M Language with the help of real world datasets.Once you have completed above course you must move on to next step for Data Modelling,В Relationships and DAX.Currently various courses at Udemy will explain only DAX and will cover data modelling & relationship only briefly. However, structuring data properly is essential to achieving good performance in your reports and to maintaining a low level of complexity in your DAX formulas.The easiest way to create a data model in Power BI is to gather the data "as is" from a data source, define relationships, and then start designing reports. But this approach raises several issues when you have too many tables, or different levels of granularity. This course will explain in detail how you can create appropriate data models by applying fundamental rules of normalizing your data. For person starting with DAX it is little challenging as he may need to visualize in my mind what result he would get from the DAX formula he is writing. This can be confusing, so I have created this course which you will give simple and easy to understand explanation about using various DAX formulas. This course will guide you to deep understanding about various concepts of DAX like filter context, row context, evaluation context, Table or scalar DAX functions, Iterator DAX functions, Calculated Measures, Calculated Columns, etc.
Overview
Section 1: Introduction
Lecture 1 Introduction to Power BI and Its components
Lecture 2 Power BI desktop - Download & Install. Learn about desktop layout
Lecture 3 Loading of data in Power BI desktop using Query Editor and separate course
Lecture 4 Headsup about the course material
Section 2: Data Modelling
Lecture 5 Data Modelling mindset - Think in multiple tables
Lecture 6 Keys in Tables - Primary Key and Foreign Key
Lecture 7 Introduction to Normalisation of Datasets
Lecture 8 Rule # 1 : First Normal Form - single value and not repeating groups
Lecture 9 Rule # 2 : Second Normal Form - composite primary key
Lecture 10 Rule # 3 : Third Normal Form - dependency between non-key fields
Lecture 11 How to normalize the a dummy dataset by applying normalization rules
Lecture 12 Recap - Three Normalisation rules
Lecture 13 Table types - Data / Fact table and Lookup / Dimension Table
Lecture 14 Relationship Cardinality an introduction
Lecture 15 One to Many relationship
Lecture 16 Many to Many relationship
Lecture 17 One to One relationship
Lecture 18 Relationship cardinality recap
Lecture 19 Relationship in Power BI - Active / In-active, one / both way filter propagation
Lecture 20 Diagram view : Top Down, Star Schema, Snow Flakes - managing table presentation
Section 3: Preparing your data for Dashboards
Lecture 21 Tables related options - Table view, Rename, Hide / Delete
Lecture 22 Columns related - Width, Rename, Sort / Sort by, Hide / Delete, Filters, Groups
Lecture 23 Data Types valid inside Power BI Desktop
Lecture 24 Formatting data inside a column
Lecture 25 How to categorize data inside Power BI Desktop
Lecture 26 How to apply default summarization to a column inside Power BI Desktop
Lecture 27 How to mark a table as Date Table inside Power BI Desktop and why is it required
Lecture 28 How to import Power Pivot data model from Excel into Power BI
Section 4: DAX fundamentals - Power of Power BI desktop
Lecture 29 An introduction to DAX language fundamentals
Lecture 30 Data Types, DAX Operators and DAX Syntax
Lecture 31 DAX Functions list by categories - Table and Scalar values
Lecture 32 Calculated in Power Bi
Lecture 33 Calculated Measures in Power BI
Lecture 34 Calculated Columns vs Calculated Measure
Lecture 35 Filter Context and Row Context
Lecture 36 Golden rules of Measures and other important things
Section 5: Basic DAX function examples
Lecture 37 Introduction to Common DAX functions
Lecture 38 Related and Related Table function
Lecture 39 Date and Time functions in DAX
Lecture 40 Fundamental Math Operation using DAX functions and Operators
Lecture 41 Rounding off numbers inside Power BI
Lecture 42 Statistical DAX Functions
Lecture 43 DISTINCTCOUNT function in DAX to count unique customers, etc.
Lecture 44 Text functions
Lecture 45 SWITCH function best alternative to nested IF functions
Section 6: CALCULATE - boss of DAX functions and functions supporting it.
Lecture 46 Introduction to CALCULATE function in DAX
Lecture 47 CALCULATE syntax explanation
Lecture 48 Examples using CALCULATE function
Lecture 49 FILTER function introduction to syntax, how it works and when to use it.
Lecture 50 Using FILTER function in filter argument of CALCULATE
Lecture 51 Context Transition using CALCULATE and FILTER function
Lecture 52 ALL, ALLEXCEPT and ALLSELECTED function inside DAX to remove filter context
Lecture 53 ALL and ALLEXCEPT function case study - single table
Lecture 54 ALL and ALLEXCEPT function case study - multiple tables
Lecture 55 ALLSELECTED - remove initial filter context and keep filter context selectively
Lecture 56 CALCULATE, FILTER, ALL - differences and similarities while using these function
Lecture 57 Bonus - Discount on my other courses
Students who have completed my Power BI Query editor course and want to learn now more about DAX,If you want to prepare for Power BI certifications from Microsoft,For all those who want to automate management reporting and wow their stakeholders.,Perform your data analysis quickly using DAX
Homepage
https://www.udemy.com/course/power-bi-desktop-dax-data-modeling-relationship-training/DOWNLOAD LINK
Download ( Rapidgator )
https://rapidgator.net/file/da8dff12a1cf2885e6074835e746bbf8/tzgws.Mastering.Dax.And.Data.Models.In.Power.Bi.Desktop.part1.rar.html
https://rapidgator.net/file/6bf8d3ed0d0575780af0601fa1868e30/tzgws.Mastering.Dax.And.Data.Models.In.Power.Bi.Desktop.part2.rar.html
https://rapidgator.net/file/4b89ec2150827720eddec29aebacaed9/tzgws.Mastering.Dax.And.Data.Models.In.Power.Bi.Desktop.part3.rar.html
H4S
https://hot4share.com/6xookav9a1qz/tzgws.Mastering.Dax.And.Data.Models.In.Power.Bi.Desktop.part1.rar.html
https://hot4share.com/1q4w1q0zpvtr/tzgws.Mastering.Dax.And.Data.Models.In.Power.Bi.Desktop.part2.rar.html
https://hot4share.com/kobbn8npjpzt/tzgws.Mastering.Dax.And.Data.Models.In.Power.Bi.Desktop.part3.rar.html
Download ( NitroFlare )
https://nitro.download/view/19399D36B29DA63/tzgws.Mastering.Dax.And.Data.Models.In.Power.Bi.Desktop.part1.rar
https://nitro.download/view/E939ECA4DD86A1F/tzgws.Mastering.Dax.And.Data.Models.In.Power.Bi.Desktop.part2.rar
https://nitro.download/view/C1334F06EA90B95/tzgws.Mastering.Dax.And.Data.Models.In.Power.Bi.Desktop.part3.rar
Download (Uploadgig)
https://uploadgig.com/file/download/C9d807f68441664f/tzgws.Mastering.Dax.And.Data.Models.In.Power.Bi.Desktop.part1.rar
https://uploadgig.com/file/download/af79177b4DDc7b1b/tzgws.Mastering.Dax.And.Data.Models.In.Power.Bi.Desktop.part2.rar
https://uploadgig.com/file/download/3a273476903d5dbE/tzgws.Mastering.Dax.And.Data.Models.In.Power.Bi.Desktop.part3.rar
Links are Interchangeable - No Password - Single Extraction
See full article