Drill down bars using dashboard action filter

Dashboard action filters are a powerful way to do drill downs in Tableau. Most users will want to dig into the details once a problem has been identified, drill downs are a great way to allow for that type of exploration. In this dashboard we have created a quick component that you can apply in many other settings with your own data.

One other thing to keep in mind is that bar charts with value labels are not that far from Excel crosstabs or pivot tables. Thus, bart charts are a good way to visualize data for an audience that is coming from a spreadsheets heavy background.

Download the workbook here

Enable self-service BI and Analytics with SeekTable – a super simple online pivot table solution

There are many dashboard solutions out there these days. They all compete on similar features like top visualizations, data connectivity, usability and simple data processing. The simplest form of self-service analytics, however, is not getting much love from these solutions. And what is the simplest form of self-service analytics? Well… pivot tables of course.

(more…)

How to automate cohort analysis and charting with Python and Matplotlib – The Python Cohort Charting Cookbook

When you are dealing with potentially hundreds or thousands of customers, the rate at which those customers come or leave is a critical KPI. Especially when it comes to certain industries like SaaS companies, customers are coming and going all the time. In fact, the rates at which clients come and go can also change drammatically based on different factors like marketing campaigns, price segmentation, price changes, etc..

(more…)

Building dashboards in Apache Superset from Google Sheets data

Google Sheets is a great tool when it comes to managing a lot of data quickly without custom code development. You can build easily quick spreadsheets to solve your data or business application workflows. You can also use spreadsheets as a way to collect input data from multiple people.

But Google Sheets, like all spreadsheets, is not great when it comes to building visually pleasing dashboards, there are better tools for that. Also, if you need to blend multiple sheets or workbooks, Google Sheets can be very manual and labour intensive.

(more…)

Challenge – Set up Python for business analytics and data crunching today (in under 1 hour)

Python is a powerful open source (and free) programming tool. You can do and automate everything with Python.

Python is now at a such level of maturity that it is used by businesses of all types (not only the Google types). It is getting increasingly popular in business settings for data science and analytics.

I created a quick challenge that will get you coding and data crunching in Python in under 1 hour, to get started, follow these steps:

And then try to answer those questions using Python and the Pandas library on the Anaconda platform:

  • Get the top 10 of something (i.e. top 10 regions in terms of sales)
  • Count of something (i.e. how many customers?)
  • Sum of something
  • Max of something (i.e. biggest customer)

You can post your answer and solutions in the comments below and I’ll give you my feedback. If you need help or have questions, also just ask below in the comments.

Bonus exercise. Now cascade this exercise down into a company or team. What additional challenges do you see and why?