Reporting with Microsoft SQL Server 2012 -- Table of Contents -- Reporting with Microsoft SQL Server 2012 -- Credits -- About the Authors -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers, and more -- Why subscribe? -- Free access for Packt account holders -- Instant updates on new Packt books -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Errata -- Downloading the color images of the book -- Piracy -- Questions -- 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 -- 2. SSRS - Standard Reporting -- Primary components of a report -- Data source -- Dataset -- Report items -- Additional components of a report -- Report parameters -- Expressions -- Actions -- 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 -- 3. Development Activity with SSRS -- Prerequisites -- Tutorial scenario -- Creating a Reporting Services project -- Creating a report object -- Creating a shared data source -- Adding reference to shared data source -- Creating a dataset -- Adding a report item -- Deploying a report project.

Summary -- 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 -- Adding data to a worksheet and inserting data into Power View -- Not adding data to a worksheet and inserting data into Power View -- Adding data to a worksheet and using PowerPivot -- Not adding data to a worksheet and using PowerPivot -- Data visualizations -- The user interface -- Enhancing data models -- Deploying and sharing 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 -- Visualization-level filters -- Basic 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 -- 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.