Become a Business Intelligence Analyst

No fluff. No outdated tutorials. No overpriced bootcamp. This Business Intelligence Analyst Career Path is your step-by-step roadmap to go from beginner (at any age!) to getting hired. You’ll be guided through our curated curriculum of courses, workshops, challenges, and action items to build your skills, portfolio and experience to become a Business Intelligence Analyst.

What You'll Learn

  • Launch a career at the intersection of business, data, and technology as a Business Intelligence Analyst
  • Learn to fetch massive datasets from text files, databases and more, then shape and transform them for analysis
  • Analyze data with the power of Excel formulas and the DAX programming language
  • Create stunning, dynamic visualizations with industry-standard tools like Excel and PowerBI
  • Automate processes and build your own enterprise-level data tools

Your Career Path

Course
The Excel Bootcamp: Zero to Mastery 16 Hours ·133 Lessons
Become a data wizard in Excel. Learn Excel Formulas and Functions, Data Visualization, Pivot Tables, VBA Macros, and much more. Start or supplement your career with data analysis & science skills & get hired in 2023.
Course
Business Intelligence with Excel 8 Hours ·133 Lessons
Become a Data Professional. You'll learn to master Excel's built-in power tools, including Power Query, Power Pivot Tables, Data Modeling, the DAX formula language, and so much more.
Action
Apply To 5 Jobs

Believe it or not, you now have enough skills to start applying to jobs and even get hired! This process usually takes a while and it's good to start even if you don't feel "ready". Apply to 5 jobs online right now and see what happens. You don't even need to "want" these jobs. The goal is to practice applying and practice going through the interview process. Once you finish applying to 5 jobs (you don't need to hear back), move on to the next step in this Career Path.

Workshop
Academy Workshop: Career Advice 3 Hours
Career Advice for Developers, Designers, Engineers and anyone who wants to have a successful career. Andrei gives you strategies, tips, and advice he's gathered over his many years to help you get hired and succeed in your career.
Course · optional for you
VBA Programming 11 Hours ·75 Lessons
Become a data analytics pro by using VBA (Visual Basic for Applications) Programming in Excel. Learn VBA Macros, Variables, Userforms, Loops, Arrays, and Pivot Tables. Build your career in data analysis & get hired.

See whole career path

What ZTM students are saying

Our courses and community have helped 1,000s of Zero To Mastery students go from zero to getting hired to levelling up their skills and advancing their careers to new heights.

Meet your instructors

Your Career Path instructors aren’t just experts with years of real-world professional experience. They have been in your shoes. They make learning fun. They make complex topics feel simple. They will motivate you. They will push you. And they go above and beyond to help you succeed.

Travis Cuzick

Travis Cuzick

Data Solutions & Analytics
Andrei Neagoie

Andrei Neagoie

Lead Instructor
Diogo Resende

Diogo Resende

Data Science & Analytics
Mo Binni

Mo Binni

Mobile Instructor

Still have questions?

Who is this Business Intelligence Career Path for?

Anyone who wants a clear step-by-step guide to learn the latest industry techniques and tools, become a Business Intelligence Analyst from scratch, and actually get hired. Oh ya, and you don't want to waste your money on overpriced bootcamps and degrees.

Also, let's be honest. Some of the topics can be a little dry. So, we're even going to have a bit of fun along the way. No way! Crazy right?!

This Business Intelligence Analyst Career Path is perfect for you if:

  • You're a complete beginner (of any age!) and want a full bootcamp curriculum and experience without having to pay $1,000s
  • You don't want to waste your valuable time. You want to learn everything needed to become a BI Analyst in one place
  • You want to build real-world, enterprise-level projects that will push you, challenge you and make your portfolio and resume stand out
  • You don't want to learn and take this journey alone. You will learn alongside 100s of other students at your same level and 1,000s more that are just a few steps ahead of you

And it's definitely for you if you're sick of:

  • Outdated tutorials
  • Free courses and tutorials that don't go beyond the basics
  • Learning topics and concepts that are mostly irrelevant in the real-world and don't even get asked in interviews
  • Courses with no community or support system
  • Tutorial hell
  • Feeling like you're going in circles with no clear path or end in sight

Let's be 100% clear. You aren't going to do 100 coding challenges or 50 projects or learn topics that aren't going to get you hired or even be used in the real-world. That's a waste of your time.

The sooner you get hired, the sooner you'll be learning more than you can from any course. That's the goal of this Career Path.

Why become a Business Intelligence Analyst?

