Business Intelligence with Excel

7h 41m 24s
English
Paid

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 Business Intelligence with Excel

Join premium to watch
Go to premium
# Title Duration
1 Business Intelligence with Excel 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

Similar courses to Business Intelligence with Excel

Data Engineering on Databricks

Data Engineering on DatabricksAndreas Kretz

Category: Data processing and analysis
Duration 1 hour 27 minutes 29 seconds
Machine Learning: Natural Language Processing in Python (V2)

Machine Learning: Natural Language Processing in Python (V2)udemy

Category: Python, Data processing and analysis
Duration 22 hours 4 minutes 2 seconds
Complete Machine Learning and Data Science: Zero to Mastery

Complete Machine Learning and Data Science: Zero to Masteryudemyzerotomastery.io

Category: Data processing and analysis
Duration 43 hours 22 minutes 23 seconds
Snowflake for Data Engineers

Snowflake for Data EngineersAndreas Kretz

Category: Data processing and analysis
Duration 2 hours 4 minutes 8 seconds
PyTorch for Deep Learning

PyTorch for Deep Learningzerotomastery.io

Category: Data processing and analysis
Duration 52 hours 27 seconds
Becoming a Better Data Engineer

Becoming a Better Data EngineerAndreas Kretz

Category: Data processing and analysis
Duration 1 hour 46 minutes 10 seconds
Data Structures and Algorithmic Trading: Machine Learning

Data Structures and Algorithmic Trading: Machine Learningudemy

Category: Data processing and analysis
Duration 2 hours 20 minutes 32 seconds
Time Series Analysis, Forecasting, and Machine Learning

Time Series Analysis, Forecasting, and Machine Learningudemy

Category: Python, Data processing and analysis
Duration 22 hours 47 minutes 45 seconds
Getting Started with Embedded AI | Edge AI

Getting Started with Embedded AI | Edge AIudemy

Category: Data processing and analysis
Duration 3 hours 33 minutes 42 seconds
Case Study in A/B Testing

Case Study in A/B TestingLunarTech

Category: Data processing and analysis
Duration 1 hour 56 minutes 17 seconds