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. Read more
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 Read more
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, Read more
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 Read more
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 Read more
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 Read more