Ubiq Blog

Business Technology News & Insights

  • What’s Ubiq
  • Features
  • Pricing
  • Try Ubiq now!

dashboard

9 financial metrics you must track for growing your Ecommerce business

Ecommerce

Financial metrics is where the rubber hits the road. You can have nice website & do marketing campaigns. But financial metrics tell you the real story.

Continue reading


MySQL date format cheat sheet

MySQL

MySQL Date format is a very handy function. It formats a date as specified in the argument. Here’s a cheat sheet for MySQL date format function.






Continue reading


9 really useful MySQL date functions that are easy to remember

MySQL

MySQL date functions that help you directly get required part of date. Commonly used MySQL date functions. These MySQL date functions are easy to remember.






Continue reading


How to calculate rank in MySQL

Analytics, MySQL, MySQL Tips, MySQL Useful Queries

Many a time you need to calculate rank in MySQL. You can order by a number but can’t calculate rank in MySQL easily. Here’s a query you can use.






Continue reading


How to find nth rank in MySQL?

Analytics, How To, MySQL, MySQL Tips, MySQL Useful Queries

Many a time you need to fin nth rank in MySQL. To find nth rank in MySQL, we will calculate rank in MySQL. Then we filter the nth rank in MySQL.






Continue reading


Calculate decile from recency in MySQL

Analytics, How To, MySQL, MySQL Tips, MySQL Useful Queries

Calculate decile from recency in MySQL. E.g, to rank customers based on recency of purchases or orders






Continue reading


Calculate decile in MySQL based on totals

Analytics, Ecommerce Analytics, How To, MySQL, MySQL Tips, MySQL Useful Queries

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.






Continue reading


Calculate decile from frequency in MySQL

Analytics, How To, MySQL, MySQL Tips, MySQL Useful Queries

Calculate decile from frequency or counts in MySQL. E.g, to rank customers based on number of purchases or orders instead of total sales






Continue reading


Calculate percentile from recency in MySQL

Analytics, How To, MySQL, MySQL Tips, MySQL Tutorials, MySQL Useful Queries

Calculate percentile from recency in MySQL. E.g, to rank customers based on recency of purchases or orders






Continue reading


Calculate percentile in MySQL based on totals

MySQL, MySQL Tips, MySQL Useful Queries

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.






Continue reading


Posts navigation

Older posts

About



Ubiq is a cloud-based BI Platform
for SMBs & Enterprises. Build Reports and Dashboards in minutes.
Try it Today!




  • Popular
  • Recent
  • How to Choose the Right Visualization for your data Jun 30, 2015
  • 5 Customer Satisfaction KPIs You Should be Tracking Nov 22, 2016
  • How Pharma Companies Use BI to Stay Ahead of the Game Nov 17, 2016
  • big data companies
    9 Myths about Big Data That Will Hurt Your Business Jun 19, 2015
  • 7 Key Inventory Metrics every Business Should know Nov 10, 2016
  • design business dashboard
    7 Practical Tips to Design Business Dashboards Oct 19, 2016
  • customer service metrics
    5 Customer Support Metrics Every Business Should be Tracking Nov 3, 2016
  • web push notification example
    5 Ways Startups can Grow Business with Web Notifications Apr 24, 2018
  • millennial marketing
    5 Actionable Tips for Marketing to Millennials Apr 24, 2018
  • instagram marketing tips for startups
    6 Ways Startups Can Use Instagram To Grow Their Business Apr 24, 2018
  • seo tips and tricks for startups to grow business
    5 SEO Tips Entrepreneurs Can Use to Grow Their Business Apr 24, 2018
  • email marketing tips for small business and startups
    5 Email Marketing Tips for Startups to Grow Faster Apr 24, 2018
  • how to promote your business using facebook live
    How to use Facebook Live to Grow your Business Apr 24, 2018
  • lead generation tips
    5 Ways to Get More Leads for Your Startup/Small Business Apr 24, 2018
dazzling Theme by Colorlib Powered by WordPress