r/analytics • u/Senior-Ad-6588 • 11d ago
Discussion Tools for data analysts?
Hey, I'm 21 years old college student learning data analytics, as AI is growing we all know traditional data analysis will no longer be the only requirement of companies we got to learn how to use AI in our work to make it more efficient. So wanted to know what tools and AI software, LLMs or anything you guys suggest which could help a data analyst understand real questions and find answers not just showing and cleaning data. And please share your advice that you think could help me. Thank you!
11
u/Muted_Jellyfish_6784 11d ago
Learn to start from the decision, not the data. Before touching a dataset, write down who is asking, what they'll do differently depending on the answer, and what number would change their mind. SQL, one BI tool, and an LLM you use to check your reasoning and draft queries is plenty of stack.
The skill that separates analysts is joining data across systems that weren't built to talk, like orders against support tickets. Plenty of teams now run a decision intelligence platform for that join, so understanding how IDs line up across sources keeps you useful rather than competing with tools that already build charts.
10
u/jkrm1920 11d ago
Basically you will doing the same designing and implementing futuristic architecture for consuming via any visual representation platform. In this you should learn how to indulge the architecture for supporting RAG models and Data Agents going forward.
Like Ontologies and Taxonomy.
And also you should certify in AWS AI Basic and Azure AI 900 Basic certs to know technology and tools.
Good luck
3
u/Legitimate_Cow_6955 11d ago
most hiring managers barely glance at the 900-level cloud certs for analyst roles, unless the company is a consultancy that needs certification quotas for partner status
5
u/WorldOfUmbro 11d ago
For us, all our analytics are done on Databricks. We’ve seen a huge increase in Genie agents. They are currently replacing more and more dashboards. They are quite easy to build, especially for analytics users that know the data
3
u/Oona_Left 11d ago
We’re incorporating Databricks soon.
Currently have a data lake on AWS which feeds reports on Power BI.
I’m not sure what the long term plan is but I haven’t been impressed by the Databricks dashboards so far 😕
2
u/WorldOfUmbro 11d ago
I like the way the dashboards have been evolving the last few months. Especially with the relationships. But still, even without it, bringing the data into the platform helps. This way you can build Genie Agents, custom agents, dashboards on the same data foundation.
4
u/skudarian 10d ago
The ability to ask the right questions to your stakeholders / interviewers. I know that's vague, but understanding the business problem and demonstrating that through your questions and outputs is key.
Who are you talking to? Different departments have different goals and analytical needs. For example, if you're interviewing for a marketing analytics role, you'll stand out if you understand marketing concepts and can connect them to the analytical work. You can use an LLM to learn what matters to different departments and roughly understand their priorities.
Stakeholders aren't your enemies, but you should study them as if they were. It pays off whether you're interviewing or looking to progress in your career.
2
u/davidphtsui 11d ago
Take a question like “why did sales drop?” and ask an LLM what you should check before writing any SQL. Then test its suggestions against the data, including whether the drop is just an incomplete week or missing records.
1
0
u/No-Comfortable-9418 9d ago
Better analyst dot com would be good for you esp bc they have public data you can play around with since you’re in college
0
u/Early-Cauliflower850 10d ago
On the task data I work with, the spread inside a data analyst job is wide. Data cleaning and preparation scores about 80% exposed to automation, while executive presentation and data storytelling scores about 22%. Business insight synthesis sits near 48%.
So the tools worth learning first are the ones that speed up the exposed work: an LLM for drafting cleaning scripts and queries, and one BI tool. That frees your time for the less exposed work, which is the part you asked about: turning a vague question into an answer someone acts on.
Practise on messy public datasets. Write the question and the decision first, let the tool do the grunt work, then check its output yourself and explain the result in plain words.
0
11d ago
[removed] — view removed comment
1
u/RemindMeBot 11d ago
I will be messaging you in 7 days on 2026-11-17 04:23:59 UTC to remind you of this link
CLICK THIS LINK to send a PM to also be reminded and to reduce spam.
Parent commenter can delete this message to hide from others.
RemindMeBot is switching to username summons. Instead of
!RemindMe 1 day, useu/RemindMeBot 1 day. More info.
Info Custom Your Reminders Feedback
•
u/AutoModerator 11d 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.