Business Analyst Tech Certificate (Self-Paced)
IDCYZN

Self-paced online training with expert support Certificate with 10 courses

Master core business analysis skills as you work with Excel, PowerPoint, and SQL to interpret and present data effectively. You’ll also gain hands-on experience with data visualization tools like Tableau and learn to automate tasks using Python.

$2,995 63 clock hours Live Support Start anytime

This program includes

  • 63 hours of project-based training from experts
  • 223 training videos
  • Software Access
  • 4 additional elective courses
  • Answers from real instructors
  • Additional 1-on-1 mentoring outside of class
  • Retake for free within 1 year
  • Access to class recordings (30 days)
  • Verified digital certificate of completion
  • Learn at an accredited institution

This course is self-paced. For live online or in-person instruction, take the Business Analyst Tech Certificate.

Develop the core skills needed for a thriving career in business analysis. This certificate program emphasizes hands-on training in Excel, SQL, Python, and Tableau, equipping you with the techniques to interpret data and effectively present insights.

  • Data Management in Excel: Begin with the fundamentals and advance to expert-level skills. Work with functions, formulas, Pivot Tables, and macros to organize large datasets and support informed decision-making.
  • Querying with SQL: Learn to retrieve, filter, and manipulate data using SQL. Write queries, apply joins, use aggregate functions, and handle large datasets with PostgreSQL to produce clear, actionable insights.
  • Analyzing Data with Python: Gain a solid grounding in Python programming and data analysis. Use Pandas to clean and structure datasets, and create visualizations with Matplotlib to prepare for advanced analytics projects.
  • Visualizing Insights with Tableau: Transform data into compelling visual narratives using Tableau. Build interactive dashboards and diverse visualizations to communicate findings clearly to varied audiences.
  • Bonus Elective Courses: Enhance your knowledge of business concepts and communication tools through additional training in financial accounting, PowerPoint, and Google Ads.
Read more

Courses & Videos in This Certificate Program

Download Syllabus PDF

Unit 1 6 Hours

Beginner Excel Course (Self-Paced)

In this beginner Excel workshop, you’ll learn the essentials of Microsoft Excel, including calculations, basic functions, graphs, formatting, and printing. This basic Excel class is perfect for those with limited experience looking to expand their proficiency.

  • Become familiar with the interface and data entry
  • Learn essential formulas and functions
  • Format and print your work
  • Create charts, including line, column, and pie charts
  • Learn tips and tricks for easy workbook management
  • Review key concepts in a final project
Lesson 1: Introduction
Lesson 2: Formulas
Lesson 3: Formatting
Lesson 4: Charts & Tables
Lesson 5: Workbook Management

Unit 2 6 Hours

Intermediate Excel Course (Self-Paced)
  • Learn to split and join text, apply data validation, and create named ranges
  • Use database functions such as VLOOKUP and HLOOKUP
  • Write logical formulas using AND, OR, and IF functions
  • Create Pivot Tables to efficiently summarize and analyze large datasets
  • Apply statistical functions such as RANK, COUNTIFS, and SUMIFS
  • Build advanced combo charts by combining multiple chart types
  • Reinforce key concepts through a guided final project
Lesson 5: Workbook Management
Lesson 1: Worksheet Management
Lesson 2: Working with Text
Lesson 3: Cell Ranges
Lesson 4: Database Functions
Lesson 5: Pivot Tables
Lesson 6: Logical Functions
Lesson 7: Statistical Functions
Lesson 8: Advanced Charts

Unit 3 6 Hours

Advanced Excel Course (Self-Paced)
  • Cell management, including cell locking, auditing,  and hot keys
  • Special formatting for calculating dates
  • Use advanced functions and advanced analytical tools 
  • Record macros and relative reference macros for ad hoc reporting
Lesson 1: Cell Management
Lesson 2: Special Formatting
Lesson 3: Advanced Functions
Lesson 4: What If Analysis
Lesson 5: Advanced Analytical Tools
Lesson 6: Advanced Database Functions
Lesson 7: Introduction to Macros
Lesson 8: Dynamic Arrays

