Lynda - Create Excel Power Pivot and Power View: Exercise Files [Via Webcentara]

seeders: 60
leechers: 40
Download torrent
Added on March 11, 2015 by webcentarain Other > Tutorials
Torrent verified.


Lynda - Create Excel Power Pivot and Power View: Exercise Files [Via Webcentara] (Size: 1.56 GB)
 Completed Dashboard.xlsx80.74 MB
 01_02 Dashboard After Import downloaded Preloaded.xlsx76.26 MB
 01_02_ImportingData Start.xlsx7.46 KB
 01_03 Dashboard Related Completed.xlsx76.35 MB
 01_03 Dashboard Related Start.xlsx76.26 MB
 desktop.ini142 bytes
 Income Bracket Customer Table.txt73 bytes
 Gross Profit FactOnLineSales Table.txt26 bytes
 desktop.ini142 bytes
 4 Same Month Last Year.txt115 bytes
 6 Previous Year.txt115 bytes
 2 Sales MTD.txt77 bytes
 3 Sales YTD.txt77 bytes
 9 MOM.txt66 bytes
 8 YOY.txt58 bytes
 5 Month over Month.txt43 bytes
 1 Sum of Sales.txt33 bytes
 7 Year Over Year.txt27 bytes
 01_04 Dashboard Calculated Fields Columns Complete.xlsx80.55 MB
 01_04 Dashboard Calculated Fields Columns Start.xlsx76.35 MB
 01_05 Dashboard Creating KPIs Start.xlsx80.55 MB
 01_05 Dashboard Creating KPIs Complete.xlsx80.55 MB
 02_01 Adding a Linked Table Complete.xlsx80.6 MB
 02_01 Adding a Linked Table Start.xlsx80.55 MB
 desktop.ini142 bytes
 GoalsByCategory.txt62 bytes
 02_02 Adding Pivot Tables to Sales Complete.xlsx80.64 MB
 02_02 Adding Pivot Tables to Sales Start.xlsx80.6 MB
 02_03 Create the Pivot Charts Complete.xlsx80.66 MB
 02_03 Create the Pivot Charts Start.xlsx80.64 MB
 02_04 Create The Pivot Tables and Charts for Customer KPI sheet Complete.xlsx80.69 MB
 02_04 Create The Pivot Tables and Charts for Customer KPI sheet Start.xlsx80.66 MB
 03_01 Adding Power View Complete.xlsx80.74 MB
 03_01 Adding Power View Start.xlsx80.69 MB
 03_02 Formating with color Complete.xlsx80.74 MB
 03_02 Formating with color Start.xlsx80.74 MB


Description

Lynda - Creating Excel Power Pivot and Power View Dashboards Ron Davis | Exersice Files Only

Subject: IT
Software: Excel

1h 12m Intermediate Nov 21, 2014 | Uploaded in Mar 10, 2015 Via Webcentara

image

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



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





Related Torrents

torrent name size seed leech

Sharing Widget


Download torrent
1.56 GB
seeders:60
leechers:40
Lynda - Create Excel Power Pivot and Power View: Exercise Files [Via Webcentara]