Business intelligence
This presentation is the property of its rightful owner.
Sponsored Links
1 / 10

Business Intelligence PowerPoint PPT Presentation


  • 71 Views
  • Uploaded on
  • Presentation posted in: General

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.

Download Presentation

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


Business intelligence

Business Intelligence

Simon Pease


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)


  • Login