Unit 4 18 Hours

SQL Bootcamp (Self-Paced)

Learn how to extract, filter, and manipulate data using SQL. This course covers PostgreSQL fundamentals, database querying, table joins, and advanced techniques for handling large datasets.

  • Write SQL queries to retrieve, filter, and sort data efficiently.
  • Use joins to combine information from multiple tables and establish relationships.
  • Apply aggregate functions like SUM, COUNT, AVG, and GROUP BY to summarize data.
  • Work with subqueries, conditional logic (CASE statements), and advanced string functions.
  • Optimize queries using indexes, data type conversions, and best practices.
  • Explore views and user-defined functions to streamline database management.
Lesson 1: Setting Up the Work Environment
Lesson 2: Let's Start Learning SQL Code
Lesson 3: Working with Characters & Numbers
Lesson 4: Using SQL Wildcards
Lesson 5: Indentifying Rows & Connecting Tables
Lesson 6: Inner vs. Outer Joins
Lesson 7: Changing Data Types
Lesson 8: Working with Dates
Lesson 9: Organizing Statistical Results Into Categories
Lesson 10: Subqueries
Lesson 11: Aggregate Window Functions
Lesson 12: Conditionals
Lesson 13: Views
Lesson 14: String Functions
Lesson 15: Additional Resources
Lesson 16: AI and SQL

Unit 5 30 Hours

Python for Data Science Bootcamp (Self-Paced)
  • Handle different types of data such as integers, floats, and strings
  • Control the flow of your programs with conditional statements, loops, and functions
  • Reuse and simplify code with object-oriented programming
  • Analyze tabular data with NumPy and Pandas
  • Create graphs and visualizations with Matplotlib
  • Make predictions with linear regression, using scikit-learn
Lesson 1: Python for Data Science Fundamentals
Lesson 2: Boolean Conditions
Lesson 3: Datetime & Random
Lesson 4: Loops & Strings
Lesson 5: Dictionaries
Lesson 6: Numpy
Lesson 7: Pandas Dataframes
Lesson 8: Bar Charts with Matplotlib
Lesson 9: Line & Scatter Charts with Matplotlib
Lesson 10: Pivot Population Data & Charts

Unit 6 12 Hours

Tableau Bootcamp (Self-Paced)

Develop the skills to turn raw data into compelling visual stories with Tableau, the industry-leading data visualization platform. This hands-on bootcamp teaches you to explore, analyze, and publish dashboards that communicate insights clearly and effectively.

  • Connect to datasets in various formats, then clean, filter, and structure the data for effective visual storytelling
  • Create a range of visualizations, including bar charts, line charts, treemaps, heat maps, and dual-axis charts
  • Use Tableau’s calculation tools to create custom fields, apply aggregates, and deepen your data analysis
  • Format charts using labels, tooltips, color, and axis adjustments to improve clarity and impact
  • Work with geographic data to create interactive map visualizations such as choropleths and proportional symbol maps
  • Customize dashboards and stories for various audiences and screen sizes using Tableau’s interactivity tools
  • Integrate external mapping services and explore advanced visualization types like spider maps and alluvial diagrams
  • Publish your work to Tableau Online and export dashboards for professional sharing and team collaboration
Lesson 1: Getting Started With Tableau
Lesson 2: Creating Visualizations
Lesson 3: Organizing Data
Lesson 4: Calculations and Dashboards
Lesson 5: Data Interpreter
Lesson 6: Multi-Chart Worksheets
Lesson 7: Parameters and Filtering

Bonus 12 Hours

Financial Accounting Bootcamp (Self-Paced)

