QlikView is a business intelligence (BI) platform that enables the creation of dynamic applications for the analysis of financial data. QlikView is based on an in-memory data store, which means that BI applications can refresh data in real time. This book will lead the finance professional through the use of Qlikview for data analysis and visualization in finance, where it is used extensively. It therefore assumes that the reader has a good knowledge of finance.
This book illustrates the QlikView financial key performance indicators and discusses planning and analysis, expense management, inventory tracking, and the do's and don'ts of information display. After reading this book, you will be able to create your own financial key performance indicators and analyze how demonstration KPIs, charts, and tables are created in the existing QlikView example applications.
Chapter 1, Getting That Financial Data into QlikView, discusses how to obtain and install QlikView, create our first QlikView analysis, and add data to that analysis. Here, we will scratch the surface of the things that can be done with QlikView.
Chapter 2, QlikView Dashboard Financial KPIs, answers question such as: What are Key Performance Indicators (KPIs)? How can we display the sales from our sample data as KPIs? How do we create our first thermometer-type gauge? Here, we will discuss the three most common financial KPIs and how to put them in a QlikView dashboard. You will also learn how you can use QlikView to extend your revenue ratio reporting.
Chapter 3, KPIs in the Financial Officer QlikView Dashboard, will illustrate the KPI tab with the example of a CFO dashboard in detail. You will discover which objects are used on the sheet and how they are layered to create a specific design look. Also, you will find out how to use the inline wizard to produce specific display results. You will learn how to set up actions within a text object. You will be able to use variables to make a chart visible or invisible and examine how a chart object can contain more than one chart.
Chapter 4, QlikView Asset Management with Multiple Data Sources, discusses the most important thing about asset management: being able to obtain and merge data from multiple sources. This chapter is an introduction to data loading options with various data sources.
Chapter 5, QlikView Sales Analysis, discusses analyzing an existing dashboard to learn the good and bad practices in dashboard design. It takes a look at creating a Group button to make more data available on a single display without overcrowding, and creating our own Sales Analysis dashboard tab, including our own containers and other sheet objects.
Chapter 6, QlikView Forecasting and Trends, continues with the Sales Analysis dashboard, adding trending lines and forecasting out to three months. Following this exercise, we will examine the Trending dashboard and how it is assembled. We will choose colors and apply them, adding them to our own theme. We will create an Input Box and apply the input data to a formula in the What If? dashboard example.
Chapter 7, QlikView Inventory Analysis, illustrates the use of the Inventory tab in a sample CFO dashboard to get ideas for inventory tracking and management. We will examine a four-quadrant layout, intuitive controls and the KPI, inventory turnover. You will be introduced to pivot tables and the additional drill-down navigation analysis features offered by them.
Chapter 8, QlikView Order Details Dashboard, examines supply chain analysis options using the Order Details tab of the dashboard in the CFO example and compares the tab to the online demonstration titled Order and Inventory Management. We will create a Fast Change type for an existing straight table, export data to Excel, color-code the data, set our own number formats, and create a dynamic expression.
Chapter 9, QlikView Expenses Dashboard, introduces the analysis of another four-quadrant dashboard layout to explain the usefulness of the display options. We will switch a sheet object so that it can be minimized and maximized. We will also review standard formula, including column variances, and experiment with pivot table formatting. Finally, we will create a URL link in an existing pivot table, and learn how to bundle images.
Chapter 10, Sharing Your QlikView Insights, signposts the next steps you can take (now that you have mastered using QlikView to provide financial management insights) to share the new information with business colleagues who need it.