Presentation Transcript

1. SQL Server 2012Business Intelligence &Enterprise Information Management

   Andrew Boudreau Technical Specialist – Data Platform Microsoft Corporation
2. SQL Server 2012Further, Forward, Faster Managed Self Service BI Industry Trends Enterprise Information Management
3. 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
4. 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?
5. Evolution of BI Traditional BI Self-Service BI Provision Niche Startups Empower Manage Delivering the next generation of BI Agility with IT Oversight
6. SQL Server 2012Further, Forward, Faster Managed Self Service BI Industry Trends Enterprise Information Management
7. 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
8. DEMO - RAPID DATA EXPLORATION & VISUALIZATION PowerPivot and PowerView
9. 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
10. 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
11. 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
12. SQL Server 2012Further, Forward, Faster Managed Self Service BI Industry Trends Enterprise Information Management
13. 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
14. 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
15. Demo: Barcelona
16. 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
17. Demo:DQS Clients
18. 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
19. Demo: Master Data Services
20. 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
21. Demo: Integration Services
22. 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
23. SQL Server 2012 Links
24. 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
25. 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
26. 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
27. Microsoft SQL 2012 Solution team - Western Canada Andrew Boudreau andrewbo@microsoft.com, mobile: +1 (250) 732-1482 Raj Cheema rcheema@microsoft.com, mobile +1 (403) 585-2558 Mark Schewe Mark.Schewe@microsoft.com, mobile +1 (403) 923-8519 Darren King daking@microsoft.com, mobile +1 (403) 612-8608
28. Follow us @ SQL 2012 www.twitter.com/sqlserver www.facebook.com/sqlserver www.microsoft.com/sqlserver