Develop practical skills to organize, clean, analyze, and visualize workplace data in Microsoft Excel. Participants use structured tables, formulas, functions, PivotTables, charts, and reporting techniques to turn raw data into clear business insights.

Professionals in operations, administration, finance, sales, project support, reporting, and other roles that use spreadsheet data.

Basic computer skills and familiarity with worksheets, rows, columns, and simple calculations.

• Prepare reliable data for analysis
• Apply formulas and functions to workplace questions
• Summarize data with PivotTables
• Create accurate charts and reports
• Communicate findings that support decisions

• Module 1: Excel data structures and efficient workbook practices
• Module 2: Data cleaning, validation, and error checking
• Module 3: Formulas, logical functions, and lookup functions
• Module 4: Sorting, filtering, PivotTables, and slicers
• Module 5: Charts, visual analysis, and dashboard principles
• Module 6: Workplace analysis project and findings presentation

Delivery is instructor-led and available live online or in person. The credential includes 16 total instructional hours, guided demonstrations, hands-on exercises, practical workplace activities, and a final applied assessment. Participants must meet attendance requirements, complete assigned activities, and demonstrate the required competencies in the final assessment.

Participants who successfully complete the requirements receive an Ohio Computer Academy certificate bearing the exact credential name: Data Analysis and Visualization with Microsoft Excel. The same exact name will appear on the participant's enrollment record, itemized invoice, completion record, and certificate.

This credential develops the core Power BI Desktop skills needed to build business reports. Participants connect to data sources, shape and clean data in Power Query, create a working data model, and build report pages with visuals, filters, and slicers that answer defined business questions.

Professionals in reporting, operations, finance, sales, and analytics roles who need to build and maintain business reports.

Basic computer skills and familiarity with spreadsheet data. No prior Power BI experience is required.

• Connect Power BI Desktop to files, databases, and other common data sources
• Shape, clean, and combine data using Power Query
• Build a working data model with tables and relationships
• Create core visuals including bar, line, table, matrix, card, and map visuals
• Apply filters, slicers, sorting, and drill down to make reports interactive
• Publish reports and share them with report consumers

• Module 1: Power BI Desktop and the reporting workflow
• Module 2: Connecting to data sources
• Module 3: Shaping and cleaning data in Power Query
• Module 4: Building the data model and relationships
• Module 5: Designing report pages and visuals
• Module 6: Interactivity, publishing, and sharing

Delivery is instructor-led and available live online or in person. The credential includes 16 total instructional hours, guided demonstrations, hands-on exercises, practical workplace activities, and a final applied assessment. Participants must meet attendance requirements, complete assigned activities, and demonstrate the required competencies in the final assessment.

Participants who successfully complete the requirements receive an Ohio Computer Academy certificate bearing the exact credential name: Data Analysis Using Power BI Desktop - Level 1 - Report Builder. The same exact name will appear on the participant's enrollment record, itemized invoice, completion record, and certificate.

This credential centers on using DAX and DAX Studio to create calculated columns, measures, and tables, manage row and filter context, perform time based and multi table calculations, and handle errors. Participants build advanced DAX skills that improve data modeling and reporting accuracy.

Report developers, analysts, and Power BI users who need calculations beyond the built in aggregations.

Working experience building reports in Power BI Desktop, including basic data modeling.

• Write calculated columns, measures, and calculated tables in DAX
• Explain and control row context and filter context in a model
• Apply CALCULATE and filter functions to change evaluation context
• Build time intelligence calculations across periods and comparisons
• Create calculations spanning multiple related tables
• Debug and optimize DAX using DAX Studio and error handling functions

• Module 1: DAX foundations and syntax
• Module 2: Calculated columns, measures, and tables
• Module 3: Row context and filter context
• Module 4: CALCULATE and filter manipulation
• Module 5: Time intelligence and multi table calculations
• Module 6: Error handling, testing, and optimization with DAX Studio

Delivery is instructor-led and available live online or in person. The credential includes 16 total instructional hours, guided demonstrations, hands-on exercises, practical workplace activities, and a final applied assessment. Participants must meet attendance requirements, complete assigned activities, and demonstrate the required competencies in the final assessment.

