From Excel Pivot Table to Power BI Desktop

Course details

Objectives

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

Preparation

You will need tocreate a subscription for Power BI free version and download the latest versionof Power BI Desktop. Instructions will be provided.  In this course, I am using a version available in Feb2016.

Whoshould take this course

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

DifficultyLevel

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