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
Data Engineering on GCPAndreas Kretz
Case Study in Product Data ScienceLunarTech
Storing & Visualizing Time Series DataAndreas Kretz
PyTorch for Deep Learning with Python Bootcampudemy
Apache Spark Certification TrainingFlorian Roscheck
Introduction to Data Engineering 2025Andreas Kretz
Python for Data Science and Machine Learning Bootcampudemy
Getting Started with Embedded AI | Edge AIudemy
The Data Science Course: Complete Data Science Bootcamp 2023udemy
