Reporting with Microsoft SQL Server 2012. Learn to quickly create reports in SSRS and Power View as well as understand the best use of each reporting tool - Helion

ebook

Autor: James Serra, William Anton
Tytuł oryginału: Reporting with Microsoft SQL Server 2012. Learn to quickly create reports in SSRS and Power View as well as understand the best use of each reporting tool.
ISBN: 9781782171737
stron: 142, Format: ebook
Data wydania: 2014-03-18
Księgarnia: Helion

Cena książki: 109,00 zł

Osoby, które kupiły tę książkę, wybierały także »

Osoby które kupowały "Reporting with Microsoft SQL Server 2012. Learn to quickly create reports in SSRS and Power View as well as understand the best use of each reporting tool", wybierały także:

Windows Media Center. Domowe centrum rozrywki 66,67 zł, (8,00 zł -88%)
Ruby on Rails. Ćwiczenia 18,75 zł, (3,00 zł -84%)
DevOps w praktyce. Kurs video. Jenkins, Ansible, Terraform i Docker 190,00 zł, (39,90 zł -79%)
Przywództwo w świecie VUCA. Jak być skutecznym liderem w niepewnym środowisku 58,64 zł, (12,90 zł -78%)
Scrum. O zwinnym zarządzaniu projektami. Wydanie II rozszerzone 58,64 zł, (12,90 zł -78%)

Spis treści

Reporting with Microsoft SQL Server 2012. Learn to quickly create reports in SSRS and Power View as well as understand the best use of each reporting tool eBook -- spis treści

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