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
DS4B 101-P: Python for Data Science AutomationBusiness Science University
MongoDB FundamentalsAndreas Kretz
Statistics Bootcamp (with Python): Zero to Masteryzerotomastery.io
Dimensional Data ModelingEka Ponkratova
Build a Large Language Model (From Scratch)Sebastian Raschka
Complete linear algebra: theory and implementationudemy
Data Structures and Algorithmic Trading: Machine Learningudemy
Data Platform & Pipeline DesignAndreas Kretz
Machine Learning with JavascriptudemyStephen Grider
