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

seeders: 44

leechers: 42

Download torrent

Added on December 19, 2014 by AceMerlinin Other > Tutorials
Torrent verified.

Main

add to bookmarks

Lynda - Creating Excel Power Pivot and Power View Dashboards {AceMerlin} (Size: 1.06 GB)

		AceMerlin.Torrents.nfo	4.81 KB
		186873_00_02_XR15_Demonstration_of_the_dashboard_we_will_be_building.mp4	6.83 MB
		186873_00_03_XR15_Building_an_enviornment.mp4	3.54 MB
		186873_00_01_WX30_Welcome.mp4	2.65 MB
		186873_00_04_XR15_using_the_exercise_files.mp4	2.03 MB
		186873_01_04_XR151_Creating_Calculated_Fields_and_Columns.mp4	16.93 MB
		186873_01_02_XR15_Importing_Data.mp4	14.96 MB
		186873_01_03_XR15_Relating_Data.mp4	4.04 MB
		186873_01_01_XR15_Dashboard_Design_Guide_Lines.mp4	3.88 MB
		186873_01_05_XR15_Creating_KPIs.mp4	2.78 MB
		186873_02_02_XR15_Create_The_Pivot_Tables.mp4	10.58 MB
		186873_02_01_XR15_Linked_Table.mp4	8.02 MB
		186873_02_04_XR15_Create_The_Pivot_Tables_and_Charts_for_Customer_KPI_sheet.mp4	6.07 MB
		186873_02_03_XR151_Create_The_Pivot_Charts.mp4	3.65 MB
		186873_03_03_XR15_Reviewing_the_completed_dashboard.mp4	8.06 MB
		186873_03_01_XR151_Adding_Power_View.mp4	6.55 MB
		186873_03_02_XR15_Formating_with_color.mp4	2.33 MB
		186873_04_01_XR15_Next_Steps.mp4	2.38 MB
		Ex_Files_Power_Dash.zip	979.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

Sharing Widget

Download torrent

1.06 GB

seeders:44

leechers:42

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