__STYLES__
Business Intelligence Analyst
Learning PathBusiness Intelligence Analyst

This path is for aspiring data professionals looking to master a powerful stack of self-service business intelligence tools, including Excel, MySQL, Power BI and Tableau

92 hours
7 courses
4 projects
Excel
MySQL
Power BI
Tableau
Overview

This path is for aspiring data professionals looking to master a powerful stack of self-service business intelligence tools, including Excel, MySQL, Power BI and Tableau.

We'll start with Thinking Like an Analyst, a crash course designed to help you build a strong foundation for a successful career in data.

From there we'll dive into some of Excel's most powerful analytics tools (including PivotTables, data visualization and dashboard design), then shift into MySQL, one of the most versatile and practical languages for building, exploring and analyzing databases.

Next we'll dive into two of the most popular business intelligence platforms on the market. You'll master Power BI Desktop by designing and building full-scale data models and reports from scratch, then use Tableau to transform raw data into stunning, interactive dashboards.

Finally, we'll wrap with Launching Your Data Career, a step-by-step guide to finding your path, building your brand, acing the interview, and landing your data dream job.

This path is designed to help you learn job-ready skills, solve real business problems, and build a project portfolio to showcase your skills to peers and employers.

WHO SHOULD TAKE THIS PATH?

  • Aspiring analysts, data scientists or BI professionals
  • Anyone looking to develop a deep and well-rounded BI skill set
  • Students looking for a hands-on, project-based learning experience

WHAT ARE THE PATH REQUIREMENTS?

  • Microsoft Excel (ideally 2016+ or Office 365 for Windows/PC)
  • Power BI Desktop (Windows/PC only)
  • MySQL Workbench & Community Server
  • Tableau Public (free) or Tableau Desktop
  • NOTE: We'll use free tools, and walk you through download & installation
Curriculum
Course
Thinking Like an AnalystCrash course for aspiring analytics & BI professionals looking to build the foundation for a successful career
Course
Excel Pivot Tables & ChartsLearn how to explore and analyze your data using Pivot Tables & Pivot Charts, with 10 real-world case studies
Guided Project
Coffee Shop DashboardBuild an interactive dashboard to explore and analyze coffee shop sales
Course
Advanced Excel Dashboard DesignBring your data to life with dynamic, interactive Excel dashboards, and build 3 real-world projects from scratch
Course
MySQL Data AnalysisExplore and analyze relational databases with MySQL, with hands-on assignments and real-world case studies
Guided Project
Restaurant Order AnalysisAnalyze order data to identify the most and least popular menu items and types of cuisine
Course
Microsoft Power BI Desktop 2023Build a full-scale business intelligence solution from scratch, using one of the world’s most powerful BI platforms
Guided Project
Toy Store KPI ReportBuild a simple, interactive KPI report to track key metrics and explore high-level trends
Course
Intro to Tableau DesktopLearn how to analyze and visualize data with Tableau Desktop, and build real-world projects & dashboards
Guided Project
Global CO2 EmissionsCreate an interactive dashboard showcasing 250 years of CO2 emissions data
Course
Launching Your Data CareerStep-by-step guide to finding your path, building your brand, acing the interview, and landing your analytics dream job
Instructors
Aaron Parry
Aaron ParryAaron is a professional analytics consultant and Microsoft Power BI expert, with 10+ years working in business intelligence and marketing analytics. He's an instructor, coach and mentor for aspiring analysts, and has deep experience helping companies develop and implement full-stack BI solutions.

Chris Dutton
Chris DuttonChris is an EdTech entrepreneur and best-selling Data Analytics instructor. As Founder and Chief Product Officer at Maven Analytics, his work has been featured by USA Today, Business Insider, Entrepreneur and the New York Times, reaching more than 1,000,000 students around the world.

Dustin Cabral
Dustin CabralDustin is a professional Tableau developer and data visualization consultant with 10+ years of experience leading analytics and BI projects. He's a featured Tableau author and currently leads the world's largest Tableau User Group.

Enrique Ruiz
Enrique RuizEnrique is a certified Microsoft Excel Expert and top-rated instructor with a background in business intelligence, data analysis and visualization. He has been producing advanced Excel and test prep courses since 2016, along with adaptations tailored to Spanish-speaking learners.

