Creating reports is natural in any business, and there are many Microsoft products for this purpose. However, the oldest and the most popular product is SQL Server Reporting Services (SSRS), which is ideal for any standard type of report. With technology evolving and the benefits of self-service reporting becoming evident, a new tool was needed. Microsoft responded to this need with Power View.
This book will cover all of the features of SSRS and Power View and will provide a step-by-step lab activity for each feature so that you can develop reports very quickly. You will learn the strengths and weaknesses of each tool, and thus be able to ascertain the best one to use for various reporting scenarios that you will encounter.
We, the authors of this book, are consultants who work with companies on a daily basis to design and create reports as well as help others to do so. When looking for a book to recommend to our clients that covers both SSRS and Power View, we found that books either talk about just one of these tools or include both but with limited information because they also cover a wide range of other reporting tools. Also, we could not find books that addressed the following topics: various reporting scenarios and the best tool to use for each; Power View for Excel 2013; the differences between Power View for SharePoint and Power View for Excel; and how SSRS is used for standard reporting, while Power View is used for self-service reporting. This book is our attempt to fill all these gaps.
Chapter 1, Getting Started with Reporting, gives an introduction to SSRS and Power View and discusses which is the best tool to use in various reporting scenarios.
Chapter 2, SSRS – Standard Reporting, describes what standard reporting is and talks about how SSRS solves standard reporting needs, covering its main features and functionalities.
Chapter 3, Development Activity with SSRS, is a step-by-step lab activity that walks you through the process of creating a basic SSRS report.
Chapter 4, Power View – Self-service Reporting, describes what self-service reporting is and talks about how Power View solves self-service reporting needs, covering its main features and functionalities.
Chapter 5, Development Activity with Power View, is a step-by-step lab activity that walks you through the process of creating a basic Power View report.