Email List Growth
Problem Statement: The organization needed a tool to effectively monitor the growth and engagement of its email subscriber list. Existing reports lacked the ability to compare key metrics across different time periods, making it challenging to identify trends and adjust marketing strategies. This project aimed to fill that gap by developing a dashboard that […]
Account Evolution
Problem Statement: The organization lacked a detailed and dynamic tool to effectively track and compare account creation trends over time. This made it difficult to assess performance and identify potential issues or opportunities in customer acquisition strategies. The project aimed to fill this gap by creating a dashboard that visualizes account data and supports comparative […]
Real-Time Sales
Problem Statement: The company required a dynamic tool to track and compare daily sales against targets in real time, enabling better visibility into performance and facilitating prompt adjustments to sales strategies. The existing reports could not provide immediate insights into sales growth and regional performance, leading to delayed responses and missed opportunities for optimization. […]
Real-Time Redemptions
Problem Statement: The company needed a real-time solution to track and analyze redemption activities across multiple business units, as existing processes lacked timely insights, hindering effective decision-making and trend identification. Tools and Technologies: Azure Data Factory, Microsoft Power BI, Azure SQL Summary: Developed a real-time data dashboard using Power BI to monitor and visualize […]
Adventure Works Report (Personal)
Problem Statement: To create Report and Dashboard which can track KPIs (sales, revenue, profit, and returns), compare regional performance, analyze product level trends and forecasts, and identify high-value customers. Github Tools and Technologies: Microsoft Power BI, Microsoft Excel Summary: Imported raw CSV files containing information about transactions, returns, products, customers, and territories in PowerBI. Connected […]
Shipping OTIF Report
Problem Statement: To create a report which showcases the On Time In Full (OTIF) status of all orders of the past two years. GitHub Tools and Technologies: Microsoft Power BI, Business Central, Azure SQL Summary: This report is based on the orders from Business Central. Used the Data warehouse (mentioned in the portfolio) to develop this report. Used SQL […]