John Pauler
John PaulerJohn brings over 15 years of business intelligence experience to the Maven team, having worked with companies ranging from Fortune 500 to early stage startups. As a MySQL expert, he has played leadership roles across analytics, marketing, SaaS and product teams.
Overview

This path is for aspiring data professionals looking to master a powerful stack of self-service business intelligence tools, including Excel, MySQL, Power BI and Tableau.

We'll start with Thinking Like an Analyst, a crash course designed to help you build a strong foundation for a successful career in data.

From there we'll dive into some of Excel's most powerful analytics tools (including PivotTables, data visualization and dashboard design), then shift into MySQL, one of the most versatile and practical languages for building, exploring and analyzing databases.

Next we'll dive into two of the most popular business intelligence platforms on the market. You'll master Power BI Desktop by designing and building full-scale data models and reports from scratch, then use Tableau to transform raw data into stunning, interactive dashboards.

Finally, we'll wrap with Launching Your Data Career, a step-by-step guide to finding your path, building your brand, acing the interview, and landing your data dream job.

This path is designed to help you learn job-ready skills, solve real business problems, and build a project portfolio to showcase your skills to peers and employers.

WHO SHOULD TAKE THIS PATH?

  • Aspiring analysts, data scientists or BI professionals
  • Anyone looking to develop a deep and well-rounded BI skill set
  • Students looking for a hands-on, project-based learning experience

WHAT ARE THE PATH REQUIREMENTS?

  • Microsoft Excel (ideally 2016+ or Office 365 for Windows/PC)
  • Power BI Desktop (Windows/PC only)
  • MySQL Workbench & Community Server
  • Tableau Public (free) or Tableau Desktop
  • NOTE: We'll use free tools, and walk you through download & installation
Instructors
Aaron Parry
Aaron ParryAaron is a professional analytics consultant and Microsoft Power BI expert, with 10+ years working in business intelligence and marketing analytics. He's an instructor, coach and mentor for aspiring analysts, and has deep experience helping companies develop and implement full-stack BI solutions.

Chris Dutton
Chris DuttonChris is an EdTech entrepreneur and best-selling Data Analytics instructor. As Founder and Chief Product Officer at Maven Analytics, his work has been featured by USA Today, Business Insider, Entrepreneur and the New York Times, reaching more than 1,000,000 students around the world.

Dustin Cabral
Dustin CabralDustin is a professional Tableau developer and data visualization consultant with 10+ years of experience leading analytics and BI projects. He's a featured Tableau author and currently leads the world's largest Tableau User Group.

Enrique Ruiz
Enrique RuizEnrique is a certified Microsoft Excel Expert and top-rated instructor with a background in business intelligence, data analysis and visualization. He has been producing advanced Excel and test prep courses since 2016, along with adaptations tailored to Spanish-speaking learners.

John Pauler
John PaulerJohn brings over 15 years of business intelligence experience to the Maven team, having worked with companies ranging from Fortune 500 to early stage startups. As a MySQL expert, he has played leadership roles across analytics, marketing, SaaS and product teams.
Curriculum
Course
Thinking Like an AnalystCrash course for aspiring analytics & BI professionals looking to build the foundation for a successful career
Course
Excel Pivot Tables & ChartsLearn how to explore and analyze your data using Pivot Tables & Pivot Charts, with 10 real-world case studies
Guided Project
Coffee Shop DashboardBuild an interactive dashboard to explore and analyze coffee shop sales
Course
Advanced Excel Dashboard DesignBring your data to life with dynamic, interactive Excel dashboards, and build 3 real-world projects from scratch
Course
MySQL Data AnalysisExplore and analyze relational databases with MySQL, with hands-on assignments and real-world case studies
Guided Project
Restaurant Order AnalysisAnalyze order data to identify the most and least popular menu items and types of cuisine
Course
Microsoft Power BI Desktop 2023Build a full-scale business intelligence solution from scratch, using one of the world’s most powerful BI platforms
Guided Project
Toy Store KPI ReportBuild a simple, interactive KPI report to track key metrics and explore high-level trends
Course
Intro to Tableau DesktopLearn how to analyze and visualize data with Tableau Desktop, and build real-world projects & dashboards
Guided Project
Global CO2 EmissionsCreate an interactive dashboard showcasing 250 years of CO2 emissions data
Course
Launching Your Data CareerStep-by-step guide to finding your path, building your brand, acing the interview, and landing your analytics dream job
Testimonials