Participants who successfully complete the requirements receive an Ohio Computer Academy certificate bearing the exact credential name: DAX for Power BI. The same exact name will appear on the participant's enrollment record, itemized invoice, completion record, and certificate.

This credential focuses on using Power BI and Excel together to acquire, shape, and transform data, build data models, and create visualizations. Participants develop the skills to publish and share reports and dashboards that support decision making across a team.

Excel users in finance, operations, sales, and reporting roles who want to extend their work into Power BI.

Working knowledge of Excel, including formulas and worksheet data.

• Acquire data from files, databases, and services into Excel and Power BI
• Shape and transform data using Power Query in both tools
• Build data models with relationships and measures
• Create PivotTables, PivotCharts, and Power BI visuals from a shared model
• Design report layouts that communicate findings clearly
• Publish and share workbooks, reports, and dashboards

• Module 1: Working across Excel and Power BI
• Module 2: Acquiring data from multiple sources
• Module 3: Shaping and transforming data with Power Query
• Module 4: Building the data model
• Module 5: Visualizing data in Excel and Power BI
• Module 6: Publishing, sharing, and refreshing

Delivery is instructor-led and available live online or in person. The credential includes 16 total instructional hours, guided demonstrations, hands-on exercises, practical workplace activities, and a final applied assessment. Participants must meet attendance requirements, complete assigned activities, and demonstrate the required competencies in the final assessment.

Participants who successfully complete the requirements receive an Ohio Computer Academy certificate bearing the exact credential name: Microsoft Power BI for Excel. The same exact name will appear on the participant's enrollment record, itemized invoice, completion record, and certificate.

This credential centers on Power BI and Power BI Desktop, working with data from CSV, TXT, and Excel files, connecting to databases, and performing data merging, grouping, summarizing, and calculations. Participants build interactive visualizations that let users explore business data themselves.

Analysts, report builders, and business professionals who present data to others.

Basic computer skills and familiarity with spreadsheet data.

• Import data from CSV, TXT, and Excel files and connect to databases
• Merge, append, group, and summarize data for reporting
• Create calculations that support visual analysis
• Select and build visuals appropriate to the question and audience
• Add interactivity using slicers, filters, drill through, and bookmarks
• Assemble and share interactive dashboards

• Module 1: Power BI Desktop and data sources
• Module 2: Importing file and database data
• Module 3: Merging, grouping, and summarizing
• Module 4: Calculations for visual analysis
• Module 5: Building interactive visuals
• Module 6: Dashboard assembly and sharing

Delivery is instructor-led and available live online or in person. The credential includes 16 total instructional hours, guided demonstrations, hands-on exercises, practical workplace activities, and a final applied assessment. Participants must meet attendance requirements, complete assigned activities, and demonstrate the required competencies in the final assessment.

Participants who successfully complete the requirements receive an Ohio Computer Academy certificate bearing the exact credential name: Microsoft Power BI Interactive Data Visualizations. The same exact name will appear on the participant's enrollment record, itemized invoice, completion record, and certificate.

This credential covers advanced data visualization and analytics in Tableau, including complex chart types, business dashboards, advanced calculations, and integration with external data sources. Participants build dashboards that deliver actionable business insight.

Tableau users who build dashboards and analyses for business stakeholders.

Working experience building views and basic dashboards in Tableau Desktop.

• Build advanced chart types including dual axis, bullet, waterfall, and spatial views
• Write advanced calculations including level of detail and table calculations
• Apply parameters, sets, and dynamic filtering to drive user interaction
• Blend and join data from multiple and external sources
• Design performant dashboards with actions and guided analysis
• Publish, schedule, and manage shared content

• Module 1: Advanced chart types
• Module 2: Advanced calculations and level of detail expressions
• Module 3: Parameters, sets, and dynamic interactivity
• Module 4: Data blending, joins, and external sources
• Module 5: Dashboard design, actions, and performance
• Module 6: Publishing and managing shared content

