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

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 | Introduction to Power Query

Class 03 – How to connect files to Power BI | Types of transformation in Power Query (Text, Number, Date) | Text Tools (Format Text (CAPITALIZE, UPPERCASE, LOWERCASE, TRIM, CLEAN) | Merge Columns | Difference between Add and Transform Columns | Steps in Power Query

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

Class 05 – Difference between CSV and Excel files | Arithmetic Operations Using Number Tools (Multiplication, Subtraction, Addition) | Reference Query

Class 06 – Appending queries | Combining multiple files (Folder queries)

Class 07 – Merge queries | Kinds of joins | Filter options in queries | Handling errors

Class 08 – Data Cleaning in Real World CRM | Modelling and it’s importance

Class 09 – Modelling in Power BI | Relationship Cardinality | Star Schema | Primary and Foreign Key

Class 10

Class 11

Class 12

Class 13

Class 14

Class 15