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.
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..
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.
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?
Ever read “must be very detailed person” in a CV? Me, all the time. It seems all companies do in finance and analytics is surfing through mountains of detail. Detail is so sexy… employees swear by it.
Understanding the world of data science and analytics today can be a daunting task. A lot of it is because definitions are not clear. Sometimes data science is defined very broadly, sometimes very narrowly. All this can be very confusing and hard to pin down.
We first discussed Superset here. The post was about first impressions, potential, pros and cons vs more mature solutions like Tableau, I suggest to read that post too as there is a lot of information and thoughts about Superset there. But I wanted to test this tool a bit more, so I thought why not trying something out with Shopify?
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.
So, it’s 2017 and I am in the middle of a self-service roll out to a global audience of 500-600 users and I am using Tableau for reporting and visualization. However, there is now a new cool kid in town and many Tableau professionals are a bit on the hedge about this new competitor. But let’s go straight to the point:
Which dashboard tool is better, Tableau or Power BI? (more…)