Centauri Alpha's Retail Data Consulting Project

• dbt
• GCP BigQuery
• Fivetran
• ELT
• Data Warehousing
• Power BI
• pandas
• Statistical Analysis
• Retail
• Customer Retention
• Business Strategy
• Boost Sales
• Data Analytics
• Analytics Engineering
• SQL
• Python

A data consulting project that I implemented for a retail business client during my employment at Centauri Alpha.

The full experience includes:
• Extracting and loading data from Snowflake to GCP BigQuery using Fivetran, and transforming data within the data warehouse by building, testing, and deploying SQL models with dbt.
• Refactoring SQL code for existing dbt models to improve modularity, simplicity, accuracy, maintainability, and readability.
• Collaborating with data engineers and analysts to meet project-specific reporting needs by defining additional metrics in semantic layer, making them accessible to integrated BI tools.
• Analysing online sales data from the data warehouse using SQL queries and Python pandas to identify key customer behaviour factor(s) influencing the client's total online sales. Utilising Spearman’s Rank Correlation and Hypothesis Tests to analyse correlations.
• Performing customer retention analysis employing statistical methods such as Bayes’ Theorem and Confidence Interval for Binomial Proportion, determining that 11% of products lead to high customer churn risk.
• Developing and evaluating a business strategy based on the retention analysis, projecting a potential 10.6% increase in total sales revenue and the retention of an additional 6.2% of customers upon implementation.
• Presenting progress to stakeholders in weekly meetings, delivering data insights through visualizations with Power BI.