1 / 23

Delivering an End-to-End Business Intelligence Solution

Required Slide. SESSION CODE: BIO205. Delivering an End-to-End Business Intelligence Solution. Peter Myers Mentor Solid Quality Mentors. Presenter Introduction. Mentor, Solid Quality Mentors BBus, MCITP (Dev, DBA, BI), MCT, MVP

infinity
Download Presentation

Delivering an End-to-End Business Intelligence Solution

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. Required Slide SESSION CODE: BIO205 Delivering an End-to-End Business Intelligence Solution Peter Myers Mentor Solid Quality Mentors

  2. Presenter Introduction • Mentor, Solid Quality Mentors • BBus, MCITP (Dev, DBA, BI), MCT, MVP • 13 years’ experience designing and developing software solutions using Microsoft products • pmyers@solidq.com

  3. Session Agenda • Using Business Intelligence (BI) • Introducing Microsoft BI • Delivering BI with Microsoft SQL Server 2008 R2 • Delivering BI with Microsoft Excel 2010 • Delivering BI with SharePoint Server 2010

  4. Using Business Intelligence (BI) See what’s happening right now Get Real-Time Information Understand variances and drill to detail to find trends Find Inefficiencies Know your cost structure and take action to ensure you hit the bottom line Save Money Focus resources where it really matters Find Profitable Customers

  5. Data Marts Staging Area Client Access Manual Cleansing Integrated Reporting and Analytics 9: Delivering BI enables a process of continuous business improvement 1: Clients need access to data 7: Manual cleansing may be required to cleanse dirty data 6: Staging areas may simplify the data warehouse population 5: Data warehouse is periodically populated from data sources 3: Data sources can be mirrored/replicated to reduce contention 2: Clients may access data sources directly 8: Clients use various tools to query the data warehouse 4: The data warehouse manages data for analyzing and reporting Data Warehouse Data Sources Client Access

  6. Microsoft’s BI Vision and Strategy To improve organizations by providing business insights to all employees, leading to better, faster, more relevant decisions • Microsoft has a long-term commitment to delivering a complete and integrated BI offering • SQL Server has led innovation in the BI space for more than a decade • There is widespread delivery of intelligence through Microsoft Office • The platforms are enterprise-grade and affordable

  7. Integrated End-To-End Offering DELIVERY COLLABORATION CONTENT MANAGEMENT SharePoint Server SEARCH Reports Dashboards Excel Workbooks Analytic Views Scorecards PowerPivot END USER TOOLS Excel PowerPivot DATA PLATFORM SQL Server Reporting Services SQL Server Analysis Services SQL Server DBMS StreamInsight SQL Server Integration Services Events

  8. Microsoft Business IntelligenceGet more out of products you already own! Familiar User Experience Self-service Access and Insight Data Exploration and Analysis Predictive Analysis Data Visualization Contextual Visualization Business User Experience Integrated Content and Collaboration Thin Clients Dashboards BI Search Content Management Compositions Business Collaboration Platform Information Platform Analysis Services Reporting Services Integration Services Master Data Data Mining Services Data Warehousing Information Platform

  9. BI for Everyone BI for Everyone Specialized BI Tools

  10. Delivering BI with Microsoft SQL Server 2008 R2

  11. 1. Delivering BI with Microsoft SQL Server 2008 R2 Peter Myers Mentor Solid Quality Mentors DEMO

  12. Delivering BI with Microsoft Excel 2010 • Provides an interface familiar to most information workers • Supports basic, advanced, and embedded analysis • Integrates with SQL Server and Analysis Services as well as other data sources • Includes a new add-in for highly-performing data integration and analysis • Enables collaboration through server workbooks shared across the Web • Supplements portals and dashboards

  13. SQL Server PowerPivot for Excel • Manages compressed storage of, and extremely fast querying and reporting from, large volumes of related tabular data • Data can be loaded from a variety of data sources • Leverages familiar Excel features • Uses Data Analysis Expressions (DAX) for sophisticated transformation of data • Supports publication of PowerPivot workbooks to SharePoint

  14. 2. Delivering BI with Microsoft Excel 2010 Peter Myers Mentor Solid Quality Mentors DEMO

  15. Introducing Microsoft SharePoint Server 2010 Sites Connect and Empower People Composites Communities Cut Costs with a Unified Infrastructure Insights Content Rapidly Respond to Business Needs Search

  16. Delivering BI with SharePoint Server 2010 • SharePoint BI capabilities are delivered through: • Reporting Services 2010 • Excel Services 2010 • SQL Server PowerPivot Add-in for SharePoint • PerformancePoint Services • Visio Services

  17. 3. Delivering BI with Microsoft SharePoint Server 2010 Peter Myers Mentor Solid Quality Mentors DEMO

  18. Required Slide Speakers, please list the Breakout Sessions, Interactive Sessions, Labs and Demo Stations that are related to your session. Related Content • BIO207 | BI Power Hour! • BIO01-HOL | Developing KPIs and Scorecards with PerformancePoint Services in Microsoft SharePoint Server 2010 • BIO02-HOL | Developing Reports and Dashboards with PerformancePoint Services in Microsoft SharePoint Server 2010

  19. Required Slide Resources Learning • Sessions On-Demand & Community • Microsoft Certification & Training Resources www.microsoft.com/teched www.microsoft.com/learning • Resources for IT Professionals • Resources for Developers • http://microsoft.com/technet • http://microsoft.com/msdn

  20. Required Slide Complete an evaluation on CommNet and enter to win!

  21. Sign up for Tech·Ed 2011 and save $500 starting June 8 – June 31st http://northamerica.msteched.com/registration You can also register at the North America 2011 kiosk located at registrationJoin us in Atlanta next year

  22. © 2010 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

  23. Required Slide

More Related