» » Pluralsight Excel An Analytics Superhub (2013)



Information of news
10-09-2013, 19:31

Pluralsight Excel An Analytics Superhub (2013)

Category: Tutorials

Pluralsight Excel An Analytics Superhub (2013)


Pluralsight Excel An Analytics Superhub (2013) | 375 MB


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
Link Download


Buy Premium To Support Me & Get Resumable Support & Fastest Speed


uploaded


Rapidgator.net
Site BBcode/HTML Code:

Tags to an Article: Pluralsight, Excel, Analytics, Superhub, 2013

Dear visitor, you went to the site as unregistered user.
We recommend you Sign up or Login to website under your name.
Information
Would you like to leave your comment? Please Login to your account to leave comments. Don't have an account? You can create a free account now.