data warehousing in sql server 2005 2008 business intelligence n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
DATA WAREHOUSING IN SQL SERVER 2005/2008 BUSINESS INTELLIGENCE PowerPoint Presentation
Download Presentation
DATA WAREHOUSING IN SQL SERVER 2005/2008 BUSINESS INTELLIGENCE

Loading in 2 Seconds...

play fullscreen
1 / 19

DATA WAREHOUSING IN SQL SERVER 2005/2008 BUSINESS INTELLIGENCE - PowerPoint PPT Presentation


  • 113 Views
  • Uploaded on

DATA WAREHOUSING IN SQL SERVER 2005/2008 BUSINESS INTELLIGENCE. Experience with BI. Developing end-to-end BI prototype for Plan International Extensive project experience with Reporting Services Books, courses, exams and played

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 'DATA WAREHOUSING IN SQL SERVER 2005/2008 BUSINESS INTELLIGENCE' - didina


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
data warehouse business intelligence
DATA WAREHOUSE = BUSINESS INTELLIGENCE
  • Business Intelligence (BI) refers to skills, processes, technologies, applications and practices used to support decision making.
    • historical, current, and predictive views
    • reporting, OLAP, analytics, data mining, business performance management, benchmarking, text mining, and predictive analytics.
  • A data warehouse is a repository of an organization's electronically stored data. Data warehouses are designed to facilitate reporting and analysis.
    • business intelligence tools, tools to extract, transform, and load data into the repository, and tools to manage and retrieve metadata.
basic concepts
BASIC CONCEPTS
  • Universal Dimensional Model
  • Cube
    • Drill-down
    • Roll-up
  • Online Analytical Processing (OLAP)
slide11
To create a new Analysis Services project, follow these steps:
  • Select Microsoft SQL Server 2005 > SQL Server Business Intelligence Development Studio from the Programs menu to launch Business Intelligence Development Studio.
slide12
To define a Data source for the new cube, follow these steps:
  • Right-click on the Data Sources folder in Solution Explorer and select New Data Source.
slide13
To create a new data source view, follow these steps:
  • Right-click on the Data Source Views folder in Solution Explorer and select New Data Source View.
slide15
To create the new cube, follow these steps:
  • Right-click on the Cubes folder in Solution Explorer and select New Cube.
terminologies
Terminologies
  • Cube

The basic unit of storage and analysis in Analysis Services is the cube. A cube is a collection of data that’s been aggregated to allow queries to return data quickly.

  • Dimension

Each cube has one or more dimensions, each based on one or more dimension tables. A dimension represents a category for analyzing business data

  • Fact table

A fact table contains the basic information that you wish to summarize. This might be order detail information, payroll records, or anything else that’s amenable to summing and averaging.

where to get sql server
WHERE TO GET SQL SERVER
  • UNCC MSDNAA:
    • http://msdn04.e-academy.com/elms/Storefront/Home.aspx?campus=uncc_cit
  • SQL Server 2005 Standard Edition
  • SQL Server 2008 Developer Edition
  • SQL Server 2008 Enterprise Edition