Data Analytics Course Microsoft Excel and Power BI

Enhance your data analysis skills with our comprehensive course on Microsoft Excel and Power BI.

Category Microsoft

Data Analytics Course Microsoft Excel and Power BI

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.

Course Syllabus

Data Cleaning in Power BI

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

AI Tools in Power BI

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

Data Modeling in Power BI

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

Introduction to DAX

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

Advanced Analytics with DAX

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

Data Visualization Fundamentals

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

Advanced Visualizations

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

Dashboards and Storytelling

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

Introduction to Power BI Service

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

Advanced Analytics with Power BI

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

Course Syllabus

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

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

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

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

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

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

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

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

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

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

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

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

Subscribe to top courses

get this course, plus 12000+ of our top rated courses, with Personal Plan, Learn more

Starting at ₹850 per month
Cancel anytime

₹ 70000/-

30 Day Money-Back Guarantee Full Lifetime Access

Share
Gift this course
Apply Coupan

LEARNNOWPLANS is applied

Apply coupan

Workshop Business

Subscribe to this course and 27000+ top-rated courses for your organization.

Learn, Innovate and Lead with Expertise
27000+ fresh users & in-demand courses
Professional Development Components
Discover, Enjoy and Master New Hobbies
Prepare, Excel and Thrive in your Career

Course Syllabus

Data Cleaning in Power BI

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

AI Tools in Power BI

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

Data Modeling in Power BI

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

Introduction to DAX

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

Advanced Analytics with DAX

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

Data Visualization Fundamentals

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

Advanced Visualizations

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

Dashboards and Storytelling

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

Introduction to Power BI Service

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

Advanced Analytics with Power BI

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

Book Your Seat

Interested in this course for your Business or Team?

Train your employees in the most in-demand topics, with edX for Business.

Purchase now Request Information