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.
Business Intelligence with Excel
7h 41m 24s
English
Paid
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!
About the Author: zerotomastery.io
Whether you are just starting to learn to code or want to advance your skills, Zero To Mastery Academy will teach you React, Javascript, Python, CSS and more to help you advance your career, get hired and succeed at some of the top companies in the world.
Watch Online 45 lessons
0:00
/ #1: Business Intelligence with Excel
All Course Lessons (45)
| # | Lesson Title | Duration | Access |
|---|---|---|---|
| 1 | Business Intelligence with Excel Demo | 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 |
Unlock unlimited learning
Get instant access to all 44 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.
Learn more about subscription