Understanding microsoft self service bi
Download
1 / 34

Understanding Microsoft Self-Service BI - PowerPoint PPT Presentation


  • 112 Views
  • Uploaded on

Understanding Microsoft Self-Service BI. Devin Knight [email protected] @ knight_devin. About Devin. Will work for cupcakes Popup books about maintaining a healthy relationship with your miniature donkeys. And supporting cult being investigated by the government.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Understanding Microsoft Self-Service BI' - marvin


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

About devin
About Devin

  • Will work for cupcakes

  • Popup books about maintaining a healthy relationship with your miniature donkeys.

  • And supporting cult being investigated by the government.

  • Blogs mainly consist of a collection of internet cat pictures

Training Director

Author of 5 books

Runs JSSUG User Group

Blogs at BIDN.com

Twitter: @knight_devin

[email protected]



Which bi do i need
Which BI Do I Need?

Problem

I need to quickly prototype a solution to work out requirements for a larger project

Best Solution

Personal BI

Data Explorer


Which bi do i need1
Which BI Do I Need?

Problem

I need to address data quality problems with my data sources

Best Solution

Corporate BI

Data Explorer


Which bi do i need2
Which BI Do I Need?

Problem

I need one version of the truth with my data. Meaning everyone should base reports on the same data structure.

Best Solution

Corporate BI

Data Explorer


Which bi do i need3
Which BI Do I Need?

Problem

I need a more agile approach to developing BI.

Best Solution

Personal BI

Data Explorer


Self service bi roles
Self-Service BI Roles

Data Explorer



  • Tables

  • Hierarchies

  • Relationships

DataPresentation

DataExtraction

DataModeling

Power Map

Power Map

Power Map

Power View

Power View

Excel

Power Pivot

Power Pivot

Template

Power Query

Power Query

Hadoop

  • Charts

  • Charts

  • Calculations

Databases

SharePoint Lists

  • Maps

  • Apps For Office

  • Key Performance Indicators

Flat Files

Internet

  • Exporting

  • 3-D Maps

Reporting Services

Active Directory

Cloud

Facebook


When do i engage it
When Do I Engage IT?

Access

Read access is required for all necessary data sources

Scalability

When you need your solution to scale to a large user base

Data Explorer


Power pivot

Power Pivot

Why use Power Pivot?

Why is Power Pivot so Fast?

Who Should Use Power Pivot?


Different flavors of analysis services
Different Flavors of Analysis Services

LearningCurve

Analysis Service Multidimensional

Power Pivot

Power Pivot For SharePoint

Analysis Service Tabular

Scalability


Why use power pivot
Why Use Power Pivot?

Performance

Uses In-Memory Technologies Providing Unmatched Analytical Performance

Short Development Cycles

Quick and Easy to Create and End to End Solution

End User Capable

Familiar Tools with Enhanced Capabilities

300 Million Excel Users Worldwide

10% of Excel Users Create PivotTables


Introduction to dax
Introduction to DAX

What is DAX?

Data Analysis Expression Language

Query Language for Power Pivot

Why DAX?

Designed to Support a Larger User Base

Simpler than Traditional Technical Languages to Learn

Leverage Existing Knowledge of Excel Formulas

Less of a Learning Curve for Analyst


Who should use power pivot
Who Should Use Power Pivot?

  • Data Wrangler

    • Harmonize and Rationalize Data

    • Brings Together and Creates Meaning out of Data

  • Data Steward

    • Ensures data standards and cohesion

    • Develops policies and creates mechanisms to ensure policies are enforced

  • Power Analysts

    • Develops Dashboards and Interactive Reports

    • Uses Data Models Created by Data Wranglers

  • Collaborative Users

    • Add Perspective Based on Their Knowledge of the Business


Demos
Demos

Importing data into Power Pivot

Creating a Data Model in Power Pivot


Power query

Power Query

Power Query Overview

Why Use Power Query?

Who Should Use Power Query?


Ways to pull in data
Ways to Pull in Data

Data Tab

Power Pivot



Who should use power query
Who Should Use Power Query?

  • Data Wrangler

    • Harmonize and Rationalize Data

    • Brings Together and Creates Meaning out of Data

  • Data Steward

    • Ensures data standards and cohesion

    • Develops policies and creates mechanisms to ensure policies are enforced

  • Power Analysts

    • Develops Dashboards and Interactive Reports

    • Uses Data Models Created by Data Wranglers

  • Collaborative Users

    • Add Perspective Based on Their Knowledge of the Business


Demos1
Demos

Discover -> Consume -> Visualize


Power view

Power View

Power View Overview

Why Use Power View?

Who would use Power View?


Microsoft reporting options
Microsoft Reporting Options

Excel PivotTables

PowerPivot

ReportingServices

Main Purpose

Ad-hoc Analytics and Reporting

Who Uses It

Power Users

Requirements

Excel 2010 or Higher

Main Purpose

Pixel Perfect Static Reporting

Who Uses It

Developers

Requirements

SQL Server

Main Purpose

Ad-hoc Reporting

Who Uses It

End Users

Requirements

Any Version of Excel

PowerView

PerformancePoint

Main Purpose

Data Exploration

Who Uses It

End Users

Requirements

SQL 2012 / SharePoint 2010 SP1 or Excel 2013

Main Purpose

Dashboards

Who Uses It

Developers

Requirements

SharePoint 2007 or Higher



Who should use power view
Who Should Use Power View?

  • Data Wrangler

    • Harmonize and Rationalize Data

    • Brings Together and Creates Meaning out of Data

  • Data Steward

    • Ensures data standards and cohesion

    • Develops policies and creates mechanisms to ensure policies are enforced

  • Power Analysts

    • Develops Dashboards and Interactive Reports

    • Uses Data Models Created by Data Wranglers

  • Collaborative Users

    • Add Perspective Based on Their Knowledge of the Business


Demos2
Demos

Creating Power View Report


Power map

Power Map

Power Map Overview

Linking Geographical Fields to Power Map properties

Mapping Time Data

Creating a Power Map Tour


Power map overview
Power Map Overview

Power Map Features

3-D Data Visualization Tool for Excel 2013

Plots Geography Data Visually

Analyze Data on a 3-D globe Using Bing

Create Visual Tours to Share with Others


Animating maps with time data
Animating Maps with Time Data

Mapping Time Data

First Half of Bringing Life into Maps

Time Settings

Data Point Persistence

Instant

Time Accumulation

Persist the Last

Easy Date Range Filter Capabilities

Playback Speed Control


Creating a power map tour
Creating a Power Map Tour

Power Map Tours

Second Half of Bringing Life into Maps

Guided Tour of Important Elements you want to Highlight

Creating Tour Scenes

A Tour is a Collection of Scenes

Scenes can be Named and have Different Effects Applied to them


Demos3
Demos

Power Map


Power bi
Power BI

Power Pivot

Power Query

Power View

Power Map

Natural Language Search

Mobile BI


Thanks
Thanks!

Email: [email protected]

Twitter: @knight_devin

Blog: www.devinknightsql.com


ad