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: zerotomastery.io

zerotomastery.io thumbnail
Whether you are just starting to learn to code or want to advance your skills, Zero To Mastery Academy will teach you React, Javascript, Python, CSS and more to help you advance your career, get hired and succeed at some of the top companies in the world.

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