HOT
blank

Power BI Desktop Masterclass – Data Analysis for Everyone

Business

Power BI Desktop Masterclass – Data Analysis for Everyone, available at $39.99, has an average rating of 4.6, with 45 lectures, based on 191 reviews, and has 2008 subscribers.

Rating4.6
Enroll Now

You will learn about 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. This course is ideal for individuals who are This course is suited to those with an interest in Excel, Data Analyst's, Data Mining, BI and Reporting or 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. or This course is meant for those involved in the Analysis of Data, Finance & Accounting and Reporting roles. or This course is for you if you are looking to learn Power BI Self Service functions or This course is NOT for your if you have advanced experience with PowerBI Desktop or 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 It is particularly useful for This course is suited to those with an interest in Excel, Data Analyst's, Data Mining, BI and Reporting or 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. or This course is meant for those involved in the Analysis of Data, Finance & Accounting and Reporting roles. or This course is for you if you are looking to learn Power BI Self Service functions or This course is NOT for your if you have advanced experience with PowerBI Desktop or 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.

Enroll now: Power BI Desktop Masterclass – Data Analysis for Everyone

Summary

Title: Power BI Desktop Masterclass – Data Analysis for Everyone

Price: $39.99

Average Rating: 4.6

Number of Lectures: 45

Number of Published Lectures: 45

Number of Curriculum Items: 45

Number of Published Curriculum Objects: 45

Original Price: $129.99

Quality Status: approved

Status: Live

What You Will 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.

Who Should Attend

  • 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

Target Audiences

  • 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

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.

Course Curriculum

Chapter 1: Power BI Desktop – Course Introduction

Lecture 1: Introduction

Lecture 2: How to take this course

Lecture 3: Lets take a tour around

Lecture 4: Activity

Chapter 2: Get and Query Data

Lecture 1: Activity and Workbooks

Lecture 2: Introduction to the query editor

Lecture 3: Connect and transform data from an Excel Workbook

Lecture 4: Connect and transform folders of Data

Lecture 5: Un-pivot data

Lecture 6: Setting up a date (Calendar) table using query

Lecture 7: Connect to a .TXT file

Lecture 8: Connect to data on the Web

Lecture 9: Activity

Chapter 3: DAX

Lecture 1: Workbook

Lecture 2: DAX introduction

Lecture 3: Relationships

Lecture 4: Activity

Lecture 5: Calculated Columns

Lecture 6: Measures

Lecture 7: Activity

Lecture 8: The X – Functions

Lecture 9: Activity

Lecture 10: Relate and Related Table Expressions

Lecture 11: The Filter Expression

Lecture 12: Activity

Lecture 13: The Calculate Function

Lecture 14: Activity

Lecture 15: Other DAX expressions

Lecture 16: More on DAX

Lecture 17: More on Calculated Columns and Measures

Lecture 18: Time Intelligence functions

Lecture 19: Activity

Chapter 4: Visualizations

Lecture 1: Introduction to Visulizations

Lecture 2: The Power BI visualization canvas

Lecture 3: Line Charts and Hierarchy

Lecture 4: Adding Slicers to your Power BI dashboards

Lecture 5: Gauges, KPI's and Cards

Lecture 6: Animated Scatter Charts

Lecture 7: Activity

Lecture 8: Using Power BI for forecasting

Lecture 9: Creating a word cloud and custom visuals

Chapter 5: More on Power BI

Lecture 1: Bonus Material

Lecture 2: Staying up to date with Power BI and Preview features

Lecture 3: How to carry out a sentiment analysis on Text data

Lecture 4: Conclusion

Instructors

Rating Distribution

  • 1 stars: 1 votes
  • 2 stars: 6 votes
  • 3 stars: 35 votes
  • 4 stars: 75 votes
  • 5 stars: 74 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

Top 10 Relationship Building Courses to Learn in November 2024

Top 10 Storytelling Courses to Learn in November 2024

Top 10 Resilience Training Courses to Learn in November 2024