Understanding microsoft self service bi
This presentation is the property of its rightful owner.
Sponsored Links
1 / 34

Understanding Microsoft Self-Service BI PowerPoint PPT Presentation


  • 81 Views
  • Uploaded on
  • Presentation posted in: General

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.

Download Presentation

Understanding Microsoft Self-Service BI

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


Understanding microsoft self service bi

Understanding Microsoft Self-Service BI

Devin Knight

[email protected]

@knight_devin


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]


Different levels of business intelligence

Different Levels of Business Intelligence

Data Explorer


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


Self service bi lifecycle

Self-Service BI Lifecycle


Understanding microsoft self service bi

  • Tables

  • 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


Data discovery with power query

Data Discovery with Power Query


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


Flavors of reporting services

Flavors of Reporting Services


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


  • Login