Power BI for Business Intelligence (Batch-16)

Categories: Data Analyst, Power BI
Wishlist Share
Share Course
Page Link
Share On Social Media

Course Content

Power BI – Assignment Solutions

  • Assignment 01 Solution
    32:27
  • Assignment 02 Solution
    20:43
  • Assignment 03 Solution
    09:46
  • Assignment 04 Solution
    16:06

Class 01 – Introduction to Business Intelligence and Analytics | Introduction to Power BI | Power BI Installation

Class 02 – What is ETL | Life Cycle of Power BI Development | Exploring Power BI Interface | Difference between CSV and Excel files | How to connect files to Power BI | Introduction to Power Query

Class 03 – Difference between Add and Transform Columns | Types of Data Types | Text Tools: Format Text (CAPITALIZE, UPPERCASE, LOWERCASE, TRIM, CLEAN) | Merge Columns | Steps in Power Query

Class 04 – Concept of Additional Context in Data Cleaning | Text Tools (EXTRACT, TEXT BEFORE DELIMITER, TEXT AFTER DELIMITER) | Replace Values | Split Columns

Class 05 – Arithmetic Operations Using Number Tools (Multiplication, Subtraction, Addition) | Reference Query

Class 06 – Intro to M-Code | Date & TIme Tools | Appending Queries | Combining multiple files (Folder queries) | Time Series and Categorical Analysis

Class 07 – Conditional Columns

Class 08 – Append Queries | Folder Query

Class 09 – Merge Queries | Kinds of Joins | Filter Options in Queries | GroupBy | Handling Errors | Advanced Editor

Class 10 – Data Cleaning in Real World CRM (Roomi Builders Dataset)

Class 11 – Power BI Architecture | Data Modelling Basics with Data Normalization | Primary Key & Foreign Key | Fact & Dimension Tables | Cardinalities (One-to-One, One-to-Many, Many-to-One, Many-to-Many)

Class 12 – Star Schema | Reference Table

Class 13 – Star Schema vs Snowflake Schema | Galaxy Schema

Class 14 – Data Modelling & Normalization (Recap) | Data Analysis Expression (DAX) – Basic Foundation | Calculated Columns & Measures | Difference between Power Query & Calculated Columns

Class 15 – Understanding Table View in Power BI – Data Copy | Data Formatting | Data Categories | DATE & TIME Functions (YEAR, MONTH, QUARTER) | FORMAT Function

Class 16 – DATE Functions (DATEDIFF, TODAY, NOW) | TEXT Functions (LOWER, UPPER, CONCATENATE and Ampersand Sign (&))

Class 17 – TEXT Functions (SUBSTITUTE, LEFT, RIGHT, SEARCH, LEN)

Class 18 – Text Functions (MID) | Writing Comments in DAX | Advanced Date Functions (WEEKNUM, NETWORKDAYS)

Class 19 – Advanced Date Functions (WEEKDAY) | Logical Functions (IF, Nested IF, AND, OR)

Class 20 – LOGICAL Functions (SWITCH, TRUE) | AND vs && and OR vs || | Row Context vs Filter Context | Introduction to Measures

Class 21 – Understanding Measures in Power BI | Implicit vs Explicit Measures | Creating a Dedicated Measures Table | Aggregation Functions (SUM, COUNT, DISTINCTCOUNT, AVERAGE)

Class 22 – Aggregation Functions (COUNTA, COUNTROWS) | RELATED Function

Class 23 – Customer Based Analysis | Manipulating Filter Context with CALCULATE Function

Class 24 – CALCULATE | FILTER Function | ALL Function | Filter Flow and Context

Class 25 – Contribution Ratio | RELATED function | Iterator Functions (SUMX, COUNTX)

Class 26 – Time Intelligence Functions: DATESMTD, DATESQTD, DATESYTD, DATEADD

Class 27

Class 28

Class 29

Class 30

Class 31

Class 32

Class 33

Class 34

Class 35

Class 36