This is a mortality trend dashboard I designed on Ms Excel whose goal is to provides a comprehensive overview of death trends across different time periods, locations, and demographic groups.
Check out the full information on my LinkedIn.https://t.co/Z8RtRasjIM
Recently, I worked on creating a stored procedure in SQL to automate a task. The goal was simple: write a procedure that accepts an Order ID and returns the list of items in that order along with the total amount.
#SQL#dataanalytics
Nobody really talks enough about the person who gave us our first shot.
That first client, that first boss, that person who believed we could actually do the job.
They took a chance on us even when we had zero experience.
I see a lot of Data Analyst portfolios...more than I'd like to admit.
Most people show dashboards. Great. But hiring managers want to see that you can think through the data not just visualize it.
Here are three projects thatโll make you stand out:
You're STILL a data analyst even if...
- you only use Excel
- you forgot the SQL syntax
- you bombed the big interview
- you don't know how to program
- you did an analysis completely wrong
- you can't remember the right function name
- you have to Google how to do something easy you've done before
You're NOT a data analyst when...
- you give up
SO DON'T GIVE UP! KEEP GOING!
Every little thing you learn adds up someday.
Iโm the kind of person whoโs open to learning and always finds a way to use any skill I have to achieve what I want.
It might not make sense now, but itโs taking me somewhere.๐ฏ
This is a manager sales performance dashboard I designed and built in power BI for a gadget company.
The goal of this dashboard is to provide a comprehensive overview of each manager sales performance.
Check out the full report on my LinkedIn
https://t.co/gx9DkVrzyx
Youโre gambling?
Pray your Solah
Youโre drinking?
Pray your Solah
You do drugs?
Pray your Solah
Youโre an Oscroh?
Pray your Solah
Youโre a fraudster?
Pray your Solah
Youโve got girlfriends?
Pray your Solah
You go clubbing?
Pray your Solah
Everyday, pray your Solah Bro!
Two years into data analysis and I still Google โhow to calculate growth rateโ at least twice a week. ๐งต๐
If youโre struggling with imposter syndrome in this field, this oneโs for you:
๐๐ก๐ ๐๐ฑ๐ฉ๐๐๐ญ๐๐ญ๐ข๐จ๐ง๐ฌ ๐it ๐๐ข๐๐๐๐ซ๐๐ง๐ญ
Your manager assumes you can build that โquick dashboardโ in 30 minutes.
Your family thinks youโre basically a fortune teller with spreadsheets.
That bootcamp classmate posting perfect visualizations on LinkedIn makes you question everything you know.
Meanwhile, youโre still figuring out why your pivot table keeps showing #VALUE errors.
๐๐ญ ๐๐จ๐ซ๐ค, ๐๐ญโ๐ฌ ๐ ๐๐๐ข๐ฅ๐ฒ ๐๐ญ๐ซ๐ฎ๐ ๐ ๐ฅ๐
I nod confidently when stakeholders mention KPIs Iโve never heard of, then frantically Google them after the meeting.
Iโve presented analysis that took me 3 days as โpreliminary findingsโ because I was too embarrassed to admit how long it actually took.
Last week I asked ChatGPT to explain my own SQL query back to me because I forgot what it was supposed to do.
๐๐๐๐ซ๐ง๐ข๐ง๐ ๐ ๐๐๐ฅ๐ฌ ๐๐ข๐ค๐ ๐๐ซ๐จ๐ฐ๐ง๐ข๐ง๐
Every tutorial assumes you know 5 things you donโt.
You follow along perfectly until step 4, then everything breaks.
YouTube comments are full of people saying โthis is so easy!โ while youโre rewinding the same 30 seconds for the tenth time.
You bookmark courses youโll โdefinitely finish next weekโ and add them to the graveyard of half completed certifications.
๐๐ฎ๐ข๐ฅ๐๐ข๐ง๐ ๐ข๐ง ๐๐ฎ๐๐ฅ๐ข๐ ๐๐ฌ ๐๐๐ซ๐ซ๐ข๐๐ฒ๐ข๐ง๐
I post my work knowing someone will point out what I did wrong.
I share โinsightsโ that feel obvious to me, terrified theyโre actually stupid.
Every LinkedIn post feels like standing naked in front of experts who could tear apart my methodology in their sleep.
But hereโs what happened when I started sharing anywayโฆ
๐๐ก๐ ๐๐๐ฌ๐ฉ๐จ๐ง๐ฌ๐๐ฌ ๐๐ก๐จ๐๐ค๐๐ ๐๐
Beginners thanked me for showing โmessyโ code. Senior analysts admitted they still struggle with the same basic concepts. That scary expert I follow? They commented โgreat question, I learned something new.โ
Turns out everyoneโs figuring it out as they go. Weโre all just at different stages of confused.
๐๐ก๐๐ญ ๐โ๐ฏ๐ ๐๐๐๐ซ๐ง๐๐ ๐๐๐ญ๐๐ซ ๐ ๐๐๐๐ซ๐ฌ
Your value isnโt knowing everything. Itโs being curious enough to find answers when you donโt. That โbasicโ question youโre afraid to ask? Five other people in the room have the same question.
The senior analyst you admire still Googles syntax. That influencer with perfect dashboards probably spent hours making it look effortless.
๐๐จ ๐๐จ๐ฐ:
I document my learning process, mistakes included. I ask โdumbโ questions in meetings because they usually arenโt dumb.
I share work thatโs good enough, not perfect.
Most importantly, I stopped waiting to feel qualified before sharing what I know.
Because hereโs the truth: If youโre helping someone whoโs one step behind you, youโre qualified enough.
Your imposter syndrome isnโt proof you donโt belong. Itโs proof you care about doing good work.
And thatโs exactly the kind of analyst we need more of.
To everyone still figuring it out: your questions make the field better, not worse. Keep asking them.
Drop a ๐ญ if this resonated with you. Whatโs one thing you Googled this week that you thought you โshouldโ already know? Letโs normalize learning in public.
#Datafam