#FREE Creating Excel Power Pivot and Power View Dashboards #IT #Excel

All it takes to point your business in the right direction are some strategic insights from your data. In this course, author Ron Davis uses the Power Pivot and Power View plugins to build robust dashboards for analyzing key metrics in Excel?all in just over an hour. First, learn some dashboard design guidelines?such as understanding your audience and identifying necessary metrics?before getting started. Then Ron walks you through importing data, setting up calculated fields and columns, creating key performance indicators (KPIs), and building the PivotTables and PivotCharts for the dashboards. Last, find out how to add charts and eye-catching visuals with Power View, in order to make your dashboards easily understood.

LEVEL –  Intermediate

COURSE TOPICS:

Dashboard design guidelines
Importing data
Relating data
Creating calculated fields and columns
Creating KPIs
Adding a linked table to the data model
Creating PivotTables and PivotCharts
Adding Power View visualizations
Formatting with color
Reviewing the completed dashboard

READ MORE

LEARN THIS COURSE FOR FREE *10 days of free unlimited access to “Creating Excel Power Pivot and Power View Dashboards”

Instructor’s Welcome Note:

(upbeat music) – [Voiceover] Hi, I’m Ron Davis and I’m going to be your guide as we walk through this course, in which we’re going to build a dashboard using PowerPivot and Power View, two siblings that are add-ins to Excel and are terrific enhancements for using analytics and dashboards within Excel. We’re going to walk through this step-by-step and create the pivot tables and pivot charts that you see. We’ll also come in and enhance the data we bring in by adding calculated fields.
We’ll further enhance the data model by adding a calculated table in here, known as a link table. We’ll create this in Excel and then add it into the data model. We’ll look at Power View, which is a very exciting technology that allows you to easily come through and add different kinds of charts. So, let’s get started and we’re going to walk through this step-by-step.

 

 

Get 10 days of FREE unlimited access to Lynda.com.

Creating Excel Power Pivot and Power View Dashboards
Business Intelligence T
Ron Davis tutorials
Lynda review

from Course reviews, freebies, coupons http://www.coursetag.com/free-creating-excel-power-pivot-and-power-view-dashboards-it-excel/