sql server 2012 business intelligence enterprise information management
Download
Skip this Video
Download Presentation
SQL Server 2012 Business Intelligence & Enterprise Information Management

Loading in 2 Seconds...

play fullscreen
1 / 29

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


  • 121 Views
  • Uploaded on

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.

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 ' SQL Server 2012 Business Intelligence & Enterprise Information Management' - briana


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

slide4

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

slide7

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

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

slide10

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

slide14

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
slide16

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
slide18

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
slide20

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
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
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
ad