Image

About Scatter Plots

The Qlik platform is all about analyzing data and making discoveries. However, in order to get valuable insights for your organization, you can’t just go around loading any data source and creating random charts. On the contrary, a good QlikView developer will always strive to use the most appropriate objects for each type of analysis.

Even though classic visualizations such as bar, line or pie charts are essential components of most applications, complex inquiries usually require more sophisticated tools to gain full understanding of the situation and make the best decisions possible. In this regard, one of my favorite visualizations is the scatter plot (Well, scatter plots and histograms, but we’ve already talked about those).

Although not very common, when used adequately, these charts can be real eye-openers. Sadly, its usage is still covered in a veil of mystery for the majority of the business users who –for a strange reason– seem to fear its power. But anyways, back to the story…

This chart stands out due its ability to elegantly handle great amounts of data. Though its simplest form only combines one dimension and two expressions plotted along the x and y axes, you can enrich them in several ways. Let’s start with an easy example:

Scatter_01

Each bubble in this chart represents one of On Nom Nom Nom’s food trucks. As the y-axis embodies the sales amount, the higher the bubble is, the “stronger” the food truck. On the other end, the x-axis represents the Margin %. Therefore, a bubble far in the right could be categorized as “more intelligent” due to its higher profitability. In this case, the best scenario for the company would be to have most of the bubbles in the upper right corner, meaning that all the food trucks sell a lot but also have good margins.

To make this visualization clearer, we can add reference lines and define static of dynamic thresholds with variables and traditional expressions: Continue reading

Advertisements

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