In this book, we have learned when to use QlikView along with many of the multiple features of QlikView. We have loaded data from Excel and learned about other data sources. We have experimented with performing analysis with QlikView in the section where we found the out of balance amount. We have modified the Load Script, loaded additional spreadsheets, and linked data.
We examined key performance indicators and learned about the different options available with QlikView to display them. We created the three most common financial KPIs and, during the process, learned about set expressions. We have created or modified most of the sheet objects available in QlikView in the preceding chapters, and created a common size income statement for analysis.
We have learned that dashboards should display key information in a quick-to-digest format, and that gauges, dials, and thermometers are often used incorrectly, causing confusion rather than clarification. We examined both the display choices and the underlying objects making up the multiple tabs of the QlikView CFO dashboard. The knowledge about the many sources of data that we can load into QlikView for analysis is very powerful. We can load information from files, database data sources, and from the Internet.
We found that there are many other sources for ideas to create a whole dashboard or just a tab that can be used for the type of analysis that best suits our business needs. We learned that our data sources are nearly limitless.
For the Sales Analysis tab of the CFO dashboard, we created a version better than the existing one by examining the existing version and the good and bad choices made in the display. We learned how to create a Group button to make more data available on a single display, without overcrowding or overloading information for the dashboard user.
In this final chapter, we covered the information required for taking QlikView to the next step, that is, as an enterprise analysis resource.
Enjoy!