LEADER 05100nam 2200637 450 001 9910787828203321 005 20200520144314.0 010 $a1-78217-173-8 035 $a(CKB)2670000000547145 035 $a(EBL)1657800 035 $a(SSID)ssj0001216917 035 $a(PQKBManifestationID)11718591 035 $a(PQKBTitleCode)TC0001216917 035 $a(PQKBWorkID)11197492 035 $a(PQKB)11675401 035 $a(Au-PeEL)EBL1657800 035 $a(CaPaEBR)ebr10852917 035 $a(CaONFJC)MIL583010 035 $a(OCoLC)874971415 035 $a(MiAaPQ)EBC1657800 035 $a(PPN)22803633X 035 $a(EXLCZ)992670000000547145 100 $a20140411h20142014 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aReporting with Microsoft SQL Server 2012 $elearn to quickly create reports in SSRS and power view as well as understand the best use of each reporting tool /$fJames Serra, Bill Anton ; cover image by Aniket Sawant 210 1$aBirmingham, [England] :$cPackt Publishing,$d2014. 210 4$dİ2014 215 $a1 online resource (143 p.) 225 0 $aProfessional Expertise Distilled 300 $aIncludes index. 311 $a1-78217-172-X 327 $aCover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Getting Started with Reporting; Standard reporting with SSRS; Self-service reporting with Power View; Power View limitations; Reporting scenarios; Scenario 1; Scenario 2; Scenario 3; Scenario 4; Scenario 5; Scenario 6; Scenario 7; Scenario 8; Scenario 9; Scenario 10; Scenario 11; Scenario 12; Scenario 13; Summary; Chapter 2: SSRS - Standard Reporting; Primary components of a report; Data source; Dataset; Report items; Additional components of a report; Report parameters 327 $aExpressionsActions; Custom code; Report development environment; Server features and functionality; Choosing an installation mode - SharePoint Integrated versus Native; Scheduling; Subscriptions; Report snapshots; Caching; Data alerts; My Reports (Native mode only); Linked reports (Native mode only); Consuming reports; Online; Offline; Data feed; Extensibility; Security; Roles and permissions; Securing Report Server objects; Data security; Summary; Chapter 3: Development Activity with SSRS; Prerequisites; Tutorial scenario; Creating a Reporting Services project; Creating a report object 327 $aCreating a shared data sourceAdding reference to shared data source; Creating a dataset; Adding a report item; Deploying a report project; Summary; Chapter 4: Power View - Self-service Reporting; Getting started; PowerPivot; Business Intelligence Semantic Model; Power View within SharePoint; Setup; Tabular model connection; Starting Power View connected to a tabular model connection; Multidimensional model connection; Starting Power View connected to a multidimensional model connection; Power View within Excel 2013; Setup; Data models; Starting Power View in Excel; Importing data into Excel 327 $aAdding data to a worksheet and inserting data into Power ViewNot adding data to a worksheet and inserting data into Power View; Adding data to a worksheet and using Power Pivot; Not adding data to a worksheet and using Power Pivot; Data visualizations; The user interface; Enhancing data models; Deploy and share reports; Presentation modes; Reports with multiple views in Power View; Adding multiple views; Navigating among views; View filters; View preview images; Chart highlighting, slicers, and filtering; Chart highlighting; Slicers; Filtering; View-level/sheet-level filters 327 $aVisualization-level filtersBasic filters; Advanced filters; Search in filters; Sorting; Export reports to Microsoft Office PowerPoint; Design tips; Undo/Redo; Arranging visualizations; Fit to window; Pop out; Summary; Chapter 5: Development Activity with Power View; Prerequisites; Tutorial scenario; Creating a BI Semantic Model (BISM) connection; Opening the Power View design interface; Creating bar charts; Creating pie charts; Creating column charts; Adding a slicer; Deploying reports to SharePoint; Summary; Index 330 $aThis is a step-by-step tutorial that deals with Microsoft Server 2012 reporting tools:SSRS and Power View.If you are a BI developer, consultant, or architect who wishes to learn how to use SSRS and Power View, and want to understand the best use for each tool, then this book will get you up and running quickly. No prior experience is required with either tool! 606 $aClient/server computing 606 $aDatabase management 615 0$aClient/server computing. 615 0$aDatabase management. 676 $a005.7585 700 $aSerra$b James$01562237 702 $aAnton$b Bill 702 $aSawant$b Aniket 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910787828203321 996 $aReporting with Microsoft SQL Server 2012$93829685 997 $aUNINA