LEADER 07012nam 22007935 450 001 9910300638303321 005 20200705113302.0 010 $a9781484205327 010 $a1484205324 024 7 $a10.1007/978-1-4842-0532-7 035 $a(CKB)3710000000371730 035 $a(EBL)1998727 035 $a(OCoLC)904594893 035 $a(SSID)ssj0001465389 035 $a(PQKBManifestationID)11821041 035 $a(PQKBTitleCode)TC0001465389 035 $a(PQKBWorkID)11470721 035 $a(PQKB)11335649 035 $a(DE-He213)978-1-4842-0532-7 035 $a(MiAaPQ)EBC1998727 035 $a(CaSebORM)9781484205327 035 $a(PPN)184888352 035 $a(OCoLC)906577994 035 $a(OCoLC)ocn906577994 035 $a(EXLCZ)993710000000371730 100 $a20150302d2015 u| 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aBusiness Intelligence with SQL Server Reporting Services /$fby Adam Aspin 205 $a1st ed. 2015. 210 1$aBerkeley, CA :$cApress :$cImprint: Apress,$d2015. 215 $a1 online resource (413 p.) 225 1 $aThe expert's voice in SQL server 300 $aIncludes index. 300 $a"The Expert's VoiceŽ in SQL Server"--Cover. 311 08$a9781484205334 311 08$a1484205332 327 $a""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"" 327 $a""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"" 327 $a""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"" 327 $a""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"" 327 $a""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"" 327 $a""Creating and Assembling the Gauges"" 330 $aBusiness 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 that seize your audience?s attention and help business users identify and react swiftly to changing business conditions. Best of all, you'll do all these things by creating new value from software that is already installed and paid for ? SQL Server and the included SQL Server Reporting Services. Businesses run on numbers, and good business intelligence systems make the critical numbers immediately and conveniently accessible. Business users want access to key performance indicators in the office, at the beach, and while riding the subway home after a day's work. Business Intelligence with SQL Server Reporting Services helps you meet these need for anywhere/anytime access by including chapters specifically showing how to deliver on modern devices such as smart phones and tablets. You'll learn to deliver the same information, with similar look-and-feel, across the entire range of devices used in business today. Key performance indicators give fast notification of business unit performance Polished dashboards deliver essential metrics and strategic comparisons Visually arresting output on multiple devices focuses attention. 517 3 $aBusiness intelligence with structured query language server reporting services 606 $aDatabase management 606 $aData structures (Computer science) 606 $aData mining 606 $aDatabase Management$3https://scigraph.springernature.com/ontologies/product-market-codes/I18024 606 $aData Structures and Information Theory$3https://scigraph.springernature.com/ontologies/product-market-codes/I15009 606 $aData Mining and Knowledge Discovery$3https://scigraph.springernature.com/ontologies/product-market-codes/I18030 615 0$aDatabase management. 615 0$aData structures (Computer science) 615 0$aData mining. 615 14$aDatabase Management. 615 24$aData Structures and Information Theory. 615 24$aData Mining and Knowledge Discovery. 676 $a005.75 676 $a005.75/85 700 $aAspin$b Adam$4aut$4http://id.loc.gov/vocabulary/relators/aut$0895187 801 0$bUMI 801 1$bUMI 906 $aBOOK 912 $a9910300638303321 996 $aBusiness Intelligence with SQL Server Reporting Services$92129304 997 $aUNINA