What will get you farther as a data analyst - knowing Excel or knowing Python? I've seen both utilized pretty impressively.

like
Posting as :
works at
You are currently posting as works at

Python … but I would urge that you’ll need intermediate skills in excel too … focus on python … excel is easy to learn and master

like

I’d say for a data Engineer python definitely. But analyst probably excel. But it would definitely be valuable to learn both

like

So in my current role, there are only a handful of reasons I really use Excel. 1) To validate or troubleshoot any data I pull from BigQuery before building out something in Tableau. 2) I'm tearing apart something that has been built by someone as I work to automate and make it more dynamic. 3) I need to produce a quick and dirty analysis that is meant to be a one off and not repeated. I'd argue that all of these things are something that can be done with even the most rudimentary Excel skills.

I'm learning that most teams in my organization are looking for people who have a familiarity with Python (if not more advanced skills), even if they don't use it a ton. Given my experiences as I was trying to get this role, if I had it to do all over, I'd have spent my time learning Python (even though my prior role was a finance role and demanded advanced Excel skills), as that was the hangup in nearly every interview I came in as a second choice. I've spent the time bolstering that skill in preparation of moving on to another role.

likehelpful

Ideally, you'd be experienced with both. But if you had to pick one, I'd say Python. As valuable as Excel is, for a data analyst you'd likely need to be working with large datasets. And for that you'd really need proficiency with Python.

like

Well both could be the same answer. It is possible to bring in some uses of Python into Excel. I would think in this day and age basics say you need Excel, and if you want to stand out learn Python or how to use a natural language to code AI to help you with your Python building.

Related Posts

Larsen & Toubro Infotech I was selected as a senior software developer (5+YOE) in Larsen & Toubro Infotech how much salary I can ask them? My current CTC is 5LPA and I'm expecting salary hike in this month

like

Would you recommend the CVS test? I dont think I want to get it done due to the risks.

Fun question: what are the best and the worst wedding trends you’ve seen?

like

For 12 Lpa in Barclays how much will be the in-hand. And why are Barclays taking so much of time to issue offer letter?Barclays

Any nonprofit/EO lawyers looking for a change of scenery and a better fit?
A firm with the best of everything is hiring. Seriously a hidden gem.

DM if interested. California bar required.

Open to given a referral if you’re a bad ass radical lawyer, just don’t make me look bad. 😊

like

This bowl was originally created for black attorneys in big law, but since it’s the only bowl for black attorneys, many black attorneys in other sectors have joined. Some people are apprehensive about starting another bowl for all black attorneys because it will take away from this bowl. Assuming that the conversations & topics will stay the same, What are you thoughts on keeping this bowl solely for black in big law verses Opening this bowl to any black lawyer?

like

What are the benefits of being licensed in multiple states? Do you use all of your different law licenses at least once a month?

like

I've always used "OTE" to describe my base + variable, but many in this bowl seem to refer only to their variable. Which is correct?

like

Hello - can anyone drop base salaries or guarantees for Television Account Executives?🧐thanks in advance

like

My employer is going on a hiring blitz and is offering new hires of the same position a higher salary than I currently have, is this normal or should I demand a raise?

likesmart

No question, but I wanted to give a huge shoutout to repvue.com that helped me increase my salary by 80% this year. If you know anyone who works in Sales, tell them about it!

Post Photo
likesmart

Took my first ever sick day today on account of my very poor and worsening mental health. Just could not bring myself to put in another 14 hour day with back to back meetings and constant activity. Felt very guilty but I honestly wish I could be more honest and actually share with my manager about why I took a day off.

For those also going through this, any tips on how you manage yourself day to day? What self talk tends to help?

like

Preferred reading -- FT or WSJ?

like

Is there any variable pay included in Virtusa for lateral hires or is it only fixed pay? Virtusa

like

Anyone looking for WOSB sub? I have a team of experienced data scientists with years of experience. We want to pad our past performance to go after more prime opportunities.

I've been so lucky to have tons of friends giving me hand me downs but it seems like it might be too much if I accept everything. What are the absolute necessaries that I should accept multiples of and what can I pass on?

Cold emailing consultant HR reps for jobs, yay or nay ?

like

Does anyone has experience using Google Fi in Canada ? Is it worth having if you only visit US once a year ?

like

I’ve been thinking about looking for a new job, but given everything going on with the Coronavirus and layoffs, it doesn’t seem like this is a good time to start looking. What do others think?

like

Additional Posts in Excel Genius

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

like

Everyone: Excel is a smart app
Excel:

Post Photo
likefunny

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

Would anyone be willing to teach me vlookup?

like

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

Does anyone know any shortcuts for the “Refresh All” button without having to always click Data->Refresh All every time I want to refresh the live data? For a Mac btw pls thanks!

Post Photo
like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal