Ben Collins is a spreadsheet developer, data consultant, and data analytics instructor. He blogs and creates courses at BenLCollins.com, focusing on how to work with data using Google Sheets, Apps Script, and Data Studio.
Ben has taught workshops on data analysis, as well as doing freelance and consulting work. Prior to striking out on his own, he spent seven years as a forensic accountant focusing on data analysis.
In this episode, we talk about what a data analyst does, how Ben taught himself how to code, why demand is high for data professionals right now, the tools a data analyst uses, and the first steps to take if you want to get started in the field.
I love Ben's work and I actually turn to his videos whenever I'm trying to figure something out in Google Sheets at my full-time job. So needless to say, I’m super excited that he's put together a special offer for Learn to Code With Me listeners.
If you want to step up your spreadsheet game, you can get 20% off his Google Sheets Training Bundle using my affiliate/commission link at LearntoCodeWith.Me/sheets. Going through this link will automatically apply the 20% discount on this course and send a few bucks my way at no extra cost to you. Thanks!
- Data analysis boils down to one key job: to take a massive amount of information and gain valuable insights from it.
- Data science and analysis positions are often the hardest for a company to fill. Demand has exploded and supply hasn't caught up yet.
- To get started in data, begin with the fundamentals in Excel and Google Sheets and see what interests you.
- There are different specializations within data science. If you like design, you can focus more on data visualization. If you prefer hard coding, specialize in analytics.
- Specializing can be a successful way to get clients, because you become known for that one thing.
Links and mentions from the episode:
- Google Sheets Training Bundle (with 20% LTCWM discount and affiliate commission)
- Google Sheets
- Apps Script
- Google Data Studio
- Everything You Should Know About Data Science: The Century's Hottest Career
- General Assembly
- General Assembly's Back-End Web Development
- Google Analytics
- Google AdWords
- Avinash Kaushik's website
- Google Docs Editors Forum
- Stack Overflow
- Renee's website, BecomingADataScientist.com
- Data Elixir
- The 12 Week Year by Brian P. Moran and Michael Lennington
- General Assembly's Data Analytics
- Ruby on Rails
- Wes Bos
- Google Drive
- Ben on Twitter @benlcollins
- Ben on YouTube
- Ben's Facebook page
Thanks for listening!
Thanks so much for tuning in! Remember, you can listen to the Learn to Code With Me podcast on the following platforms:
If you have a few extra minutes, please rate and review the show in iTunes. Ratings and reviews are extremely helpful when it comes to the ranking of the show. I would really, really appreciate it!
Special thanks to this episode's sponsors
Xojo: Want to create native apps for desktop, mobile, web, and/or Raspberry Pi–without individually developing four separate versions? Xojo is a cross-platform development tool that lets you use one language and drag-and-drop tools to program multiple fully functional apps, so you can focus on the important things instead of specific platform development differences. Check out xojo.com/learntocode and get 20% off with the coupon code LEARN20.
Fullstack Academy: With a cutting-edge curriculum and supportive educational environment, Fullstack Academy is a leading coding bootcamp that has helped graduates get jobs at companies like Google, Amazon, and Facebook. Visit BootcampPrep.io to get a $500 scholarship to Fullstack Academy's beginner coding course, Bootcamp Prep, using the code LEARNWITHME or clicking the link at the bottom of the page.