Data Analyst with AI (Batch-10)

Categories: MS Excel, Power BI, Python, SQL, Tableau
Wishlist Share
Share Course
Page Link
Share On Social Media

Course Content

Assignments

  • Assignment 01 Solution
    15:42
  • Assignment 02 Solution
    20:43
  • Assignment 03 Solution
    09:47
  • Assignment 04 Solution
    16:05

Introductory Class

Class 01 –

Class 02 –

Class 03 – Power Query (Basic, Text & Number Tools)

Class 04 – Power Query (Data Profiling, Column Quality, Date Tools, Conditional Columns)

Class 05 – Power Query (Introduction to M-Code, Column From Examples, Group By, Merge and Append Queries, Parameters)

Class 06 – Power BI Fundamentals (Data Modelling Basics with Normalization, Star vs Snowflake Schema)

Class 07 – Data Analysis Expression (DAX): TEXT Functions (LEFT, RIGHT, UPPER, LOWER, SUBSTITUTE), Nested DAX Functions (LEFT with SEARCH)

Class 08 – DAX: Text functions (LEFT, RIGHT) | Date & Time Functions (DATEDIFF, TODAY, EOMONTH, NETWORKDAYS, WEEKDAY, FORMAT)

Class 09 – Logical Operators | Functions | Order of Operation (Lower & Upper Bound) | IF Functions | Nested IF | Multiple Conditions | Multiple Conditions & Multiple Logics | Uses of AND

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

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

Class 12 – Data Analysis Expression (DAX) Measures: Filter Modifier CALCULATE Function | ALL Function

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

Class 14 – Measures: Time Intelligence Functions (Time Series Analysis & Categorical Analysis) | MoM | SamePeriodLastYear | DateAdd | ToDate Analysis | DatesYTD | DatesMTD | Rolling Revenue | DATESINPERIOD

Class 15 – Error Handling (IFERROR) | Dashboard: Color Palette | Formatting | New Card Visual | Line Chart (Trend Line, Reference Line: Comparison Analysis)

Class 16 – Dashboard: Categorical Analysis (Corporate Standards) | Bar Chart | KPI Card | Donut Chart | Pie Chart

Class 17 – Data Visualization: Filters (Basic, Cross, Advanced, TOPN) | Visuals (Table, Matrix, Cards) | Differences (Matrix vs. Table, TOPN, Cards)

Class 18 – Data Visualization: Gauge Chart | Drilling (Up, Down, Through) | Drillthrough Page | Bookmarks | Page Navigation | Custom Tooltips | Conditional Formatting | Slicer | Area Chart

Class 19 – Project Introduction: Austin Real Estate | Data Exploration | User-Centered Design | Data Normalization | New Card Visual | Median, Mean & Outlier Comparison

Power BI Project: 365 Media Feathers

Power BI Project: 365 Granny’s Café

Class 20 – Conditional Formatting (DAX & Gradients) | Map Visuals | Unpivot Data | Stacked Charts | Field & Numeric Parameters | Dynamic Measures

Class 21 – Learned Binning & Sorting Visuals | Processed Text Data | Used Key Influencer Visual | Designed Layouts in PowerPoint | Implemented Custom Designs in Power BI

Class 22 – Learned Buttons, Selection & Grouping | Created Bookmark Navigation | Built Custom Slicer Panel | Explored Power BI Service, Workspaces, Publishing & Sharing Reports

Class 23 – Explored BI Ecosystem | Built ERD Model | Connected Power BI with SQL Server | Researched Financial Reports | Created Auto Date Tables

Class 24 – Understanding Income Statement Requirements | Introduction to Variables | Manipulating Filter Context for Advanced Dax Measures | NOT ISFILTERED Function | Waterfall Chart | Manipulating Matrix Visual with DAX

Class 25 – Understanding Balance Sheet | Requirements Manipulating Filter | Context for Advanced DAX Measures (2) | Creating and Assigning Roles in Power BI Service

Microsoft Excel – Basics to Intermediate Level

Class 26 – Introduction to Excel | Tables vs Ranges | Power Query in Excel vs Power BI | Creating Dynamic File Paths with Parameters | Loading Options | Pivot Tables & Power Pivot Basics

Class 27 – Advanced Pivot Tables (Formats, Filters, Conditional Formatting) | Power Pivot Setup | Data Modeling | DAX Measures & Reporting

Class 28 – Understanding Business Requirement | Requirement Gathering Questions | Dynamic Paths using Folder Query | Understanding M-Language Code | Dynamic Calendar Table in Power Query | Date Function in Power Query | Difference between List and Tables in Power Query | Advanced Editor and reusing MCode using Blank Queries | Creating Report in Pivot Table | Custom Formatting Option, Conditional Formatting in Pivot Table | Setting Print Area in Excel, Creating PDF and distribution to shareholders

Class 29 – Change Report Based Dynamic Path | Manipulating M-Code for Data Import | Switching Column and Row in Pivot Table | Create Income Statement using Pivot Table | Priority Matrix | Scatterplots Dynamic Report in Excel Using Named Ranges

Class 30 – Introduction to SQL | Difference between Server and DBMS | Database Schema (Tables, Databases, Columns) | Why companies use SQL | Introduction and Installation of Azure Data Studio | Clauses in SQL (SELECT , FROM)

Class 31 – Clauses in SQL (WHERE, GROUP BY ORDER BY) | Logical Operation in SQL | Data Types in SQL | Order of Operations | Aggregate functions (SUM, AVG, MIN, MAX, COUNT) Aliases

Class 32 – Introduction to functions in SQL | Date functions (DATEADD,DATEDIFF) | Text functions (LOWER,UPPER,CONCAT,LEFT,RIGHT, LEN, REPLACE)IS NULL , IS NOT NULL | Advanced Operators (IN,BETWEEN) | Conditional functions (IIF, CASE Statement) | Introduction to Joins

Class 33 – Introduction to Joins (INNER JOIN, LEFT JOIN, RIGHT JOIN) | Relationships between tables

Class 34 – Sub Queries | Derived Tables | Windows Function (PARTITION BY, OVER, ROW NUMBER, RANK, DENSE RANK)

Class 35 – Python: Introduction to Python | Anaconda Installation | Variables and rule for variables | Introduction to libraries | Numeric Function | Data Types in Python

Class 36 – Python: String Functions | Lists and List Functions | Introduction to Conditions

Class 37 – IF | ELSE | ELIF | Advanced ELIF Conditions | Introduction to Loops | FOR LOOP | Use Case for Loops

Class 38 –

Class 39 –

Class 40