Business Intelligence project: showcasing an Airflow ETL pipeline to automate the extraction of school data from an API, apply transformations, and load the data into a PostgreSQL database. Includes Python scripts for ETL, detailed documentation, and examples.
Automating School Data ETL from API with Apache Airflow Read More »
Business Intelligence Project: Analyze marketing campaign impact on term deposits using EDA, correlation, chi-square tests, and linear regression.
Exploratory Data Analysis (EDA) of Bank Marketing Campaign Read More »
Analyzing housing data using Python with EDA, data preprocessing, and statistical methods. Includes Pearson Correlation, Chi-Square Test, Linear Regression, T-Test, and ANOVA to explore trends, correlations, and hypothesis testing.
Exploratory Data Analysis (EDA) for House Prices Read More »
Automate your ETL process using PostgreSQL stored procedures! This project showcases the implementation of dwh.generate_sales(), a robust ETL solution that extracts, transforms, and loads sales data efficiently. Learn how to structure transactional, staging, and data warehouse schemas for optimized reporting and business intelligence.
Automating ETL with Stored Procedures in PostgreSQL Read More »
Explore a comprehensive Data Warehouse design for employee performance analytics, leveraging the star schema approach. Discover insights on employee performance by department, education level, and gender, with actionable recommendations for HR decision-making.
Designing a Data Warehouse for Employee Performance Analytics Read More »
Optimized Sales Data Warehouse Design for a coffee shop business using a Star Schema approach. Includes ERD, data marts, SQL queries, and insightful business analysis to improve store performance, product sales, and sales trends. A must-have BI project for data-driven decision-making!
Sales Data Warehouse Design: A Coffee Shop Case Study Read More »
Data Engineering project focused on designing a Star Schema for a bus travel agent dataset using Kimball’s methodology. Includes ERD creation, identification of slowly changing dimensions (SCD), defining fact tables, and illustrating a Star Schema to support data analysis, reporting, and historical data tracking.
Bus Travel Data Warehouse Read More »
