Hi all,
What th best way to break into data analytics.
I'm currently a pricing analyst with experience with excel, power BI, tabluea, QlikView and I'm currently learning Python and SQL.

Should I be learning about databases and ETL, as well???

Github profile?

Also what should be my main goal with Python, SQL.

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

For python you’ll want to learn data wrangling with Pandas — basically can you filter for rows of data based on give criteria like amount and time, create new columns on the dataframe to do additional calculations, do get aggregate metrics like average, sum, count, for whatever groupings of rows.

For SQL there are some conceptual overlaps. But the main operations to get familiar with are joins, filters, aggregate functions. Once you are more advanced you can get into stuff like window functions. There should be lots of articles on basic SQL skills, start there.

GitHub is probably unnecessary. Databases and ETL too, but can’t hurt if you wanna pick up some background knowledge.

I think one of the stronger moves you can make, apart from applying these skills at work, is putting together a basic data pipeline and model from a publicly available dataset, and get some insights. You’ll get a sense for what data processing is like and how models work. If you end up participating in Kaggle competitions it could be a good talking point for interviews too.

My response skews higher up in the programming skill chain. If you don’t want to get so deep into coding, there’s plentiful jobs in other niches as well.

like

Sink or swim. Two ways.

1. Prep for interviews seriously. Then talk to contract vendors. Then knock it out of the park.

2. Start doing the job in place. Get some data and analyze the bajezus out of it to the point whoever is the would-be stakeholder basically has to take your project. Eventually get a title change.

like

Ya “data analytics” doesn’t use Python and barely any SQL, that’s data science, and if you don’t have a PHD you shouldn’t really be doing data science in a professional setting bc you won’t actually understand anything you’re using the algorithms for. If you know powerbi and tableau (and can back it up) your a job application away from being a data analyst. Now if you add some basic schema architecture in there and some solid SQL fundamentals then you’re getting into BI Engineer territory. People often over inflate what data people do, it’s not that wild in 98% of situations

like

@SC1 considering that you were the one who originally pushed back on Python and SQL because it belongs to “data science”, the hashtag at the end is bit ironic.

Agree that it may be tough to break into DS roles without some kind of shift, but a PhD is absolutely not necessary for 99% of companies that build models for marketing analytics, demand forecasting, supply chain optimization, geofencing, etc etc. The required technical skills can be learned in a masters program for CS, DS, or analytics, and business knowledge can be as important as technical knowledge here. Again, the current generation of algorithms is highly performant and well documented for a variety of contexts. You do not need a stats PhD level of knowledge to build models, and the technical bar is only to get lower and lower as ML becomes more commodified, and more and more companies want people who can model. Of course that doesn’t mean that an entry level DS should be able to lead a whole project, regardless of whether or not they have a PhD.

If you’re talking about actually creating novel algorithms, that is very niche stuff which does required an advanced level of stats knowledge. But that’s largely irrelevant on the job market apart for research scientist roles at places like Google and Meta that do novel research. For industry applications a PhD is overkill, nobody expects that anymore. If someone want to spend 5 years of your life to feel like they’re doing “real data science”, go ahead. I say it’s a much better use of your time to go for a CS/DS masters at strong state school and target local companies if need be.

like

So the Consensus is continue Python master SQL learn some more stats and build data engineering skills to be even better. Then domain knowledge come later

Agree that it’s a good idea to leverage whatever domain knowledge you have, provided your industry has a lot of data jobs and pays them well

We're hiring for a Senior Business Data Analyst/ BI / Dashboard developer.

5+ years exp in data, analytics or other data heavy roles. Must be highly proficient in SQL, Qlik Sense, and Excel. Position is in Mountain View CA. Nice-to-have Skills: Workato experience, Procure to Pay, Sourcing and Supply Chain knowledge, Python Oracle (eBiz R12) & exp building custom APIs. We’re a big global FinTech company. Send me your LinkedIn link if you are interested!

Related Posts

Any Tax directors, VP's of Tax, Tax peeps who made it to CFO, or Tax people who became successful (or not) entrepreneurs. Care to give your stories or thoughts on your career. My goal is to stick in PA Business tax till Manager and move to Corporate. This busy season sucks right now (S1) and could use some inspiration or general thoughts to help get me through. Thank you

like

Hey Folks, need help in choosing between American Express and JPMorgan Chase. Seeking insights on basis of WLB, Work and brand. YOE- 7 years . Skill- Data Engineer. Also is it worth to switch from Deloitte India given the current market scenario. TIA

like

Best YouTube channel to learn Salesforce?

like

What are some of the best online resources to learn Power BI?

like

Templates and many more if you thinking about getting into Project Management.

Post Photo
like

18 year vet looking to acquire businesses in Denver area. Looking to exit? Let’s talk

like

Does anyone teach in class elementary, middle, or high school and also teaches college level? If so, how did you get the college level job? I have a masters and specialist degree and teach in class. I also want to teach college level online but have a hard time either finding a position available or applying. I’m now in the middle of my doctorate degree though it’ll be another year before I’m done.

like

I am project manager in clinical research industry (CRO). After earning PhD, I gave up my science dream to take a more stable job. After slowly climbing the ladders, I feel like I finally got a seat at the table. Half the days I like the hustle, but now I miss being creative. I want to take more brainstorming, decision making responsibilities but I don’t see that in the career path for PM. Career path usually goes like this- Sr PM, Director, Sr Director, and so on. But all do same work.

like

Starting at AWS next week in a non technical L5 role. Any advice on how to survive?

like

Is Manager role at Deloitte India equivalent to AVP role at EXL Services? In terms of seniority?

like

What are the Top MBAs outside of M7 to land an MBB role?

like

I am A2 in PwC AC Bangalore in Management consulting - I want to shift to US office due to some reasons. Can anyone please elaborate the intercompany transfer / internal rotation process? Like where to apply? what are the requirements?

likefunny

Microsoft is hiring an account executive and I’m really interested in the role. I have B2B sales experience in a different industry, but my skills include lead generation, prospecting, account management, negotiating, etc (all within the C Suite and other decision makers).

Would appreciate knowing if this is something I have a shot at with no tech sales experience and what I could expect for promotional opportunities and compensation.

Thanks for the help!

like

I’m in my 4th year at a small plaintiffs’ firm. Past two years I’ve received meager raises (5k) and terrible bonuses (3k). My boss prides himself on allowing me to gain experience so I have more courtroom experience than most attorneys with twice the experience. As I’ve applied for other firms, I’ve been denied interviews based on how my boss is perceived in the community. I’ve gathered professional references from opposing attorneys and other attorneys we work with but still can’t land. Help

like

Looking for details on the Analytics Advisory Specialist role… salary, work/life balance, growth, etc. please give me the scoop!!

like

I’m currently an experienced tax associate. A recruiter from another B4 reached out to seem if I’m interested in a tax position at that firm. Is it okay to to express my interest in advisory? I want to get out of tax

like

Just got another rejection... Is exiting to FAANG or MB really this hard? Trying to go tech.. or mbb, but not getting anywhere. I have 2 masters (mba, ms) from top schools, been in consulting for over 10 years, I am confident that I know my stuff well..but still I keep getting rejected. Interviewed with Google, Amazon, Cisco, McKinsey, and a few others and every-time there is something that is not a match... are the hiring managers looking for like 100% match? That will never happen!!!

like

Anyone here spent several years in industry and then gone back to PA? If so, why did you go back? How was the transition?

like

Does Lebanese diaspora really command more power in the MBB and T2 in the region? How can others navigate a career here?

like

More Posts

Anyone know if any Tech/FAANG companies hiring in Sourcing and Supply Chain management roles?

like

Hi all, I’ve recently onboarded as an HR recruiter with a small NGO. It has been wonderful so far. I want to make the most of my new role. If you have any suggestions or advise, I’d greatly appreciate it.

like

How does underwriting compare to PIP litigation in terms of flex time (ability to stop/start work throughout day, work at 2 am if needed, etc)

For example.. in PIP Litigation I can review my suits at 2 am if needed (as a result of having a rough day or other emergency) and still be in compliance

Does Underwriting carry any time sensitive tasks?

likehelpful

Any brand/model recommendations for stylish and functional thermos bottles?

like