Delivery is instructor-led and available live online or in person. The credential includes 16 total instructional hours, guided demonstrations, hands-on exercises, practical workplace activities, and a final applied assessment. Participants must meet attendance requirements, complete assigned activities, and demonstrate the required competencies in the final assessment.

Participants who successfully complete the requirements receive an Ohio Computer Academy certificate bearing the exact credential name: Advanced Tableau. The same exact name will appear on the participant's enrollment record, itemized invoice, completion record, and certificate.

Build the core Tableau Desktop skills needed to connect to data, create visual analysis, apply calculations, and assemble interactive dashboards. The course emphasizes accurate visualization choices and practical workplace reporting.

Business analysts, reporting professionals, data users, managers, and professionals preparing to demonstrate Tableau Desktop proficiency.

Basic data literacy and comfort working with tables, categories, measures, and common business reports.

• Connect to and interpret common data sources
• Build appropriate charts and analytical views
• Use calculations and filters effectively
• Create interactive dashboards
• Apply Tableau Desktop practices to workplace questions

• Module 1: Tableau interface, data connections, and field types
• Module 2: Charts, marks, sorting, filtering, and groups
• Module 3: Calculated fields, table calculations, and dates
• Module 4: Maps, analytics features, and trend analysis
• Module 5: Dashboards, actions, and visual communication
• Module 6: Specialist-level applied dashboard project

Delivery is instructor-led and available live online or in person. The credential includes 16 total instructional hours, guided demonstrations, hands-on exercises, practical workplace activities, and a final applied assessment. Participants must meet attendance requirements, complete assigned activities, and demonstrate the required competencies in the final assessment.

Participants who successfully complete the requirements receive an Ohio Computer Academy certificate bearing the exact credential name: Tableau Desktop Specialist. The same exact name will appear on the participant's enrollment record, itemized invoice, completion record, and certificate.

Establish a practical foundation in Python syntax, program structure, data types, control flow, functions, collections, file handling, and debugging. Participants write and test small programs that automate common tasks.

New Python programmers, technical professionals, analysts, testers, and developers transitioning from another language.

General computer proficiency. Prior exposure to programming concepts is helpful but not required.

• Write and execute Python programs
• Use control structures and collections
• Create reusable functions
• Read and write files safely
• Debug common programming errors

• Module 1: Python environment, syntax, variables, and data types
• Module 2: Conditions, loops, and program flow
• Module 3: Lists, tuples, dictionaries, and sets
• Module 4: Functions, modules, and reusable code
• Module 5: Files, exceptions, and debugging
• Module 6: Applied Python automation project

Delivery is instructor-led and available live online or in person. The credential includes 16 total instructional hours, guided demonstrations, hands-on exercises, practical workplace activities, and a final applied assessment. Participants must meet attendance requirements, complete assigned activities, and demonstrate the required competencies in the final assessment.

Participants who successfully complete the requirements receive an Ohio Computer Academy certificate bearing the exact credential name: Python Programming Level 1: Introduction for Programmers. The same exact name will appear on the participant's enrollment record, itemized invoice, completion record, and certificate.

This credential advances Python programming skills with topics including Jupyter Notebook, regular expressions, data handling, object oriented programming, and debugging. Participants build and maintain more complex Python applications.

Developers, analysts, and technical staff with working Python experience.

Practical experience writing Python scripts, including functions, loops, and data structures.

• Work productively in Jupyter Notebook for development and analysis
• Apply regular expressions to search, validate, and transform text
• Handle structured data from files, APIs, and databases
• Design classes, inheritance, and other object oriented structures
• Apply testing, logging, and debugging practices to working code
• Package and maintain Python code across modules and environments

• Module 1: Development environments and Jupyter Notebook
• Module 2: Regular expressions and text processing
• Module 3: Working with structured data and external sources
• Module 4: Object oriented programming in Python
• Module 5: Testing, logging, and debugging
• Module 6: Packaging, modules, and maintainability

Delivery is instructor-led and available live online or in person. The credential includes 16 total instructional hours, guided demonstrations, hands-on exercises, practical workplace activities, and a final applied assessment. Participants must meet attendance requirements, complete assigned activities, and demonstrate the required competencies in the final assessment.

