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
Lesson 7: Lookup_Functions_ Hlookup
The lesson content is empty.
Home
Courses
Search
Search
Account
Login with your site account
Lost your password?
Remember Me
Modal title
Main Content