Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Power BI & Excel Complete Bootcamp for Business Intelligence

Name: Power BI & Excel Complete Bootcamp for Business Intelligence
Rating: 4.3 (63 reviews)

Master Power BI and Excel for A-Z Data Analytics. Get Hands-on Skills and Become Microsoft Business Intelligence Expert.

Created byShahriar's Sight Academy

Last updated 3/2025

English

What you'll learn

Gain knowledge of data analytics fundamentals, including data analysis, statistical analysis, hypothesis testing, and machine learning.
Utilize Power BI to craft professional, insightful, and visually engaging dashboards that effectively communicate data-driven stories.
Learn Power BI for data manipulation, in-depth analysis, and extracting meaningful insights to design compelling dashboards.
Master Excel for data cleaning, manipulation, sorting, conditional filtering, formulas, functions, and visualizations with graphs and charts.
Explore advanced Excel techniques, such as PIVOT tables and charts, statistical analysis with the Data Analysis ToolPak, and interactive dashboard creation.

Course content

23 sections • 101 lectures • 11h 1m total length

What is data analysis?7:11
Explore how data analysis inspects, cleans, transforms, and models data to uncover insights, inform conclusions, and support decision making, and learn descriptive, diagnostic, predictive, prescriptive, and exploratory approaches.
Key components of data analysis10:18
Things make you Full Business Intelligent!0:56
Understanding exploratory data analysis5:37
Methods of exploratory data analysis Part 112:15
Methods of exploratory data analysis Part 211:17
Explore symmetric and asymmetric distributions, including the normal bell-shaped curve and skewness, and learn how percentiles (q1, median, q3) and min and max reveal data structure.
Methods of exploratory data analysis Part 315:36
Necessary foundation on data analysis

What is statistical data analysis?8:31
Statistical data analysis v/s EDA4:10
Population v/s sample and its methods11:05
Types of statistical data analysis4:58
A recap on descriptive analysis3:14
Inferential statistics Part 1 – T-tests and ANOVA6:54
Inferential statistics Part 2 – Relationships measures3:16
Inferential statistics Part 3 – Linear regression11:53
Necessary foundation on statistical analysis

Hypothesis testing for inferential statistics6:03
Selecting statistical test and assumption testing10:26
Confidence level, significance level, p-value3:37
Explore confidence level, significance level (alpha), and p-value in hypothesis testing, including how they guide decision making with null and alternative hypotheses, for business intelligence analysis.
Making decision and conclusion on findings2:55
Learn how to decide and conclude findings in hypothesis testing by comparing the p value to a 5% significance level and stating whether to accept the null or alternative hypothesis.
Complete statistical analysis and hypothesis testing7:01
Compare class A new-method and class B traditional-method scores via a hypothesis testing workflow. Apply independent sample t test, Shapiro-Wilk, and p-value at alpha 0.05 to decide H0 or H1.
Necessary foundation on hypothesis testing

Text data manipulation6:10
Numeric manipulation9:48
Learn to use Power BI's numerical tools for statistical analysis and calculations on the transaction amount data, including total, average, and count distinct, while transforming data with Power Query.
Date manipulation5:20
Learn to manipulate a date and time column in Power BI using the date option to extract year, month, quarter, and day, and create transaction month and year for insights.
Conditional columns6:11
Learn to create a new inventory status column in Power BI using conditional columns in Power Query Editor, labeling as alert when stock quantity is below 20 and normal otherwise.
Group by analysis4:32
Merging queries8:40
Merge Power BI queries using the customer ID as the common key, performing an inner join to combine demographics with transaction history and reveal spending patterns.
Appending queries3:12
Learn to append queries in Power BI by concatenating two product catalog tables, creating a new data frame with 100 products, and aligning columns for a complete product catalog data.

Requirements

Desktop/Laptop (Mac or Windows)
Dedication to be a data analyst

Description

Unlock the full potential of Power BI and Excel to drive data-driven decision-making and master business intelligence. This comprehensive course equips you with the skills to analyze, visualize, and present data effectively. Whether you're a beginner or looking to advance your expertise, you'll gain hands-on experience in Power BI and Excel, covering everything from data manipulation to interactive dashboards and business intelligence solutions.

Why Take This Course?

Power BI for Data Analysis and Visualization

Master Power BI to clean, transform, and analyze data effectively.
Learn Power BI's DAX (Data Analysis Expressions) to enhance data calculations.
Create dynamic Power BI dashboards that tell compelling data stories.
Utilize Power BI's visualization tools to extract valuable insights.
Connect and integrate multiple data sources in Power BI for seamless reporting.

Excel for Data Analytics and Business Intelligence

Use Excel for data cleaning, transformation, and manipulation.
Apply sorting, filtering, formulas, and functions to refine datasets.
Create advanced Pivot Tables and Charts for business reporting.
Use Excel's Data Analysis ToolPak for statistical insights.
Build interactive Excel dashboards for data visualization.

Interactive Dashboards with Power BI

Develop Power BI dashboards with real-time, interactive data visualizations.
Create professional, insightful reports using Power BI’s powerful tools.
Design Power BI dashboards that help stakeholders make data-driven decisions.

Practical Hands-On Learning

Work on 30+ real-world Power BI and Excel assignments.
Test your knowledge with 10 quizzes and 100+ questions.
Complete two capstone projects to solidify your expertise in Power BI and Excel.

Capstone Projects

Bank Churn Analysis: Use Power BI to analyze customer data and predict churn trends.
Website Performance Analysis: Leverage Power BI and Excel to track key website metrics and optimize user experience.

Course Features

Step-by-step video lectures covering both beginner and advanced Power BI techniques.
Hands-on assignments to reinforce learning with Power BI and Excel.
Practical quizzes to test your understanding of Power BI and business intelligence.
Capstone projects to build a Power BI portfolio for your career.
Community support to engage with fellow learners and experts.

Course Outcomes

By the end of this course, you will:

Be proficient in Power BI and Excel for data analysis and business intelligence.
Create interactive Power BI dashboards that provide valuable business insights.
Use Power BI's powerful tools to analyze large datasets with ease.
Develop real-world Power BI projects that showcase your skills to employers.
Be well-equipped for a successful career in business intelligence and data analytics.

Take the first step in mastering business intelligence—enroll now and become a Power BI and Excel expert!

Who this course is for:

This course is ideal for anyone looking to harness the power of Microsoft Power BI and Excel for data-driven decision-making.

Power BI & Excel Complete Bootcamp for Business Intelligence

What you'll learn

Explore related topics

Course content

---------- FOUNDATION: Understanding Data Analysis ----------7 lectures • 1hr 3min

Understanding Statistical Analysis8 lectures • 54min

Understanding Hypothesis Testing5 lectures • 30min

Various Data Visualization Methods4 lectures • 22min

---------- POWER BI: Complete Guide to Story Telling ----------3 lectures • 1min

[Power BI] Getting Started with BI Tool5 lectures • 20min

[Power BI] Data Manipulation and Analysis7 lectures • 44min

[Power BI] Data Modeling and Connections5 lectures • 29min

[Power BI] Data Analysis Expressions (DAX)3 lectures • 26min

[Power BI] Creating Dashboard PART 16 lectures • 44min

Requirements

Description

Who this course is for: