1 / 34

Jordan Martz

Jordan Martz. As today’s cloud-ready information platform, SQL Server 2012 will unlock breakthrough insights as well quickly build solutions and extend data across on-premises and public cloud, backed by mission critical confidence for your organization.

fawzia
Download Presentation

Jordan Martz

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Jordan Martz As today’s cloud-ready information platform, SQL Server 2012 will unlock breakthrough insights as well quickly build solutions and extend data across on-premises and public cloud, backed by mission critical confidence for your organization MCT, MCITP: SharePoint, SQL Server and SQL Server Business Intelligence Instructor

  2. Audience DB Professionals Database professionals who administer and maintain SQL Server database solutions. IT Professionals who want to become skilled on SQL Server product features and technologies for implementing a database. BI Professionals Database professionals who need to fulfill a Business Intelligence Developer role. Core Skills Everybody…

  3. PRIVATE AND PUBLIC CLOUD • DATA EXPLOSION • CONSUMERIZATION • OF IT Hosted On-premises Virtualized Private Cloud Digital data will grow 44x over the next decade (2009-2020)1 Public cloud services will account for 46% of net-new growth in IT spending in 20153 In 2011, 20% of new databases will be virtualized 2 1IDC Digital Universe Study, sponsored by EMC, May 2010. 2Microsoft internal research 3IDC, Worldwide and Regional Public IT Cloud Services 2011 – 2015 Forecast, Doc #228485, June 2011

  4. New Platform options: managed services Platform (Self Managed) Infrastructure (as a Service) Platform (as a Service) Software (as a Service) Managed Services Managed Services Managed Services

  5. Data platform requirements

  6. SQL Release timelines

  7. Data platform: sql server 2012 * New / improved in SQL Server 2012

  8. polls

  9. Online Operation Enhancements Contained Database Authentication AlwaysOn Reliable Secondaries Multi-site Clustering SQL Server Express LocalDB Windows Server Core Support Statistical Semantic Search PHP & Java Connectivity FileTable Unstructured Data Performance ColumnStore Index Extended Events Enhancements AlwaysOn Connection Director Multiple Secondaries PowerShell 2.0 Support Reporting Alerts Database Recovery Advisor SQL Server Data Tools PowerPivot Enhancements Resource Governor Enhancements T-SQL Debugger Enhancements Audit Filtering Power View Full Globe Spatial Flexible Failover Policy Unstructured Data Performance CDC Support for SSIS BI Semantic Model Audit Resilience Distributed Replay New SSIS Design Surface User-defined Audit SSMS to Windows Azure Platform Data Quality Services FTS Support for Czech and Greek 15k Partitions Master Data Management Excel Add-in Full-Text Search Performance HA for StreamInsight Availability Groups SSIS Troubleshooting Ad Hoc Reporting Default Scheme for Windows Groups Spatial 2D Support ODBC Driver for Linux SharePoint Active Directory Support SQL Audit for All Editions SSIS Package Management T-SQL Enhancements

  10. Next evolution of Visual Studio based database development tools Provides developers with a single tool to support database development needs Most developers will not need to install SSMS Free availability via Web Platform Installer Platform Targeting SQL Server Data Tools

  11. SQL Server As a Data Warehousing Platform Microsoft SQL Server Integration Services Microsoft SQL Azure and the Windows Azure Marketplace 1011000110 Data Warehousing SQL Server Database Engine SQL Server Data Quality Services SQL Server Master Data Services SQL Server Analysis Services SQL Server Reporting Services Microsoft PowerPivot Technologies Business Intelligence • Microsoft Excel • Data Mining Add-In • PowerPivot Add-In • MDS Add-In Interactive data analysis  Microsoft SharePoint Server Power View Interactive data visualizations Reports, KPIs, and Dashboards

  12. Components of a Data Warehousing Solution Reporting and Analysis Data Cleansing 1011000110 ETL Staging Process ETL Load Process Data Sources Staging Database Data Warehouse Landing Database • An ETL process extracts data from business applications and other sources • Data is typically staged before being loaded into the data warehouse • Data cleansing and deduplication ensures the quality of data in the data warehouse • Master data management provides definitive data for business entities  Master Data Management

  13. INTRODUCTION SQL SERVER ENTERPRISE INFORMATION MANAGEMENT Integration Services Master Data Services Data Quality Services • Knowledge-driven data cleansing • Corrects, de-duplicates and standardizes data • Integrates with Integration Services • Primarily designed to implement ETL processes • Provides a robust, flexible, fast, scalable and extensible architecture • Master data management • Manages reliable, centralized data • Broadens its reach with a new Excel Add-in that can leverage Data Quality Services Complete, Current, Consistent and Clean Data

  14. Extract, Transform, and Load Processes • Staging: • What data must be staged? • Staging data format • Required transformations: • Transformations during extraction versus data flow transformations • Incremental ETL: • Identifying data changes for extraction • Inserting or updating when loading

  15. Data Quality and Master Data Management • Data quality: • Cleansing data: • Validating data values • Ensuring data consistency • Identifying missing values • Deduplicating data 1011000110 • Master data management: • Ensuring consistent business entity definitions across multiple systems • Applying business rules to ensure data validity 

  16. SQL SErVER 2012 Data Quality Services DQS PROCESS Cloud Services Knowledge Management Build Enterprise Data Reference Data Discover / Explore Data / Connect Knowledge Manage Integrated Profiling Status Progress Notifications Use Correct & Standardize Match & De-duplicate Data Quality Projects

  17. Data Cleansing Projects Process of Cleansing

  18. Data Quality SerVices Process of Matching Data

  19. SQL Server 2012 Master Data Services The next-generation master data management solution delivered in SQL Server 2012

  20. The Need for Master Data Management Order Processing System Marketing System CRM ?

  21. What Is Master Data Services? Order Processing System Master Data Hub Marketing System CRM  Master Data Services Data Steward Other consumers (e.g. Data Warehouse ETL)

  22. Master Data Models • A versioned data model for specific business item or area of the business • Contains definitions for entities required in the business area • Often an entity with the same name as the model, as well as related entities • Each entity has a defined set of attributes • All entities have Code and Name attributes • Attributes can be categorized in attribute groups • Each instance of an entity is a known as a member Customers Model Version 1 Account Type Entity Member Attributes: • Code (string) • Name (string) • Code: 1 • Name: Standard Member • Code: 2 • Name: Premier Customer Entity Member • Code: 1235 • Name: Ben Smith • Address: 1 High St, Seattle • Phone: 555-12345 • AccountType: 1 • CreditLimit: 1000 Attributes: • Code (free-form text) • Name (free-form text) • Address (free-form text) • Phone (free-form text) • AccountType (domain-based) • CreditLimit (free-form number) Contact Details Attribute Group Version 3 Version 2

  23. Implementing a Master Data Hub Master Data Hub Other consumers (e.g. Data Warehouse ETL) SSIS SSIS Order Processing System Marketing System CRM  SSIS SSIS Data Steward • Users insert and update data in application data stores • Application data is loaded into the master data hub via staging tables for consolidation and management by data stewards • Master data flows back to application data stores and other consumers across the enterprise via subscription views

  24. SQL Server 2012 Analysis Services PowerView Reporting Services SharePoint Insights Third-Party Applications Excel PowerPivot Use cases DAX Query MDX Query Tabular Multidimensional Tabular Project Type PowerPivot Workbook Multidimensional Project Tabular Project Excel 2010 SQL Server Data Tools SQL Server Data Tools BI Semantic Model MDX DAX DAX Team BI Personal BI Corporate BI In-MemoryN/A MOLAPROLAP In-MemoryDirectQuery Design Type Analysis Services PowerPivot for SharePoint PowerPivot for Excel One Model for All End User Experiences Development Tool SharePoint Library / Analysis ServicesPowerPivot Analysis ServicesMultidimensional Analysis ServicesTabular Business Logic Data Access – CachePassthrough Deployment A PowerPivot workbook can be restored to a Tabular instance, or imported to create a Tabular Project RelationalDatabases LOBApplications ODataFeeds DeployedBI Semantic Model Cloud Services Files 30

  25. SQL SERVER 2012 Reporting SERVICES POWER VIEW Use Cases • Visualizations: • Matrices • Charts • Cards • Tiles • Scatter charts SQL AZURE REPORTING DATA ALERTS

  26. Microsoft Learning Data Warehousing and Business Intelligence Course 10777A: Implementing a Data Warehouse with Microsoft® SQL Server® 2012 Course 10778A: Implementing Data Models and Reports with Microsoft® SQL Server® 2012 http://www.microsoft.com/learning/

  27. Microsoft Learning Program First Look Clinic 40007A: Microsoft® SQL Server® 2012 Database Professional 10774A: Querying Microsoft® SQL Server® 2012 10775A: Administering Microsoft® SQL Server® 2012 Databases 10776A: Developing Microsoft® SQL Server® 2012 Databases Business Intelligence Professional 10777A: Implementing a Data Warehouse with Microsoft® SQL Server® 2012 10778A: Implementing Data Models and Reports with Microsoft® SQL Server® 2012 Existing SQL Server Professional 40008A: Updating your Database Skills to Microsoft® SQL Server® 2012 40009A: Updating your Business Intelligence Skills to Microsoft® SQL Server® 2012 http://www.microsoft.com/learning/

  28. Microsoft Certification Program http://www.microsoft.com/learning/

  29. Resources SQL Server 2012 Information and Downloads microsoft.com/sqlserver

  30. New MicrosoftCertifications www.netcomlearning.com

  31. SQL Server 2012 Certifications www.netcomlearning.com

  32. Upgrade Paths www.netcomlearning.com

  33. Upcoming SQL Server 2012 Classes MCSA: SQL Server 2012 (120 Hours) • March 4th in NYC & Live Online MCSA: SQL Server 2012 Boot Camp (120 Hours) • February 11th in Las Vegas & Live Online (All Inclusive Learning Package) • April 8th in DC Metro Area & Live Online MCSE: Business Intelligence (80 hours) • April 1st in New York City & Live Online MCSE: Data Platform (80 Hours) • April 22nd in New York City & Live Online Locations: Attend in-class or Live Online Instructor-led • New York • Las Vegas (All Inclusive Learning Package) • Arlington VA • Philadelphia, PA www.netcomlearning.com

  34. Q & A Contact us for training solutions for your career! www.NetComLearning.com 1-888-563-8266 www.netcomlearning.com

More Related