1 / 10

Business Intelligence

Simon Pease combines extensive experience in Business Intelligence (BI) development, focusing on end-to-end solutions for organizations like Plan International. With a solid background in Reporting Services, he has developed various applications to optimize data aggregation and reporting for detailed analysis. His proficiency in SQL Server, including OLAP and OLTP concepts, enables him to effectively design, build, and deploy BI systems. Simon's experience includes managing diverse data sources, implementing star schemas, and utilizing tools such as SQL Server Management Studio and Integration Services for comprehensive data analysis.

mattox
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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Business Intelligence Simon Pease

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

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

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

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

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

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

  8. Demo – Star and SSIS • NwindOLTP2005 – Source Database • NwindStar2005 – Star Schema • Data issues • Re-mapping to keys in Dimension Tables • vwRawFactData • vwMappedFactData

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

  10. Demo – Report Wizard • Report Services Project • Connect AS • Drag on Measures and Dimensions, set ParametersTabular, set options • Publish to Report Server (IIS)

More Related