In this chapter, we learned the difference between standard reporting and self-service reporting and how SSRS is ideal for the former and Power View for the latter. We got a brief overview of these two products and the data sources they use, and discussed Power View's limitations, which prevent it from being the tool used for all reporting. Finally, we saw certain reporting scenarios and discussed the best tool to use and why.

In the next chapter, we will start using SSRS and cover it in more detail.