Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Power BI Desktop Masterclass - Data Analysis for Everyone
Rating: 4.3 out of 5(191 ratings)
2,012 students

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
Created byPaula Guilfoyle CPA
Last updated 11/2017
English

What you'll 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.

Course content

5 sections • 45 lectures • 3h 2m total length

  • Introduction3:16

    A quick introduction to this course

  • How to take this course1:41

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

  • Lets take a tour around3:38

    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.

  • Activity0:15

    Carry out the following activity

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 this course is for:

  • 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

Report abuse