In Excel, we often merge cells, add title rows, or insert subtotal rows to improve the appearance. If you are just looking at the screen, that might be easier to understand. However, when aggregating ...

Web apps love exporting CSV files, but they don't always play nice with Excel. Leading zeros disappear, dates break, and text fields merge together. Most people waste time fixing these problems ...

This project delivers a production-grade, end-to-end business intelligence and data engineering pipeline designed to evaluate macro e-commerce operations. By integrating multi-table relational ...

This portfolio demonstrates real Data Analyst skills using the Northwind database — a classic business dataset containing customers, orders, products, employees, and suppliers. Every query in this ...