Participants who successfully complete the requirements receive an Ohio Computer Academy certificate bearing the exact credential name: Advanced Python 3 Programming. The same exact name will appear on the participant's enrollment record, itemized invoice, completion record, and certificate.

Use Python and widely adopted data libraries to collect, clean, analyze, and visualize structured data. Participants complete an end-to-end analysis that combines programming, data preparation, exploratory analysis, and communication.

Aspiring data analysts, technical business professionals, Python users, and team members supporting data science work.

Basic Python programming knowledge, including variables, conditions, loops, functions, and collections.

• Load and inspect structured datasets
• Clean and transform data with Python
• Perform exploratory analysis
• Create meaningful visualizations
• Document and communicate analytical findings

• Module 1: Data science workflow and Jupyter-based analysis
• Module 2: NumPy arrays and numerical operations
• Module 3: Pandas data loading, cleaning, and transformation
• Module 4: Exploratory analysis and descriptive statistics
• Module 5: Visualization with Matplotlib and Seaborn
• Module 6: End-to-end data science programming project

Delivery is instructor-led and available live online or in person. The credential includes 16 total instructional hours, guided demonstrations, hands-on exercises, practical workplace activities, and a final applied assessment. Participants must meet attendance requirements, complete assigned activities, and demonstrate the required competencies in the final assessment.

Participants who successfully complete the requirements receive an Ohio Computer Academy certificate bearing the exact credential name: Programming for Data Science with Python. The same exact name will appear on the participant's enrollment record, itemized invoice, completion record, and certificate.

This credential covers obtaining, cleaning, and preparing data for analysis using Python, then applying statistical and predictive techniques to visualize, categorize, and interpret data for business insight.

Analysts and technical professionals who work with data and want to analyze it in Python.

Basic Python experience and familiarity with working with data.

• Obtain data from files, databases, and other sources using Python
• Clean, reshape, and prepare datasets for analysis
• Apply descriptive statistics to summarize and compare data
• Produce visualizations that expose patterns, trends, and outliers
• Apply categorization and basic predictive techniques to business questions
• Interpret results and communicate findings with their limitations

• Module 1: Python tools for data analytics
• Module 2: Obtaining and loading data
• Module 3: Cleaning and preparing datasets
• Module 4: Descriptive statistics and exploration
• Module 5: Visualization for analysis
• Module 6: Categorization, prediction, and interpretation

Delivery is instructor-led and available live online or in person. The credential includes 16 total instructional hours, guided demonstrations, hands-on exercises, practical workplace activities, and a final applied assessment. Participants must meet attendance requirements, complete assigned activities, and demonstrate the required competencies in the final assessment.

Participants who successfully complete the requirements receive an Ohio Computer Academy certificate bearing the exact credential name: Python for Data Analytics. The same exact name will appear on the participant's enrollment record, itemized invoice, completion record, and certificate.

Develop foundational knowledge of AWS services, terminology, security, architecture, pricing, and support. Guided activities demonstrate how core compute, storage, database, networking, monitoring, and identity services work together.

IT professionals, technical managers, developers, operations staff, and business technology teams beginning their AWS journey.

General understanding of IT infrastructure, networking, storage, and computing concepts.

• Explain core AWS concepts and services
• Recognize basic security responsibilities
• Select services for common requirements
• Interpret foundational cloud architecture
• Apply cost and operational considerations

• Module 1: AWS global infrastructure and shared responsibility
• Module 2: Identity, access management, and security fundamentals
• Module 3: Compute services and scalable application concepts
• Module 4: Storage and database service selection
• Module 5: Networking, monitoring, reliability, and cost awareness
• Module 6: AWS architecture scenario and knowledge assessment

Delivery is instructor-led and available live online or in person. The credential includes 16 total instructional hours, guided demonstrations, hands-on exercises, practical workplace activities, and a final applied assessment. Participants must meet attendance requirements, complete assigned activities, and demonstrate the required competencies in the final assessment.

