Business intelligence
Download
1 / 10

Business Intelligence - PowerPoint PPT Presentation


  • 85 Views
  • Uploaded on

Business Intelligence. Simon Pease. Experience with BI. Developing end-to-end BI prototype for Plan International Extensive project experience with Reporting Services Books, courses, exams and played Developed numerous reporting apps that should have been BI solutions!. Concepts.

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 'Business Intelligence' - mattox


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

Experience with bi
Experience with BI

  • Developing end-to-end BI prototype for Plan International

  • Extensive project experience with Reporting Services

  • Books, courses, exams and played

  • Developed numerous reporting apps that should have been BI solutions!


Concepts
Concepts

  • Business Intelligence

    • Organisation-wide perspective

    • Combining data from diverse systems

    • High level aggregation to detailed drill-down

  • Relational data not designed for BI

    • Narrow focus on specific business requirement

    • OLTP for speed of entry and integrity

    • OLAP (On-line Analytical Processing) for aggregating large data volumes


Core processes
Core Processes

  • ELT (Extract, Load, Transform)

    • Import, clean and combine diverse data

    • Store in Data Warehouse

  • Star Schema

    • Relational structure for OLAP, not OLTP

  • Cubes

    • Pre-aggregate results (sum, count)

  • Reporting

  • (Data Mining and Prediction)


Sql server 2005
SQL Server 2005

  • SQL Server Management Studio

    • Design and query databases

    • Replaces Enterprise Manager, Query Analyser

    • Manage Servers (DB, AS, RS, IS)

  • SQL Server Business Intelligence Studio

    • VS .NET 2005 projects

    • Design, build and deploy


Business intelligence studio
Business Intelligence Studio

  • Integration Services

    • Data import and transform (replaces DTS)

    • Merge data into Star Schema

  • Analysis Services

    • Design and populate Cubes

  • Report Model

    • ERD for reporting

  • Report Server

    • Design and publish reports


Star schema
Star Schema

  • Star focuses on business area

    • Sales, Logistics

  • Fact Table stores numeric measures

    • Order Value, Order Quantity

  • Dimension Tables

    • How data is analysed (aggregates and heirarchies)

    • Product, Customer, Time


Demo star and ssis
Demo – Star and SSIS

  • NwindOLTP2005 – Source Database

  • NwindStar2005 – Star Schema

  • Data issues

    • Re-mapping to keys in Dimension Tables

    • vwRawFactData

    • vwMappedFactData


Demo as cube
Demo – AS Cube

  • Turn on Services (AS, SQL Browser)

  • Set up Data Source and Data Source View

    • Warning – use Service Account

  • Run wizard to create the Cube

  • Configure Deployment Options

  • Process and Deploy

    • Browse in Management Studio – drag on dimensions and measures


Demo report wizard
Demo – Report Wizard

  • Report Services Project

  • Connect AS

  • Drag on Measures and Dimensions, set ParametersTabular, set options

  • Publish to Report Server (IIS)


ad