Master Power BI Desktop and unleash the power of data analytics! A friendly guide to transform, model, and visualize your data.
This course is your friendly guide to mastering Power BI Desktop! Learn to transform, model, and visualize your data like a pro with no IT hassle!
Master Power BI Desktop- Get, Transform, Model and visualize data like never before - Self Service Business Intelligence
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.
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.
9 Lectures
19 Lectures
9 Lectures
With over 25 years of expertise in Accountancy, Business Management, and Operations, I, Paula, am a seasoned CPA (Certified Public Accountant) dedicated to empowering learners with practical skills and knowledge. As a former Microsoft MVP (Most Valuable Professional) in Excel for two consecutive years (2020 & 2021), I've been recognized for my commitment to excellence in spreadsheet solutions and financial...
I am learning a lot. For the most part I have only known the very basics of PBI. Now I am building on what I know.
I thought it was a good course. The only issue I have with online courses is the inability to ask a question, especially when something is not working as being demonstrated. That aside (and this is an issue with ALL online courses) this course was well done and worth the money.
Yes, some things I already knew , but some things were new to me.
Had very basic knowledge of Power BI previously, this course is giving me the foundation required to start my Power BI journey.
The course has a lot of good info, but at times it is hard to navigate because she is going really fast.
Excellent course, well explained and with a lot of practices
Excellent lecturer!!!
The course moves pretty quickly - I have to keep pausing the video - but that's the beauty of these self-paced courses. I'm familiar with Power Bi, so it's mostly revision for me, but I'm also learning a few new things, which is great.
This course was a good introduction to Power BI. Thanks.
Your email address will not be published. Required fields are marked *
Jololdin M.
This course is very valuable and clear to understanding. But can we get contact with Instructors real time. Thank you very much.