Lynda - Creating Excel Power Pivot and Power View Dashboards {AceMerlin}

seeders: 44
leechers: 42
Added on December 19, 2014 by AceMerlinin Other > Tutorials
Torrent verified.



Lynda - Creating Excel Power Pivot and Power View Dashboards {AceMerlin} (Size: 1.06 GB)
 AceMerlin.Torrents.nfo4.81 KB
 186873_00_02_XR15_Demonstration_of_the_dashboard_we_will_be_building.mp46.83 MB
 186873_00_03_XR15_Building_an_enviornment.mp43.54 MB
 186873_00_01_WX30_Welcome.mp42.65 MB
 186873_00_04_XR15_using_the_exercise_files.mp42.03 MB
 186873_01_04_XR151_Creating_Calculated_Fields_and_Columns.mp416.93 MB
 186873_01_02_XR15_Importing_Data.mp414.96 MB
 186873_01_03_XR15_Relating_Data.mp44.04 MB
 186873_01_01_XR15_Dashboard_Design_Guide_Lines.mp43.88 MB
 186873_01_05_XR15_Creating_KPIs.mp42.78 MB
 186873_02_02_XR15_Create_The_Pivot_Tables.mp410.58 MB
 186873_02_01_XR15_Linked_Table.mp48.02 MB
 186873_02_04_XR15_Create_The_Pivot_Tables_and_Charts_for_Customer_KPI_sheet.mp46.07 MB
 186873_02_03_XR151_Create_The_Pivot_Charts.mp43.65 MB
 186873_03_03_XR15_Reviewing_the_completed_dashboard.mp48.06 MB
 186873_03_01_XR151_Adding_Power_View.mp46.55 MB
 186873_03_02_XR15_Formating_with_color.mp42.33 MB
 186873_04_01_XR15_Next_Steps.mp42.38 MB
 Ex_Files_Power_Dash.zip979.4 MB


Description

Creating Excel Power Pivot and Power View Dashboards with Ron Davis

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
Length: 1h 12m
Released: November 21, 2014

Topics include:
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


Uploaded by Request

image



Sharing Widget


Download torrent
1.06 GB
seeders:44
leechers:42
Lynda - Creating Excel Power Pivot and Power View Dashboards {AceMerlin}