Everyone has their own reason(s) as to why they want to become a BI Analyst. But here are a few of the best reasons:

  1. Lots of jobs available. As we're writing this, there are over 175,000 Business Intelligence job postings available on ZipRecruiter (not to mention GlassDoor, Linkedin, Indeed or elsewhere). And it isn't going to slow down. The amount of data being generated is growing exponentially every single day, and the need for companies to help make sense of this data and take advantage of it is growing exponentially along with it. That's where BI Analysts come in, and they're getting more important every single day.
  2. High demand = High salary. The average annual salary for a Business Intelligence Analyst in the United States is ~$90,000 across all levels (entry-level to senior). Plus BI Analyst knowledge and skills are well-known for being advantageous for C-suite executives, meaning your career has lots of upward mobility potential.
  3. No degree required. It's very possible to get hired as a Business Analyst without having any college degree. You also definitely do not need a Computer Science degree to be a Business Analyst.
  4. Work remotely. Many data-related jobs are remote. Work from the comfort of your own home, a coffee shop or even while travelling the world. Some roles even allow you to work on your own schedule.
  5. It's fun. And rewarding. You get to have a real-world impact. The work you're doing on a daily basis can have a huge impact on hundreds, thousands, or even millions of people.

How long does it take to become a Business Intelligence Analyst (and complete this Career Path)?

Everyone is different. So it's hard to give a specific amount of time. The two biggest variables are the number of hours per week you're dedicating to completing the steps in the Career Path and your current experience level.

Don't hold us to it but here's a rough guideline based on feedback we've received from past ZTM students on how long it takes to become a BI Analyst:

  1. 20-40 hours a week = 4-6 months. Students who have started from scratch as complete beginners (no matter their age!) and spend a few hours per day.
  2. 40-80 hours a week = 2-3 months. Students who are able to learn basically full-time and/or already have some experience (ex: students that already have advanced Excel analysis skills).
  3. 0-10 hours a week = 7-12+ months. Students from all experience levels but are only able to dedicate a few hours a week.

What’s the ZTM Discord community and how can it help me?

The ZTM Discord is our exclusive online community for ZTM students, alumni, TAs and instructors.

How it helps you, short version: Increase the chances that ZTM students achieve their current goals and help them continue to grow throughout their career.

Longer version: Learning alone is hard. We've all been there. We've all tried to learn new skills and struggled. It can be frustrating, daunting, and just plain challenging, especially if you're trying to change careers.

We feel strongly that the Zero To Mastery Discord community is an essential part of the learning experience and greatly increases the chances for students to achieve their goals.

It's crazy to think that Colleges and Coding Bootcamps charge you tens of thousands of dollars to provide you with this type of experience. It doesn't have to be that way!

In fact, ~20% of ZTM students are also enrolled at a College or in-person Coding Bootcamp but feel like they just aren't getting all of the skills and support they need. But with ZTM, they do.

Within the Zero To Mastery Discord community, you can:

  • Connect with other Developers, Engineers, Data Scientists, Designers
  • Form study groups and complete ZTM Career Paths and Courses together
  • Ask questions and get advice from other people at your same level as well as more experienced professionals
  • Get feedback on projects
  • Meet other students around the world (and likely even someone from your hometown!)
  • Learn how to answer questions and help other students which will accelerate your own learning
  • Get help from others with questions and exercises
  • Work on coding challenges and real-world open-source projects with other students

It’s pretty awesome to see many ZTM alumni also active every single day, continuing to engage with the community, give back, and level up their own skills and career.

Are there any prerequisites for this Career Path?

A computer (Windows/Mac/Linux) and access to the internet. That's it! No previous experience is needed.

If you haven't already, take our tech career path quiz. We'll give you our recommendation for which path is the best fit for you.

How is a Career Path different from a course?

Career Paths are like a full College curriculum. Our Career Paths give you the exact courses, workshops, challenges, articles and actions to take to go from absolute beginner to getting hired.

Career Paths start with ensuring you know the foundations from scratch. But they go far beyond by teaching you advanced topics and non-technical skills that are essential for your career but aren't taught in Computer Science Degrees or Coding Bootcamps.

Courses are more focused. Different courses have different goals. Some courses are a great fit for experienced Developers, Engineers and Programmers who want to level-up their skills in a specific topic or framework. Other courses cover a wider range of topics teaching the foundations and fundamentals for beginners.

Can I change my Career Path?

Yes. You can change your Career Path anytime. As a member of Zero To Mastery, you have unlimited access to all ZTM courses, workshops, challenges, articles and other materials needed to complete any of the ZTM Career Paths.

Take the first step to living the life you want

Monthly
100% OFF$39 / month
$ 39 / month
  • Unlimited access to all courses, workshops and career paths
  • Invite to private Discord with 300K+ members
  • Exclusive Academy member-only content
  • Access to private LinkedIn networking group
  • Custom ZTM course completion certificates
Start Learning Now
Annual
100% OFF$279 / year
$ 279 / year
$23 / month
  • All the benefits of a monthly membership
  • Download all lessons for offline learning
  • Save 40 % compared to monthly membership
Start Learning Now
Lifetime
100% OFF$999
$ 999
  • All the benefits of a monthly membership
  • Download all lessons for offline learning
  • Unlimited, priority access to all future courses, content and features
  • Only pay once, ever
Start Learning Now