microsoft business intelligence
Download
Skip this Video
Download Presentation
Microsoft Business Intelligence

Loading in 2 Seconds...

play fullscreen
1 / 24

Microsoft Business Intelligence - PowerPoint PPT Presentation


  • 543 Views
  • Uploaded on

Microsoft Business Intelligence . Gavin Watson – Platform SSP: [email protected] 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.

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

PowerPoint Slideshow about 'Microsoft Business Intelligence' - Jeffrey


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
slide2
The IT Balancing Act

The challenge of managing value and cost

Reduce Cost and Complexity

Deliver Business Needs

slide3
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
Microsoft Business Intelligence Offering

END USER EXPERIENCE

BUSINESS PRODUCTIVITY INFRASTRUCTURE

DATA INFRASTRUCTURE AND BI PLATFORM

slide5
Microsoft Business Intelligence Offering

END USER EXPERIENCE

BUSINESS PRODUCTIVITY INFRASTRUCTURE

DATA INFRASTRUCTURE AND BI PLATFORM

Reporting Services

Analysis Services

DBMS

Integration Services

slide6
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
Management Studio

DATA INFRASTRUCTURE & BI PLATFORM

integration services
Integration Services

DATA INFRASTRUCTURE & BI PLATFORM

slide9
Analysis Services

DATA INFRASTRUCTURE & BI PLATFORM

slide10
Reporting Services

DATA INFRASTRUCTURE & BI PLATFORM

slide11
Report Builder

DATA INFRASTRUCTURE & BI PLATFORM

slide12
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
Dashboards

BUSINESS PRODUCTIVITY INFRASTRUCTURE

slide14
IT Infrastructure Management

BUSINESS PRODUCTIVITY INFRASTRUCTURE

slide15
Performance

Management

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

BUSINESS PRODUCTIVITY INFRASTRUCTURE

slide16
SharePoint BI

BUSINESS PRODUCTIVITY INFRASTRUCTURE

slide17
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
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
Ad-hoc Analysis

In Excel

BUSINESS USER EXPERIENCE

slide20
Investment strategy for Business Intelligence

The focus on managing value and cost

Investment Strategy

Low Total Cost of Ownership

Leverage your existing Infrastructure

futures
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

slide23
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
ad