Curriculum
5 Sections
32 Lessons
26 Weeks
Expand all sections
Collapse all sections
ADVANCE EXCEL
19
1.1
Module 1: Excel Basics and Customization
1.2
Module 1 Excel Basics and Customization (Assignment Questions)
1 Week
1.3
Module 2: Advanced Functions and Formulas
1.4
Module 2 Advanced Functions and Formulas (Assignment Questions)
1 Week
1.5
Module 3: Data Validation Techniques
1.6
Module 3 Data Validation Techniques (Assignment Questions)
1 Week
1.7
Module 4: Data Organization and Analysis
1.8
Module 4 Data Organization and Analysis (Assignment Questions)
1 Week
1.9
Module 5: Power Functions for Data Analytics
1.10
Module 5 Power Functions for Data Analytics (Assignment Questions)
1 Week
1.11
Module 6: Data Visualization Techniques
1.12
Module 6 Data Visualization Techniques (Assignment Questions)
1 Week
1.13
Module 7: Macros and Automation
1.14
Module 7 Macros and Automation (Assignment questions)
1 Week
1.15
Module 8: What-If Analysis Tools
1.16
Module 8 What-If Analysis Tools (Assignment Questions)
1 Week
1.17
Module 9: New Features and Enhancements in Excel
1.18
Module 9 New Features and Enhancements in Excel (Assignment Questions)
1 Week
1.19
Advance Excel Quizzes
1 Week
50 Questions
SQL (Structured Query Language)
23
2.1
Module 1: SQL Basics
2.2
Module 1 SQL Basics (Assignment Questions)
1 Week
2.3
Module 2: DML, DDL & DQL
2.4
Module 2 DML, DDL & DQL (Assignment Questions)
1 Week
2.5
Module 3: SQL Constraints
2.6
Module 3 SQL Constraints (Assignment Questions)
1 Week
2.7
Module 4: Querying Data
2.8
Module 4 Querying Data Assignment Questions
1 Week
2.9
Module 5: SQL Joins
2.10
Module 5 SQL Joins (Assignment Questions)
1 Week
2.11
Module 6: SQL Functions
2.12
Module 6 SQL Functions (Assignment Questions)
1 Week
2.13
Module 7: Aggregate Functions and Grouping
2.14
Module 7 Aggregate Functions and Grouping (Assignment Questions)
1 Day
2.15
Module 8: Subqueries and Nested Queries
2.16
Module 8 Subqueries and Nested Queries (Assignment Questions)
1 Week
2.17
Module 9: Window Functions
2.18
Module 9 Window Functions (Assignment Questions)
1 Week
2.19
Module 10: Indexing and Performance Optimization
2.20
Module 10 Indexing and Performance Optimization (Assignment Questions)
1 Week
2.21
Module 11: Data Warehousing Concepts
2.22
Module 11 Data Warehousing Concepts (Assignment Questions)
1 Week
2.23
SQL (Structured Query Language) Quizzes
1 Hour
50 Questions
Power BI
11
3.1
Module 1: Introduction to Power BI
3.2
Module 1 Introduction to Power BI (Assignment Questions)
1 Week
3.3
Module 2: Data Visualization
3.4
Module 2 Data Visualization (Assignment Questions)
1 Week
3.5
Module 3: Power BI Service, Publishing & Sharing
3.6
Module 3 Power BI Service, Publishing & Sharing (Assignment Questions)
1 Week
3.7
Module 4: Data Transformation
3.8
Module 4 Data Transformation (Assignment Questions)
1 Day
3.9
Module 5: Data Modeling & DAX
3.10
Module 5 Data Modeling & DAX (Assignment Questions)
1 Week
3.11
Power BI Quizzes
1 Hour
50 Questions
Tableau
14
4.1
Module 1: Tableau Overview
4.2
Module 1 Tableau Overview (Assignment Questions)
1 Week
4.3
Module 2: Data Sources
4.4
Module 2 Data Sources (Assignment Questions)
1 Week
4.5
Module 3: Worksheets
4.6
Module 3 Worksheets (Assignment Questions)
1 Week
4.7
Module 4: Calculations
4.8
Module 4 Calculations (Assignment Questions)
1 Week
4.9
Module 5: Sorting & Filtering
4.10
Module 5 Sorting & Filtering (Assignment Questions)
1 Week
4.11
Module 6: Data Visualization
4.12
Module 6 Data Visualization (Assignment Questions)
1 Week
4.13
Module 7: Projects
4.14
Tableau Quizzes
1 Hour
50 Questions
Final Exam
2
5.1
Business Analytics Final Quizzes
1 Hour
50 Questions
5.2
Business Analytics Final Test
3 Hours
Business Analytics
Search
Module 5: Data Modeling & DAX
Topics:
Understanding Relationships and Creating Relationships
Cardinality and Cross Filter Direction
Introduction to DAX and Its Syntax
Using DAX Functions for Calculated Columns, Measures, and Tables
Learning Table, Information, Logical, Text, Iterator, and Time Intelligence Functions (YTD, QTD, MTD)
Cumulative Values, Calculated Tables, and Ranking
Modal title
Main Content