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

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?