microsoft bi 2013

54
Microsoft Business Intelligence KEVIN CARTER MANAGING CONSULTANT

Upload: thecomputersolutioncompany

Post on 29-Nov-2014

275 views

Category:

Technology


0 download

DESCRIPTION

 

TRANSCRIPT

Page 1: Microsoft bi 2013

Microso ft Bus iness In te l l igence

KEVIN CARTERM A N A G I N G C O N S U L T A N T

Page 2: Microsoft bi 2013

THE ISSUES

Do more with less

Get the job done, wherever you are

Focus your efforts and deliver results

You need to stretch fewer resources to accomplish more.

To get the job done fast, your people require the freedom to work wherever they need to be.

You need to focus on informing your decision making with the best information available.

Page 4: Microsoft bi 2013

LEVERAGE EXISTING INVESTMENTS

Page 5: Microsoft bi 2013

LEVERAGE EXISTING INVESTMENTS

Analysis Services

Data Quality Services

Master Data Services

Integration Services

Database Server

Reporting Services

Page 7: Microsoft bi 2013

DELIVER CROSS PLATFORM

Page 8: Microsoft bi 2013

DELIVER CROSS PLATFORM

44% of CIO’s said business intelligence was one of their top priorities for technology spending in 2013.

40% of CIO’s said mobile technologies were one of their top priorities for 2013.

In 2014 spending on mobile devices will overtake spending on fixed devices.

57% of companies plan to provide tablets for some employees in 2013, or already do.

* Wall Street Journal Monday, September 16, 2013

Page 10: Microsoft bi 2013

DELIVER CROSS PLATFORM

Excel Services• Worksheet as Web Page

• Central Publishing Location

• High Fidelity Rendering

• Interactive

Page 11: Microsoft bi 2013

DELIVER CROSS PLATFORM

Reporting Services• Integrated with SharePoint

• New Rendering Options• Surface and Apple Devices

• Excel

• Word

Page 12: Microsoft bi 2013

REPORTING SERVICES• Support for Mapping Data

• Multiple Map layers

Page 13: Microsoft bi 2013

REPORTING SERVICES

Page 14: Microsoft bi 2013

DELIVER CROSS PLATFORM

Power View• HTML5 Support Coming

Soon

• Office 365 Preview

Page 15: Microsoft bi 2013

POWER VIEW

Visual Design ExperienceRich InteractivityPresentation Ready

Page 16: Microsoft bi 2013

POWER VIEW

• Multiple Views Per Report

Page 17: Microsoft bi 2013

POWER VIEW

Page 18: Microsoft bi 2013

POWER VIEW

Page 19: Microsoft bi 2013

POWER VIEW

Page 20: Microsoft bi 2013

POWER VIEW

• Overlapping Elements

Page 21: Microsoft bi 2013

DELIVER DATA VALUE

Page 22: Microsoft bi 2013

ANALYTICS DEFINED

…the discovery and communication of meaningful patterns in data.

Page 23: Microsoft bi 2013

DELIVER DATA VALUE

1

2

3

Use Microsoft Excel to easily find, combine and explore multiple sources of data.

Make data your differentiator, with easy dashboards, visualizations and analysis using familiar Office tools.

Share insights and work together around data to make faster, better-informed decisions.

Page 24: Microsoft bi 2013

WHY EXCEL?

With Microsoft Excel, you can get to the information you need and make sense of it—without a learning curve.

Page 25: Microsoft bi 2013

POWER QUERY

Search and Access Public Data and Organization Data

Clean, Transform and Merge Data

Page 26: Microsoft bi 2013

POWER PIVOT

Perform Fast Analytics with In-Memory Technology

Create Relationships, Custom Measures and Hierarchies

Page 27: Microsoft bi 2013

INTO THE FUTURE

?

Page 28: Microsoft bi 2013

POWER MAP

Stunning Interactive Visualizations

Depth with 3D Geospatial Analysis

Interactive Data Views and Tours

?

Page 29: Microsoft bi 2013

POWER MAP ?

Page 30: Microsoft bi 2013

POWER BI

• Share Data & Insights

• Get Answers

• Access Anywhere

?

Page 31: Microsoft bi 2013

SITES ?

Page 32: Microsoft bi 2013

Q&A ?

Page 33: Microsoft bi 2013

Q&A ?

Page 34: Microsoft bi 2013

DATA MANAGEMENT ?

Page 35: Microsoft bi 2013

STORE APP ?

Page 36: Microsoft bi 2013

DELIVERY EXAMPLES

Page 37: Microsoft bi 2013

IT Software QA

Page 38: Microsoft bi 2013

IT Service Desk

Page 39: Microsoft bi 2013

PC Service Desk

Page 40: Microsoft bi 2013

Manufacturing

Page 41: Microsoft bi 2013

Operations

Page 42: Microsoft bi 2013

Education

Page 43: Microsoft bi 2013

Public Safety

Page 44: Microsoft bi 2013

Mini Dashboards

Page 45: Microsoft bi 2013

Sales Dashboard

Reporting Services

Page 46: Microsoft bi 2013

Sales Dashboard

Page 47: Microsoft bi 2013

Vendor Payments Dashboard

Reporting Services

Page 48: Microsoft bi 2013

Sales Dashboard

Reporting Services

Page 49: Microsoft bi 2013

International Non-Profit

Page 50: Microsoft bi 2013

Branded Power View

Page 51: Microsoft bi 2013

CFO Center

Page 52: Microsoft bi 2013

• Architectural Design• Data Integration• Security Planning• Data Modeling• Report Design &

Development• Dashboards and Scorecards

DATA REIMAGINED

Page 53: Microsoft bi 2013

LET’S GET STARTEDWe’re ready as soon as you are.

Page 54: Microsoft bi 2013

KEVIN CARTER | [email protected] A N A G I N G C O N S U L T A N T

THANK YOU