Data Analyst with AI Certification
Course Content
Class 01 – Introduction to Excel | Shortcuts | Fill Handle | Flash Fill
-
Data Analyst with AI – Session 01
58:22
Class 02 – Sorting | Filtering | Grouping | Custom Sort | Hide and Deleting
Class 03 – Mathematical Calculation | Referencing (Relative, Absolute, Mixed) – Session 03
Class 04 – Function Syntax | Text Functions in Excel | Formula Nesting
Class 05 – Text Functions in Excel (LEFT, RIGHT, MID, FIND, LEN, SEARCH)
Class 06 – Advanced Text Functions
Class 07 – Logical Functions (IF, Nested IF, IF ELSE) | Order of Execution
Class 08 – Logical Functions (IFS, SWITCH, TRUE)
Class 09 – Logical Functions (AND, OR, Mixed AND-OR)
Class 10 – Conditional Functions (COUNTIFS) for Data Analysis
Class 11 – Conditional Functions (SUMIFS, AVERAGEIFS) & Sparkline’s
Class 12 – LOOKUP Functions (LOOKUP, VLOOKUP, INDEX & MATCH)
Class 13 – Data Validation (Number, Text Length, List, Dynamic Criteria)
Class 14 – Conditional Formatting in Excel (Basic to Advance Formatting)
Class 15 – Data Visualization with Excel Charts (Column, Bar, Line, Histogram)
Class 16 – Data Visualization with Excel Charts (Pie, Donut, Tree Map, Combo)
Class 17 – Interactive Excel Dashboard (Data Analytics and Measuring KPI’s)
Class 18 – Interactive Excel Dashboard (Advanced Data Analytics)
Class 19 – Top/Worst Performers Analysis | Time Series Analysis in Excel
Class 20 – Interactive Charts (KPI Charts, Dynamic Bar Charts)
Class 21 – Interactive Charts (Line Chart, Combo Chart)
Class 22 – Interactive Excel Dashboard Design
Class 23 – Introduction of SQL | Basic SQL Clauses (SELECT, FROM)
Class 24 – WHERE and GROUP BY Clauses in SQL
Class 25 – WHERE | GROUP BY (Revision) | HAVING | ORDER BY | Comments
Class 26 – Aggregation (SUM, COUNT, AVG) Numeric (ROUND, CEILING, FLOOR)
Class 27 – Date Types & Parts Date Function (DATEDIFF, GETDATE, DATEADD)
Class 28 – String Functions (CONCAT, LEFT, UPPER, LOWER, REPLACE)
Class 29 – String Functions (RIGHT, SUBSTRING, Dynamic String Functions
Class 30 – Comparison Operators Conditional Functions (AND, OR, IS)
Class 31 – Conditional Functions (LIKE, IIF Function) Analytic Buckets
Class 32 – Conditional Functions (Nested IIF, CASE Statement)
Class 33 – Basics of Data Normalization
Class 34 – Foundations of SQL Joins ERD Diagram Fact vs Dim Tables
Class 35 – Advanced Analysis with JOINS Exporting Results RIGHT JOIN
Class 36 – Star and Snowflake Schema Appending Data (UNION and UNION ALL)
Class 37 – Creating VIEWS in SQL Server Exporting SQL Results to POWER BI
Class 38 – Sub Queries (Scalar, Multi Rows, Derived Column)
Class 39 – Sub Queries (Derived Column, Derived Table & Co-Related)
Class 40 – Advanced Co-Related Sub Query | Common Table Expressions (CTEs)
Class 41 – Derived Table Windows Function (OVER, PARTITION BY, ORDER BY)
Class 42 – WINDOW Functions (ROW_NUMBER, RANK, DENSE_RANK, LAG)
Class 43 – Introduction of MySQL Software | Data Analysis using MySQL
Class 44 – WINDOWS Functions | Sub Queries (Column_Table)
Class 45 – DDL (ALTER, CREATE, RENAME) | DML (INSERT, UPDATE, SET, DELETE)
Class 46 – Data Cleaning in SQL | SUBSTRING_INDEX | STR_TO_DATE Function
Class 47 – Introduction of 365 Hardware Store Database
Class 48 – Custom Functions in SQL How to make Function in MySQL
Class 49 – Advanced Custom Functions | Multiple Layer SQL JOINS
Class 50 – Stored Procedures in SQL and MySQL for Dynamic Inputs
Class 51 – User Management in SQL USING Clause in SQL
Class 52 – Introduction of Power BI for Data Analytics | Steps to Build a Power BI Dashboard | ETL (Extract, Transform and Loading) Explained
Class 53 – Introduction of Power Query | Practically Explanation of ETL (Extract, Transform and Loading) | Replace Values | Applied Steps Automation | Data Types
Class 54 – Exploratory Data Analysis (EDA) Explained | Power Query (Removed Columns, Use First Row as Headers, Removed Other Columns, M-Code for Efficiency)
Class 55 – Power Query: Text Transformations (Merge Columns, Upper, Lower, Proper, Trim, Clean) | Optimizing Power Query Steps | Promote Headers
Class 56 – 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 57 – Power Query: Data Quality Assurance – Handling Errors and Missing Data | Column Profiling | Column Distribution | Column Quality | Query Optimization
Class 58 – Power Query: Number Functions (Standard – Addition, Multiple, Subtraction, Statistics: SUM, AVERAGE, MIN, MAX, Rounding)
Class 59 – Power Query: Date Tools (Year, Name of the Month, Day Name, Start of Month, Start of Week) | Categorical vs Time Series Analysis
Class 60 – Power Query: Conditional Columns | Conditional Operators | Data Buckets for Context Development
Class 61 – Power Query: GROUP BY Tool for Data Reporting | Merge Queries (Left Join Connection)
Class 62 – Power Query:
Class 63 – Power Query:
Class 64 – Power BI Fundamentals: Data Modelling Basics with Normalization | Star vs Snowflake Schema | Data Formatting | Data Categories
Class 65 – Data Analysis Expression (DAX) – Basic Foundation | Difference between Power Query and Calculated Columns | DAX Function Categories | DAX Formula Syntax | TEXT Functions (CONCETENATE, &)
Class 66 – Data Analysis Expression (DAX): TEXT Functions (LEFT, RIGHT, UPPER, LOWER, SUBSTITUTE) | DATE Functions (MONTH, DAY, YEAR, HOUR, MINUTE, SECOND, DATEDIFF)
Class 67 – DATE Functions (DATEDIFF Function with TODAY), WEEKDAY, WEEKNUM, NETWORKDAYS) | Nested DAX Functions (RIGHT, LEFT with SEARCH/ FIND, LEN Functions)
Class 68 – Variables | Difference between VAR & Functions | LEN, FIND, Automating Left, Right, DAX Format
Class 69 – 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 70 – SWITCH Function | MID Function | Data Categorization | Hiding Foreign Keys
Class 71 – PL-300 Question (Calculated Column VS Measures) | Aggregation Functions (Sum, Count ) | Measures | Relationships In Data Model | Implicit VS Explicit Measures | Filter Flow
Class 72 – Measures: Implicit vs Explicit Measure | Aggregation Functions (SUM, COUNT, COUNTROWS, AVERAGE, DISTINCTCOUNT, DIVIDE, MAX, MIN)
Class 73 – Measures: Calculate Function | Return Rate | Batching Similar Measures | Decision Making | Text Box (Comments) | Presenting Report | ALL Function | Contribution Analysis
Class 74 – Measures: Table Function | Default Nature of Measures | Making Calculate Function Dynamic Through FILTER Function
Class 75 – Measures: Introduction of Iterator Functions | Measures (SUMX, AVERAGEX, MINX, MAXX) | RELATED Function
Class 76 – Measures: Time Intelligence Functions (Time Series Analysis & Categorical Analysis) | MoM | SamePeriodLastYear | DateAdd
Class 77 – Measures: ToDate Analysis | DatesYTD | DatesMTD | Rolling Revenue | DATESINPERIOD
Class 78 – Measures: Error Handling | ISBLANK | Moving Average
Class 79 – Discussion (Dashboard | Images | Elements | Shapes | Color Palette | Formatting | UI UX | Card Visual | Corporate Standards)
Class 80 – Dashboard: Line Chart (Trend Line | Reference Line: Comparison Analysis) | Bar Chart | Column Chart | Difference between Clustered and Stacked Charts)
Class 81 – Dashboard: KPI Card | Donut Chart | Pie Chart
Class 82 – Dashboard: Visual | Page | Report Level Filters | Basic Filter | Advanced Filters | TOPN Filter | Table Visual | Matrix Visual | TOPN Cards Visual | Slicer | Area Chart
Class 83 – Dashboard: Guage Chart (Filtering, Monthly Filter, Industry Standards) | Conditional Formatting (Brainstorming)
Class 84 – Dashboard: Drilling (Up, Down, Through) | Bookmarks | Page Navigation | Custom Tooltips
Class 85 – PBI Updates (Discussion) | More Visuals | Cross Filtering | Edit Interactions | Parameters
Class 86 – Group Brainstorming Session (Banking Dataset)
Project: 365 Media Feathers
Project: 365 Granny’s Cafe
Class 87 – Field Parameters | Making Titles Dynamic | SELECTEDVALUE | GENERATESERIES
Project: 365 Real Estate
Project: 365 Financial Statement
Presentation: Banking Group Project
Class 88 – Power BI Service
Student Ratings & Reviews
No Review Yet