Real. Happy. Students.

We've helped thousands of students land dream jobs, launch new careers, and build powerful data skills. Start writing your own success story today!

"Thinking like an analyst" course is a very complete compact course if you have to go through the process of getting to know your customers business till building an insightful dashboard for them. I did a lot of courses the past year but this one is totally different. Key is satisfying your customer by giving them strong insights. I really enjoyed the course and put it on pause many times to check or use it directly in my own ongoing project. I can recommend this course to anybody working as a consultant in the data area.
Marjolein Opsteegh
Marjolein Opsteegh
Marjolein Opsteegh
Maven's Pivot Table & Charts class was a great intro to dashboard design but Advanced Excel Dashboard Design will take your approach to a whole new level. You'll learn the importance of formula-based dashboard design and how to manipulate colors, charts, and KPI metric cards to tell your story. By far one of my favorite Maven classes!
Nate Dunn
Nate Dunn
Thinking like an Analyst course has helped me to clearly understand what it takes to have a successful career in data analytics. I have learnt that my focus should be on the skills I acquire while learning and not the tools. I have also learnt a data analysis workflow for high quality analysis that drives actionable outcomes. I had fun while learning during this course. It is self pacing and elaborate.
Eniola Dada
Eniola Dada
Eniola Dada
For all aspiring or converted analyst out there, stop looking around, this is the way to get the role you are looking for. I am truly impressed with the quality of the information and the completeness of the package Maven Analytics put together. In this well rounded package you have everything you need, from finding your own path, writing or re-writing your resume, marketing on LinkedIn, to building the so needed project portfolio, and even interview skills and approaches.
Radu Tecuceanu
Radu Tecuceanu
Radu Tecuceanu
Love the Maven courses! The instructors always have great slide content to help solidify the concepts and drive home the key aspects. The examples and very relatable making it so much easier to understand how to apply my own projects.
Joseph Collins
Joseph Collins
Joseph Collins
Maven Analytics changed my life, I found a better job position taking the Excel and Power BI paths, nowadays I can apply my skills in my company innovating everyday. Thankful forever.
Rodrigo Chavez
Rodrigo Chavez
Rodrigo Chavez
An excellent course with top-notch data sets to work around with. As usual, Chris Dutton did a fabulous job of covering each element with a simplistic but analytical approach. Although I've been using pivot tables for 5+ years, the new learnings will open a whole array of opportunities for extracting actionable insights. Thank you!
Faizan Qadri
Faizan Qadri
Faizan Qadri
Before deciding to join this learning platform, I struggled to understand and figure out what direction I needed to take for my skill development to be a Data Analyst. This first course helped ease some of my fears and confusion. I am more passionate about my decision to become a data analyst. THANK YOU Chris, John, Aaron, and Enrique , and I look forward to learning more through Maven.
Angie
Angie
Angie
The Maven Analytics Courses are packed full of practical lessons and useful pro tips that can be immediately applied to data in the workplace. One of the best trainings I've ever taken!
Randy McCauley
Randy McCauley
Randy McCauley
Once again Maven blows it out of the water. In this fantastic, well structures course about the way to "Think Like an Analyst". It has so many good points and actions to take when putting together a project. I found it very useful and was able to put it into practice at work straight away. Thank Guys!
Catherine Taylor
Catherine Taylor
Catherine Taylor
Maven really makes it possible to get into data analytics without taking (and paying for) a traditional education program. The courses I took left me with a better understanding and deeper knowledge of what I like most: analyzing data.
Erik van’t Ende
Erik van’t Ende
Erik van’t Ende
The course is fantastic and highly recommended. It gave me the confidence to perform the logical analysis in any given data source and of course build kickass visuals business dashboards for my clients :). Loved the course from the first second to the last.
Tonmoy Hashmi
Tonmoy Hashmi
Tonmoy Hashmi
View all testimonials

Trusted by top companies to upskill their teams

Launch Your Data Career
For IndividualsLaunch Your Data CareerStart learning for free, no credit card required
Request A Free Demo
For TeamsRequest A Free DemoRequest a demo and access a free trial for your team