CF

Business Intelligence with Excel

7h 41m 24s
English
Paid

Launch your career as a Data Professional with the most comprehensive course available! Master Excel's built-in power tools, including Power Query, Power Pivot Tables, Data Modeling, and the DAX formula language. Start on your journey to become a Business Intelligence Analyst and secure your dream job in 2022.

Why Choose This Course?

This is not just any Excel course; we guarantee that it is the best and most up-to-date Excel for Business Intelligence Bootcamp available. With our course, you will learn to perform professional, compelling analyses with advanced Excel tools such as Power Query, Power Pivot Tables, and the DAX formula language.

Comprehensive Learning Experience

Our curriculum is designed to provide an end-to-end learning experience. You will build a complete Business Intelligence solution for a fictional Surf Shop, creating numerous powerful KPIs that deliver deep insights into business performance. This hands-on project is designed to simulate real-world challenges.

Career Opportunities

By the end of the course, you'll have acquired valuable skills that make you a strong candidate for Business Intelligence Analyst positions. With our training, you can confidently approach job opportunities and interviews in 2022 and beyond!

About the Author: Zero To Mastery

Zero To Mastery thumbnail

Zero To Mastery (ZTM) is a Toronto-based online coding academy founded by Andrei Neagoie, originally a senior developer at large Canadian tech firms before turning to teaching full-time. The academy's signature is the cohort-based bootcamp track combined with a deep self-paced course library, all aimed at career-changers and self-taught developers preparing to land software-engineering roles at top companies.

The instructor roster has grown well beyond Andrei to include other senior practitioners: Daniel Bourke (machine learning), Aleksa Tešić (DevOps), Jacinto Wong, and others. Courses cover the full software-engineering career path: web development with React and Next.js, Python, machine learning and deep learning, DevOps and cloud, system design, mobile, and the algorithm / data-structure interview prep that gates engineering jobs.

The CourseFlix listing under this source carries over 120 ZTM courses spanning that full range. Material is paid; ZTM itself runs on a monthly / annual membership model. The teaching style favours long-form, project-based courses where students build complete portfolio-quality applications rather than disconnected feature tutorials.

Watch Online 45 lessons

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 45 lessons in this course and access 10,000+ hours of premium content across all courses.

View Pricing
0:00
/
#1: Business Intelligence with Excel
All Course Lessons (45)
#Lesson TitleDurationAccess
1
Business Intelligence with Excel Demo
02:41
2
Introducing Power Query
10:56
3
Applying Basic Transformations
12:14
4
Editing Transformations
08:47
5
Numerical Transformations
08:44
6
Text Transformations
07:46
7
Date Transformations - Building a Calendar Table
08:54
8
Conditional Transformations
07:10
9
Merging Datasets
11:35
10
Appending Datasets
08:57
11
Introducing Excel's Data Model
08:57
12
Putting the Data Model to Work
13:09
13
Relationships
10:30
14
Relationships in The Excel Data Model
15:15
15
Power Pivot Tables
13:06
16
Calendar Tables
06:49
17
Exercise: Imposter Syndrome
02:57
18
Power Pivot Pitfalls
08:06
19
Multiple Data Tables
11:23
20
Calculated Columns With DAX
10:23
21
The IF Function in DAX
11:36
22
The SWITCH Function
15:11
23
The RELATED Function
09:45
24
Introducing Measures
12:08
25
Using DAX Functions in Measures
10:40
26
The CALCULATE Function
13:34
27
The ALL Function
10:49
28
Introducing Time Intelligence Functions
17:33
29
The ISBLANK Function
04:43
30
The DATEADD Function
10:41
31
The DATESINPERIOD Function
13:02
32
Variables in DAX
10:34
33
The X Functions
08:43
34
The RANKX Function
09:26
35
The TOPN Function
09:46
36
Pivot Table Formatting Tips
08:53
37
Conditional Formating: Data Bars, Color Scales, and Icon Sets
15:03
38
Custom Conditional Formats
10:12
39
Introducing Pivot Charts
14:59
40
Column Charts
06:07
41
Line Charts, Area Charts, and Timelines
11:44
42
Combo Charts
05:50
43
Changing Measures With Slicers
13:29
44
Using Pivot Tables as Formulas
17:19
45
Thank You!
01:18
Unlock unlimited learning

Get instant access to all 44 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.

Learn more about subscription

Related courses

Frequently asked questions

What prerequisites are needed for this course?
This course is designed for individuals looking to start a career in Business Intelligence using Excel. While prior experience with Excel is beneficial, the course covers the necessary tools and techniques from the basics. No advanced knowledge of Excel's power tools is required, as the course includes detailed lessons on Power Query, Power Pivot Tables, and the DAX formula language.
What will I build during the course?
Throughout the course, you will build a complete Business Intelligence solution for a fictional Surf Shop. This project involves creating powerful KPIs and performing analyses that provide insights into business performance. The hands-on project is crafted to mimic real-world scenarios, helping you gain practical experience with tools like Power Query, Power Pivot Tables, and DAX.
Who is the target audience for this course?
The course is intended for aspiring Business Intelligence Analysts and professionals interested in learning how to leverage Excel for business analytics. It is suitable for anyone looking to enhance their skills in data modeling and analysis using Excel's advanced features, such as Power Query and DAX functions.
What tools and platforms will I learn to use?
The course focuses on Excel's built-in power tools, including Power Query for data transformations, Power Pivot Tables for data modeling, and the DAX formula language for complex calculations. You will also learn how to utilize Excel's Data Model and create various chart types like Pivot Charts and Combo Charts.
What topics are not covered in this course?
This course does not cover advanced data science techniques or other business intelligence tools outside of Excel. It focuses exclusively on Excel's capabilities for business intelligence, so other platforms like SQL or Power BI are not included in the curriculum.
How much time should I expect to commit to this course?
The course comprises 45 lessons, providing a comprehensive learning path. While the runtime is not specified, a typical Excel bootcamp could range from 20 to 40 hours of content, depending on your pace. Students are encouraged to engage with the material actively, especially during the hands-on project for the fictional Surf Shop.
How will the skills learned in this course benefit my career?
Completing the course equips you with skills that are directly applicable to roles such as Business Intelligence Analyst. By mastering tools like Power Query, Power Pivot Tables, and DAX, you'll be well-prepared for job opportunities that require data analysis and business reporting expertise. These skills are valuable across various industries where data-driven decision-making is critical.