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

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

Comments

0 comments

Want to join the conversation?

Sign in to comment

Similar courses

Storing & Visualizing Time Series Data

Storing & Visualizing Time Series Data

Sources: Andreas Kretz
Processing, storing, and visualizing time series data is becoming an increasingly important task. From IoT data and system logs to statistics...
2 hours 11 minutes 34 seconds
Mathematical Foundations of Machine Learning

Mathematical Foundations of Machine Learning

Sources: udemy
Mathematics forms the core of data science and machine learning. Thus, to be the best data scientist you can be, you must have a working understanding of the mo
16 hours 25 minutes 26 seconds
dbt for Data Engineers

dbt for Data Engineers

Sources: Andreas Kretz
dbt (data build tool) is a data transformation tool with a priority on SQL. It allows for simple and transparent transformation, testing, and documentation...
1 hour 52 minutes 55 seconds
Getting Started with Embedded AI | Edge AI

Getting Started with Embedded AI | Edge AI

Sources: udemy
Nowadays, you may have heard of many keywords like Embedded AI /Embedded ML /Edge AI, the meaning behind them is the same, I.e. To make an AI algorithm or model
3 hours 33 minutes 42 seconds
Build Fast Masterclass

Build Fast Masterclass

Sources: BuildFast Academy
How to finally Launch your AI Product (without ripping your hair out).. that makes you money in 30 days (or less). But unlike other AI courses, you won't learn
7 hours 22 minutes 11 seconds