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

Artificial Intelligence

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