Business Intelligence with Excel

7h 41m 24s
English
Paid

Course description

The only course you need to launch your career as a Data Professional! Learn to master Excel's built-in power tools, including Power Query, Power Pivot Tables, Data Modeling, the DAX formula language, and so much more. Become a Business Intelligence Analyst and get hired in 2022.

Read more about the course

We guarantee you that this is the best and most up-to-date Excel for Business Intelligence Bootcamp that you can find. You will learn to conduct professional, compelling analyses with Excel using the advanced 'power' tools built-in to Excel including Power Query, Power Pivot Tables, and the DAX formula language. You'll even build an end-to-end Business Intelligence solution for a fictional Surf Shop where you'll create dozens of powerful KPIs that provide deep insight into business performance. By the end, you'll have the skills to get hired as a Business Intelligence Analyst in 2022!

Watch Online

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

Watch Online Business Intelligence with Excel

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

Comments

0 comments

Want to join the conversation?

Sign in to comment

Similar courses

Data Engineering on AWS

Data Engineering on AWS

Sources: Andreas Kretz
This course is the perfect start for those who want to learn cloud technologies and start working with Amazon Web Services (AWS), one of the most popular..
4 hours 46 minutes 38 seconds
Machine Learning A-Z : Become Kaggle Master

Machine Learning A-Z : Become Kaggle Master

Sources: udemy
Want to become a good Data Scientist? Then this is a right course for you. This course has been designed by IIT professionals who have mastered in Mathematics and Data Science....
36 hours 23 minutes 54 seconds
Apache Iceberg Fundamentals

Apache Iceberg Fundamentals

Sources: David Reger
Modern data platforms need the flexibility of data lakes and the reliability of warehouses. Apache Iceberg combines both approaches. In this course, you will...
33 minutes 32 seconds
PyTorch for Deep Learning and Computer Vision

PyTorch for Deep Learning and Computer Vision

Sources: udemy
PyTorch has rapidly become one of the most transformative frameworks in the field of Deep Learning. Since its release, PyTorch has completely changed the landsc
10 hours 20 minutes 51 seconds
Introduction to Data Engineering

Introduction to Data Engineering

Sources: zerotomastery.io
Companies of all sizes have access to enormous amounts of data, but the problem is that the data is often unstructured. In order to answer important...
57 minutes 26 seconds