Business Intelligence with SQL Server Reporting Services
Business Intelligence with SQL Server Reporting Services helps you deliver business intelligence with panache. Harness the power of the Reporting Services toolkit to combine charts, gauges, sparklines, indicators, and maps into compelling dashboards and scorecards. Create compelling visualizations t...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Berkeley, CA :
Apress
2015.
|
| Edición: | 1st ed. 2015. |
| Colección: | The expert's voice in SQL server
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629994706719 |
Tabla de Contenidos:
- ""Contents at a Glance""; ""Contents""; ""About the Author""; ""About the Technical Reviewers""; ""Acknowledgments""; ""Introduction""; ""Chapter 1: SQL Server Reporting Services as a Business Intelligence Platform""; ""Business Intelligence Concepts""; ""Key Performance Indicators""; ""Scorecards""; ""Dashboards""; ""SSRS for Business Intelligence, Practically""; ""Getting the Data Right""; ""Prepare the Data""; ""Use Views and Stored Procedures""; ""Views""; ""Stored Procedures""; ""Some Ideas on Source Data Definition""; ""Real-World Data""
- ""Designing SQL Server Reports for Business Intelligence""""Presentation""; ""Design""; ""Layout""; ""Interface and Interactivity""; ""Multi-Purposing""; ""The Sample Database""; ""Preparing Your Environment""; ""Creating an SSDT Project""; ""Adding a Shared Datasource""; ""Add Shared Datasets""; ""Configuring Parameters""; ""Code and Stored Procedures""; ""Reusability""; ""The CarSales_Reports Database""; ""Book Audience""; ""How Best to Use This Book""; ""Conclusion""; ""Chapter 2: KPIs and Scorecards""; ""What Are Key Performance Indicators?""; ""KPI Value""; ""KPI Goal""; ""KPI Status""
- ""KPI Status Thresholds""""Threshold Flags""; ""KPI Trends""; ""KPI Trend Thresholds and Flags""; ""A Simple KPI""; ""The Source Data""; ""How the Code Works""; ""Building the KPI""; ""How It Works""; ""A More Complex KPI Using Sparklines""; ""The Source Data""; ""How the Code Works""; ""Building the KPI""; ""How It Works""; ""Gauge-Based KPIs""; ""The Source Data""; ""How the Code Works""; ""Building the Gauge-Based KPI""; ""How It Works""; ""Hints and Tips""; ""Text-Based KPIs""; ""A Simple Text-Based KPI""; ""The Source Data""; ""How the Code Works""; ""Building a Text-Based KPI""
- ""How It Works""""A Complex Text-Based KPI""; ""The Source Data""; ""How the Code Works""; ""Building a Complex Text-Based KPI""; ""How It Works""; ""Conclusion""; ""Chapter 3: Gauges for Business Intelligence""; ""Gauge Elements""; ""Data for Gauges""; ""Gauge Development""; ""Classic Gauges""; ""The Source Data""; ""How the Code Works""; ""Building the Gauge""; ""How It Works""; ""Hints and Tips""; ""Using Multiple Pointers in Gauges""; ""The Source Data""; ""How the Code Works""; ""Creating the Gauge""; ""How It Works""; ""Varying the Pointer Types and Assembling Gauges""
- ""The Source Data""""How the Code Works""; ""Building the Gauge""; ""How It Works""; ""Hints and Tips""; ""Gauges with Multiple Elements""; ""The Source Data""; ""Creating the Gauge""; ""How It Works""; ""Hints and Tips""; ""Less Traditional Gauges""; ""Thermometers""; ""The Source Data""; ""How the Code Works""; ""Building the Thermometer""; ""How It Works""; ""Hints and Tips""; ""Sub-Gauges""; ""The Source Data""; ""How the Code Works""; ""Creating Gauges with Sub-Gauges""; ""How It Works""; ""Hints and Tips""; ""Interesting Tricks with Gauges""; ""The Source Data""; ""How the Code Works""
- ""Creating and Assembling the Gauges""
