1 / 24

Microsoft Business Intelligence

Microsoft Business Intelligence . Gavin Watson – Platform SSP: gavwat@microsoft.com. The IT Balancing Act The challenge of managing value and cost. Reduce Cost and Complexity. Deliver Business Needs. Microsoft Vision and Strategy Democratising Business Intelligence.

Jeffrey
Download Presentation

Microsoft Business Intelligence

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. Microsoft Business Intelligence Gavin Watson – Platform SSP: gavwat@microsoft.com

  2. The IT Balancing Act The challenge of managing value and cost Reduce Cost and Complexity Deliver Business Needs

  3. Microsoft Vision and StrategyDemocratising Business Intelligence Improving organisations by providing business insights to allemployees leading to better, faster, more relevant decisions • Familiar end user tools • Integrated into portal infrastructure • Secure, reliable, extensible platform

  4. Microsoft Business Intelligence Offering END USER EXPERIENCE BUSINESS PRODUCTIVITY INFRASTRUCTURE DATA INFRASTRUCTURE AND BI PLATFORM

  5. Microsoft Business Intelligence Offering END USER EXPERIENCE BUSINESS PRODUCTIVITY INFRASTRUCTURE DATA INFRASTRUCTURE AND BI PLATFORM Reporting Services Analysis Services DBMS Integration Services

  6. DATA INFRASTRUCTURE & BI PLATFORM • Common Developer Experience • SQL Server Management • ETL engine in Integration Services • OLAP engine in Analysis Services • Cube Analysis • Data Analysis • Data Mining • Report engine in Reporting Services • Developer tool • End-user Report tool VS on MSDN http://msdn.microsoft.com/en-us/vstudio/default.aspx BIDS on MSDN http://msdn.microsoft.com/en-us/library/ms173767.aspx

  7. Management Studio DATA INFRASTRUCTURE & BI PLATFORM

  8. Integration Services DATA INFRASTRUCTURE & BI PLATFORM

  9. Analysis Services DATA INFRASTRUCTURE & BI PLATFORM

  10. Reporting Services DATA INFRASTRUCTURE & BI PLATFORM

  11. Report Builder DATA INFRASTRUCTURE & BI PLATFORM

  12. Business Intelligence – Thin Client • Scorecards and Analytics • Report Centre • Excel Services • Collaboration • Search • Version Control / Compliance BUSINESS PRODUCTIVITY INFRASTRUCTURE SharePoint BI http://www.microsoft.com/bi/products/sharepoint.aspx

  13. Dashboards BUSINESS PRODUCTIVITY INFRASTRUCTURE

  14. IT Infrastructure Management BUSINESS PRODUCTIVITY INFRASTRUCTURE

  15. Performance Management Charlotte-Mecklenburg Schools : http://pmd.cms.k12.nc.us/Default.aspx BUSINESS PRODUCTIVITY INFRASTRUCTURE

  16. SharePoint BI BUSINESS PRODUCTIVITY INFRASTRUCTURE

  17. BUSINESS USER EXPERIENCE • Business Intelligence Rich-client • Cube Analysis using Excel • Data Analysis using Excel • Data Mining using Excel • Report output using Excel, Word, Powerpoint

  18. Data Mining BUSINESS USER EXPERIENCE Data Mining http://www.microsoft.com/sqlserver/2008/en/us/data-mining.aspx Excel 2007 for SSAS2008 http://www.microsoft.com/sqlserver/2008/en/us/data-mining-addins.aspx Excel 2007 for SSAS2005 http://www.microsoft.com/sqlserver/2005/en/us/data-mining.aspx#Office07

  19. Ad-hoc Analysis In Excel BUSINESS USER EXPERIENCE

  20. Investment strategy for Business Intelligence The focus on managing value and cost Investment Strategy Low Total Cost of Ownership Leverage your existing Infrastructure

  21. Futures SQL Server 2008 R2: http://www.microsoft.com/sqlserver/2008/en/us/R2.aspx http://www.microsoft.com/sqlserver/2008/en/us/R2-SSBI.aspx Project Gemini : Independent analysis: http://www.olapreport.com/Comment_Gemini.htmhttp://www.tdwi.org/News/display.aspx?ID=9386 Video: Part 1: http://www.youtube.com/watch?v=MzgMMO-P9F0 Part 2: http://www.youtube.com/watch?v=y_sBgjOHvRk http://www.youtube.com/user/geminute Blogs: http://business-intelligence.kdejonge.net/tag/excel

  22. www.microsoft.com/bi

  23. Other Resources • Best Bet Resource • Here is the place to start http://technet.microsoft.com/en-au/sqlserver/default.aspx • The SQL Server TechNet site is the best place to find the most up to date information on the BI capabilities of SQL Server including older versions. http://technet.microsoft.com/en-au/sqlserver/bb671410.aspx • Free Microsoft BI training: • Complementary Online Training: • Virtual Labs are a great way to train for free. Virtual labs are simple with no complex setup or installation required. Users will get a downloadable manual and a 90-minute block of time for each module. The list of Virtual labs  is extensive and dives deeper into the BI products in SQL Server. http://www.microsoft.com/events/series/technetsqlserver2008.aspx?tab=virtuallabs • Webcasts are less hands-on but are more extensive. http://www.microsoft.com/events/series/technetsqlserver2008.aspx?tab=webcasts • Another cross reference site is the SQL Server 2008 site http://www.microsoft.com/sqlserver/2008/en/us/learning.aspx • SQL Server 2008 Developer Training Kit • Want some FREE training on the new developer features of SQL Server 2008? Download this developer training kit from - http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=e9c68e1b-1e0e-4299-b498-6ab3ca72a6d7. • This kit contains examples, presentations, hands on labs. It works with Express Editions of SQL Server 2008 and Visual Studio. • SQL Server Community: • SQL User Group: http://www.sqlserver.org.au/ • CodePlexhttp://sqlserversamples.codeplex.com/ • StackOverflowhttp://stackoverflow.com/questions/tagged/sql-server

More Related