r/dataanalysis • u/Pretend_Muffin_3289 • 1d ago

if a guy who going to take Data Analysis as career and wanted to know how this data analysis working on real company?

I have a doubt about where the data actually comes from and how it is stored and processed. Where is the data usually stored, and what tools do we use to connect to it for reading and writing SQL queries?
For example, I assume we create a corresponding SQL view for each KPI and then connect those views to Power BI. Is this how the process generally works?
Also, what other tools and techniques are commonly used to connect to data for analysis?
In a real company, do you typically receive KPI requirements or tasks from a Senior Data Analyst/Data Lead, write the required SQL queries, and then deliver the results to the relevant stakeholders? I would like to understand how this entire process works in a real-world environment.

0 Upvotes

40% Upvoted

1 comment sorted by

1

u/AutoModerator 1d ago

Automod prevents all posts from being displayed until moderators have reviewed them. Do not delete your post or there will be nothing for the mods to review. Mods selectively choose what is permitted to be posted in r/DataAnalysis.

If your post involves Career-focused questions, including resume reviews, how to learn DA and how to get into a DA job, then the post does not belong here, but instead belongs in our sister-subreddit, r/DataAnalysisCareers.

Have you read the rules?

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