• views: 1 819
• date: 21 November 2013
• posted by: Soomro

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.

Download     Download Mirror
   
   

Forex Trading

Crypto Trading. 20 USD Bonus after KYC

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm

0 1 2 3 4 5

| Print version |

	Information
		Users of GUESTS are not allowed to comment this publication.