QlikView for Finance

 
 
Packt Publishing Limited
  • 1. Auflage
  • |
  • erschienen am 29. September 2015
  • |
  • 174 Seiten
 
E-Book | ePUB mit Adobe DRM | Systemvoraussetzungen
E-Book | PDF mit Adobe DRM | Systemvoraussetzungen
978-1-78439-794-4 (ISBN)
 
Concoct dynamic business intelligence dashboards for financial analysis with QlikViewAbout This BookGet accustomed to QlikView features for effective data analysis and visualization in FinanceEmploy the Memory data store, which refreshes data in real time, providing a faster response to business financial informationA step-by step guide to using Qlikview features such as key performance indicators, interactive charts, and tables for financial analysisWho This Book Is ForIf you are a finance professional with basic knowledge of QlikView functions and wish to increase your knowledge of QlikView to apply it in the field of finance, then this book is for you. A good knowledge of financial aspects is an must-have.What You Will LearnDesign Key Performance Indicators and extend your revenue ratio reportingSet up actions within a Text Object and create variables to make a chart toggle between visible and not visibleMerge data from multiple sources to get more asset management optionsExamine good and bad practices in dashboard design and create a Group button to make more data available in less spaceAnalyse the sales dashboard by adding tending lines and forecastingCreate input boxes and use the input in formulas to perform "What If" analysisExamine the Key Performance Indicator (KPI) and Inventory Turnover, and investigate the usefulness of PivotCreate a QlikView analysis document and add data to it to gain deep insightsIn DetailThis book is an effective step-by-step tutoring guide for financial analysis using Qlikview.It begins by teaching you the crucial concepts of Qlikview Finance to help you develop an effective understanding of financial data analysis and finance. The book then goes on to cover real-world, practical examples on the use of Qlikview for financial planning and analysis, expense management, risk management, and more.Moving on, topics such as Asset Management QlikView Dashboard and Retail Sales Analysis are covered in a strategic way. We then shift the focus to deal with the concepts of Inventory, Supply Chain, and Plant Coverage Dashboards. The book then reaches its conclusion by dealing with ways to share your QlikView insights. By the end of this book, you will have a good understanding of how to use Qlikview for numerous applications in finance.Style and approachThis book is designed to explore what can be done in QlikView to facilitate Financial Analysis. It follows a step-by-step approach and each chapter has easy-to-follow, hands-on examples of important concepts.
  • Englisch
  • Birmingham
978-1-78439-794-4 (9781784397944)
1784397946 (1784397946)
weitere Ausgaben werden ermittelt
  • Cover
  • Copyright
  • Credits
  • Disclaimer
  • About the Author
  • About the Reviewers
  • www.PacktPub.com
  • Table of Contents
  • Preface
  • Chapter 1: Getting That Financial Data into QlikView
  • When do we use QlikView?
  • Downloading and installing QlikView
  • Becoming familiar with QlikView
  • Opening and examining QlikView
  • Loading data from Excel
  • How QlikView works for analysis - finding the out of balance
  • Adding more data - modifying the load script
  • Loading more than one spreadsheet
  • Summary
  • Chapter 2: QlikView Dashboard Financial KPIs
  • What are key performance indicators?
  • Display sales as a KPI
  • What are the three most common financial KPIs?
  • Adding ROI, ROA, and ROE into a QlikView dashboard
  • Building our set expressions
  • Expression shortcuts
  • Mathematical and set operators
  • Creating our three-KPI display
  • Common size income statement
  • Summary
  • Chapter 3: KPIs in the Financial Officer QlikView Dashboard
  • Opening the example CFO dashboard
  • The KPIs tab in a nutshell
  • Delving into sheet objects
  • The third text object in the first row
  • The second row of sheet objects
  • The third row of sheet objects
  • Load script for the KPIs dashboard tab
  • Summary
  • Chapter 4: QlikView Asset Management with Multiple Data Sources
  • Assets under management (financial investments)
  • Fixed asset management
  • Adding data sources
  • Loading from another QlikView document
  • Loading from files
  • QlikView files
  • XML files
  • HTML files
  • Excel files
  • Text and delimited files
  • Loading from databases
  • Summary
  • Chapter 5: QlikView Sales Analysis
  • Reopening the example CFO dashboard
  • The sales analysis tab in a nutshell
  • Table display
  • Chart display
  • The nuts and bolts of the sales analysis dashboard
  • The group button
  • Containers
  • Improving the sales analysis dashboard
  • Steps to create a new sales analysis tab
  • Creating a new variable
  • An interface for the new variable
  • Applying the new variable
  • Adding a container with multi boxes
  • Moving and changing the chart
  • Summary
  • Chapter 6: QlikView Forecasting and Trends
  • Reopening the example CFO dashboard
  • Trend and forecast lines in charts
  • Adding a trend line to the monthly sales and margin chart
  • Basing a trend line on an existing measure
  • Extending a trend line into a forecast line
  • The nuts and bolts of the trending dashboard
  • Colors
  • Experimenting with color formulas
  • How to get other colors
  • Layout themes
  • The nuts and bolts of the What If? dashboard
  • Summary
  • Chapter 7: QlikView Inventory Analysis
  • Reopening the CFO dashboard
  • Delving into the four-quadrant layout
  • The good and the bad of the Inventory tab
  • What is inventory turnover?
  • Other measures at the dashboard level
  • Inventory on hand
  • The nuts and bolts of the Inventory dashboard
  • The pivot table
  • Creating the inventory profile ranges
  • Summary
  • Chapter 8: QlikView Order Details Dashboard
  • Reopening the CFO dashboard
  • Analyzing the order details dashboard display
  • Comparing the order and inventory management on-line demonstration
  • The nuts and bolts of the CFO dashboard order detail tab
  • Export to Excel
  • Color-coding data
  • Number format patterns
  • Dynamic expressions
  • Summary
  • Chapter 9: QlikView Expenses Dashboard
  • Reopening the CFO example dashboard
  • Analysis of the expenses dashboard display
  • The nuts and bolts of the CFO dashboard expenses tab
  • Minimizing the pie chart
  • Improving the line chart
  • Bar chart formulas
  • Pivot table variances
  • Formatting and linking
  • Summary
  • Chapter 10: Sharing Your QlikView Insights
  • Sharing QlikView information with business associates
  • Licensing and servers
  • Licensing
  • QlikView business servers
  • Security, deployment, and technology in an enterprise application
  • Security
  • Deployment
  • Technology
  • Data sources
  • Mobile applications
  • Where to get further information
  • QlikCommunity
  • Development source control integration
  • QlikView Reference Manual
  • Delving into Qlik Sense
  • Summary
  • Index