Participants who successfully complete the requirements receive an Ohio Computer Academy certificate bearing the exact credential name: AWS Technical Essentials. The same exact name will appear on the participant's enrollment record, itemized invoice, completion record, and certificate.

This credential develops the ability to design and optimize IT infrastructure on AWS, covering cloud best practices, solution architecture, and deployment patterns for scalable and secure cloud environments.

Solution architects, engineers, and technical staff responsible for cloud infrastructure decisions.

Working familiarity with core AWS services and general networking concepts.

• Design AWS architectures using compute, storage, networking, and database services
• Apply identity, access, and security controls across an architecture
• Design for high availability, fault tolerance, and disaster recovery
• Select deployment patterns appropriate to workload requirements
• Apply cost optimization and performance efficiency practices
• Document and justify an architecture against defined requirements

• Module 1: Architecture principles and the AWS Well-Architected Framework
• Module 2: Compute, storage, and database design choices
• Module 3: Networking and connectivity design
• Module 4: Security, identity, and access architecture
• Module 5: Availability, resilience, and disaster recovery
• Module 6: Cost, performance, and architecture review

Delivery is instructor-led and available live online or in person. The credential includes 16 total instructional hours, guided demonstrations, hands-on exercises, practical workplace activities, and a final applied assessment. Participants must meet attendance requirements, complete assigned activities, and demonstrate the required competencies in the final assessment.

Participants who successfully complete the requirements receive an Ohio Computer Academy certificate bearing the exact credential name: Architecting on AWS. The same exact name will appear on the participant's enrollment record, itemized invoice, completion record, and certificate.

Design and implement Microsoft-centered DevOps practices that connect planning, source control, continuous integration, testing, delivery, security, monitoring, and feedback. Participants build a practical delivery pipeline and governance plan.

DevOps engineers, cloud engineers, developers, administrators, technical leads, and delivery professionals working with Microsoft platforms.

Experience with software delivery, source control, cloud services, or system administration. Familiarity with Azure is recommended.

• Design an end-to-end DevOps workflow
• Configure source and build practices
• Plan reliable deployment strategies
• Integrate security and governance
• Use monitoring and feedback to improve delivery

• Module 1: DevOps strategy, value streams, and work planning
• Module 2: Source control, branching, repositories, and collaboration
• Module 3: Continuous integration and build automation
• Module 4: Release pipelines, environments, and deployment strategies
• Module 5: Security, compliance, monitoring, and feedback
• Module 6: Microsoft DevOps implementation project

Delivery is instructor-led and available live online or in person. The credential includes 16 total instructional hours, guided demonstrations, hands-on exercises, practical workplace activities, and a final applied assessment. Participants must meet attendance requirements, complete assigned activities, and demonstrate the required competencies in the final assessment.

Participants who successfully complete the requirements receive an Ohio Computer Academy certificate bearing the exact credential name: Designing and Implementing Microsoft DevOps Solutions. The same exact name will appear on the participant's enrollment record, itemized invoice, completion record, and certificate.

Apply DevOps principles and AWS services to automate infrastructure, continuous delivery, monitoring, security, and resilient operations. Participants design a delivery workflow for a cloud-based application.

Cloud engineers, DevOps engineers, developers, system administrators, and technical leads responsible for AWS delivery environments.

Foundational AWS knowledge plus familiarity with software delivery, scripting, infrastructure, or operations.

• Design an AWS-based DevOps workflow
• Automate infrastructure and environments
• Implement continuous delivery concepts
• Apply monitoring and operational controls
• Plan secure and resilient deployments

• Module 1: AWS DevOps operating model and delivery architecture
• Module 2: Infrastructure as code and configuration practices
• Module 3: Continuous integration and continuous delivery on AWS
• Module 4: Deployment strategies and environment automation
• Module 5: Monitoring, logging, security, and incident response
• Module 6: AWS DevOps pipeline project

Delivery is instructor-led and available live online or in person. The credential includes 16 total instructional hours, guided demonstrations, hands-on exercises, practical workplace activities, and a final applied assessment. Participants must meet attendance requirements, complete assigned activities, and demonstrate the required competencies in the final assessment.

