Power BI for Business Intelligence (Batch-15)

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
    14:40
  • Assignment 03 Solution
    09:46
  • Assignment 04 Solution
    16:05

Class 01 – Introduction of Power BI for Data Analytics | Steps to Build a Power BI Dashboard | ETL (Extract, Transform and Loading) Explained

Class 02 – Introduction of Power Query | Practically Explanation of ETL (Extract, Transform and Loading) | Replace Values | Applied Steps Automation | Data Types

Class 03 – Exploratory Data Analysis (EDA) Explained | Power Query (Removed Columns, Use First Row as Headers, Removed Other Columns, M-Code for Efficiency)

Class 04 – Power Query: Text Transformations (Merge Columns, Upper, Lower, Proper, Trim, Clean) | Optimizing Power Query Steps | Promote Headers

Class 05 – Power Query: Text Transformations: Extract Tools – Text Before/ After/ Between Delimiter | Split Columns – By Delimiters, By Upper to Lower, By Non-Digit to Digit

Class 06 – Power Query: Data Quality Assurance – Handling Errors and Missing Data | Column Profiling | Column Distribution | Column Quality | Query Optimization

Class 07 – Power Query: Number Functions (Standard – Addition, Multiple, Subtraction, Statistics: SUM, AVERAGE, MIN, MAX, Rounding)

Class 08 – Power Query: Date Tools (Year, Name of the Month, Day Name, Start of Month, Start of Week) | Categorical vs Time Series Analysis

Class 09 – Power Query: Conditional Columns | Conditional Operators | Data Buckets for Context Development

Class 10 – Power Query: GROUP BY Tool for Data Reporting | Merge Queries (Left Join Connection)

Class 11 – Power Query:

Class 12 – Power Query:

Class 13 – Power BI Fundamentals: Data Modelling Basics with Normalization | Star vs Snowflake Schema | Data Formatting | Data Categories

Class 14 – Data Analysis Expression (DAX) – Basic Foundation | Difference between Power Query and Calculated Columns | DAX Function Categories | DAX Formula Syntax | TEXT Functions (CONCETENATE, &)

Class 15 – Data Analysis Expression (DAX): TEXT Functions (LEFT, RIGHT, UPPER, LOWER, SUBSTITUTE) | DATE Functions (MONTH, DAY, YEAR, HOUR, MINUTE, SECOND, DATEDIFF)

Class 16 – DATE Functions (DATEDIFF Function with TODAY), WEEKDAY, WEEKNUM, NETWORKDAYS) | Nested DAX Functions (RIGHT, LEFT with SEARCH/ FIND, LEN Functions) (copy)

Class 17 – Variables | Difference between VAR & Functions | LEN, FIND, Automating Left, Right, DAX Format

Class 18 – Intro to BIT Concept | Logical Operators | Functions | Order of Operation (Lower & Upper Bound) | IF Functions | Nested IF | Multiple Conditions | Multiple Conditions & Multiple Logics | Uses of AND

Class 19 – SWITCH Function | MID Function | Data Categorization | Hiding Foreign Keys

Class 20 – PL-300 Question (Calculated Column VS Measures) | Aggregation Functions (Sum, Count ) | Measures | Relationships In Data Model | Implicit VS Explicit Measures | Filter Flow

Class 21 – Measures: Implicit vs Explicit Measure | Aggregation Functions (SUM, COUNT, COUNTROWS, AVERAGE, DISTINCTCOUNT, DIVIDE, MAX, MIN)

Class 22 – Measures: Calculate Function | Return Rate | Batching Similar Measures | Decision Making | Text Box (Comments) | Presenting Report | ALL Function | Contribution Analysis

Class 23 – Measures: Table Function | Default Nature of Measures | Making Calculate Function Dynamic Through FILTER Function

Class 24 – Measures: Introduction of Iterator Functions | Measures (SUMX, AVERAGEX, MINX, MAXX) | RELATED Function

Class 25 – Measures: Time Intelligence Functions (Time Series Analysis & Categorical Analysis) | MoM | SamePeriodLastYear | DateAdd

Class 26 – Measures: ToDate Analysis | DatesYTD | DatesMTD | Rolling Revenue | DATESINPERIOD

Class 27 – Measures: Error Handling | ISBLANK | Moving Average

Class 28 – Discussion (Dashboard | Images | Elements | Shapes | Color Palette | Formatting | UI UX | Card Visual | Corporate Standards)

Class 29 – Dashboard: Line Chart (Trend Line | Reference Line: Comparison Analysis) | Bar Chart | Column Chart | Difference between Clustered and Stacked Charts)

Class 30 – Dashboard: KPI Card | Donut Chart | Pie Chart

Class 31 – Dashboard: Visual | Page | Report Level Filters | Basic Filter | Advanced Filters | TOPN Filter | Table Visual | Matrix Visual | TOPN Cards Visual | Slicer | Area Chart

Class 32 – Dashboard: Guage Chart (Filtering, Monthly Filter, Industry Standards) | Conditional Formatting (Brainstorming)

Class 33 – Dashboard: Drilling (Up, Down, Through) | Bookmarks | Page Navigation | Custom Tooltips

Class 34 – PBI Updates (Discussion) | More Visuals | Cross Filtering | Edit Interactions | Parameters

Class 35 – Group Brainstorming Session (Banking Dataset)

Project: 365 Media Feathers

Project: 365 Granny’s Cafe

Class 36 – Field Parameters | Making Titles Dynamic | SELECTEDVALUE | GENERATESERIES

Project: 365 Real Estate

Project: 365 Financial Statement