9 Sections
31 Lessons
14 Hours
Expand all sections
Collapse all sections
Introduction to Data Analytics
3
1.1
What is data analysis?
1.2
What is data analysis?
1.3
Tools overview
Excel Basics for Analysis
4
2.1
Interface
2.2
Formulas
2.3
Functions
2.4
Formatting
Excel Data Cleaning
4
3.1
Remove duplicates
3.2
Basic cleaning
3.3
Organizing data
3.4
Simple transformations
Excel Data Analysis Tools
4
4.1
Pivot charts
4.2
Lookup functions
4.3
Basic KPIs
4.4
Pivot tables
Introduction to Power BI
4
5.1
Interface walkthrough
5.2
Importing data
5.3
Report view
5.4
Visualizations
Data Modeling (Basics)
3
6.1
Relationships
6.2
Tables
6.3
Simple model setup
Creating Dashboards in Power BI
4
7.1
Charts
7.2
Cards
7.3
Filters
7.4
Layout design
Excel ↔ Power BI Integration
3
8.1
Connecting files
8.2
Data refresh
8.3
Combined workflows
Final Project
2
9.1
Create an Excel report + Power BI dashboard
9.2
Present insights & recommendations
Data Analytics Basics (Excel + Power BI)
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
Prove your humanity
7 + 7 =
Lost your password?
Remember Me
Modal title
Main Content