Data & Business Analyst Training

SQL | Microsoft SQL Server | SQLite Studio | Microsoft Excel | Tableau | Flourish | Power BI | Jira | Agile | Scrum | Project Management

Agile Product Owner Role: Foundations

In this one-hour course from LinkedIn Learning, the role of product owner was discussed, including collaborators, the product road map, and establishing a minimum viable product.
Skills: Agile, Project Management

Break Into Tech Data Analytics Certificate

This in-depth certificate course covers using SQL and Tableau to analyze and solve business problems using data analysis and visualization.
Skills: Data Analysis, Microsoft Excel, SQL, Tableau

The Complete Business Analysis Fundamentals Course + CERT

Offered through Udemy, this 11-hour course reviewed key concepts for new analysts, tools, and applications, including Agile methodology, Jira, Trello, and Microsoft Teams.

Skills: Agile Project Management, Gathering, Validating, Prioritzing Requirements

Data Analysis in Excel

This three-hour interactive class from DataCamp reviewed cleaning and analyzing data using aggregate functions, conditional aggregates, and VLOOKUP.

Skills: Data Analysis, Microsoft Excel

Excel: Lookup Functions in Depth

This one-hour course from LinkedIn Learning covered lookup functions, including XLOOKUP, VLOOKUP, HLOOKUP, as well as uses of the MATCH function and the XMATCH function to match up data, how to extract data using the INDEX function, how to restructure the lists being searched to ensure that you're using each function efficiently, and learn about dynamic array lookup functions like UNIQUE, SORT, SORTBY, and FILTER  
Skills: Data Analysis, Microsoft Excel

Intro to SQL: Querying and Managing Data

Offered through Khan Academy, this course demonstrates how to use SQL to store, query, and manipulate data.
Skills: SQL

Introduction to Power BI

This three-hour interactive course offered through DataCamp reviewed loading multiple data sets, building a data model, creating interactive reports, cleaning data with Power Query, creating visualizations with hierarchies and drill-down paths, and sorting, filtering, and controlling interactivity in the visualizations.

Jira Fundamentals Badge

This three-course Jira training covers the fundamental skills needed for new Jira users, including issues, projects, and boards. Courses included are Getting Started with Jira, Basic Jira Navigation, Jira Best Practices.
Skills: Jira, Project Management

Learning Excel: Data-Analysis

This two-hour course from LinkedIn Learning covered foundational concepts for data analysis, such as using formulas to calculate mean, median, and standard deviation, as well as creating visualizations, and calculating covariance and correlation between data sets.
Skills: Data Analysis, Microsoft Excel

Scrum: The Basics

This one-hour course from LinkedIn Learning reviewed the different roles of the scrum framework and how agile project management works.
Skills: Agile, Scrum, Project Management

Scrum Launchpad

Offered by Cavu, this ten-module course covers the history of Agile, core Agile values, scrum roles, sprint refinement, sprint estimation, sprint planning and sprint review, and prepares the student to interact effectively with a scrum team and how to use scrum patterns in creating high-performing teams.
Skills: Agile, Scrum, Project Management

SQL Basics

The SQL Basics course from LearnSQL.com starts with simple queries and progresses to joining multiple tables. You will find out about the subtle differences between various joining methods, including INNER JOIN, LEFT JOIN, RIGHT JOIN, and OUTER JOIN. Master using the GROUP BY function to create simple reports and begin learning to use subqueries.
Skills: SQL

SQL Fundamentals

In this five-course learning track from DataCamp, basic and intermediate-level SQL skills are covered over 21 hours, including joining data, window functions, and common table expressions.
Skills: SQL

Tableau Creator

 Learn how to prepare, analyze, and share your data using Tableau.
Skills: Tableau, Data Analysis, Data Visualization

21 Days to Data

In this 21 day challenge, I worked with a data set about NYC crime. I practiced cleaning data, creating visualizations, and analyzing the data.
Skills: Data Cleaning, Data Analysis, Data Visualizations