Ai & Data Analytics HOC Orientation

AI&Data Analytics Model Paper & Exam Pattren Explained

Video 1 Why Power BI and How to Install

Video 2 Start, Load and Go (Making Table and Matrix)

Video 3 Visual Formattings, Numbers formatting, Cards Visuals, AI in BI via QA

Video 4 Bar Charts (All variations) and Slicers Basics

Video 5 Line Charts Area Charts Multiple Axis and

Video 6 Ribbon, Pie, Donut, Treemap and Filled maps

Video 7 Power Platform, Basic Data Transformation, waterfell, funnel and scatter chart

Video 1 Loading Data from Different Sources

Video 2 Data Transformation Colum Split and Merge

Video 3 Replace, Text based , Unpivot and Practice Example

Video 4 Merging sheets from a Workbook

Video 5 Merging Workbooks in same folders and append rule

Video 6 Adding New Columns and time date functions

Video 7 Group by Function in Power query Basic and Advance

Video 8 Merge Queries (Full outer, Left Outer, Right outer, Inner and antis joins) & Fuzzy Matching

Video 9 Add Columns (index, Duplicate, Custom Column)

Video 10 Column from Example and Date issues

Video 1 Data Modeling and why we do it (DB Basics, Quantum of data, Normalized vs Denormalized)

Video 2 Data Modeling and building relationship in Star Schema

Video 3 Auto Detect Relation and Introduction to DAX

Video 4 DAX Multiline, Double operators, IF and Nested IF

Video 5 Adding Calculated Tables

Video 6 Introduction to the Measures

Video 1 Time Intelligence MTD, WTD, DTD, YTD and SameperiodLastYear

Video 2 Time Intelligence Comparatives, ParallelPeriods, SOM,EOM, previous period and next period

Video 3 Applying filters in calculate Function and ignoring other filters (HD)

Video 4 Adding Tables with filters and conditional counts (HD)

Video 5 SWITCH, SELECTEDVALE, ISINSCOPE and Excluding totals from measures (HD)

Video 6 SWITCH SELECTEDVALUE and external slicers

Video 7 Add Tables using ADDCOLUMNS with FILTER function and SUMMARIZE

Video 1 Field Parameters ( X and Y axis, Ordering, Drill Through and Exand all)

Video 2 Conditional Formatting 1(Table Gradient, Font colors, Bars & Sparklines)

Video 3 Conditional Formatting 2 (Heatmap, Icons based on rules)

Video 4 Drill through and Updating sources of Data

V1 Super Assignment 1 AGAL part a & b

V2 Super Assignment 1 AGAL part C

V3 Super Assignment 1 AGAL part D

V4 Super Assignment 1 AGAL part E F

V5 Super Assignment 1 AGAL part G

V1 Super Assignment 2 PSL part a & b

V2 Super Assignment 2 PSL part c

V3 Super Assignment PSL Point d

V4 Super Assignment PSL Point e

V5 Super Assignment PSL Point f & g

Video 1 Why we need to study PYTHON and what is it

Video 2 Starting the PYTHON in Jupyter Notebook

Video 3 Libraries, Data Loading and viewing through PANDAS

Video 4 Basic Summarization and Adding Columns

Video 5 Deleting Columns and Markdown formatting in Python

Video 6 Data Filters, Multiple Filters and Calculated Filters

Video 1 Check Unique Values and Set index

Video 2 Replace missing values and generating code from GPT

Video 3 Drop and Dropna with inplace, axis and how arguments

Video 4 Change data type with astype and todatetime

Video 5 Groupby(single multiple and date based)

Video 1 Plots in Pandas, Introduction to matplotlib and seaborn

Video 4 Line Chart Area Chart and using GPT to generate update chart

Video 2 How things work in Matplotlib and Seaborn

Video 3 Single and multiple column charts with groupby and melt

Video 5 Histogram, Box Plot and Corelation Heatmap

V1 AI, Machine Learning and Supervised ML

V2 Basic SupML Calculations and concept

V3 Liner Regression Model ML1(import, Load, Split, Set , Fit and Print)

V4 Liner Regression Model (Evaluation, Scatter Plot & Outliers Identification)

V5 Liner Regression Model (Data Cleaning from Outliers and increasing Precision )

V6 Multiple Liner Regression ML2

Video 1 Introduction to RPA and Installing Power Automate

Video 2 Project 1 Excel Data Consolidations Bot (Multiple Sheets)

Video 3 Project 2 Excel Data Consolidations Bot (Same Sheet)

Video 4 Project 3 Part 1 Adding Sum clicking buttons in Ribbon

Video 5 Project 3 Part 2 Wrtie Read Delete rename and File Actions

Video 6 Excel Macros Project 4

V1 Project 5 Part I Web Automation, Data Entry in Google Form Browser Extensions

V2 Project 5 part II Loops concept, foreach loop, buttons and checkbox for web data entry

V3 Project 6 Conditional Actions (If, elseif and else)

V4 Word and PDF Automation Project 7

V5 Templates Introduction

V6 Outlook Automation Setting up, sending emails