Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Reporting with Microsoft SQL Server 2012
  • Table Of Contents Toc
Reporting with Microsoft SQL Server 2012

Reporting with Microsoft SQL Server 2012

4.1 (7)
Buy this Book
close
close
Reporting with Microsoft SQL Server 2012

Reporting with Microsoft SQL Server 2012

4.1 (7)
Buy this Book

Overview of this book

Table of Contents (12 chapters)
close
close
close
Reporting with Microsoft SQL Server 2012
Icon
Reporting with Microsoft SQL Server 2012
Credits
Icon
Credits
About the Authors
Icon
About the Authors
About the Reviewers
Icon
About the Reviewers
www.PacktPub.com
Icon
www.PacktPub.com
Preface
Icon
Preface
Lock Free Chapter
1
Getting Started with Reporting
Icon
Getting Started with Reporting
Icon
Standard reporting with SSRS
Icon
Self-service reporting with Power View
Icon
Power View limitations
Icon
Reporting scenarios
Icon
Summary
2
SSRS – Standard Reporting
Icon
SSRS – Standard Reporting
Icon
Primary components of a report
Icon
Additional components of a report
Icon
Report development environment
Icon
Server features and functionality
Icon
Consuming reports
Icon
Summary
3
Development Activity with SSRS
Icon
Development Activity with SSRS
Icon
Prerequisites
Icon
Tutorial scenario
Icon
Summary
4
Power View – Self-service Reporting
Icon
Power View – Self-service Reporting
Icon
Getting started
Icon
PowerPivot
Icon
Business Intelligence Semantic Model
Icon
Power View within SharePoint
Icon
Power View within Excel 2013
Icon
Data visualizations
Icon
The user interface
Icon
Enhancing data models
Icon
Deploying and sharing reports
Icon
Presentation modes
Icon
Reports with multiple views in Power View
Icon
Chart highlighting, slicers, and filtering
Icon
Sorting
Icon
Export reports to Microsoft Office PowerPoint
Icon
Design tips
Icon
Summary
5
Development Activity with Power View
chevron up
Icon
Development Activity with Power View
Icon
Prerequisites
Icon
Tutorial scenario
Icon
Summary
1
Index
Icon
Index

Chapter 5. Development Activity with Power View

In this chapter, we'll walk through the process of creating a basic Power View report. As we learned in the previous chapter, Power View reports can be created using Excel 2013 or directly through the browser when connected to a SharePoint site, which has the Reporting Services Add-in for SharePoint Products installed. In the following development activity, we will be leveraging the second option.

The development activity in this chapter is broken up into the following sections:

  • 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

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Reporting with Microsoft SQL Server 2012
End of Section 5
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon