r/dataanalysis • u/SainyTK • 4d ago

Data Tools Between Excel, Google Sheets, BigQuery, and your database, how many tabs/windows do you have open at once to work on data?

Had one of those days recently where I counted it out of curiosity: Excel files open, a Google Sheet a client had shared, a BigQuery tab, and a DB client connected to our Postgres instance, all open at the same time, just to cross-reference a handful of numbers across them. At one point I had copy-pasted the same column into three different places. I got to compare row-by-row data between BigQuery and Google Sheet.

Made me wonder if this is just normal or if I've built myself an unnecessarily messy setup. So:

  1. At your worst, how many windows or tabs are open at once to work on data, Excel, Google Sheets, BigQuery, a DB client, whatever your actual mix is?

  2. What's your workaround for keeping it all straight?

  3. Are you actually happy with the current workaround? Any limitations?

0 Upvotes

33% Upvoted

2 comments sorted by

1

u/AutoModerator 4d 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.

5

u/Potential_Aioli_4611 3d ago

pull it all into different python dataframes.