Business Intelligence with Excel
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
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 subscriptionComments
0 commentsWant to join the conversation?
Sign in to commentSimilar courses
PyTorch for Deep Learning and Computer Vision
dbt for Data Engineers
Analytics Engineering for Data Professionals
Machine Learning in JavaScript with TensorFlow.js
