Details for this torrent 

Lynda - Creating Excel Power Pivot and Power View Dashboards Ron
Type:
Other > Other
Files:
17
Size:
143.99 MiB (150983294 Bytes)
Tag(s):
Excel
Uploaded:
2015-03-11 03:54:24 GMT
By:
2boweb VIP
Seeders:
0
Leechers:
0
Comments
0  

Info Hash:
A0EB6D3EAD3A65820B2373C81EC5901D74B52FA7




(Problems with magnets links are fixed by upgrading your torrent client!)
Lynda - Creating Excel Power Pivot and Power View Dashboards Ron Davis 

Subject:  IT 
Software:  Excel 

1h 12m Intermediate Nov 21, 2014  | Uploaded in Mar 10,  2015 by 2boweb

  
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.

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



/////////////////////////////////////////////////////////////////////////////////

01_04-Creating_Calculated_Fields_and_Columns.mp424.08 MiB
01_02-Importing_Data.mp420.45 MiB
02_02-Create_The_Pivot_Tables.mp414.3 MiB
02_01-Linked_Table.mp410.26 MiB
03_03-Reviewing_the_completed_dashboard.mp49.96 MiB
00_02-Demonstration_of_the_dashboard_we_will_be_building.mp49.11 MiB
03_01-Adding_Power_View.mp48.77 MiB
02_04-Create_The_Pivot_Tables_and_Charts_for_Customer_KPI_sheet.mp48.27 MiB
00_03-Building_an_enviornment.mp45.88 MiB
00_01-Welcome.mp45.48 MiB
01_03-Relating_Data.mp45.33 MiB
02_03-Create_The_Pivot_Charts.mp45.22 MiB
01_01-Dashboard_Design_Guide_Lines.mp44.37 MiB
01_05-Creating_KPIs.mp43.8 MiB
03_02-Formating_with_color.mp43.22 MiB
00_04-using_the_exercise_files.mp42.82 MiB
04_01-Next_Steps.mp42.7 MiB