Nothing on here for the Forestry industry. This app caters to do nothing managers it seems. :(

like

Can someone recommend a good photographer for headshots? I’ve tried two so far with mixed results. Don’t really like the final product and most are not great for a professional setting.

like

Looking for a job change in a branded company ..YOE 8, Business Analyst, bangalore location.

Any Managers or Seniors Managers.Please DM in case of business analyst opening only in branded companys

like

Guys what is paytm kit???

like

Hey Fishes 🐟,

Where can I get study material for SAP IS-U ? I visited lot of sites but couldn't find detailed explanation for each concept.

like

Hey Boschlers,
Is tomorrow holiday??

What is more important tech like the cloud or money while switching a job?

Anyone know anything about 300 E 23rd? Good building, neighborhood, etc.? New to New York and don’t really know what to look out for - want something with some life (bars, restaurants) but not filled with clubs

like

Any fun leagues or groups to join to make some new friends? Gay 30M here.

like

I am currently working at KPMG as an Analyst. I want to do my MBA in HR and Operations. The feedback that I received from people is that growth in HR is slightly restricted and that HRs don't get hikes (while switching) similar to that of Consulting or Finance or Marketing?

I am not solely interested in HR and am open to other domains as well.

like

Has anyone found a good mutual fund that matches Dave Ramsey's recommendations? I've always dumped into an s&p500 index fund, but have some time to explore other options. Curious where to start.

like

Hi,

How much variable pay will we get in Virtusa? Please consider the average case

And one more thing any idea about yearly hike % ?

Thanks.

like

S&P Global Currently working in TIAA. I was received an offer from S&P Global. Considering the current situation, Is it good to move Company. S&P Global , TIAA

Current role in TIAA- Product Owner
Offered role in S&P Global :- Product lead.
A hike of 25% was offered by S&P

likehelpful

Anyone own a Baltic watch? Less expensive micro brand that has a cool vintage inspired dive watch coming out this summer. Curious if owners like them

I don’t care what y’all think...Navy Yard is hands down the best neighborhood in DC (and I’m not a Rebublican if that matters)
🌊 🚢

Post Photo
likefunny

Additional Posts in Data & Analytics Consultants

Is 128k a fair base salary for Consultant in Deloitte Analytics & Cognitive. MS CS and about 3 yrs experience. In one of the fastest growing but midtier tech cities in the US.

like

What’s so good about the Georgia Tech OMSC and OMSA? Is it just the cost? Seems to be recommended by most of reddit

likehelpful

Have you ever failed to deliver? What was it and why?

like

I'm planning to transition to Data Science. What should be the key technologies that i need to learn and add to my resume to make this work?

Thanks for your suggestions.

like

Noob question - I want to consolidate the dates into a single dates column. Would numpy or pandas help me reorganize this dataset effectively or should I do it within excel?

Post Photo
like

This might be a long shot ... but I have a Statistics assignment due for tonight in a few hours

Does anyone know how to do Linear Discriminant Analysis with more than one predictor - by hand? I know how to compute in R but my professor wants it done by hand .... fml

likefunny

Any recommended courses or books on customer care/cust success analytics or marketing analytics in general?

like

Can anyone at Ford Motor Company tell me more about the “Learning Analytics and Engagement Specialist” remote position? Very curious and would love a referral!

like

How hard is it to get an interview for SWE at FAANG outside of on campus recruiting? I’m in GT’s OMSCS program right now, hoping to take advantage of career fairs this fall, but I don’t know if I’ll have enough time to prepare for the technical interviews before then. I’m worried about missing out on the recruiting opportunity and having to resort to applying online/LinkedIn afterwards. Any insights into this?

like

What do you think when associates/senior associates misspeak on a concept during a meeting or interview?

I’ve learned something new on each project, and I’m afraid of coming off as an idiot so I rarely contribute to conversations; only after I have done research on the topic and have prepared do I speak/give ideas

like

Does your company split data science roles into different practices like data & analytics and software engineering? Does this inhibit collaboration & Where does a data engineer fall?

like

I was hired a few months ago by D to do data science. I am not doing data science currently, is there a way I can switch roles internally? Should I talk to my coach? Or should I just start looking for a new job. I’m starting to feel that the field is so hot rn my small stint at D won’t be a big deal to other firms.

like

Is anyone working with Elastic at DoD?

What are some interesting non-tech/insurance/advertising/consulting careers where data science is applied? Thinking of epidemiology and economics

like

Hiring for data scientists and BI analysts across a couple levels, DM me if interested!!

like

Anyone have recommendations on the best app/site to learn Python? 🐍
I’m a complete beginner.

like

Partner: Let’s take the data in the spreadsheet and put it in PowerBI so we can cut it up.

Me: What? It’s already cut up in the spreadsheet. I don’t get it.

Also me: Yeah! Analytics!

likefunny
like

Meeting with a recruiter at one of the FAANG companies. I won’t be able to move jobs because of H1b /GC at least for the next year. Any idea if I should start off with that or should I just try to understand the work that they have been doing?

like

Could anyone recommend a set of indices that are publicly available and is a good predictor for consumer spend in home renovations ?

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