Power BI Desktop Masterclass - Data Analysis for Everyone
4.4 (93 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,664 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Power BI Desktop Masterclass - Data Analysis for Everyone to your Wishlist.

Add to Wishlist

Power BI Desktop Masterclass - Data Analysis for Everyone

Master Power BI Desktop- Get, Transform, Model and visualize data like never before - Self Service Business Intelligence
4.4 (93 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,664 students enrolled
Created by Paula Guilfoyle
Last updated 5/2017
English
Current price: $10 Original price: $150 Discount: 93% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 11 Articles
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • In this course you will learn how, with Power BI, to connect to multiple sources of data, and then how to transform that data into a usable format.
  • You will learn how, with the power of basic DAX, create powerful calculations and comparisons across multiples tables of data from multiple sources
  • And you will learn how you can visualize that data in a meaningful way to revile insights to your business like never before.
View Curriculum
Requirements
  • You will need to download the FREE Power BI Desktop software, however you will be given directions in the course on how to do this.
Description

Updated May 2017

Power BI Desktop is a combination of Excels Power Features (Power Pivot, Power Query and Power View) all in a standalone package. Using Power BI, you can find, get, transform, analyse and Combine data from disparate databases, files, and web services with visual tools that help you understand and fix data quality and formatting issues automatically. Combined with BI Service, these data queries reports and dashboard can be shared and viewed on the go.

This self-service business intelligence systems brings data analytics to the ordinary company.

COURSE SUMMARY

Power BI Desktop brings the world of data analytics and business intelligence to the ordinary business. By connecting to data from multiple sources and transforming or modelling that data, you can view and share insights to your business like never before. Being a self-service system, means you don’t need the help of and IT department to transform or model the data.

LEARN TO GATHER DATA, TRANSFORM DATA AND MODEL DATA BEFORE YOU CREATE VISUALIZATIONS TO EXPLAIN THE DATA AND SHARE VALUABLE INSIGHTS WITH YOUR ORGANISATION.

CONTENTS AND OVERVIEW

In section 1 you will learn how to download and install Power BI Desktop and you will also be given a guided tour.

In section 2 of this course we will look at getting data from multiple sources, both internal and external. Connecting to different types of files of data, Folders or data and online data.  Setting up data queries and transforming the data into a format that can be used.

In section 3 of this course we will look at Data modelling, setting up relationships, creating calculated columns and measures using DAX, using calculated tables and creating hierarchy. In addition to this we will also look at some time intelligence functions.

In section 4 of this course we will look at Data visualization. We will go through the use of different charts,Column charts, scatter charts, slicer’s, forecasting and other visualizations.  In addition to the standard visualizations you will also be introduced to Custom Visuals.

The use of Power BI is not just for numerical data, so in this course you will also learn how to use Power BI and Microsoft Cognitive Services to carry out a sentiment analysis on Text data. 


Who is the target audience?
  • This course is suited to those with an interest in Excel, Data Analyst's, Data Mining, BI and Reporting
  • This course is well suited for Accountants, Auditors, Internal Auditors, Business Analysts, Finance staff, Banking staff, Management and those involved with Compliance and Risk assessment and BI.
  • This course is meant for those involved in the Analysis of Data, Finance & Accounting and Reporting roles.
  • This course is for you if you are looking to learn Power BI Self Service functions
  • This course is NOT for your if you have advanced experience with PowerBI Desktop
  • This course is NOT for you if you require Advanced DAX language training or any of the other languages that can be used with Power BI
Students Who Viewed This Course Also Viewed
Curriculum For This Course
44 Lectures
03:01:06
+
Power BI Desktop - Course Introduction
4 Lectures 08:50

A quick introduction to this course

Preview 03:16

Before we begin this course, here is some further information about what you can expect from this course and what is expected from you 

Preview 01:41

Once the Power BI desktop installation is complete, it is a good idea to have a look around the software to get a feel for where everything is. In this lesson you will learn where you can find the option to connect to data, to carry out calculations on the data, to create visualizations. You will lean how to view the relationships view and table view.

Lets take a tour around
03:38

Carry out the following activity

Activity
00:15
+
Get and Query Data
9 Lectures 35:28

Complete the following activities

Activity and Workbooks
00:13

When you connect to data, you get the opportunity to shape, or transform that data before you pull it into Power BI.  This is done from the query editor.  In this Section we will look at Power BI Desktop to connect to, query and transform data from multiple sources

Introduction to the query editor
00:26

Learn how to connect to different sheets in a workbook and append data together along with other data transformations.

Connect and transform data from an Excel Workbook
09:46

In this lesson you will learn how to connect to a folder of data and how to create custom columns and we will have a quick look at M language

Connect and transform folders of Data
08:35

In this lesson you will learn how to unpivot data and merging queries

Un-pivot data
05:44

In this lesson you will learn how to set up a  date table query using Power BI.  Date tables are important for time intelligence calculations and period comparisons which we will look at in a later lesson

Preview 02:32

In this lesson you will learn how to connect to and transform a .txt file

Connect to a .TXT file
01:21

Learn how to connect to external data sources

Connect to data on the Web
06:41

Complete the following activity

Activity
00:09
+
DAX
19 Lectures 01:19:53

Please download this workbook to practice along and do the activities

Workbook
00:00

An explanation and overview of DAX (Data Analysis Expressions)

Preview 01:33

In this lesson you will learn how to create relationships between your tables of data

Relationships
09:17

Complete the following activity

Activity
00:07

In this lesson you will learn how to create a Calculated Column using DAX expressions

Calculated Columns
07:45

In this lesson you will learn how to create Measures using DAX expressions

Measures
04:40

Carry out the following Activities

Activity
00:06

Some functions allow you carry out calculations on different columns, these are know as the X Functions

The X - Functions
08:03

Carry out the following Activity

Activity
00:03

Measures and calculated columns can include expressions that use data from other tables.  One way of doing this is using the Related and Related table functions.

Relate and Related Table Expressions
07:21

Learn how to use the Filter Expression in DAX and the difference between the Filter function and the Filter Context when modelling data

The Filter Expression
05:33

Carry out the following activity

Activity
00:06

The Calculate function in DAX is a very powerful function that allows you replace and even remove the filter context from a report or visualization in Power BI

The Calculate Function
07:53

Carry out the following Activity

Activity
00:02

In this lesson we will look at other DAX expressions that you would be familiar with from using Excel

Other DAX expressions
01:55

In this lesson we will look at more DAX examples

More on DAX
10:11

Lets look at calculating more columns and measures

More on Calculated Columns and Measures
04:00

Power BI has a suite of Time intelligence expressions, which are not to be confused with Date functions or date expressions.  In this lesson we will look at time intelligence for comparing periods

Time Intelligence functions
11:09

Returning to the PowerBI document you created in the Get and Query Data section, carry out the same calculated columns and measures as shown in the previous 3 lessons

Activity
00:07
+
Visualizations
9 Lectures 42:35

In this lesson we will talk about different chart types such as column charts, pie charts, line charts and when they are best used for visualizations.


Preview 02:40

Look around the visualization canvas and create your first visualization 

The Power BI visualization canvas
06:21

learn how to create hierarchy to drill down on data and how to use line charts

Line Charts and Hierarchy
03:25

Learn how to add slicers to your dashboard in Power BI desktop

Adding Slicers to your Power BI dashboards
03:13

Learn how to visualize data using Gauges, KPI's and Cards

Gauges, KPI's and Cards
07:24

Learn how to create Scatter Charts 

Preview 05:23

carry out the following activity

Activity
00:04

Using Power BI for forecasting
08:56

Creating a word cloud and custom visuals
05:09
+
More on Power BI
3 Lectures 14:18
Staying up to date with Power BI and Preview features
04:17

download the sheet to get access to the code used in this lesson or visit http://theexcelclub.com/sentiment-analysis-with-power-bi-and-microsoft-cognitive-services/

How to carry out a sentiment analysis on Text data
08:14

Thank you for taking this course - conculsion

Conclusion
01:47
About the Instructor
Paula Guilfoyle
4.3 Average rating
1,418 Reviews
21,280 Students
19 Courses
CPA Accountant, Online Educator & Life Long Learner

Paula is a Qualified CPA with over 15 years' experience in the fields of Accountancy, Business Management,Process improvement, Internal Audit, Group accountant, Operations management and Training. All across a broad range of industries and sectors. Paula has been Key Speaker at many Accounting Events where her talks on Excel are received very positively. Taken from her experiences in Accounting and business fields, Paula also has Udemy courses for those wishing to up skill, especially in the area of Spreadsheets, Bookkeeping and Accounting.

Now an E-learning Educator 5+ years, Paula also has a focus on E-learning and online teaching. Drawn from her online teaching experience,Paula has a number of courses available to online teachers to help bridge the skills gap for those that teach or wish to teach online.