u/Due-Doughnut1818

Image 1 — End-to-End E-Commerce portfolio project
Image 2 — End-to-End E-Commerce portfolio project
Image 3 — End-to-End E-Commerce portfolio project
Image 4 — End-to-End E-Commerce portfolio project
Image 5 — End-to-End E-Commerce portfolio project
Image 6 — End-to-End E-Commerce portfolio project

End-to-End E-Commerce portfolio project

Hi there 👋

I’ve been wanting to build a project related to e-commerce for a while, but I was looking for a dataset rich enough to build a complete analysis project around. That’s when I found the Olist E-Commerce dataset

I worked on this project in multiple stages:

• Performed the ETL process mainly using SQL Server

• Did the EDA in Python

• Defined the main KPIs

• Connected the database to Power BI and built the dashboard

You can check out the full project here:

[Olist E-Commerce](https://github.com/Madian20/Portfolio\_Projects/tree/main/Olist%20E-Commerce?utm\_source=chatgpt.com)

I’d really appreciate any tips, feedback, or suggestions that could help me improve my next project.

u/Due-Doughnut1818 — 5 days ago

Hi there

I’ve been thinking for a while about what my next project should be and then I realized most of the people who saw my projects on this sub are from the US so I thought why not build something that actually helps people make better decisions about where and how they seek healthcare

The data comes from the Centers for Medicare and Medicaid Services and is based on DRG codes and honestly it did not include a lot of detailed information so I worked with what was available and tried to extract as much value as possible I also used AI to get median household income by state

The workflow was pretty straightforward

ETL in SQL Server

EDA in SQL Server

and the final report in Power BI

You can check out the full project here

[View Project](https://github.com/Madian20/Portfolio\_Projects/blob/main/US%20Healthcare%20Cost%20Analysis/READ\_ME.md)

If you have any tips or recommendations I’d really appreciate hearing them

And if you’d like to connect with me on LinkedIn

[My LinkedIn](https://www.linkedin.com/in/mahmoud-madian)

u/Due-Doughnut1818 — 15 days ago