Just finished my first data analytics portfolio project. ๐
An E-commerce sales Analysis.
360 orders. 4 countries. โฆ249K in revenue. And one product that was quietly running the whole show.
Full Project on GitHub:
https://t.co/BRG1PUh7BM
#DataAnalysis#BuildInPublic
โWireframing in powepointโ ๐
โWireframing in Figmaโ ๐
โHTML aminationโ ๐
Are these part of Data visualization or Iโve entered another universe? Because Iโm still wrapping my mind around DAX but lately Iโve been beleaguered on the timeline with these phrases.
Please help o ๐คฒ๐พ
โ๐๐๐ซ๐, ๐ฐ๐ ๐๐จ๐ญ๐ก ๐ค๐ง๐จ๐ฐ ๐ฒ๐จ๐ฎ ๐๐ข๐๐งโ๐ญ ๐ฌ๐ญ๐๐ซ๐ญ ๐ญ๐ก๐ข๐ฌ ๐จ๐ง ๐ญ๐ข๐ฆ๐.โ๐
I have this thing where I work best under pressure. Give me a tight deadline and Iโll deliver. (๐๐ฌ ๐ญ๐ก๐ข๐ฌ ๐๐ฏ๐๐ง ๐ง๐จ๐ซ๐ฆ๐๐ฅ?๐ฉ)
Give me two weeks and Iโll spend the first ten days convincing myself I still have time.
This is not the case when I have work Deadlines, deliverables, back-to-back tasks โ I handle all of it.
๐๐ฎ๐ญ ๐ญ๐ก๐ ๐ฆ๐จ๐ฆ๐๐ง๐ญ ๐ข๐ญโ๐ฌ ๐ฌ๐จ๐ฆ๐๐ญ๐ก๐ข๐ง๐ ๐ฉ๐๐ซ๐ฌ๐จ๐ง๐๐ฅ? ๐๐จ๐ฆ๐๐ญ๐ก๐ข๐ง๐ ๐๐จ๐ซ ๐๐? ๐ ๐ฐ๐ข๐ฅ๐ฅ ๐๐ข๐ง๐ ๐๐ฏ๐๐ซ๐ฒ ๐ซ๐๐๐ฌ๐จ๐ง ๐ญ๐จ ๐๐๐ฅ๐๐ฒ ๐ข๐ญ.
This project has been sitting in my head for a while. I knew what I wanted to do. I just kept pushing it. Until I finally said okay, letโs do this.
And here we are. Still not done, but itโs alive. ๐ฉ
I think a lot of us do this with the things we actually care about. We give our best energy to everything else and leave our own ideas on the back burner.
If youโre sitting on something right now โ a project, an idea, something you keep saying youโll start. ๐๐ฎ๐ฌ๐ญ ๐ฌ๐๐ญ ๐ ๐ซ๐๐๐ฅ ๐๐๐ญ๐. ๐๐ก๐๐ง ๐ญ๐๐ฅ๐ฅ ๐ฌ๐จ๐ฆ๐๐จ๐ง๐ ๐ฌ๐จ ๐ฒ๐จ๐ฎ ๐๐๐งโ๐ญ ๐๐๐๐ค ๐จ๐ฎ๐ญ.
Thatโs literally how it might work, I guess.
Anyways, more updates soon. ๐
Lesson learned:
If your visuals arenโt responding to filters, donโt rush to rewrite your measures.
Check your model.
Power BI is only as smart as your relationships.
I hit a wall in powerBI at 2am this morning.
I spent hours debugging a Power BI dashboard todayโฆ only to realize the problem wasnโt my DAX.
My visuals showed the right totals, but refused to respond to filters.
A thread ๐งต
The moment I fixed the relationships (especially cross-filter direction), everything clicked instantly. The same measures I had doubted started working perfectly.
That moment changed how I think about Power BI.
@officialladi_T Keep going champ ๐ฅ
I hopped on the Google Data Analytics Professional Certificate as well. I found a huge knowledge gap that needed to be filled and structured.
One course in, so far so goodโฆ
What helped me:
A simple flowโ
Understand the data โ Identify stakeholders โ Ask the right questions โ Define KPIs โ Analyze โ Communicate insights
The shift?
From โwhat can I build?โ
To โwhat problem am I solving?โ
#DataAnalytics#LearningInPublic
One thing Iโve learned in data analytics:
Having data โ having direction.
Most times, weโre given datasets with instructions.
But in reality, youโre given data and expected to think.
Thatโs where many beginners get stuck.
๐งต ๐๐พ
There are 2 ways to approach analysis:
1. Question-driven โ Youโre given a question, then find data
2. Data-driven โ Youโre given data, then figure out the questions
The second is harderโฆ
But thatโs where real analysis begins.