How to get into analytics? I just earned a bachelors in history, have entry level analytics experience.

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

History? Probably should have gotten a BS in a STEM field if you wanted to go into analytics.

like

Thank you for your hindsight.

likefunny

Until ML became accessible, 90% of analytics was reporting history. You came to the right field.

Making ties from data to major events that happened in industry or history is a essential skill. Use what you learned about history and its reteilling to make compelling arguements.

Analytics is storytelling of history, predictions on future, and arguement for outcomes. You'll do great!

Dive into some vlog or sites on working with data. Learn excel, some python, PBi, principles of unstructured data (lots of this around).

Take on some data experiments, microsoft has tons of dummy data laying around to test with.

Best regards!

like

Thank you!

Pick up data skills - Python, Tableau, and SQL. Look at jobs and see what tech skills they're looking for. You have to start somewhere.. and if you don't like the idea of programming, then time to reconsider what you really want.

like

That doesn’t dissuade me at all I would like to learn a STEM related skill.

Then learn some SQL. Gateway to programming as its will work like excel, but a bit more direct.

like

I would recommend doing the Google Data Analytics certification. It gives you a solid foundation and is meant for someone that doesn't have any background in data analysis. Even seasoned analysts can learn a thing or two from that program. The certification is cost effective too. It's $49 per month through Coursera. You could finish it within 3-6 months so at most this will cost you around $300. The best part is that once you are done, you will get interview and career prep, along with having access to their employer consortium. Essentially an alert will be sent out to potential employers that says you completed the certification and potential employers will want to talk to you. The US has a shortage of data analysts and data scientists so you won't have any issue landing a job. Before you ask, no I don't work for Google and this is not a paid advertisement. I've just seen it work out for a lot of people and the results speak for themselves. Check it out!

https://grow.google/certificates/data-analytics/

likehelpful

To my knowledge it teaches Tableau, R, and SQL along with Google Sheets.

like

Get a certification in Power BI through Microsoft Learn. Then apply to AFS.

like

Thanks!

What is your entry level analytics experience? You might not need a masters degree if you already have your foot in the door. Just try to up skill as you progress in your career!

like

It was mostly work with reading and analyzing contracts and working with raw data in excel and databases. Daily use of a database and excel but no use programming. I would like to increase my technical capacity and have a degree to show continued learning. I have experience analyzing data but I would like to become strong with the tools.

I’m pursuing my masters in data analytics…thank you for all of your insights

Here’s how I would approach it:

1. Study statistics - this is going to be your foundation so spend a lot of time understanding statistical concepts.
2. Learn how to code in R by performing statistical analyses.
3. Once you know R, learning Python is going to be much easier. Practice Python skills by performing exploratory data analysis. This includes cleaning data, performing statistical analyses and creating visualizations.
4. Learn the basics of SQL and learn about ETL . At this point you can pick up SQL fairly easily and you just need to know enough to select and join tables so you can retrieve the data you need. You can also practice your ETL skills using SQL.
5. Finally study data visualization best practices and pick a platform to master. I suggest Tableau or Power BI.

Tip: Don’t waste your time learning how to use Excel. All you need to know is the difference between an xlsx, csv and json file.

It's a good idea to start with learning SQL and data modeling if you want to break into Analytics. Using the Star Schema method is great for this. If your data isn't structured well, your analysis will be rough, at best. So, get to know relational datasets and how to structure and query them with SQL first. When you're comfortable with that, you can move on to visual analytics tools like Tableau or Power BI. I'd recommend starting with Tableau, though, because it's easier to learn after you've got the hang of SQL.

Related Posts

Be honest, do you see yourself staying in the game to make partner?

likehelpful

Really need you help !!

I have joined Techmahindra as associate security analyst on 23rd August,2021.

Now I want to exit as soon as possible.

But the situation here is they asked for 2 year bond and I haven't submitted that, then I have signed a undertaken to sign that 2 yrs bond. Still I haven't submitted that bond.
So how should I go forward from here as I didn't liked the type of work they are doing.

Commercial vs Public sector/Federal Consulting within the Big 4 or MBB. Differences in culture, types of work, wlb, exit opportunities, etc

