Summary
In this chapter, you were introduced to three very powerful tools that allow us to create data models, transform and shape data, and create stunning dashboard visualizations. You now have knowledge of what Power BI, Power Query, and Power Pivot can offer and have learned how to set up and install these apps within the Microsoft Office Excel platform, as well as for different desktop versions and releases. You have also learned about their differences and functionality across updates. To end this chapter, you learned how to locate and launch Power Query using the Get Data method.
Chapter 2, Power Pivot Basics, Inadequacies, and Data Management, focuses on the shortcomings of Power Pivot and why Power Query is the better tool to use when handling complex data in order to retrieve, extract, and reshape data. By completing this chapter, you will gain an understanding of the importance of data management and data analysis in business. We will look at examples in both Power Pivot...