▄▄▄ ▄▄▄
█████▄ ▄▄▄ ▄█████
▄▄▄▄ ▀█████ ▄▄█▓█████▄▄ █████ ▄▄▄ ▄▄▄▄
▄██████████▄████▓ █████████████ ████ ▄█████ ██████
███▓▀▀▀▀█████▓████ █████▀ ▀████▓ ▓███ ▄██▄ █████▓ ▓██████
░▓███▄ ▄████ ████ █████▓ ▓█████▓███ ████ ██████▄ ▄██████▓
████████████▀ ████ █████ █████████ ████▄██▄███████▄███▀████▓
▀███▄ ▄▄▄ ▄████▀ ▓████ █████████ ████████▓███ ▀██▓▀ ████
▀███▄████▄█████ ██████ ████▓█████▄▓████ ▀▀ ████ ▀ ████
▄████▄ ▀▀████████▓ ███████ ▓▓██▀███▀ ▀██████▄██▄ ███ ████
█████████ ▀█▓▀ █████▄▄ ░▓███████▄▄▄████▄██▓ ▀████████████ ████
██████████▄ ▄▄ ▀▀█████▄▄▓████▀███████▀▄███ ▄▄ ████████████ ▓▄▄▄▄ ████▓░
▓█████████████▓▓█▄▄ ▀▀▓▓█████▓░ ▀▀▀ ▄ ▀████▄ ▀██ ████████████ ████▀ ▄███▓
▀███▓▓▓█████████████▄▄▄ ▀▀███▀ ▄███████▄ ▀▀███▄ ▓ ███▓███▓████ ▓█▀ ▄███▀▀
▀▀▀ ▀▀▀▓▓███▄▄▄▄▄███████▀▀▀▀▓ ▀▀ ███▓ ▀▀ ████ ▀ ▀▓▓█▄▄
▀▀▀▀▀▀ ▀▀ ▀██▀ ▀▀▀▀▀
RELEASE NAME....: Lynda.com.Creating.Excel.Power.Pivot.and.Power.View.Dashboards-ELOHiM
RELEASE DATE....: 2014-11-21
RELEASE SIZE....: 20x50Mb
FORMAT..........: Bookware
LANGUAGE........: English
URL.............: http://www.lynda.com
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
Author: Ron Davis
Subject: IT, Business Intelligence
Software: Excel 2013
Level: Intermediate
Duration: 1h 12m
Released: Nov 21, 2014