Power BI for Business Intelligence (Batch-16)

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 – ISBLANK() Function | DATESINPERIOD()

Class 28 – Power BI Documentation | On-Object Interaction Option | Dashboards | Images | Card Visual

Class 29 – Dashboard: Executive Summary | Card Visuals | Discussion (Dashboard | Elements | Shapes | Color Palette | Formatting | UI UX | Corporate Standards)

Class 30 – Dashboard: Brief information about Custom Charts | Bar Chart | KPI Chart

Class 31 – Dashboard: Text Box | Pie Chart | Donut Chart

Class 32 – Dashboard: Visual Level Filter | Report Level Filters | Report Level Filters | Basic Filters | Advanced Filters | TOPN Filter | Drill-through Filters | TOPN Cards Visual

Class 33 – Sample Dashboard Discussion | Understanding Corporate Standards | Table Visual (Formatting, Data Bars, Background Colour) | Gauge Chart

Class 34 – Dashboard Design Discussion | Slicer Charts (Vertical, Tile, Dropdown)

Class 35 – Gauge Charts | Drill-through Filters | Custom Tooltips

Class 36 – Bookmarks in Power BI (Reset Button, Insights Button, Navigation Button) | Edit Interactions

Class 37 – Variables | Advance DAX using Variables

Class 38 – Maven Roasters Project: Dynamic Path | Inactive Relationships | ALL & ALLSELECTED

Class 39 – Maven Roasters Project: Rounding Functions (ROUND, ROUNDUP, ROUNDDOWN, CEILING, FLOOR) | Info Functions (CONTAINSTRING, CONTAINSSTRINGEXACT, ISLOGICAL, ISVALUE) | Conversion Functions (CURRENCY, FOMAT)

Class 40 – Maven Roasters Project: Table vs. Matrix | ALL | ALLEXCEPT | SWITCH | REMOVEFILTERS

Class 41 – Maven Roasters Project: KEEPFILTERS | ISINSCOPE | SELECTCOLUMNS | ADDCOLUMNS

Class 42 – Maven Roasters Project: SUMMARIZE | FILTER | RELATED | USERELATIONSHIP | CROSSFILTER

Project: 365 Media Feathers

Project: 365 Granny’s Cafe

Class 43 – Power BI Service – Dashboard Sharing & Distribution | Publish to Power BI | Workspaces | Access & Roles | Sharing & Exporting | Subscriptions & Alerts | Gateway & Data Refresh | Security Roles

Class 44 – Microsoft Fabric | Workspace | Lakehouse | File Upload | Dataflow Gen2

Course Content

Power BI – Assignment Solutions

Assignment 01 Solution

Assignment 02 Solution

Assignment 03 Solution

Assignment 04 Solution

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

Power BI (Batch-16) – Class 01

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

Power BI (Batch-16) – Class 02

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

Power BI (Batch-16) – Class 03

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

Power BI (Batch-16) – Class 04

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

Power BI (Batch-16) – Class 05

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

Power BI (Batch-16) – Class 06

Class 07 – Conditional Columns

Power BI (Batch-16) – Class 07

Class 08 – Append Queries | Folder Query

Power BI (Batch-16) – Class 08

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

Power BI (Batch-16) – Class 09

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

Power BI (Batch-16) – Class 10

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)

Power BI (Batch-16) – Class 11

Class 12 – Star Schema | Reference Table

Power BI (Batch-16) – Class 12

Class 13 – Star Schema vs Snowflake Schema | Galaxy Schema

Power BI (Batch-16) – Class 13

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

Power BI (Batch-16) – Class 14

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

Power BI (Batch-16) – Class 15

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

Power BI (Batch-16) – Class 16

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

Power BI (Batch-16) – Class 17

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

Power BI (Batch-16) – Class 18

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

Power BI (Batch-16) – Class 19

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

Power BI (Batch-16) – Class 20

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

Power BI (Batch-16) – Class 21

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

Power BI (Batch-16) – Class 22

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

Power BI (Batch-16) – Class 23

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

Power BI (Batch-16) – Class 24

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

Power BI (Batch-16) – Class 25

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

Power BI (Batch-16) – Class 26

Class 27 – ISBLANK() Function | DATESINPERIOD()

Power BI (Batch-16) – Class 27

Class 28 – Power BI Documentation | On-Object Interaction Option | Dashboards | Images | Card Visual

Power BI (Batch-16) – Class 28

Class 29 – Dashboard: Executive Summary | Card Visuals | Discussion (Dashboard | Elements | Shapes | Color Palette | Formatting | UI UX | Corporate Standards)

Power BI (Batch-16) – Class 29

Class 30 – Dashboard: Brief information about Custom Charts | Bar Chart | KPI Chart

Power BI (Batch-16) – Class 30

Class 31 – Dashboard: Text Box | Pie Chart | Donut Chart

Power BI (Batch-16) – Class 31

Class 32 – Dashboard: Visual Level Filter | Report Level Filters | Report Level Filters | Basic Filters | Advanced Filters | TOPN Filter | Drill-through Filters | TOPN Cards Visual

Power BI (Batch-16) – Class 32

Class 33 – Sample Dashboard Discussion | Understanding Corporate Standards | Table Visual (Formatting, Data Bars, Background Colour) | Gauge Chart

Power BI (Batch-16) – Class 33

Class 34 – Dashboard Design Discussion | Slicer Charts (Vertical, Tile, Dropdown)

Power BI (Batch-16) – Class 34

Class 35 – Gauge Charts | Drill-through Filters | Custom Tooltips

Power BI (Batch-16) – Class 35

Class 36 – Bookmarks in Power BI (Reset Button, Insights Button, Navigation Button) | Edit Interactions

Power BI (Batch-16) – Class 36

Class 37 – Variables | Advance DAX using Variables

Power BI (Batch-16) – Class 37