Finally completed my Capstone Project with @TechSphereAcad
I saw 14 tables and how voluminous the dataset was and I told myself I’ll keep the dashboards simple and clear. And I think I did just that.
Thank you @ezekiel_aleke for tutoring me, you’re amazing.👏🏽👏🏽
#DataAnalytics
Task 4 — Power BI Dashboard Built a Sales Performance & Insights Dashboard with 5 KPI cards, 6 visuals and custom DAX measures. Key finding — 41.42% of orders were Cancelled or Returned.
Task 3 — SQL Data Analysis
Cleaned the raw dataset in SSMS — handled NULLs, extracted Month/Year from dates, fixed data types. Then extracted insights using SELECT, WHERE, GROUP BY, ORDER BY and aggregations.
Task 1 — Data Collection
Loaded an e-commerce dataset of 1,200 orders across 7 products and understood its structure: columns, data types, missing values and what the data represents.
Task 2 — Excel EDA
Performed exploratory data analysis using SUMIF, COUNTIF, QUARTILE and more. Uncovered trends across months, products, and referral sources. Detected 8 outlier orders using the IQR method.
Exponential growth is never sudden even though it might appear that way; it is a function of daily tiny additions that are almost invisible.
Just keep showing up.
Finally completed my Capstone Project with @TechSphereAcad
I saw 14 tables and how voluminous the dataset was and I told myself I’ll keep the dashboards simple and clear. And I think I did just that.
Thank you @ezekiel_aleke for tutoring me, you’re amazing.👏🏽👏🏽
#DataAnalytics
After a few days away, I'm back and picking up right where I left off.
Honestly, this week has been really stressful but I finally have the chance to sit down and share this 😅
I completed a 4-page Power BI dashboard on the Sample Superstore dataset — and these are my findings👇
finished this capstone over a week ago and almost kept it to myself because I didn’t like how the dashboard turned out.😭
In my defense, i was trying something new and it didn’t come out exactly how I imagined. but a friend convinced me to share it yesterday
What do you think?
Finally completed my Capstone Project with @TechSphereAcad
I saw 14 tables and how voluminous the dataset was and I told myself I’ll keep the dashboards simple and clear. And I think I did just that.
Thank you @ezekiel_aleke for tutoring me, you’re amazing.👏🏽👏🏽
#DataAnalytics