Home
Diane Blackwood's 2015 Book
Deliver dynamic business intelligence dashboards for financial analysis with QlikView
Diane Blackwood's 2015 Book
Deliver dynamic business intelligence dashboards for financial analysis with QlikView
About This Book
Get accustomed to QlikView features for effective data analysis and visualization in Finance
Employ the Memory data store, which refreshes data in real time, providing a faster response to business financial information
A step-by step guide to using Qlikview features such as key performance indicators, interactive charts, and tables for financial analysis
If 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.
Book available from Packt Publishing, Safari, www.amazon.com, www.barnesandnoble.com:
e-book prices around $26.59. Print $34.99. ISBN: 978-1-78439-574-2
Instant QlikView 11 Application Development
e-book prices around $16.99. Print $27.99. ISBN: 978-1-84968-964-9
Sample section from bonus chapter:
Getting ready
You may have played the game Six Degrees of Kevin Bacon or at least heard of it. It is a game based on the sociological theory of six degrees of separation, the idea that everyone is on average approximately six steps away by way of introduction, from any other person in the world. Social psychologist Stanley Milgram put the idea of six degrees of separation to the test in the 1960s by asking volunteers to get a message to a random individual living near Boston. The test subjects were asked to send the message to a friend who was more likely than they to know the target person. It took an average of 5.2 people in the chain to get the letter to the target, so because it was over five, the theory rounded up to six degrees apart from any other person on the globe.
Duncan Watts expanded the theory of six degrees of separation to Network Theory, the scientific field that examines how networks form and how they work in society. Network Theory covers many subjects, including:
• How people interact socially
• How diseases spread
• How people find jobs
• How aspects of the World Wide Web operate
Using this theory and the QlikView Movie Database available from QlikView in the Getting Started examples section; we are going to play the game Six Degrees of Kevin Bacon as an analysis example. If we understand how to analyze data on this smaller scale, then it should make it easier for us to see ways of using the expanded and refined version, Network Theory, to analyze our own data in ways we might not have seen before.
How to do it...
We start by opening QlikView 11. This time at the start screen, scroll down to the Examples section and select Movie Database. Note that it claims to have over four thousand movies. With approximately four hundred movies produced each year, currently, that represents the equivalent of ten years of recent movies, but the movies in the QlikView Movie Database range from Tillie's Punctured Romance (1914) to movies released in the year 2008. Therefore, we know it is not a comprehensive list of movie titles, directors, and actors.
If you are interested in verifying this for yourself, jump to the Analysis tab of the