Data Analytics Course Microsoft Excel and Power BI

★★★★☆ (1,230 reviews)

Trisha Jagtiani

Created by

2025-03-18

Start Date

2025-03-21

Last Date

Data Science

What you'll learn

Master advanced formulas like INDEX-MATCH and dynamic arrays. Automate data cleaning and transformation with Power Query. Build interactive dashboards and models using Power Pivot and DAX.
Power BI Expertise: Import, clean, and model data efficiently. Create interactive reports with advanced DAX calculations. Publish and share Power BI dashboards securely.
End-to-End Analytics Workflow: Integrate Excel and Power BI for seamless data analysis. Work on real-world projects and case studies.
Industry Applications: Use analytics to optimize decisions in finance, sales, operations, and more. Explore AI tools for trend identification and predictive insights.

Requirements

Laptop/ computer run lightweight softwares
Good wifi

Description

Data Analytics Course: Microsoft Excel and Power BI

Key Topics Covered: Excel for Data Analytics Advanced formulas (e.g., INDEX-MATCH, dynamic arrays) Power Query for data cleaning and transformation Power Pivot and DAX for data modeling Dashboards with interactive visualizations Power BI for Business Intelligence Data import and transformation with Power Query Building data models and relationships DAX calculations for deep analytics Designing interactive dashboards with Power BI Publishing and sharing Power BI reports End-to-End Analytics Workflow Connecting Excel with Power BI for enhanced workflows Real-world case studies and industry-specific use cases Capstone project to showcase end-to-end analytics skills

Course Syllabus

Understanding Power Query for Data Cleaning and Transformation
Handling Missing Data
Duplicates and Data Types
Combining and Merging Datasets

Q&A (Natural Language Processing)
Key Influencers Visual
Decomposition Tree
Anomaly Detection
Forecasting (Time Series)
AutoML (Automated Machine Learning)

Building Relationships Between Tables
Star vs. Snowflake Schema in Data Models
Brief understanding of Relationships
Cardinality: Meaning and various types

Creating Calculated Columns and Measures with DAX
Understanding Data Hierarchies and Aggregations

Understanding Data Analysis Expressions (DAX)
Advanced DAX functions and calculations
Time intelligence functions for analyzing trends over time
Dive deeper into DAX functions
including more complex functions like CALCULATE
FILTER
ALL
RELATED and many others.
Learn about advanced DAX patterns and techniques for solving complex business problems.
Explore time intelligence functions like DATESYTD
DATEADD and others for analyzing data over time

Introduction to data visualization principles
Creating basic visualizations (bar charts line charts pie charts etc.)
Customizing visualizations with formatting and design options

Creating a hierarchy in Power BI
Advanced visualization types (treemaps waterfall charts Donut Chart funnel chart Guage Chart etc.)
Interactive features (drill-down slicers bookmarks etc.)
Custom visuals and integrating them into reports

Designing Interactive Dashboards with Best Practices
Using Bookmarks and Selections for Storytelling
Building Dashboard Navigation with Buttons and Menus
Creating Summary and Drill-Down Views

Publishing Reports to the Power BI Service
Creating and Sharing Dashboards in the Cloud
Collaboration with Workspaces and Apps
Exporting Reports to PDF
Excel and PowerPoint

Using DAX for Complex Calculations and Aggregations
Applying Row-Level Security (RLS) to Control Data Access
Exploring AI Capabilities: Q&A Visual
Key Influencers and Decomposition Tree
Predictive Analytics and Forecasting

Who this course is for:

Professionals in MIS, Reporting, and Business Intelligence
Aspiring Data Analysts or Data Scientists
Business Owners and Entrepreneurs looking for actionable insights
Students and Recent Graduates aiming to enter data-driven roles
Corporate Teams seeking to improve their organization's analytics capabilities

Meet your instructors

Trisha Jagtiani

View Profile

GET ACCESS TO CURATED JOBS WITH

Dadicated career support

Exclusive access to Great Learning job board, Exclusive access to Great Learning job board. Its a test