Business Insights

Business Insights dashboard Custom Blocks
Business insights dashboard Standard Blocks
Customers List Custom block
Customer Details view Custom Block
Inventors List Custom Block
Inventors Details Custom Block
Browse branches
Monitor Inventory

Inspiration

Customers love to avail discounts and deals. Business owners are constantly trying to increase sales by offering attractive deals. They wish to find trends in sales and suggestions of targeted deal recommendations for their loyal customers.

What is needed is a dashboard that empowers business owners with valuable insights from transactional data.

What it does

Our Air table dashboard helps business owner to visualise insights, sales and customer adoption trends, and promote contextual deals to customers based on their past transactions.

How I built it

Created Custom Blocks Customers - A custom block for viewing reward points of customers, transactions, current and recommended deals for each customer. Inventory - A custom block for viewing inventory stock details, recent stock bought and sold, current deals and recommended deals for a specific inventory item. Branches - A custom block for browsing branches in a carousel style view. Monitor Stock Inventory - A custom block for monitoring which inventory is running out of stock and needs refill etc.

Standard Blocks Sales trends(daily/weekly) - Amount of sales by day and week. Most popular deals - Popularity of deals. Active deals - Number of deals. Total customer rewards - Total reward points issued in a period. Average weekly spend - Average weekly spend per customer.

Challenges I ran into

There was a learning curve initially for Air Table. But the documentation is awesome, so did not take much time after that to sort things.

Accomplishments that I'm proud of

We are able to use custom blocks beta version to create an insightful dashboard that can help business owners improve sales, plan promotions and increase customer adoption.