business intelligence
Download
Skip this Video
Download Presentation
Business Intelligence

Loading in 2 Seconds...

play fullscreen
1 / 10

Business Intelligence - PowerPoint PPT Presentation


  • 89 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