Masters in Data Analytics

• Advance Excel Setting
• File Setting
• Formulas
• SUMIFS
• COUNTIFS
• Text Function
• IF Formula (Part 1-4)
• Chart (Part 1-3)
• Conditional Formatting (Part 1-4)
• Filter (Part 1-6)
• Sorting (Part 1-2)
• VLookup (Part 1-8)

• MATCH Function
• MATCH with CONCAT Function
• Index Function
• Index MATCH (Part 2)
• CellRef (Part 1-3)
• Text Function
• Count Function
• Date Function (Part 1-2)
• Logical Functions (IF, AND, OR, IFNA, Nested IF, Dynamic IF)
• VLookup (Complete Series)
• Custom Level Format
• Data Validation (Part 1-4)

• Home Tab (1-2)
• Data Sorting
• Goto Special
• Copy Visible
• Paste Special
• Filter
• Sheet Table (Part 1-3)
• Pivot Table (Part 1-5)
• Dashboard (Part 1-2)
• Trend Chart (Part 1-4)
• Sparkline
• Hyper Link (Part 1-2)
• What If Analysis
• Solver

• Power Pivot
• Power Query (Part 1-3)
• AI Tool Analyse Data (Introduction, Basic, Error)
• Microsoft Account
• Word 365 with Copilot (Part 1-2)
• PowerPoint 365 with Copilot (Part 1-3)
• MS Excel with Copilot

• Super Income Journey
• Part 2: Super Income Journey
• Fast Track Results Journey in Silver Club
• The Self Discovery Process to Attain Result
• Using Ira Platform At The Best Level For Faster Results
• What Are Top 10 Skills You'll Need to Acquire
• Getting Started with LinkedIn: Your First Step to Career Growth
• LinkedIn Codex: Use AI to Create a High-Impact Profile
• LinkedIn Visibility Formula: Right Design + Right People + Right Action
• From Connection to Opportunity: LinkedIn Growth Secrets
• Powerful brand and 24L active income journey

Week 1- Introduction & Power BI

• Introduction of Data Analysis
• Introduction of Power BI
• How To Install Power BI
• Power BI Interface
• Power BI Workflow
• How To Connect Data Source
• Connect and Load Data
• Connect and Load Data from Text File
• Connect and Load Data from Web
• Connect and Load Data from Databases (SQL & Access)
• Introduction to Power Query Interface
• Power Query- Remaining Query, Table & Column Name
• Power Query Merge Columns
• Power Query Split Column
• Power Query Merge Queries
• Power Query Append Queries
• Power Query Calculated Columns
• Power Query Data Type & Load

Week 2- Data Model & Dax

• Introduction to Data Model
• Data Model- Column Data Behavior
• Data Model- Table Relationship Part 1
• Data Model- Table Relationship Part 2
• Data Model- Table Relationship Part 3
• Dax- Introduction
• Dax- Calculated Column
• Dax- Calculated Table