Dateiformat: EPUB
Kopierschutz: Adobe-DRM (Digital Rights Management)

Systemvoraussetzungen:

Computer (Windows; MacOS X; Linux): Installieren Sie bereits vor dem Download die kostenlose Software Adobe Digital Editions (siehe E-Book Hilfe).

Tablet/Smartphone (Android; iOS): Installieren Sie bereits vor dem Download die kostenlose App Adobe Digital Editions (siehe E-Book Hilfe).

E-Book-Reader: Bookeen, Kobo, Pocketbook, Sony, Tolino u.v.a.m. (nicht Kindle)

Das Dateiformat EPUB ist sehr gut für Romane und Sachbücher geeignet - also für "fließenden" Text ohne komplexes Layout. Bei E-Readern oder Smartphones passt sich der Zeilen- und Seitenumbruch automatisch den kleinen Displays an. Mit Adobe-DRM wird hier ein "harter" Kopierschutz verwendet. Wenn die notwendigen Voraussetzungen nicht vorliegen, können Sie das E-Book leider nicht öffnen. Daher müssen Sie bereits vor dem Download Ihre Lese-Hardware vorbereiten.

Weitere Informationen finden Sie in unserer E-Book Hilfe.


Dateiformat: PDF
Kopierschutz: Adobe-DRM (Digital Rights Management)

Systemvoraussetzungen:

Computer (Windows; MacOS X; Linux): Installieren Sie bereits vor dem Download die kostenlose Software Adobe Digital Editions (siehe E-Book Hilfe).

Tablet/Smartphone (Android; iOS): Installieren Sie bereits vor dem Download die kostenlose App Adobe Digital Editions (siehe E-Book Hilfe).

E-Book-Reader: Bookeen, Kobo, Pocketbook, Sony, Tolino u.v.a.m. (nicht Kindle)

Das Dateiformat PDF zeigt auf jeder Hardware eine Buchseite stets identisch an. Daher ist eine PDF auch für ein komplexes Layout geeignet, wie es bei Lehr- und Fachbüchern verwendet wird (Bilder, Tabellen, Spalten, Fußnoten). Bei kleinen Displays von E-Readern oder Smartphones sind PDF leider eher nervig, weil zu viel Scrollen notwendig ist. Mit Adobe-DRM wird hier ein "harter" Kopierschutz verwendet. Wenn die notwendigen Voraussetzungen nicht vorliegen, können Sie das E-Book leider nicht öffnen. Daher müssen Sie bereits vor dem Download Ihre Lese-Hardware vorbereiten.

Weitere Informationen finden Sie in unserer E-Book Hilfe.


Download (sofort verfügbar)

28,05 €
inkl. 19% MwSt.
Download / Einzel-Lizenz
ePUB mit Adobe DRM
siehe Systemvoraussetzungen
PDF mit Adobe DRM
siehe Systemvoraussetzungen
Hinweis: Die Auswahl des von Ihnen gewünschten Dateiformats und des Kopierschutzes erfolgt erst im System des E-Book Anbieters
E-Book bestellen

Unsere Web-Seiten verwenden Cookies. Mit der Nutzung des WebShops erklären Sie sich damit einverstanden. Mehr Informationen finden Sie in unserem Datenschutzhinweis. Ok