Class 02 – Introduction of Power BI – Power Query

Class 03 – Text Tools (Extract, Merge Columns, Split Columns, Format) | Number Tools (Statistics) | Reference Queries | Column Quality | Date Tools (Age, Time Series, Categorical)

Class 04 – Conditional Column | Column for Example | Date Tools (Substract Days) | Group By | Filtering and Sorting | Parameters

Class 05 – Append Queries | Select from Folder | Data Normalization Concept | Data Modelling

Class 06 – Data Modelling | Star & Snow Flake Schema | Data Formatting | DAX Calculated Columns – Text Functions (LEFT, RIGHT, UPPER, LOWER, CONCATENATE, &) | Date Functions (DAY, MONTH, YEAR, DATEDIFF, TODAY)

Class 07 – Text Function (SUBSTITUTE, FIND, SEARCH, Dynamic RIGHT, LEFT) | Date Functions (WEEKDAY, WEEKNUM) | Logical Operator | Logical Functions (IF, Nested IF)

Class 08 – Logical Functions (Nested IF, SWITCH, SWITCH with TRUE, AND, OR)

Class 09 – Measures | Implicit vs Explicit Measures | Filter Context | Filter Flow | Aggregation Functions (SUM, COUNT, COUNTROWS, AVERAGE, DISTINCTCOUNT, DIVIDE, MAX, MIN)

Class 10 – CALCULATE | ALL | FILTER Functions | Variables and Commenting

Class 11 – Iterator Functions (SUMX, AVERAGEX, MINX, MAXX) | Time Intelligence Functions (DATEADD, PREVIOUSMONTH, PREVIOUSYEAR, PREVIOUSQUARTER, SAMEPERIODLASTYEAR, DATESYTD, DATESMTD, DATESQTD, DATESINPERIOD)

Class 12 – Handling Errors | Data Visualization (Navigation Bar, Images, Card Visual, Visual Formatting)

Class 13 – Data Visualization (Line Chart, Forecasting, Reference Line, Bar Chart, KPI Charts, Donut Chart, Pie Chart)

Class 14 – Data Visualization (Visual, Page, Report Level Filters, Basic Filter, Advanced Filters, TOPN Filter | Table Visual | Matrix Visual | TOPN Cards Visual | Slicer | Area Chart)

Class 15 – Data Visualization (Guage Chart) | Drilling (Up, Down, Through) | Bookmarks | Page Navigation | Custom Tooltips | Conditional Formatting

Class 16 – Project 01 – Oodles of Noodles

Class 17 – Project 01 – Oodles of Noodles

Class 18 – Project 02 – Market Mindz

Class 19 – SQL – Introduction to Database | Clauses (SELECT, FROM, WHERE, GROUP BY Statements) | TOP N | TOP N PERCENT Keyword

Class 20 – SQL – Clauses (HAVING, ORDER BY) | SQL Order of Operations | Aggregation Functions (SUM, COUNT, AVG, MAX, MIN) | Numerical Functions (ROUND, CEILING, FLOOR) | Date Functions (DATENAME, MONTH, DATEDIFF, DATEADD) | String Functions (CONCAT, UPPER, LOWER, CHARINDEX, LEFT, RIGHT, LEN)

Class 21 – SQL – Comparison Operators | IS and IS NOT Function | Conditional Functions (AND, OR, IIF, CASE – WHEN, THEN) | ISNULL Function

Class 22 – SQL – JOINS (INNER, FULL/OUTER, LEFT, RIGHT) | ER Diagram | Facts vs Dimension Tables | Relationships in SQL | UNION for Appending Queries

Class 23 – SQL – LIKE Function | CREATE VIEWS | Sub Queries (Scalar Query, Multi Row Query)

Class 24 – Sub Queries (Derived Column in SELECT, Derived Table in FROM) | Windows Functions (OVER(), PARTITION BY, ROW NUMBER, RANK, DENSE RANK. LAG & LEAD)

Class 25 – Data Cleaning in MySQL

Class 26 – World Life Expectancy Project

Class 27 – Microsoft Excel – Introduction to Excel | Shortcuts | Fill Handle | Flash Fill | Sorting | Filtering | Grouping | Custom Sort | Hide and Deleting | Mathematical Calculation | Referencing (Relative, Absolute, Mixed)

Class 28 – Microsoft Excel – Numerical Functions in Excel | 3D Referencing | Text Functions | Logical Functions in Excel (IF, Nested IF, LET, SWITCH Functions)

Class 29 – Microsoft Excel – Conditional Functions in Excel (COUNTIFS, SUMIFS Functions) | Lookup Functions (LOOKUP, VLOOKUP, INDEX & MATCH, IFERROR) | Data Validation (Number, Text Length, List, Dynamic Criteria)

Class 30 – Microsoft Excel – Conditional Formatting in Excel (Basic to Advance Formatting) | Data Visualization with Excel Charts (Column, Bar, Line, Histogram, Pie, Donut, Tree Map, Combo Chart)

Class 31 – Introduction of Pivot Tables

Class 32 – Advanced Pivot Tables

Class 33 – Warehouse Project (Data Analysis and Dashboarding) using Pivot Tables

Class 34 – Interactive Human Resource (HR) Dashboard using Advanced Excel

Class 35 – Introduction of Python | Types of Variables | Numerical Functions | String Type and Functions

Class 36 – Python – Conditional Functions | List Functions

Class 37 – Python – For Loop | List of List Working

Class 38 – Pandas for Data Analysis – DataFrame Basics | Creating DataFrames

Class 39 – Pandas for Data Analysis – Reading and Writing CSV and Excel | Handling and Replacing Missing Data