Business Intelligence with Excel
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
| # | 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
Azure Data Pipelines with TerraformAndreas Kretz
dbt for Data EngineersAndreas Kretz
Spark and Python for Big Data with PySparkudemy
Dockerized ETL With AWS, TDengine & GrafanaAndreas Kretz
Python for Data EngineersAndreas Kretz
PyTorch for Deep Learningzerotomastery.io
Relational Data ModelingEka Ponkratova
Machine Learning Design Questionsalgoexpert
Python for Business Data Analytics & Intelligencezerotomastery.io
