SlideServe
Télécharger Obtenir Pro
Menu
Accueil Pro
Préférences
ApparenceLight Aide et commentaires
© SlideServe · v2026

Business Intelligence with SQL Server 2008 Short Course Overview

trapper avatar
trapper
0 diapositives · 142 Views · Jul 03, 2014

SQL Server 2008 for Business Intelligence, covering essential concepts such as cubes, measures, dimensions, and hierarchies. Learn about time dimensions and the cube browser for effective data analysis. Additionally, we explore SQL Reporting Services, including the steps to create impactful reports. Join us to boost your understanding of business intelligence tools and reporting methods in SQL Server 2008, empowering you to make data-driven decisions.

#sql server 2008 #business intelligence #reporting services #data cubes #measures and dimensions #time dimensions #creating reports #cube browser
Business Intelligence with SQL Server 2008 Short Course Overview - slide 1
01 / 1Business Intelligence with SQL Server 2008 Short Course Overview
1 / 17

Télécharger la présentation

Business Intelligence with SQL Server 2008 Short Course Overview
Une image / un lien ci-dessous est fourni (tel quel) pour télécharger la présentation

Politique de téléchargement : le contenu du site vous est fourni TEL QUEL pour votre information et votre usage personnel ; il ne peut être vendu, concédé sous licence ni partagé sur d’autres sites sans l’accord de son auteur.Le contenu vous est fourni TEL QUEL, pour votre information et votre usage personnel uniquement. Téléchargez la présentation en cliquant sur ce lien. Lors du téléchargement, si vous ne parvenez pas à télécharger une présentation, l’éditeur a peut-être supprimé le fichier de son serveur.Pendant le téléchargement, si vous ne parvenez pas à obtenir une présentation, le fichier a peut-être été supprimé par l’éditeur.

F I N

Plus de contenu associé

Transcription de la présentation
  1. SQL Server 2008 for Business Intelligence UTS Short Course
  2. Recap Cubes What is a cube? Measures/Facts? Dimensions? Hierarchies? Time Dimensions? Cube Browser? Why?
  3. Session 3: Reporting Services What is SQL Reporting Services? Steps in Creating a Report Demo: Creating a Report Hands on Lab
  4. Why are we doing this?
  5. 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
  6. The plan
  7. 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)
  8. SSRS
  9. 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
  10. SQL Server BI Platform Reporting Services Development Tools Management Tools Analysis Services OLAP & Data Mining Integration Services ETL SQL Server Relational Engine
  11. 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.
  12. Report Authoring
  13. 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
  14. Report Authoring - Controls Data regions Tablix (New in SQL 2008) Table List (like Access) Matrix Chart Gauge Subreports Images Custom Controls
  15. Tablix Generalized layout report item Grouped and Detail data
  16. 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.
  17. 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
  18. 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.
  19. Charts
  20. Charts
  21. Charts
  22. Gauge
  23. Interactive reports
  24. 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
  25. Interactivity Document maps Collapse / Expand Actions
  26. Report Management
  27. 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
  28. SQL Server Reporting Architecture
  29. Report Manager
  30. Configuration Manager
  31. Report Delivery
  32. 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
  33. 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
  34. 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
  35. Report Builder
  36. Report Builder v2
  37. 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
  38. Report Builder v3 Only for SQL Server R2 http://www.microsoft.com/downloads/en/details.aspx?FamilyID=d3173a87-7c0d-40cc-a408-3d1a43ae4e33&displaylang=en
  39. Report generation
  40. Server side
  41. Server side
  42. Client side Reportviewer Control in "local mode" ASP.NET Windows Forms Silverlight WPF
  43. Client-side
  44. Resources All about the ReportViewer control http://www.gotreportviewer.com/ Community site with reports to learn from http://www.reportsurfer.com/
  45. 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
  46. 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 info@ssw.com.auwww.ssw.com.au