Microsoft Business Intelligence - PowerPoint PPT Presentation

Microsoft business intelligence l.jpg
Download
1 / 24

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.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

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


Microsoft business intelligence l.jpg

Microsoft Business Intelligence

Gavin Watson – Platform SSP: gavwat@microsoft.com


Slide2 l.jpg

The IT Balancing Act

The challenge of managing value and cost

Reduce Cost and Complexity

Deliver Business Needs


Slide3 l.jpg

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


Slide4 l.jpg

Microsoft Business Intelligence Offering

END USER EXPERIENCE

BUSINESS PRODUCTIVITY INFRASTRUCTURE

DATA INFRASTRUCTURE AND BI PLATFORM


Slide5 l.jpg

Microsoft Business Intelligence Offering

END USER EXPERIENCE

BUSINESS PRODUCTIVITY INFRASTRUCTURE

DATA INFRASTRUCTURE AND BI PLATFORM

Reporting Services

Analysis Services

DBMS

Integration Services


Slide6 l.jpg

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


Management studio l.jpg

Management Studio

DATA INFRASTRUCTURE & BI PLATFORM


Integration services l.jpg

Integration Services

DATA INFRASTRUCTURE & BI PLATFORM


Slide9 l.jpg

Analysis Services

DATA INFRASTRUCTURE & BI PLATFORM


Slide10 l.jpg

Reporting Services

DATA INFRASTRUCTURE & BI PLATFORM


Slide11 l.jpg

Report Builder

DATA INFRASTRUCTURE & BI PLATFORM


Slide12 l.jpg

  • 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


Slide13 l.jpg

Dashboards

BUSINESS PRODUCTIVITY INFRASTRUCTURE


Slide14 l.jpg

IT Infrastructure Management

BUSINESS PRODUCTIVITY INFRASTRUCTURE


Slide15 l.jpg

Performance

Management

Charlotte-Mecklenburg Schools : http://pmd.cms.k12.nc.us/Default.aspx

BUSINESS PRODUCTIVITY INFRASTRUCTURE


Slide16 l.jpg

SharePoint BI

BUSINESS PRODUCTIVITY INFRASTRUCTURE


Slide17 l.jpg

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


Slide18 l.jpg

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


Slide19 l.jpg

Ad-hoc Analysis

In Excel

BUSINESS USER EXPERIENCE


Slide20 l.jpg

Investment strategy for Business Intelligence

The focus on managing value and cost

Investment Strategy

Low Total Cost of Ownership

Leverage your existing Infrastructure


Futures l.jpg

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


Slide22 l.jpg

www.microsoft.com/bi


Slide23 l.jpg

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


  • Login