Projects

Built an end-to-end Snowflake + dbt analytics engineering pipeline for 17K+ Airbnb listings and 410K+ reviews. Implemented layered modelling, 26 data-quality tests, incremental processing and deduplication, SCD Type 2 snapshots, Jinja macros, RBAC and DEV/PROD deployment, producing a tested analytics-ready OBT for downstream BI. Click here for the Github Repository. Click here for the Project Video. Tableau Dashboard

Retail sales data is often spread across multiple files and systems, making it difficult for business leaders to get a clear view of sales performance, profitability, returns, discounts, and regional/product-level performance. This project solves the problem by building an end-to-end analytics platform using Microsoft Fabric and Power BI, where raw retail data is ingested, transformed through a Bronze–Silver–Gold Lakehouse architecture, validated, modeled semantically, and visualized through a business-ready Power BI report.

Built an end-to-end GCP analytics solution for e-commerce order fulfilment and customer experience. The project uses BigQuery public data and Cloud Storage ingestion, with Dataform for transformation, data quality assertions, dependency management, version-controlled production workflows, and scheduled execution. Business marts power a Looker Studio dashboard analyzing order status, cancellations, returns, fulfilment time, product risk, customer behavior, and performance against service targets. Google Data Studio Dashboard:

Project: Facebook Ads, GA Marketing Project: Hospitality Business Project: NGO Project: Pharma

Google Data Studio is an online tool for converting data into customizable informative reports and dashboards that are easy to read and share.

Tableau is a powerful data visualization tool used for Business Intelligence and Data Analysis. With Tableau, one can create beautiful & effective visualizations. Check out the visualizations created by me on my Tableau public profile: Click Here

Here is a sample of a Power BI paginated report created by me. Paginated reports are created when you need data to be displayed in a way that it fits well on a page, like a table of data which spans multiple pages. These well formatted reports are optimized for printing or PDF generation. They are also called Pixel Perfect reports as you can easily control the report page layout.

Surveys are great tools for getting insights into various aspects of businesses. Recently, I created a survey analysis report for a client. Here is a sample of the analysis created. Main Excel tools used are – Power Query, Pivots and Charts. The data used here has been completely changed for privacy requirements.

Create a smart solution with this smart analytics tool. Power BI is easy to use and can create great visualizations & interactive reports, enabling and enhancing business decisions. Here is a view of a report for a Furniture store chain created in Power BI.

Here is a Dashboard for a pharmacy chain. Main concepts used are – Power Pivot, Power Query, DAX, Charts, Slicers. Power Pivots can handle multiple Excel files with large amounts of data. Using these concepts excellent reports and dashboards can be created easily and additional data can be added with ease.