Pinned Loading

1. bloomcrest-revenue-intelligence bloomcrest-revenue-intelligence Public

   Revenue intelligence case study: PostgreSQL data warehouse, HubSpot CRM pipeline, automation, and SQL/Python analytics for a two-channel (DTC + wholesale) retail business.

   Python

2. everdale-retail-analytics everdale-retail-analytics Public

   Excel/Power Query retail analytics build: 194K order-line records turned into governed revenue, profitability, and forecast reporting, with data-quality checks and corrected metrics documented.

3. kavora-crm-migration-data-governance kavora-crm-migration-data-governance Public

   CRM migration data-prep build: seven legacy exports consolidated into governed, import-ready Company/Contact/Deal datasets, with the reconciliation gaps documented rather than smoothed over.

4. stock-performance-risk-monitoring stock-performance-risk-monitoring Public

   Python/SQL pipeline + Power BI dashboard for a 10-stock US equity watchlist: extraction, validation, feature engineering, a PostgreSQL star schema, and a walk-forward ARIMA backtest against a naive…

   Python

5. weatherintel-global-weather-analytics weatherintel-global-weather-analytics Public

   NOAA GHCN-Daily weather data turned into a star-schema warehouse, forecast model evaluation (XGBoost/SARIMA vs. baselines), and a Power BI report.

   Python

6. data-analytics-etl-portfolio data-analytics-etl-portfolio Public

   Four Excel/Power Query ETL case studies covering CRM, HR, inventory, and sales, each with a data-quality engine, star-schema modeling, and an executive dashboard.