Business Insights 360
Simulated a real-world analytics project by designing end-to-end Power BI dashboards from mock client requirements, practicing the full BI delivery lifecycle with agile workflows and stakeholder collaboration.
Expense Analysis
• Built WebSocket connection handling 9 crypto pairs with 50ms latency
• Implemented live price tracking processing 500+ data points per minute
• Developed market microstructure analysis with order flow metrics
• Designed
responsive UI with universal search across coins/metrics/alerts
• Integrated risk assessment system with visual volatility indicators
Crypto View
• Built RESTful API with 15+ endpoints using FastAPI handling expenses, users, budgets, and analytics.
• Developed interactive Streamlit frontend with 6 main pages featuring real-time data visualizations and filtering.
• Implemented
multi-user authentication system with phone number registration and admin controls.
• Designed comprehensive analytics engine calculating spending trends, velocity analysis, and financial health scores.
• Deployed full-stack application
on Render with two synchronized services using JSON database.
Employee Reimbursement Dashboard (prompted by "Perplexity labs")
Designed an interactive Power BI dashboard for employee reimbursement tracking using Perplexity Labs.
Automated data cleansing and currency conversion to streamline reporting accuracy.
Integrated dynamic visuals and filters to
reveal key spending and approval trends.
Enabled stakeholders to analyze transactions and optimize expense management decisions.
AtliQ Sales Report
Designed interactive sales performance dashboards using Power BI.
Leveraged Power Query, Pivot, and DAX for data modeling and KPIs.
Compared regional market performance against targets.
Delivered actionable insights to support
data-driven decision making.
AtliQ Finance Report
Created financial reports including Profit & Loss and variance analysis.
Demonstrated financial storytelling to improve strategic planning.
Streamlined Excel-based reporting processes with formulas and automation.
Communicated
key insights effectively to stakeholders.
Project Priority Matrix
Helps evaluate and prioritize key initiatives using a structured scoring system.
Projects are scored on Feasibility (success likelihood), Impact (business value), and Size (effort needed).
Enables identification of high-impact, low-effort
"quick wins" and high-risk, high-reward projects. with formulas and automation.
Used for strategic planning, resource allocation, and aligning projects with organizational goals.
Scenario Planning Tool
Built an Excel-based Scenario Planning Tool for financial forecasting.
Analyzed Best, Realistic, and Worst Case scenarios for product sales performance.
Automated calculations for sales, discounts, COGS, and gross margin against targets.
Enabled data-driven decision-making by comparing profitability across scenarios.
Finance & Top N Insights (SQL)
Used advanced SQL to automate financial reporting in the CPG domain.
Built stored procedures, UDFs, and views for efficient data analysis.
Delivered key insights on top-performing segments and KPIs.
Strengthened SQL optimization
for large-scale reporting pipelines.
View Project
Live Demo