Sql server 2012 business intelligence enterprise information management
This presentation is the property of its rightful owner.
Sponsored Links
1 / 29

SQL Server 2012 Business Intelligence & Enterprise Information Management PowerPoint PPT Presentation


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

SQL Server 2012 Business Intelligence & Enterprise Information Management. Andrew Boudreau Technical Specialist – Data Platform Microsoft Corporation. SQL Server 2012 Further, Forward, Faster. Managed Self Service BI. Industry Trends. Enterprise Information Management.

Download Presentation

SQL Server 2012 Business Intelligence & Enterprise Information Management

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


Sql server 2012 business intelligence enterprise information management

SQL Server 2012Business Intelligence &Enterprise Information Management

Andrew Boudreau

Technical Specialist – Data Platform

Microsoft Corporation


Sql server 2012 further forward faster

SQL Server 2012Further, Forward, Faster

Managed Self Service BI

Industry Trends

Enterprise Information Management


State of business intelligence

State of Business Intelligence

Only 28% of potential BI users have any meaningful access

32% of Excel users are comfortable with using it for “Advanced Analysis” e.g., PivotTables

31% of all BI initiatives partially meet or don’t meet the business goals originally set

– Business Intelligence Purchase Drivers and Adoption Rates, Gartner

– BI Survey 9, BARC

– Excel Segmentation Research

Requirements change way too fast for IT and traditional technology to keep up.

Knowledge workers spend too much time looking for, not enough time analyzing the information.

Lines between producers and consumers of information have largely disappeared.

Agile BI Out of The Box, Forrester Research, Inc., April 22, 2010


Sql server 2012 business intelligence enterprise information management

Evolution of BI

Traditional BI

Self-Service BI

Provision

Analysis

Reports

Dashboards & Scorecards

Data

Staging

Analysis

Cubes

Data Warehouse

ETL/Data Quality

Specialized Tools

?

End Users

Spreadsheets

Existing Data

IT Pro

LOB Applications

Data Marts

Files

IT has been busy keeping up with the growing demand for BI…

Harvesting existing data, cleaning it and staging it …

To provision reports, dashboards & scorecards to meet End User demand.

But business is outpacing IT and End Users are demanding Agility …

Rapidly breaking down the barriers of Control with Self-Service BI!

Is it possible to balance Control with Agility?


Evolution of bi

Evolution of BI

Traditional BI

Self-Service BI

Provision

Niche Startups

Empower

Manage

Delivering the next generation of BI Agility with IT Oversight


Sql server 2012 further forward faster1

SQL Server 2012Further, Forward, Faster

Managed Self Service BI

Industry Trends

Enterprise Information Management


Sql server 2012 business intelligence enterprise information management

One Model for All End User Experiences

Personal BI

Team BI

Organizational BI

Empowered

Aligned

Our Context

BI Solution created by power user. Context is for a small team & it’s managed on a server.

The Org’s Context

BI Solution created by IT, Established corporate context & is reusable, scalable and backed up.

My Context

BI solution created by user. Context is only for user & exists as document.

PowerPivot For Excel

PowerPivot For SharePoint

Analysis Services


Demo rapid data exploration visualization powerpivot and powerview

DEMO - RAPID DATA EXPLORATION & VISUALIZATION PowerPivot and PowerView


Managed self service bi

MANAGED SELF-SERVICE BI

We can balance our employees’ need for rich information and collaboration with IT’s need to manage the safety & confidentiality of information.

-CareGroup Healthcare System

End user

created,IT managed

Single

Administration

from SharePoint

Gain insight

& oversight with

IT dashboards


Sql server 2012 business intelligence enterprise information management

  • BI Semantic Model

PowerPivot

Applications

Reporting Services Reports

Excel

Workbooks

Third-Party BI Applications

SharePoint

Dashboards & Scorecards

BI Applications

Relational

Multidimensional

Data Model

DAX

MDX

BI Semantic Model

BI Semantics

xVelocity

Realtime

Data Access

Odata

Feeds

Data Sources

Files


Xvelocity

xVelocity

  • Column Store Index

  • Faster, interactive query response time

    • Easier data exploration

    • Better decision

  • Reduced physical DB design effort

    • Fewer indexes

    • Reduced need for summary aggregates and indexed views

    • May eliminate need for OLAP cubes

    • Transparent to the application

  • Less hardware needed for given workload


Sql server 2012 further forward faster2

SQL Server 2012Further, Forward, Faster

Managed Self Service BI

Industry Trends

Enterprise Information Management


Enterprise information management

Enterprise Information Management

Data Quality Services

Master Data Services

CLEANSE

MANAGE

Integrate

Integration Services

Barcelona

Integrated Deployment & Management

Data Cleansing

& Matching

Ensure Accurate,

Trustworthy data


Sql server 2012 business intelligence enterprise information management

Project Barcelona key features…

Minimal Investment

Incremental Investment

