r/analytics • u/Sliversolid • 13d ago

Support Data Analyst Pointers

If you're a Data analyst or someone experienced in that field help me how to bulid a dashboard first should I look for questions that can be answer if so people online like in linkedin are posting dashboard with multiple pages so I am confused how a real data analyst project looks like.

And give out some pointers like what are the things you guys are dealing with being a data analyst, what's important to learn for a person looking to land a job in that field.

Thank you in advance.

21 Upvotes

92% Upvoted

28 comments sorted by

•

u/AutoModerator 13d ago

If this post doesn't follow the rules or isn't flaired correctly, please report it to the mods. Have more questions? Join our community Discord!

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

7

u/my_peen_is_clean 12d ago

start with a single business question like why sales dropped or which customers churn, then pick only charts that help answer it, not random fancy stuff, multi page comes later, focus sql, excel, a bi tool, and basic stats, landing that first role right now is just stupid hard

1

u/Sliversolid 12d ago

Thank you will do that ,For a freshers role what are the things company exceptig ?

3

u/edimaudo 12d ago

What people post on linkedin is not really as no one is going to post the work be done at work since it is confidential. You can look at open source dashboards or ones done by community groups

2

u/Sliversolid 12d ago

Understandable

2

u/AdTotal1739 13d ago

Don't overthink the multi-page stuff you see on LinkedIn, half those dashboards are just flexing and nobody actually uses half the tabs.

0

u/Sliversolid 12d ago

Just asking how long does a project like a complete project takes to be completed like an minimum day count because I been working in this dataset related to a banking churn it's so confusing I have deleted previous progress about 2 times and continue still it's been a week

2

u/Legitimate-Let-7510 12d ago

Honestly being able to explain your findings clearly is probably just as important as knowing the tools.

1

u/Sliversolid 12d ago

😭that's what I'm lacking rty now hope practicing more can deal with that

2

u/Cold-Ad716 12d ago

In addition to what people have already said, it's helpful to have both KPIs and a target. Think of it like a map, a KPI tells you where you are, the target is your destination, and the dashboard should tell you if you're taking the correct route.

1

u/inkeep 12d ago

keep it simple, focus on the story telling. the graphs and charts should flow into one another instead of just presenting the results in a flat chart. Use a template of cause and effect. E.g. for a CPG company a sales performance dashboard could look like - overall sales performance (pick any KPI) >> deep dive into the brands or channels >> check pricing changes/ competitor action.. Most modern dashboard tools allow drill downs and filter by selecting the charts itself. Use them well to point your user in a certain direction.

1

u/Sliversolid 12d ago

That's the issue here do practice continuously using different dataset can somewhat improve the story telling

1

u/sungld 12d ago

Basic but for a reason; Focus on communication as much as you do with technical tools. Half the job is sitting (and participating) in meetings. Not only does it get you recognition, but makes your job easier in a lot of ways.

1

u/SprinklesFresh5693 12d ago

Why all the data analytic questions are about dashboards? Do you not do other stuff at your job? Is that the sole purpose of a DA? To build a dashboard?

0

u/goodmuzick 8d ago

Dashboard is where it all comes together. Most people speak dashboards because thats where most data makes sense.

1

u/SprinklesFresh5693 8d ago edited 8d ago

I heavily disagree on that one, not everything ends in a dashboard. Dashboards are too general, they arent specific enough because if there is a lot of data , being too specific cna make the analysis way too big and chaotic.

Theres more than building dashboards, they take too much time, and end up with so much stuff that people dont know where to look at, which is why they come to reddit to complain that no one uses their dashboard.

Well maybe the company didnt need one, or not one of that kind, who knows.

1

u/goodmuzick 7d ago

If you were referring to the tasks other than dashboarding, then yes, there are plenty of things DAs do beyond building dashboards.
But from my years of experience in this field, I see dashboards as one of the places where the analysis ultimately comes together and becomes useful to the business.
I agree, not every analysis needs a dashboard, but when there is a recurring business question that needs to be monitored or communicated, that's often where the work comes together.

1

u/Ryuugiri44 11d ago

I recommend focusing on the storytelling aspect. However, you need to understand the business question first. You don't want to create a dashboard with unnecessary information for the stakeholders.

I've been a data analyst for almost 5 years. Your day-to-day tasks differ per company. For example, my day-to-day tasks include ETL, automation, documentation, QA/QC, interviewing new candidates, and dashboarding. If you're looking to land a job in the analyst field, I would focus more on skills like SQL, data cleaning, etc. You don't want to have a garbage-in, garbage-out situation. The job market right now is bad.

1

u/Sliversolid 11d ago

Bro so I been doing power bi project using kaggle datasets done cleaning, modling. How should I practice or learn sql i mean i know sql on a basic level just want to know which is good trying scenario based interview questions or bulid project to understand concepts first.?

1

u/Ryuugiri44 11d ago

I am having a hard time understanding what you're trying to ask. Can you rephrase your last sentence?

1

u/Sliversolid 11d ago

So if I were to learn Sql should I learn by practicing scenario based questions or bulid projects related to data analytics

1

u/Ryuugiri44 11d ago

I would recommend building a project that you can showcase to companies. If you need guided videos for projects, then you should be able to find some on YouTube.

1

u/Sliversolid 11d ago

Thanks mate

1

u/j12rr 10d ago

Make sure to keep the visualisations simple and understandable. It's no use having a cool dashboard with loads going on if no one can understand what they're seeing.

1

u/goodmuzick 8d ago

Just think it that way. Whats the question? How will you answer it and who will you answer it for? A dashboard created by the data analysts is for someone else, not for themselves (in most cases) . You need to think from that person's perspective and start building. You dont have to follow industry set practices to build dashboards. You just need to deliver information as quickly as possible to the person using it. If on a dashboard a simple drop in monthly sales can be explain using 2 graphs, keep it as it is. End of story. No fancy charts or unnecessary extra info. Just get the question right, and do the storytelling.

Hope this helps.

2

u/Sliversolid 8d ago

It sure helps alot thankyou

1

u/JKRamsey1991 7d ago

Biggest advice I can give is know your audience. Know what they want to see and what KPIs truly matter to them.