LOGiN PANeL

«    April 2019    »
MoTuWeThFrSaSu
1234567
891011121314
15161718192021
22232425262728
2930 
PoLL




eBooks Tutorials Templates Plugins Scripts Applications GFX Collections WSO Stuff SCRiPTMAFiA.ORG
Support SCRiPTMAFiA.ORG
Make a donation to help us stay online
Support SCRiPTMAFiA.ORG
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 ...

RSS

FRiENDS
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.
Content:
Introduction

Introduction

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

Overview
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

Wrap-Up

Review
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:

 

Information

 
  Users of GUESTS are not allowed to comment this publication.