like

Would anyone at Alvarez and marshal or IBM be willing to refer me?

For A&M - TAS associate in the New York office. Currently a TAS associate with 5 months experience in New York at a different firm. Main reason for the switch - lack of growth and deal flow.

For IBM - Financial Analyst co-op in the New York office. Main reason for the switch - large interest in the tech and corporate finance.

My background - 5 months TAS, 1.5 years financial services consulting, 8 months audit with PwC.

like

Any Publicis PMs go to TBWA\Chiat\Day LA? How was your experience with that transition?

like

Thinking about making a switch from supply chain to marketing, any suggestions for tools/software that i should learn?

like

What is the best way to get deeper into tech sales? And make more money! Currently Director for a SaaS tech company, do I need to stick it out for a year or two, to appear valuable to another org or should I start applying?

like

Is it worth it to exit for pharma sales? I know some people have made the switch. The money is tempting but I can't help wondering if it's just a "grass is greener" situation

like

CFA or CAIA?

Hlo guys,
Which are the certifications that can add great value to our CV as An IT employee ?

Hey Partners! I accepted a position at another firm and was bumped from manager to Senior consultant level. Could you give me some advice on 3 key things I can focus on to help me re-advance quickly?

like

Has anyone taken a Florida CPE ethics course that was easy?

like

Advice needed!! Have 8+ years of compliance/legal/in house experience (not privacy law except HIPAA). I really want a Privacy Counsel role so I took and passed the CIPP/US and CIPM exams this past year. I’ve been offered an Associate Director job at PwC. Is this a good stepping stone to a Privacy Counsel role? How long should I expect to work at PwC before I could apply to Privacy Counsel roles??

like

The majority of my career has been in healthcare tech with some retail experience. Looking to break into event management/coordinating (I believe this is the correct job title) space in either the entertainment, fashion & retail or cosmetic industry. Any insights or advice is appreciated!

like

Hey would anybody mind looking at book to tell me why I’m unhirable so I can further justify quitting? Please DM me.

like

Planning a switch from big 4 to dr. Reddy. Strategy role. This is for a mid senior level position. Is this a good decision?

like

Young professional with 3 years of retail banking experience, 1 year of claims experience, and now roughly 6 months into insurance sales. Between selling in retail banking environment and every month of insurance sales regularly pacing 200% or over to goal. Loving comp but not loving the call center environment and hoping to move to another lucrative sales position with less non stop calls. Any suggestions?

like

New York folks:
Are you aware of the CPA exam credit extension to 2021 for NY CPA candidates impacted by COVID19? It’s on a person-by-person basis and you need to request the extension. Has anyone tried doing this yet? Can anyone shine more light on this? The extension would really help me, but I’m not sure what more to tell them in my email than the fact that I couldn’t sit for the exams this Spring/Summer due to test centers closing in NYC.

like

I’m a junior full-stack developer. What job titles should I be looking at where I can use my skills?

like

I just graduated with a concentration in Environmental Policy. Any advice for someone who is interested in breaking into corporate sustainability/a related field?

like

More Posts

@microsoft my spouse is starting a new job at Microsoft and want to buy him swag. How can I find some or buy something new off someone? The Microsoft merchandise store has a steep shipping price

like

How much an EXL pay for 3.5 YOE data engineer?

like

Working Moms/Dads: Do in-house positions exist with flex time hours? I need to be able to leave work at 4pm to pick up my son from daycare, but i can get back online at home to resume any unfinished work at 8pm. Is this realistic to convey to any companies in an interview? Pandemic aside, is face time 9-7pm really important? Or should i just try to find a job with a salary that covers a nanny salary and accept that i will never see my son on weekdays (which would be sad for both of us)? TIA!

like

Have any one used a resume coach or service for in house job search, particularly for IP and product counsel positions? If so, how did you find a good one? Thanks!

like

Had two rounds of interviews for an in house role and really like the company/job. I followed up Friday regarding next steps and was told they are still interviewing and should be wrapping up soon. Advice on how to stay calm? I want the position and need to know if there’s a way to speed up the process.

like

