9 Sections
54 Lessons
8 Weeks
Expand all sections
Collapse all sections
Module 1: Introduction and Excel Basics
0
Module 1:1 Introduction to Data
6
2.1
Lesson 1: Welcome Address
2.2
Lesson 2: What is Data
2.3
Lesson 3: What is Big Data
2.4
Lesson 4: Analysis vs Analytics
2.5
Lesson 5: Types of Data Analytics
2.6
Lesson 6: Who is a Data Analyst, Tools and Methodology
Module 1:2 Understanding Excel for Data Analytics
9
3.1
Lesson 1: Introduction to Excel
3.2
Lesson 2: Basic Features of Excel
3.3
Lesson 3: Understanding Excel Interface
3.4
Lesson 4: Relative cell Referencing
3.5
Lesson 5: AbsoluteCell Referencing
3.6
Lesson 6: Structure Cell Referencing
3.7
Lesson 7: Mixed Cell Referencing
3.8
Lesson 8: Functions and Formulars
3.9
Lesson 9: Mastering Excel Data Formatting
Module 1:3 Data Cleaning
3
4.1
Lesson 1: Data Cleaning_Trim and Substitute function
4.2
Lesson 2: Data Cleaning Functions_Trim, Clean, Substitute, Upper, Lower, Proper, Mid, Right and Left
4.3
Lesson 3: Data Cleaning in Excel
Module 2: Excel and Statistics
7
5.1
Lesson1: Data Validation
5.2
Lesson 2: Conditional Formating
5.3
Lesson 3: Statistical Functions in Excel
5.4
Lesson 4: Conditional Functions
5.5
Lesson 5: Countif and Sumif
5.6
Lesson 6: Lookup Functions_Vlookups
5.7
Lesson 7: Lookup_Functions_ Hlookup
Module 3: Dashboarding with Excel
Materials Used
6
6.1
Lesson 1: Pivot Tables in Excel
6.2
Lesson 2: Creating KPIs using pivot tables
6.3
Lesson 3: Designing the wireframe
6.4
Lesson 4: Wireframe completion + Icons
6.5
Lesson 5: Importing KPIs into the Dashboard
6.6
Lesson 6: Project Completion
Module 4: Getting started with Power BI
11
7.1
Lesson 1: introduction to PowerBI
7.2
Lesson 2: PowerBI Achitecture
7.3
Lesson 3: Downloading PowerBI
7.4
Lesson 4: PowerBI Workflow
7.5
Lesson 5: How does a company use powerBi to drive business
7.6
Lesson 6: Data Modelling
7.7
Lesson 7: Concept of Primary and Foreign Keys
7.8
Lesson 8: What is ERD
7.9
Lesson 9: Facts and Dimensions Tables
7.10
Lesson 10: Building ERD with DRAW.IO
7.11
Lesson 11: PowerBI interface
Module 5: Intermediate Power BI (DAX and Dashboarding)
6
8.1
Lesson 1: Using Power Query
8.2
Lesson 2: AI for analysis, DAX, measures and KPIs
8.3
Lesson 3: Creating a Calendar Table
8.4
Lesson 4: Chart Creation
8.5
Lesson 5: Designing Wirefram and creating Dashboard
8.6
Lesson 6: Dashboard completion and Slicers
Module 6: SQL for Analytics
6
9.1
Lesson 1: Introduction to SQL
9.2
Lesson 2: Understanding DATA
9.3
Lesson 3: What is Database
9.4
Lesson 4: RDBMS AND NoSQL
9.5
Lesson 5: Data Warehouse, OLAP and OLTP
9.6
Lesson 6: Downloading and Installing SQL Server
Data Analytics
Curriculum
This content is protected, please
login
and enroll in the course to view this content!
Home
Courses
Search
Search
Account
Login with your site account
Lost your password?
Remember Me
Modal title
Main Content