CourseFlix

Business Intelligence with Excel

7h 41m 24s
English
Paid

Launch your career as a Data Professional with the most comprehensive course available! Master Excel's built-in power tools, including Power Query, Power Pivot Tables, Data Modeling, and the DAX formula language. Start on your journey to become a Business Intelligence Analyst and secure your dream job in 2022.

Why Choose This Course?

This is not just any Excel course; we guarantee that it is the best and most up-to-date Excel for Business Intelligence Bootcamp available. With our course, you will learn to perform professional, compelling analyses with advanced Excel tools such as Power Query, Power Pivot Tables, and the DAX formula language.

Comprehensive Learning Experience

Our curriculum is designed to provide an end-to-end learning experience. You will build a complete Business Intelligence solution for a fictional Surf Shop, creating numerous powerful KPIs that deliver deep insights into business performance. This hands-on project is designed to simulate real-world challenges.

Career Opportunities

By the end of the course, you'll have acquired valuable skills that make you a strong candidate for Business Intelligence Analyst positions. With our training, you can confidently approach job opportunities and interviews in 2022 and beyond!

About the Author: Zero To Mastery

Zero To Mastery thumbnail

Zero To Mastery (ZTM) is a Toronto-based online coding academy founded by Andrei Neagoie, originally a senior developer at large Canadian tech firms before turning to teaching full-time. The academy's signature is the cohort-based bootcamp track combined with a deep self-paced course library, all aimed at career-changers and self-taught developers preparing to land software-engineering roles at top companies.

The instructor roster has grown well beyond Andrei to include other senior practitioners: Daniel Bourke (machine learning), Aleksa Tešić (DevOps), Jacinto Wong, and others. Courses cover the full software-engineering career path: web development with React and Next.js, Python, machine learning and deep learning, DevOps and cloud, system design, mobile, and the algorithm / data-structure interview prep that gates engineering jobs.

The CourseFlix listing under this source carries over 120 ZTM courses spanning that full range. Material is paid; ZTM itself runs on a monthly / annual membership model. The teaching style favours long-form, project-based courses where students build complete portfolio-quality applications rather than disconnected feature tutorials.

Watch Online 45 lessons

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 45 lessons in this course and access 10,000+ hours of premium content across all courses.

View Pricing
0:00
/
#1: Business Intelligence with Excel
All Course Lessons (45)
#Lesson TitleDurationAccess
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

Related courses

  • Data Engineering on Azure thumbnail

    Data Engineering on Azure

    Sources: Kristijan Bakarić
    Microsoft Azure is a cloud platform offering more than 200 products and services for data storage, management, virtual machine deployment, and...
    1 hour 20 minutes 57 seconds
  • PyTorch for Deep Learning with Python Bootcamp thumbnail

    PyTorch for Deep Learning with Python Bootcamp

    Sources: Udemy
    Welcome to the best online course for learning about Deep Learning with Python and PyTorch! PyTorch is an open source deep learning platform that provides a sea
    17 hours 2 minutes 14 seconds 5 / 5
  • Machine Learning in JavaScript with TensorFlow.js thumbnail

    Machine Learning in JavaScript with TensorFlow.js

    Sources: Udemy
    Interested in using Machine Learning in JavaScript applications and websites? Then this course is for you! This is the tutorial you've been looking for to becom
    6 hours 42 minutes 20 seconds