Open & Extensible

  • New crawlers, UIs added over time

  • In-house customized solutions

  • Opportunity for partners

  • No up front planning, modeling, ongoing maintenance

  • Out of the box, just starts working

  • As more of the enterprise is crawled, more and more dependencies are uncovered


Demo barcelona

Demo: Barcelona


Sql server 2012 business intelligence enterprise information management

Data Quality Services is…

Knowledge-driven

Easy To Use

Open & Extensible

  • Rich Knowledge Base

  • Continuous improvement and knowledge acquisition

  • Build once, reuse for multiple DQ improvements

  • Focus on productivity and user experience

  • Designed for business users

  • Out-of-the-box knowledge

  • Focus on cloud-based Reference Data

  • User-generated knowledge

  • Integration with SSIS


Demo dqs clients

Demo:DQS Clients


Sql server 2012 business intelligence enterprise information management

Master Data Services Provides you tools to…

Enable

Integrate

Manage

  • Self-service management with MDS Add-in for Excel

  • Enable users to build simple solutions

  • Data Stewards work in familiar tools like Excel

  • New Entity Based Staging

  • Subscription views

  • WCF API programmability

  • Integration with Data Quality Services

  • Manage data that is worth managing for its consumer

  • Modeling of Entities, Attributes, Hierarchies

  • Role-based Security, Transaction Annotation, Versioning, and Validation


Demo master data services

Demo: Master Data Services


Sql server 2012 business intelligence enterprise information management

SSIS Server Gives You…

Integration

Easy To Use

Management

  • Data Quality Services task integrates with Knowledge bases

  • Entity based staging facilitates loading of MDS entities

  • Consumed by Barcelona crawler

  • Built in tasks for workflow, dataflow and event handlers

  • Easy consumption/integration with MDS, Barcelona and DQS

  • Out-of-the-box logging

  • Interactive package execution and SQL Agent integration

  • Dashboard and built in reports for troubleshooting

  • Central connection manager configuration


Demo integration services

Demo: Integration Services


Sql 2012 now available

SQL 2012 NOW AVAILABLE

INSIGHTS

SQL Server 2012 Business Intelligence

  • PowerPivot & Power View

  • Analysis Services

  • Reporting Services

  • Integration Services

  • Data Quality Services

  • Master Data Services

RELATIONAL

NON-RELATIONAL

  • Hadoop Connectors for SQL Server and PDW

  • Hadoop based service for Windows Azure CTP2

  • Hive ODBC driver and Excel Add-In CTP2

  • SQL Server 2012 Database with xVelocity

  • SQL Server PDW AU3

  • Fast Track for SQL Server 2012


Sql server 2012 business intelligence enterprise information management

SQL Server 2012 Links


Next steps

Next Steps

  • Download and evaluate SQL Server 2012 - www.microsoft.com/sqlserver

  • Learn more about SQL Server 2012

    Additional resources

    Webcasts (200-300)

  • Engage with your solution specialist for the detailed SQL Server 2012 TCO assessment

  • Do business value assessment for SQL Server 2012 Migration- http://sqlmigrationbva/

  • Get ready for deployment & Find a partner doing Microsoft SQL 2012 deployment planning services

    http://directory.partners.extranet.microsoft.com/psbproviders/ProviderListing.aspx?i=1&pst=IWSSD&pcn=&cty=0&stpr=0&cntry=124&seg=0&lev=0&slan=0


Sql 2012 additional recourses

SQL 2012 Additional Recourses

  • SQL Server 2012 Learning Center Resources

  • SQL Server 2012 Virtual labs

  • SQL Server 2012 Business Intelligence

  • Database Management

  • Enterprise Data Warehousing

  • Appliances

  • Hybrid-IT

  • SQL Server 2012 Mission Critical Confidence

  • SQL Server 2012 Enterprise Information Management


Sql server 2012 webcasts

SQL Server 2012 webcasts

  • The Baker's Dozen Webcasts

  • Breakthrough Insights using Microsoft SQL Server 2012 : Analysis Services and Credible, Consistent data

  • Breakthrough Insights using Microsoft SQL Server 2012 : Reporting Services and Visualization

  • Breakthrough Insights using Microsoft SQL Server 2012 : Scalable Data Warehouse and Beyond Relational

  • Cloud on your terms with Microsoft SQL server 2012 : Scale On Demand

  • Mission Critical Confidence using Microsoft SQL Server 2012


Microsoft sql 2012 solution team western canada

Microsoft SQL 2012 Solution team - Western Canada

  • Andrew Boudreau

    [email protected],

    mobile: +1 (250) 732-1482

  • Raj Cheema

    [email protected],

    mobile +1 (403) 585-2558

  • Mark Schewe

    [email protected],

    mobile +1 (403) 923-8519

  • Darren King

    [email protected],

    mobile +1 (403) 612-8608


Follow us @ sql 2012

Follow us @ SQL 2012

  • www.twitter.com/sqlserver

  • www.facebook.com/sqlserver

  • www.microsoft.com/sqlserver


  • Login