Summary

By completing this chapter, you have added another precious instrument to your data analytics practitioners' backpack: Power BI. You have learned how to load data and set up a routine of transformation steps required for cleaning that data and making it useful. You have seen how to define the relationships that connect all tables into a single and coherent data model. You have also seen what it means to build interconnected visuals that allow for human interaction. You have created a dashboard that will enable business users to explore the data they need when they need it, fishing for insights and unveiling business opportunities in complete autonomy.

Now, think about the amount of data that lies largely unutilized and inaccessible in company databases (or even in Excel files stored on individuals' laptops). The business opportunities that wait to be unlocked by making this data visually accessible through a simple dashboard are vast and, in many cases, reasonably...