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
The Data Bootcamp: Transform your Data using dbt™
Data Engineering on Azure
dbt for Data Engineers
Data Engineering on AWS
