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