Summary

In this chapter, we discussed the best practices when using business intelligence tools such as Microsoft Power BI Desktop, Tableau Desktop, Tableau Prep Builder, and Alteryx Designer. We covered how to handle potentially confusing date convention formats by updating the format and checking the locale settings. Ensuring that date formats are consistent will help ensure that our analysis is accurate and reliable. Next, we used data visualization features such as the scatter chart in Power BI and the histogram in Tableau to identify data outliers. By working on these hands-on examples, I am sure that you have grown more confident in what you have learned. Lastly, we discussed how to find and manage orphaned records in both Power BI and Alteryx. Understanding various ways to address a problem is an important skill to develop.

Business intelligence tools are powerful tools to clean, transform, analyze, and visualize data. They can even be used to detect fraudulent transactions...