Participants who successfully complete the requirements receive an Ohio Computer Academy certificate bearing the exact credential name: DevOps Engineering on AWS. The same exact name will appear on the participant's enrollment record, itemized invoice, completion record, and certificate.

Build structured database programs with Oracle PL/SQL. Participants create blocks, procedures, functions, packages, cursors, and exception-handling logic while applying maintainability, testing, and performance practices.

Database developers, application developers, SQL professionals, technical analysts, and support teams working with Oracle databases.

Working knowledge of SQL queries, joins, data manipulation, and relational database concepts.

• Create executable PL/SQL blocks
• Develop procedures and functions
• Process data with cursors and collections
• Handle exceptions and transactions
• Organize maintainable database code

• Module 1: PL/SQL architecture, blocks, variables, and data types
• Module 2: Conditional logic, loops, and SQL integration
• Module 3: Cursors, records, and collections
• Module 4: Procedures, functions, and parameters
• Module 5: Packages, exceptions, and transaction control
• Module 6: Applied PL/SQL development project

Delivery is instructor-led and available live online or in person. The credential includes 16 total instructional hours, guided demonstrations, hands-on exercises, practical workplace activities, and a final applied assessment. Participants must meet attendance requirements, complete assigned activities, and demonstrate the required competencies in the final assessment.

Participants who successfully complete the requirements receive an Ohio Computer Academy certificate bearing the exact credential name: Oracle PL/SQL Programming. The same exact name will appear on the participant's enrollment record, itemized invoice, completion record, and certificate.

Learn to retrieve, filter, combine, summarize, and modify relational data using SQL. Participants practice writing clear queries against realistic business datasets and checking results for completeness and accuracy.

Beginning data analysts, application support staff, testers, business intelligence users, and professionals who need direct access to relational data.

Basic computer skills and familiarity with tabular data. No prior SQL experience is required.

• Write accurate SELECT statements
• Filter and sort query results
• Combine related tables with joins
• Summarize data using aggregate functions
• Validate and communicate query results

• Module 1: Relational databases and SELECT fundamentals
• Module 2: Filtering, sorting, expressions, and built-in functions
• Module 3: Joins and multi-table queries
• Module 4: Grouping, aggregation, and HAVING
• Module 5: Subqueries, set operators, and data modification
• Module 6: Business querying project and result validation

Delivery is instructor-led and available live online or in person. The credential includes 16 total instructional hours, guided demonstrations, hands-on exercises, practical workplace activities, and a final applied assessment. Participants must meet attendance requirements, complete assigned activities, and demonstrate the required competencies in the final assessment.

Participants who successfully complete the requirements receive an Ohio Computer Academy certificate bearing the exact credential name: Fundamentals of SQL Querying. The same exact name will appear on the participant's enrollment record, itemized invoice, completion record, and certificate.

Develop well-structured SQL databases using sound table design, data integrity, programmability, performance, and concurrency practices. Participants implement and test database objects for a realistic application scenario.

SQL developers, database developers, application developers, and technical professionals responsible for database design and implementation.

Working knowledge of SQL querying, relational database concepts, keys, joins, and data modification.

• Design normalized database structures
• Enforce data integrity
• Create programmable database objects
• Apply indexing and performance principles
• Implement safe transactional logic

• Module 1: Relational design, normalization, tables, and data types
• Module 2: Keys, constraints, indexes, and data integrity
• Module 3: Views, stored procedures, functions, and triggers
• Module 4: Query plans and performance fundamentals
• Module 5: Transactions, concurrency, and error handling
• Module 6: Database development capstone

Delivery is instructor-led and available live online or in person. The credential includes 16 total instructional hours, guided demonstrations, hands-on exercises, practical workplace activities, and a final applied assessment. Participants must meet attendance requirements, complete assigned activities, and demonstrate the required competencies in the final assessment.

Participants who successfully complete the requirements receive an Ohio Computer Academy certificate bearing the exact credential name: Developing SQL Databases. The same exact name will appear on the participant's enrollment record, itemized invoice, completion record, and certificate.