Creating Stunning Dashboards with QlikView

It’s been a while since the last time I shared a post here, but believe me, I have a great excuse! Over the last few weeks, I’ve been working very hard with the guys from Packt Publishing on a book that covers two of my favorite topics: dashboards and data visualization. So, without further ado, I gladly present you “Creating Stunning Dashboards with QlikView”.

Cover

This tome guides you through the process of creating effective and engaging dashboards that deliver tangible value to the business. Throughout its chapters, you will learn how to apply some of the best practices in the field of data visualization, create a robust navigation schema, work with colors, choose the best chart types for each scenario and many other things that will help you create useful applications that will uncover all the stories behind your data.

Though you might think that this is the average “do this, do that” handbook, this publication was written much like my blog; it contains technical stuff, best practices, opinions, tutorials and even some humor. However, this time I had an amazing group of people that helped me out: Larissa Pinto, Priyanka Mehta, Shruti Iyer and Parag Topre from Packt; Hakan Hansson, Speros Kokenes, Mark O’Donovan and Karl Pover in charge of the technical review and QlikView All-Star Bill Lay who was kind enough to write the foreword.

PACKT LogoAmazon LogoBarnes Noble Logo

 

If you want to know more about this book, go to its section in this site (you didn’t know there were other pages in this blog right? Surprise!!!). Although Amazon usually delivers faster, I prefer Packt because you have immediate access to the digital version in multiple formats*

Subpages

I really like the end result, and I hope you find it useful and have a good time reading it, so be sure to check it out. Also, don’t forget to share your thoughts about it, I’ll be looking forward to hearing your feedback!

Hope to see you around,

Julian Villafuerte

Advertisements
Quote

Just Qlik it: Double Gauge

‘Just Qlik it’ is a new section of our blog that focuses on sharing useful components… that kind of objects that are not incredibly complex, but are easy on the eye and convenient to have around.

On our first delivery, I’d like to share a double gauge that gets along pretty well with comparisons between ratios (for example, net and gross margins).

9.1

You can easily copy, paste and configure this component by modifying the colors and formulas in the Presentation tab. Just remember that there are two independent gauges and that you should include your formula in the Lower Bound of the second segment.

You might also want to change the Min and Max values allowed. If your numbers are usually between 0% and 30% there’s no need for a gauge that goes all the way to 100%.

9.2

[ Download File ]

I often use this kind of representation to highlight the main KPIs of the tab and reinforce them with a detailed table in the lower part of the screen. In the downloadable file, most of the objects are dummies created only to Continue reading