Sql server 2008 for business intelligence
This presentation is the property of its rightful owner.
Sponsored Links
1 / 46

SQL Server 2008 for Business Intelligence PowerPoint PPT Presentation


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

SQL Server 2008 for Business Intelligence. UTS Short Course. Recap. Cubes What is a cube? Measures/Facts? Dimensions? Hierarchies? Time Dimensions? Cube Browser? Why?. Session 3: Reporting Services. What is SQL Reporting Services? Steps in Creating a Report Demo: Creating a Report

Download Presentation

SQL Server 2008 for 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


Sql server 2008 for business intelligence

SQL Server 2008 for Business Intelligence

UTS Short Course


Recap

Recap

  • Cubes

    • What is a cube?

    • Measures/Facts?

    • Dimensions?

      • Hierarchies?

    • Time Dimensions?

    • Cube Browser?

  • Why?


Session 3 reporting services

Session 3: Reporting Services

  • What is SQL Reporting Services?

  • Steps in Creating a Report

  • Demo: Creating a Report

  • Hands on Lab


Why are we doing this

Why are we doing this?


Business intelligence defined

Business Intelligence Defined

Business intelligence (BI) is a broad category of applications and technologies for gathering, storing, analyzing, and providing access to data to help enterprise users make better business decisions.

Answer questions


The plan

The plan


Step by step to bi

Step by step to BI

  • Create Data Warehouse

  • Copy data to data warehouse

  • Create OLAP Cubes

  • Create Reports

  • Do some Data Mining

    • Discovering a Relationship that was not obvious

    • Predict future events (e.g. targeting and forecasting)


Sql server 2008 for business intelligence

SSRS


What is sql server reporting

What is SQL Server Reporting?

  • Reporting platform

    • Traditional

    • Interactive reports

  • Scalable and manageable server infrastructure

  • Integrated with

    • SharePoint

    • Office applications

    • Browser and other familiar tools

  • Single platform and tools for all types of structured data

    • Relational

    • Hierarchical

    • Multidimensional


Sql server bi platform

SQL Server BI Platform

Reporting Services

Development Tools

Management Tools

Analysis Services

OLAP & Data Mining

Integration

Services

ETL

SQL Server

Relational Engine


Reporting lifecycle

Authoring

Management

Delivery

Reporting Lifecycle

  • Reporting Services is an open and extensible platform supporting the authoring, management and delivery of rich, interactive reports to the entire enterprise.


Report authoring

Report Authoring


Report authoring1

Report Authoring

  • Reports are defined in Report Definition Language (RDL), a documented XML schema

  • Use Microsoft or 3rd party tools that support RDL

  • Create single reports from multiple data sources(SQL, OLE DB, ODBC, Oracle, and .NET data providers)

More info on the RDL spec: www.microsoft.com/sql/reporting


Report authoring controls

Report Authoring - Controls

  • Data regions

    • Tablix (New in SQL 2008)

      • Table

      • List (like Access)

      • Matrix

    • Chart

    • Gauge

  • Subreports

  • Images

  • Custom Controls


Tablix

Tablix

  • Generalized layout report item

    • Grouped and Detail data


Tablix table

Tablix - Table

  • Use a table to display detail data

  • Organize the data in row groups, or both.

  • The Table template contains three columns with a table header row and a details row for data.


Tablix matrix

Tablix - Matrix

  • Use a matrix to display aggregated data summaries

  • Grouped in rows and columns, similar to a PivotTable or crosstab.

  • The number of rows and columns for groups is determined by the number of unique values for each row and column groups


Tablix list

Tablix - List

  • Use a list to create a free-form layout. You are not limited to a grid layout, but can place fields freely inside the list.

  • You can use a list to design a form for displaying many dataset fields or as a container to display multiple data regions side by side for grouped data.


Charts

Charts


Charts1

Charts


Charts2

Charts


Gauge

Gauge


Interactive reports

Interactive reports


Drill through reports

Drill-through Reports

  • Start in Report Builder

  • Get the data you want

  • In report properties choose Allow users to drill to this report option

  • Optionally customize in Report Designer


Interactivity

Interactivity

  • Document maps

  • Collapse / Expand

  • Actions


Report management

Report Management


Report management1

Report Management

  • Report definitions, folders, and resources are published and managed in a reporting web service

  • Managed reports can be executed either on-demand or via schedule and can be cached for consistency and performance

  • Scalable & Extensible server architecture


Sql server reporting architecture

SQL Server Reporting Architecture


Report manager

Report Manager


Configuration manager

Configuration Manager


Report delivery

Report Delivery


Report delivery1

Report Delivery

  • Traditional (paper) and interactive (web) reports

  • On-demand (“pull”) or event-based (“push”) delivery

  • Choose from multiple formats (HTML, Excel, PDF, XML, Word)

  • Deliver reports to many devices (e-mail, file share, etc.)

  • Ad-hoc Reporting


Ssrs and ssas working together

SSRS and SSAS – Working Together

Standard reports

Ad hoc reports

Detail reports

SSAS

SSRS

  • Intuitive reporting

  • Interactive analysis

  • High performance

  • Powerful calculations

  • Detail reporting

  • Standard reporting

  • Ad hoc reporting

  • Flexible delivery


Ssas and reporting services

SSAS and Reporting Services

Data Layer

SSAS

Presentation Layer

UnifiedDimensionalModel

ETL

DB1

Interactive reporting

UDM

DB2

DW

Standard reporting

DB3

multiple data sources supported

Ad hoc reporting

  • Dimensional schema = intuitive reporting

  • SSAS for better performance and business metrics

  • UDM serves many reporting needs


Report builder

Report Builder


Report builder v2

Report Builder v2


It s fantastic but

It’s fantastic but….

  • It doesn’t ship with SQL 2008

  • It is part of SP1

  • http://www.microsoft.com/downloads/details.aspx?familyid=DBDDC9B6-6E19-4D4B-9309-13F62901B0D5&displaylang=en


Report builder v3

Report Builder v3

  • Only for SQL Server R2

  • http://www.microsoft.com/downloads/en/details.aspx?FamilyID=d3173a87-7c0d-40cc-a408-3d1a43ae4e33&displaylang=en


Report generation

Report generation


Server side

Server side


Server side1

Server side


Client side

Client side

  • Reportviewer Control in "local mode"

    • ASP.NET

    • Windows Forms

    • Silverlight

    • WPF


Client side1

Client-side


Resources

Resources

All about the ReportViewer control

  • http://www.gotreportviewer.com/

    Community site with reports to learn from

  • http://www.reportsurfer.com/


Summary

Summary

  • What is Reporting Services?

  • Steps in Creating a Report

  • Demo: Creating a Report

  • Hands on Lab

    http://www.ssw.com.au/ssw/Standards/Rules/RulesToBetterSQLReportingServices.aspx


Sql server 2008 for business intelligence

Thank You!

Gateway Court Suite 10 81 - 91 Military Road Neutral Bay, Sydney NSW 2089 AUSTRALIA

ABN: 21 069 371 900

Phone: + 61 2 9953 3000 Fax: + 61 2 9953 3105

[email protected]


  • Login