Business Dashboards are a great way to monitor your business and grow it faster. A dashboard provides at-a-glance view of all the key aspects of your business, in one place. If designed properly, dashboards can provide amazing insights. Else they can confuse and misguide you. Here are 7 steps you can use to design business dashboards for your business. […]
Dashboards are a great way to keep track of your business. However, if you’re not using a good dashboard software, you won’t be able to build insightful dashboards for your business. Here’s a list of features you can look for in a dashboard software while selecting one for your business. 1. Supported data sources Wouldn’t it be […]
Data Visualization enables you to easily draw insights from data and make better decisions. However, if you don’t use the right visualization to display your data, it can confuse the viewer, instead of educating him.
Calculate decile from recency in MySQL. E.g, to rank customers based on recency of purchases or orders
You can calculate decile in MySQL to identify best customers. You can come up with more focused, relevant retention initiatives. Here’s a query to do it.
Calculate decile from frequency or counts in MySQL. E.g, to rank customers based on number of purchases or orders instead of total sales
Calculate percentile from recency in MySQL. E.g, to rank customers based on recency of purchases or orders
It can be a pain to calculate percentile in MySQL. There are no functions for it yet. Here’s a ready made query to do it.
Calculate percentile from frequency or counts in MySQL. E.g, to rank customers based on number of purchases or orders instead of total sales
Calculating difference between two dates in MySQL is really easy. Here’s how you can do it. Let’s say dt1 and dt2 are 2 columns in table table_name.