The Power Pivot, Power Query in Excel and Power BI Bundle

Learn how to analyze millions of rows of data in Excel and Power BI in this two-course bundle

4.58 (382 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
The Power Pivot, Power Query in Excel and Power BI Bundle
1,967
students
10 hours
content
Jan 2024
last update
$89.99
regular price

What you will learn

Learn to unlock advanced Excel tools Power Query and Power Pivot as well as Power BI in this two-course bundle!

Analyze huge buckets of data to make informed business decisions

Become confident cleaning, sorting and linking data from various sources

Learn via expert instruction and exercises designed to have you performing complex analysis

How to create stunning, interactive dashboards with Power BI

How to share your analysis and dashboards using Power BI Online

To import CSV and Excel files into Power BI Desktop

All about DAX including using the COUTROWS, CALCULATE, and SAMEPERIODLASTYEAR functions

All about using the card visual to create summary information

How to create amazing visuals, such as clustered column charts, maps, and trend graphs

How to use Slicers to filter your reports

How to edit the interactions between your visualizations and filter at visualization, page, and report level

Description

**This course includes practice exercise files**

Learn Microsoft Power BI and Power Pivot, Power Query and DAX in Excel in this two-course bundle from Microsoft experts Simon Sez IT.


We've combined two of our best data analysis courses to create this huge-value bundle. If you have reached your limit in Excel and you need to analyze and make sense of huge amounts of data, then you need Power Pivot, Power Query and Power BI. These tools can help you take your existing data-crunching capabilities to new heights!


Power Pivot, Power Query and DAX

In this advanced Excel course, we look at three crucial advanced Excel features Power Pivot, Power Query, and DAX. This suite of Excel functions allows you to manipulate, analyze, and evaluate millions of rows of data from Excel or other databases.

We first look at how to bring your data together, merge, and clean it using Power Query before moving onto creating relationships between our data tables and building out a data model. We then look at performing calculations on our data model using DAX, and finally, we look at displaying our analysis using PivotTables and PivotCharts.

***Exercise and demo files included***

In the Power Pivot, Power Query & DAX course you will learn:

  • How to get started with Power Query

  • How to connect Excel to multiple workbooks

  • How to get data from the web and other sources

  • How to merge and append queries using Power Query

  • How the Power Pivot window works

  • How to set up and manage relationships in a data model

  • How to create a PivotTable to display your data from the Power Pivot data model

  • How to add calculated columns using DAX

  • How to use functions such as CALCULATE, DIVIDE, DATESYTD in DAX

  • All about creating Pivot Charts and PivotTables and using your data model

  • How to use slicers to adjust the data you display


Power BI

Power BI is an incredibly powerful, self-service Business Intelligence (BI) solution from Microsoft. It is the perfect Business Intelligence tool for people with limited technical experience.

In this Power BI course, we start by looking at Power Query, and how to use this tool to organize and clean our data. We then show you how to build a Data Model and relate separate tables. After that, we teach you all about the data analysis language DAX in Power BI. Finally, we look at how to present this data using the charts and graphs available.

In the Power BI course you will learn:

  • What is Power BI and why you should be using it.

  • To import CSV and Excel files into Power BI Desktop.

  • How to use Merge Queries to fetch data from other queries.

  • How to create relationships between the different tables of the data model.

  • All about DAX including using the COUTROWS, CALCULATE, and SAMEPERIODLASTYEAR functions.

  • All about using the card visual to create summary information.

  • How to use other visuals such as clustered column charts, maps, and trend graphs.

  • How to use Slicers to filter your reports.

  • How to use themes to format your reports quickly and consistently.

  • How to edit the interactions between your visualizations and filter at visualization, page, and report level.


***Exercise files included***

This course includes:

  1. 7+ hours of video tutorials

  2. 89 individual video lectures

  3. Exercise files to practice what you learned

  4. Certificate of completion


Here’s what our students are saying…


"Very detailed course, really enjoyed the Power BI section. Simon has done a really good job explaining each process step. Looking forward to completing additional Power BI courses for advance techniques."

- Martin

"Brilliant course. I'm quite new to the world of POWER and this course has shown me what it can do in a way that a newbie can understand. Recommended. I will be looking for other courses by them."

- Andrew

"Extremely clear instructions and has framed the subject matter as usable in the real world as opposed to just an academic sample. I was exposed to Power Pivot in one of my classes in college but it was presented in a way that made it difficult to apply to my work. Glad I found this course!"

- Jeff

"The best course where you can get the knowledge from Advance Excel to Power Bi. Highly recommended for Excel data analyst."

- Sabari

Content

Introduction to PowerPivot and PowerQuery

Welcome and Overview
READ ME: Essential Information for a Successful Training Experience
DOWNLOAD ME: Course Exercise Files
DOWNLOAD ME: Course Demo Files
What is Power Query?
What is Power Pivot?
Section 1 Quiz

Getting Started with Power Query

Exploring the Power Query Editor
Common Power Query Transformations
Editing an Existing Query
Import Multiple Files from a Folder
Connect to Data in Another Excel Workbook
IMPORTANT: Checking the Location of your Query's Source
Get Data From the Web
Practise Exercise
Section 2 Quiz

Useful Power Query Features

Unpivoting Columns
Combine Data from Multiple Tables with Merge Queries
Use Merge Queries to Compare Two Tables
Stack Data into One Table with Append Queries
Duplicating and Referencing Queries
Grouping and Aggregating Data
Conditional Columns in Power Query
Practise Exercise
Section 3 Quiz

Creating the Data Model

Enable the Power Pivot Add-In
Understanding the Power Pivot Window
Creating Relationships Between tables
Managing the Relationships of the Model
Creating a PivotTable from the Data Model
Hide Fields from Client Tools
Grouping Queries
Practise Exercise
Section 4 Quiz

Introduction to DAX

Why use DAX?
Creating Calculated Columns with DAX
Creating your First DAX Measure
The COUNTROWS Function
SUMX and RELATED Functions
Practise Exercise
Section 5 Quiz

More DAX Measures

Create a Date Table in Power Pivot
The CALCULATE Function
The DIVIDE Function
Using the DATESYTD Function
Calculate the Percentage of a Total
Practise Exercise
Section 6 Quiz

Using PivotTables and Slicers

Create PivotTables and PivotCharts
Using Slicers with your PivotTables
Create a Top 10 PivotTable
Practise Exercise
Section 7 Quiz

Closing

Wrap Up

Introduction to Power BI

Welcome and Overview
READ ME: Essential Information for a Successful Training Experience
DOWNLOAD ME: Course Exercise File
What is Power BI?
Install Power BI Desktop
A Tour of BI Desktop
Explore Commonly Used Power BI Options
Section 9 Quiz

Getting and Transforming Data

Import Files from a Folder into Power BI Desktop
Get Data from Excel and Text Files
Reference Queries to Create Additional Lookup Tables
Merge Queries in Power Query
Prevent Queries from Loading into Power BI Desktop
Practise Exercise
Section 10 Quiz

Data Modelling

Create Relationships Between tables
Create a Dynamic List of Dates
Create Additional Date Columns for Analysis
Sort the Month and Weekday Names Correctly
Mark the Table as a Date Table
Hide Unnecessary Fields from Report View
Practise Exercise
Section 11 Quiz

Introduction to DAX Measures

Calculate the Total Revenue
Count the Total Rows of a Table
Use the CALCULATE Function
Calculate the Total Revenue Last Year
Difference Compared to Last Year
Practise Exercise
Section 12 Quiz

Adding Visualizations to your Report

Show Summary Information with Cards
Columns Charts to Compare Values
Map Visual to Plot Geographic Data
Slicers to Filter your Reports
KPI Card to Measure Performance Against a Goal
Line Graps to Visualise Trend
Show Detail with the Matrix
Top N Lists with the Table Visualisation
Practise Exercise
Section 13 Quiz

Report Design

Adding Text Boxes and Shapes
Use Themes
Conditional Formatting
Practise Exercise
Section 14 Quiz

Editing Interactions and Filters

Edit the Interactions between your Visualisations
The Filter Pane to Filter at Any Level
Drill Through to More Detail
Practise Exercise
Section 15 Quiz

Power BI Service

Publish Your Report to the Power BI Service
Different Ways to Share your Power BI Report
Practise Exercise
Section 16 Quiz

Closing

Wrap Up

Reviews

Giel
July 7, 2023
This course is very interesting to me as i am busy with a project that involves a lot of transforming data from spread sheets to model the data for decision making
Brandon
March 17, 2023
Great course. Easy to listen to. Great pace! Learned a lot and was able to apply it to some of my own work!
Philip
February 21, 2023
This course is a great intro for those looking to break into Power Query, DAX, and Power BI. I've really enjoyed the examples and the pace that the course is taught at. Thanks and well done!
Greg
July 6, 2022
There are some differences between British / US handling of dates that are not addressed for US users of the course. Also - video speed has been slow. End of lesson questions could be a little more challenging. But course has been great thus far.
Kenneth
April 10, 2022
Good course for getting details, too much time spent on formatting items. If you're exploring Power BI or Excel at this level those are things you should already know.
Alessandra
March 9, 2022
Really useful course covering aspects of Excel I'd not yet learned (Power Query, Power Pivot), DAX which I had no awareness of and Power BI which I had played with but really had not understood. PowerBI keeps changing so some of the options esp for formatting have changed since the course was published.
Deborah
February 23, 2022
I appreciate when Alan comments on his best practices and explains why he recommends them. He also provides real use case scenarios that give a very clear understanding of why you might take one approach when transforming data, rather than another.
Delilah
February 18, 2022
I was so excited to start this course, The demo files are missing and the online support is poor. This causes frustration. Money is spent on these courses and it's very disheartening, when your questions are not addressed. If I had the files I am sure I would have benefited from this course.
Hutomo
January 25, 2022
Very easy to understand for beginners, the explanation is concise and exercise really help to understand the modul. Thanks.
Rachel
December 8, 2021
Definitely a good course, worth the time and effort. No course can give you everything, but this course is a really good place to start and get going with Power BI. I will be taking other courses through Simon Sez IT.
Anthony
October 16, 2021
Simon Sez IT course are brilliant so far, Alan is extremely good at providing meaningful example to explain difficult concepts. Overall i would recommend this course to any business analyst
Stanislav
October 15, 2021
Overall, the course is great, very comprehensible. Good point to start with. I'd like more practice in DAX though.
Andrew
June 4, 2021
Brilliant course. I'm quite new to the world of POWER and this course has shown me what it can do in a way that a newbie can understand. Recommended. I will be looking for other courses by them.
Michael
May 31, 2021
Amazing course! Alan is fantastic lecturer. Please email me with recommendations as to follow up courses you would recommend. In particular, i am keen to learn more about DAX, as i feel that setting up your data to work well is a much harder area than the actual visualizations
Martin
May 21, 2021
Very details course, really enjoyed the Power BI section. Simon has done a really good job explaining each process step. Looking forward to completing additional Power BI courses for advance techniques

Charts

Price

The Power Pivot, Power Query in Excel and Power BI Bundle - Price chart

Rating

The Power Pivot, Power Query in Excel and Power BI Bundle - Ratings chart

Enrollment distribution

The Power Pivot, Power Query in Excel and Power BI Bundle - Distribution chart
3225651
udemy ID
6/11/2020
course created date
7/24/2020
course indexed date
Bot
course submited by