Anshu Anshu

I’m Anshu, a B.Tech CSE student (2026 batch) based in Noida, currently training in data science at Ducat. I’m looking for an entry-level Data Analyst or Business Analyst role where I can work on real business questions and learn from a team.
My main project is OlistEcom, a SQL Server data warehouse built on the Olist e-commerce dataset (about 100k orders across 9 tables). I used a Bronze/Silver/Gold architecture with a stored-procedure load, error handling, a star schema and validation checks, then built a 6-page Power BI report on top of it. The part I’m proudest of is the data quality work: I checked NULL patterns against order status, handled 1,359 orders with contradictory timestamps without dropping real records, and kept 610 uncategorized products so I wouldn’t delete real revenue.
I also built a Python analysis of the same dataset (pandas, Matplotlib, Seaborn) covering sales, customers, delivery and sellers. One finding: customers whose first delivery was late repeated at a lower rate (2.62% vs 3.13%).
Skills: SQL/T-SQL, Power BI/DAX, Python, Excel, data cleaning and validation.
SQL Project: github.com/anshubalhara23/OlistEcom
Python Project: github.com/anshubalhara23/Olist-Ecommerce-Business-Analytics