This is the great resignation, right? Thoughts on jumping for the fourth time in seven years? I’m chasing the pay to get to where I want to be and have an offer but am getting reservations on making a move within a year. Appreciate any similar personal experience.

like

Can anyone refer me to the Starz/Lionsgate Legal Affairs, Counsel role? I’d be happy to send you my resume first. Thanks!

likesmart

Is there any leeway for me to leave without having to pay the $8,922? The Feds are now aiming below the belt to retain their talent. 😭💀

Post Photo
like

Hello, looking for a bit of advice. I have applied to about 30 positions in the last two weeks and have not gotten any interviews. I have 7 years of military supply chain experience, plus a year and a half outside of the military. I am an inventory control manager currently, and have applied to positions like demand planner, supply chain manager, supply planner, and other manager positions. Any advice on how to correct my job search?

like

Fishbowlers. I got a bad performance review. I need to knock my next one out of the park. Open to any suggestions. S1 in month 6 of starting. I need to get quicker and be able to be a ‘lead senior’. How can I make a manager and directors life easier?

like

McK AMA. On PTO this week and next. What do you want to know?

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

I have an idea for a website but don't know how to develop/code it. Any ideas on finding someone with the technical knowhow?

like

What kind of copyright work can you practice for clients outside your jurisdiction without violating ethical rules besides copyright registrations.

My lease is coming up & I’m probably going to move. Which apartments do y’all recommend in the city?

like

When can we expect appraisal letters ?

Got way too drunk at a work event last night. Please tell me horror stories to make me feel better 🙇🏽

like

is Infosys going to start office soon? will wfh option provided ? please give some information

What amount can i ask for 4+ years of experience in devops profile in EPAM Anywhere?

like

Guys.. just a headup.. dnt join epam anywhere .. they dnt have projects.. they are re-evaluating people again .. same technical interview of 1.5 hours ... Not sure wat is the outcome of the technical interview after geeting offer letter n joining epam.

like

Additional Posts in Data & Analytics Consultants

today I choose violence

Post Photo
funnylikesmartuplifting

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

Have a lay-off meeting lined up, and now look for next opportunity. My background is around building machine learning models, data wrangling, visualization, feel confident with python. Open to any industry. Appreciate any lead on job opportunity. 3yrs of work experience

like

What is a data lake in basic terms?

like

Hello, Anyone here from Deloitte Omnia AI who could refer me for an open opportunity.

like
like

I am currently working mostly in Data Analytics, but I want to transition into Data Engineering. I've applied to a couple Data engineer positions but it seems I don't have the qualifications for them. Should I maybe look for Jr. Data Engineer positions to get experience and try to move up from there? If so anybody know of any Jr. Data Engineer positions available?

like

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

like

How should I move to tech as a ML Engineer? How did people here make the transition?

likehelpful

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

like

My manager continues to ask me to help other teams and do work on other billable projects. I’m sick of it .. and I’m going to explicitly say that no I can’t do it because my hours are taken by the existing project we are doing. Is this appropriate?

like

What biotech stocks are yall trading right now?

GILD, INO, MRNA

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

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

Anyone who has done masters in business analytics Singapore? Could you help on courses, Scholarships and careers and jobs. Looking for help.

Any conda users in here have to install a binary and use conda forge? Need some help installing pdftotext. Throwing a weird message saying “Found conflicts!” Any and all help would be appreciated.

like

I'm non US citizen and thinking of moving back to EU. My plan is getting remote opportunities across the world and work as a freelancer. My speciality is Data analytics and BI (Qlikview, Tableau). 1) How likely I can get a gig from the US? 2) if a job looking for a remote 2-3 months contract do they care what country I'm in? 3) how can I compete Indian rates as I'm in Europe 60-70$ per hour as a BI consultant is a good rate but I see online rates as low 10$😫?

like

Quick survey: Do you guys think having a template package to envelope an ML model as an application would be helpful. The package could contain boiler plate template for unit test, docker image, CI/CD, database connectors etc and act as a starting point for doing that. Tech firms usually have that internally but limited options in open source.

like

Anyone here work or has interviewed for a data science role at DataRobot? Would love to get some insight. Third interview coming up.

like

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

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