Bank Transaction Analysis in SQL

The management team at Data Bank want to increase their total customer base - but also need some help tracking just how much data storage their customers will need. This case study is all about calculating metrics, growth and helping the business analyse their data in a smart way to better forecast and plan for their future developments!.

HPN Key Metrics Analysis in Power BI

High Power Nutrition(HPN) needs to track KPIs like (Net Sales, Profit, Orders and Returns) show the products with the highest returns and refund rates Show insights on monthly, weekly, quarterly and yearly basses

Business Operation Optimization Using SQL

Danny is faced with the challenge of expanding his new Pizza Empire, but he recognizes that relying solely on pizza sales may not secure the seed funding needed. To address this issue, he aims to create a new business model by combining pizza delivery with an "Uber-like" approach.

MovieNow decision making using SQL

MovieNow wish to make informed decisions about which movies to add to their inventory, which actors are the most popular, and which genres are the most in demand. Additionally, the rental data could be used to optimize rental policies to maximize customer satisfaction and revenue.

Get in touch