Data Analyst with AI + AWS + Snowflake Certification

Categories: Data Analyst, Power BI
Wishlist Share

Course Content

Power BI – Assignment Solutions

  • Assignment 01 Solution
    32:27
  • Assignment 02 Solution
  • Assignment 03 Solution
  • Assignment 04 Solution
    16:06

Pre-Requisite Videos

Class 01 – Text Functions in Excel (LEFT, RIGHT, MID, FIND, LEN, SEARCH)

Class 02 – Advanced Text Functions

Class 03 – Logical Functions (IF, Nested IF, IF ELSE) | Order of Execution

Class 04 – Logical Functions (IFS, SWITCH, TRUE)

Class 05 – Logical Functions (AND, OR, Mixed AND-OR)

Class 06 – Conditional Functions (COUNTIFS) for Data Analysis

Class 07 – LOOKUP Functions (LOOKUP, VLOOKUP, INDEX & MATCH)

Class 08 – Data Validation (Number, Text Length, List, Dynamic Criteria)

Class 09 – Conditional Formatting in Excel (Basic to Advance Formatting)

Class 10 – Data Visualization with Excel Charts (Column, Bar, Line, Histogram)

Class 11 – Data Visualization with Excel Charts (Pie, Donut, Tree Map, Combo)

Class 12 – Interactive Excel Dashboard (Data Analytics and Measuring KPI’s)

Class 13 – Top/Worst Performers Analysis | Time Series Analysis in Excel

Class 14 – Interactive Charts (KPI Charts, Dynamic Bar Charts)

Class 15 – Interactive Charts (Line Chart, Combo Chart)

Class 16 – Interactive Excel Dashboard Design

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

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

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

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

Class 21 – 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 22 – Power Query: Data Quality Assurance – Handling Errors and Missing Data | Column Profiling | Column Distribution | Column Quality | Query Optimization

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

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

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

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

Class 27 – Power Query:

Class 28 – Power Query:

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

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

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

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

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

Class 34 – 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 35 – SWITCH Function | MID Function | Data Categorization | Hiding Foreign Keys

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Class 51 – Group Brainstorming Session (Banking Dataset)

Project: 365 Media Feathers

Project: 365 Granny’s Cafe

Project: 365 Real Estate

Project: 365 Financial Statement

Presentation: Banking Group Project

Class 52 – Power BI Service

Class 53 – Introduction of Data Analytics | Databases | Type of Databases

Class 54 – Introduction of SQL | Basic SQL Clauses (SELECT, FROM)

Class 55 – WHERE and GROUP BY Clauses in SQL

Class 56 – WHERE | GROUP BY (Revision) | HAVING | ORDER BY | Comments

Class 57 – Aggregation (SUM, COUNT, AVG) Numeric (ROUND, CEILING, FLOOR)

Class 58 – Date Types & Parts Date Function (DATEDIFF, GETDATE, DATEADD)

Class 59 – String Functions (CONCAT, LEFT, UPPER, LOWER, REPLACE)

Class 60 – String Functions (RIGHT, SUBSTRING, Dynamic String Functions

Class 61 – Comparison Operators Conditional Functions (AND, OR, IS)

Class 62 – Conditional Functions (LIKE, IIF Function) Analytic Buckets

Class 63 – Conditional Functions (Nested IIF, CASE Statement)

Class 64 – Basics of Data Normalization

Class 65 – Foundations of SQL Joins ERD Diagram Fact vs Dim Tables

Class 66 – Advanced Analysis with JOINS Exporting Results RIGHT JOIN

Class 67 – Star and Snowflake Schema Appending Data (UNION and UNION ALL)

Class 68 – Creating VIEWS in SQL Server Exporting SQL Results to POWER BI

Class 69 – Sub Queries (Scalar, Multi Rows, Derived Column)

Class 70 – Sub Queries (Derived Column, Derived Table & Co-Related)

Class 71 – Advanced Co-Related Sub Query | Common Table Expressions (CTEs)

Class 72 – Derived Table Windows Function (OVER, PARTITION BY, ORDER BY)

Class 73 – WINDOW Functions (ROW_NUMBER, RANK, DENSE_RANK, LAG)

Class 74 – Introduction of MySQL Software | Data Analysis using MySQL

Class 75 – WINDOWS Functions | Sub Queries (Column_Table)

Class 76 – DDL (ALTER, CREATE, RENAME) | DML (INSERT, UPDATE, SET, DELETE)

Class 77 – Data Cleaning in SQL | SUBSTRING_INDEX | STR_TO_DATE Function

Class 78 – Introduction of 365 Hardware Store Database

Class 79 – Custom Functions in SQL How to make Function in MySQL

Class 80 – Advanced Custom Functions | Multiple Layer SQL JOINS

Class 81 – Stored Procedures in SQL and MySQL for Dynamic Inputs

Class 82 – User Management in SQL USING Clause in SQL

Class 83 – Python Fundamentals: Installation & Configuration | Exploring Jupyter Notebook & VS Code | Python Data Types (Integers, Floating Points, Strings, Lists, Dictionaries, Tuples, Sets, Booleans) | Essential Built-in Functions

Class 84 – Pyhton: List Data Type (Creating Lists | String Indexing & Slicing | Basic List Methods (len, append, pop, reverse, sort) | Nested Lists | Two-dimension Indexing & Slicing) | Dictionaries Data Type (Constructing a Dictionary | Basic Dictionary Methods (upper, keys, values, items), Reinitalizing | Nested Dictionaries | Tuples Data Type (Creating Tuples | Methods (index, count) | Immutablity | When to Use Tuples) | Sets (Basic Methods (add, remove, pop)) | Booleans | Comparison & Chained Comparison Operators | Conditional Statements (if, elif, else)

Class 85 –

Class 86 –