How to impress your boss: Infographics, dashboard, visualization tools

An image worth more than thousand of data, sorry words. Yes, sometimes you have a lot of data to present in a very small period of data. What is better than a good dashboard where to see in a glance your KPI’s or a nice infographics to show tons of info in few seconds?

People don’t have time, so having all in one page is very useful to present but also to make a good storytelling to help your audience to digest complex info and memorize important messages.

63% of your audience could remember stories, but only 5% could remember a single statistic (Source: Stanford professor Chip Heath)

Create an infographics

You can simply create an infographics with Picktochart

Infographics Photo by rawpixel on Unsplash
Infographics Photo by rawpixel on Unsplash

Here how it works:

  • Sign in to piktochart
  • Define a template 
  • Select from the left menu with icon, graphics that you want to change or adjust (graphics, background, text, color, tools) 
  • On the top side you can save, share or download

Below you can find some examples 

A simple but powerful infographics could be found here:

How quitting smoking affect your body

Infographics on Pinterest

What now you have to do is just think about which are the data that you would like to present and how to create a good storytelling that your audience will remind.

If you need to analyze quickly your data, consider to read: How to analyze your data in 5 minutes with Panda.

Build your dashboard in 5 minutes

Dashboard helps you to understand immediately what is going well (maybe showing green numbers, up arrows) and where to investigate more maybe with other self-service reports.  

An example of interactive dashboard
An example of interactive dashboard -Photo by rawpixel on Unsplash

To create powerful visualization you need to fulfill the following requirements:

What I want to explain with this dashboard? Maybe I want to show if we have reach our sales target, or which are the most contributors for growth or products that are in delay

Test how simple and easy to read is your dashboard: go to one of your colleague with less familiarity with technology and ask to explain the content of our report. If he/she report the right message you have created a good one. Otherwise interview other people on what is difficult to read or unclear and simplify.

Create your dashboard: you have several tools to create it:

  • Excel: Best info At Chandoo.org where you will discover how to create and manage your dashboard.
  • Python: More complicated but you can define every aspect of your dashboard. 
    • Plotly and Bokeh are the modules that you can use to excel on this topic. 
    • An interesting example is this Bokeh dashboard or Kickstarter project by category and status (successfull, cancelled…) including also name of the project if you pass through 
An example of kickstarter dashboard done in Bokeh
An example of kickstarter dashboard done in Bokeh
  • R: Best choice: Here you can customize everything, using Shiny and Rmarkdown using less code than Python. 
    • An interesting example is R Cran download monitor, where in one page you can see evolution of package download, name 
CRAN download - R dashboard example
CRAN download – R dashboard example

 

 

 

 

 

 

 

 

If you want more please consider in subscribing to our fun newsletter and our recent posts

 

3 fundamentals statistic skills for data science?

Today I would like to discuss with you about statistic skills you need to develop, if you want to become a data scientist. Do you need to be graduated in Statistics to do this job? The quick reply is some Statistics is needed, but practice is more important.

Statistic skills: what are you talking about?

I really loved this quotation by Manish Tripathi 

Data Science without Statistics is like owning a Ferrari without brakes. You can enjoy sitting in Ferrari, show off your newly owned car to others, but you can’t enjoy the drive for long because you would crash land soon!

http://qr.ae/TUpAIF

A good data scientist, need to know :

-use statistic skills to explore and visualize data

-most important statistical theories (like hypothesis testing, bayesian analysis)

-know most common statistical models and define which is best to use (like linear regressions. Time series analysis) 

-evaluate if the model is working for the purpose of your analysis.

But theory is not all, so the best way to learn about Stat skills is through practical approach. So don’t expect to become a good data scientist only reading books or learning theory. 

Use statistics skills to explore data: 

Understand & summarize your data: 

If you are new in the world of data, dataset and graph, you can start from this free course  : Analyzing categorical data provided by Khan Academy.  Here you will learn how to identify individuals, variables, read different  types of graphs and much more. I suggest to stop at first module, if you are at a basic level.

Grouping & Visualization

This is a fondamental exercise to be done with your dataset. Let’use a free dataset on regarding Wine reviews Kaggle dataset

In this dataset you  will have 130k wine reviews with wines coming from all over the world, scored by wine taster from 0 to 100, including a lot of info related to qualitative features of the wine. 

We would like to understand in few minutes:

  • which variable do we have in the dataset? 
  • which data types are (numbers? if so what kind of numbers – maybe strings of text)
  • How many data we have? Number of rows and columns 
  • For some variables which are minimum, average and maximum values
  • which is the median (mid point of the data set) and the mode (most frequent observation)?
  • How is the distribution of our data? For on?e variable which is the average observation for the first 25% of my dataset, and for 50%

To see these analysis in action, have a look to: Python: Analyze your data in 5 minutes with Panda

Take advantage of Simple statitiscal concept

Let’s briefly report same simple statistical concept that it will be deep dive in separate post

  • Descriptive statistics: you are probably familiar with mean, median, mode, ranges and quartile.  This info will help you to understand how looks like your dataset. 

Coming back to our Wine dataset just with one command you can identify many of these information. In this case you will see that your database has around 130.000 records, with an average points (coming from reviews) of 88,45 and a reported average price of 35,36$

Statistic skills: Analyze your data with pyton and panda_df.describe
Simple statistic skills: descpritive statistics with pyton and pandas

Minimum value is 80 and 4€ for price and max is 100 for variable points and 3.300 for price (Wow!!)

Percentiles:25%, also called first quartile: it means that observation 32.492 is represe
nting 25% of your dataset (in ascending order). This observation has an average review of 86 and a price of 17$. 

Interesting to see that to arrive to 50% of this database you will increment only 2 value in points (88) but +30% in price (25%)

More specifics on percentile could be found at Statistichowto or at Statistic for Dummies

  • Distributions: explain you how it is possible (probable) that your data will be distributed. More famous is normal distribution, also knowned as “bell curve” (that happens many time in nature). Another important distribution curve, is binomial, that easily represent two status, i.e success or failure of a new drug.We will discuss about distributions in a separate post about distributions.

In the next topic we will discuss also about Hypothesis testing, Regression model, Time series analysis and other Intermediate Statistical concepts

Stay connected and subscribe to our newsletter to learn more about how to became a great data scientist. 

If you have liked this post on fundamentals statistic skills for a great data scientist, please sharing it through social buttons. Let me know your comment or thought adding a comment!