Learn the fundamentals of financial accounting in this beginner-friendly bootcamp. This course introduces key concepts, including income statements, balance sheets, and cash flow statements, while also exploring advanced topics such as investments, securities, and depreciation. You’ll gain hands-on experience analyzing real-world financial data and develop accounting skills for careers in finance, bookkeeping, and beyond.

  • Understand the structure and purpose of key financial reports, including income statements, balance sheets, and cash flow statements
  • Learn to apply Generally Accepted Accounting Principles (GAAP) and distinguish between cash and accrual accounting methods
  • Analyze financial performance using income statement metrics and profit ratios
  • Explore advanced accounting concepts, including depreciation, amortization, and unusual items
  • Work with analytical tools like Trailing Twelve Months (TTM) and Year-over-Year (Y/Y) comparisons
  • Dive into complex accounting areas such as deferred taxes, intercompany investments, and debt accounting

Bonus 6 Hours

PowerPoint Level I (Self-Paced)

This self-paced, beginner-friendly PowerPoint course teaches the core skills needed to create engaging, professional presentations on your own schedule.

  • Build presentations from templates and customize layouts, themes, and content structure
  • Add and format text, bullets, and numbered lists using Outline View and formatting tools
  • Insert and enhance photos, SmartArt, and shapes with effects, cropping, and alignment options
  • Create and format tables, add connector lines, and import charts from Excel
  • Apply transitions, manage presenter notes, and use tools for live or virtual delivery
  • Save, print, and export presentations to PDF with professional formatting options

Bonus 6 Hours

PowerPoint Level II (Self-Paced)
  • Create and manage Slide Master layouts for consistent branding across presentations
  • Design custom PowerPoint themes with personalized color palettes, fonts, and reusable backgrounds
  • Animate text, charts, and objects using entrance, emphasis, exit effects, and the Morph transition
  • Incorporate video, hyperlinks, and dynamic charts and tables from Excel for interactive presentations
  • Customize workflows with hidden slides, custom shows, sections, and the Quick Access Toolbar
  • Collaborate and finalize presentations using commenting tools, PDF export, and optimized print settings

Bonus 12 Hours

Google Ads Bootcamp (Self-Paced)

Learn how to develop and manage successful Google Ads campaigns, generate leads and sales, track conversions, and improve your search engine ranking with this comprehensive workshop. Perfect for anyone looking to expand their brand awareness through effective paid advertising techniques.

  • How to set up and manage a Google Ads account
  • Keyword Strategies
  • How to use Match Types to control who sees your ads
  • Bidding Strategies
  • How the Google Ads Auction Works
  • How to Create Ads That Convert
  • Landing Page Best Practices
  • How to Set Up Call and Conversion Tracking
  • Navigating the Google Ads Interface
  • Optimizing Your Campaign for Maximum Results
  • Remarketing for Search & Display
  • Campaign Automation
  • Display Advertising with Google Ads
Lesson 1: Google Ads Foundations
Lesson 2: Keywords & Research Strategy
Lesson 3: Campaign Setup & Structure
Lesson 4: Ad Creation & Compliance
Lesson 5: Quality, Landing Pages & Conversion Tracking
Lesson 6: Reporting & Optimization
Lesson 7: Audience Expansion & Scaling
A group of adult learners sits in a classroom, smiling and engaged in a government training session.
A government training instructor in a suit gestures while teaching in front of a whiteboard covered with notes and diagrams.
A person in professional attire holds a Graduate School USA folder, symbolizing participation in government training programs.

Group Training

Since 1921, Graduate School USA has partnered with over 125 federal agencies and trained more than one million federal employees. Led by instructors with deep, real-world knowledge of federal regulations, policies, and practices, our private group programs are practical, mission-driven, and tailored to your agency’s objectives. We offer expertise across key federal domains—including human resources, financial management, acquisition and contracting, leadership, and more—to deliver training where and how your team needs it.

Complete this form and we’ll get back to you within 1 business hour.

The Fact Is – We’ve Been Government’s Training Partner Since 1921

400+ Courses & Certificates 125+ Federal Agencies Served 200+ Subject-Matter Experts