From Excel Pivot Table to Power BI

[mitsumi]

From Excel Pivot Table to Power BI
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + .srt | Duration: 30 lectures (2h 38m) | Size: 372.9 MB

Be THE Power BI guru! Learn a new way of handling data and creating interactive dashboards with Microsoft Power BI tools

What you'll learn:
Understand what is good and bad data. Good data allows you to analyze it without wasting time in clean-up.
Identify incoming data as good or bad and clean it up very fast. (unimaginably fast)
Understand how to detect inefficiency while working and how to find the most efficient approach.
Combine transnational data with master data without using VLOOKUP
Import millions of rows of data and analyze it quickly
Learn which type of visualization to use depending upon business reuqirements
Create interactive and easy to understand dashboards using Power BI tools
Use Power BI capabilities to find out interesting but usually unseen insights about data using "Quick Insights"
Share the dashboards and reports with others in a secure manner

Requirements
You must know how to use Excel. You must also know how to use Pivot Tables.
If you do not know Pivot Tables well, you can check my "Pivot Tables: Second Honeymoon" course.

Description
Objectives

Learn a new way of gathering data and creating interactive dashboards using the new, free tool - Power BI Desktop. It is independent of Excel and therefore easier to use. Microsoft is enhancing this tool actively. This is the future of analytics and visualization. Start from scratch and then learn the entire lifecycle with Dr. Nitin Paranjape, who has been an Office MVP for 12 years and Microsoft Regional Director since 2015.

Preparation

You will need to create a subscription for Power BI free version and download the latest version of Power BI Desktop. Instructions will be provided. In this course, I am using a version available in Feb 2016.

Who should take this course

Anyone who currently works with data and generates reports will benefit from this course. The course is designed to be jargon free and easy to grasp. Even if you are an expert, you will be surprised at the simplicity and effectiveness of Dr. Nitin's approach. No knowledge of Excel or any other programming language or database is necessary. There is a module which introduces you to all the technical concepts you need to know in order to benefit from the course.

Difficulty Level

200

Topics covered:

- Power BI - the concepts

-Preparing data for Analysis in Power BI

-Creating a cohesive database

-Working with dates

-Creating reports

-Working with DAX

-Natural language Q&A

-Facebook Analytics

-Integration with Excel

Who this course is for
Do you spend lot of time in getting data, cleaning it up and creating reports? Then this course is for you.
This course is NOT for developers or SQL / Database programmers.

Screenshots

Download link:

Só visivel para registados e com resposta ao tópico.

Only visible to registered and with a reply to the topic.

Links are Interchangeable - No Password - Single Extraction