«    April 2019    »

eBooks Tutorials Templates Plugins Scripts Applications GFX Collections WSO Stuff SCRiPTMAFiA.ORG
Make a donation to help us stay online
LaST oN NULLeD.org
We Die Young 2019 1080p BluRay x264-BRMP We Die Young 2019 1080p ...
We Die Young 2019 720p BluRay x264-BRMP We Die Young 2019 720p BluRay ...
The Upside 2017 1080p WEB-DL DD5.1 H264-FGT The Upside 2017 1080p WEB-DL ...
Dormant 2019 AMZN WEB-DL DDP5.1 H264-CMRG Dormant 2019 AMZN WEB-DL ...
Escape Room 2019 BRRip AC3 x264-CMRG Escape Room 2019 BRRip AC3 ...


Nulled.org Software SEOMAFiA URL Shortener Money for webmaster

Pluralsight: Excel - An Analytics Superhub

Category: Tutorials
Download Pluralsight: Excel - An Analytics Superhub

Pluralsight: Excel - An Analytics Superhub

Pluralsight: Excel - An Analytics Superhub
English | WMV | 1024 x 768 | WMV3 ~31.1 kbps | 15 fps
WMA | 128 Kbps | 44.1 KHz | 2 channels | 3h 02m | 294 MB
Genre: Video Tutorial / Bisiness Intelligence & Reporting (2013)

A look at the analytics capabilities in the core Excel product and its add-ins, including PowerPivot, Power View, "Data Explorer" and "GeoFlow," as well as an investigation into how to use these tools together.


Excel as a BI Tool

Excel's Ubiquity and Strategic Importance for BI
Excel Analytics Facilities and Workflow

Data Management and Modeling: Core Excel and the Excel Data Model

Core Excel BI
Demo: Web Queries and The Data Connection Wizard
Office Data Connections
Demo: Managing Office Data Connections
Analysis Services Support
Demo: Querying an OLAP Cube
The Excel Data Model
The BI Semantic Model

Data Management and Modeling: PowerPivot

Features Overview
Obtaining the Add-In, Data Import
Demo: Data Import and Setting Relationships
Advanced Modeling
Demo: Advanced Modeling, Querying in Excel

Data Discovery and Visualization: Power View

Creating Reports
Demo: Power View Basics
Maximize, Filters and Bubble Charts
Demo: Filters, Bubble Charts and the Play Axis
Advanced Properties

Data Acquisition: "Data Explorer"

Overview, Data Sources and Tie-Ins with Excel Data Model
Demo: Importing Web and Facebook Data
Data Shaping, Data Manipulation and Integrating Child Data
Demo: Importing, Shaping and Visualizing HDInsight (Hadoop) Data
Data Formulas, Scripts and the 'M' langauge
Demo: Working with Data Steps and Scripts

Mapping: "GeoFlow"

Overview and First Steps
Demo: Mapping the Hadoop Data
Chart Types, Controls and Visual Elements
Demo: Bubble Charts, Heat Maps, Panning, Zooming, and Themes
Layers, Scenes and Tours
Demo: Working with Layers, Building Scenes and Tours

How SharePoint Ties In

Overview and Excel Services/Excel Web App
Demo: Excel Analytics in the Excel Web App on Office 365
PowerPivot and Power View
PerformancePoint/Reporting Services, Analysis Services Clients


Upsides, Downsides, Reference Links

Exercise Material includes only Slides, no code files. dle 10.6

Download Pluralsight: Excel - An Analytics Superhub
Download     Download Mirror

Related news:



  Users of GUESTS are not allowed to comment this publication.