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…)

Analytics and Dashboards with ElasticSearch and Kibana, setup and link to a demo

Today we will have a look at how to setup an analytics dashboard with the Elastic suite, specifically at Elasticsearch, Kibana and Logstash.

The Elastic suite is a set of applications made to provide everything needed to build a data analysis system fully integrated with existing software, be it an ecommerce like Salesforce or a custom-made platform, like Django or Rails-based applications.

(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?

Exporting a Tableau viz data into Excel (html Excel button)

Rolling out Tableau to 500+ users is challenging, especially if your users are coming from old BI tools like BOBJ or Cognos. The first question most of them will ask is: where is the Excel download? Yet Tableau does not have an Excel download option, only csv. Yes, you can open csv in Excel, but unfortunately, csv is problematic when you are dealing with an international audience as dots and commas get misinterpreted when you open the file in Excel. This is bad as it messes with the numbers, which is the reason why users are downloading files in the first place. There is no direct Excel download from Tableau that I know off, so I built one.

(more…)