Creating a Complete Solution

Abstract

So far in this book, you’ve gained experience working with each of the pieces of Microsoft’s self-service BI toolset. You’ve used Power Query, Power Pivot, Excel, and the Power BI Desktop. This chapter provides you with several use cases to solidify the concepts of the previous chapters. By working through these use cases, you will gauge which areas you have mastered and which you need to spend more time studying. Because this is sort of like your final exam, I have deliberately not included step-by-step instructions as I did for earlier exercises. Instead, I have given you general directions that should be sufficient to get you started. If you get stuck, refer back to the previous chapters to remind yourself of how to accomplish the task.