The Reynolds and Reynolds Sales Leadership Institute at Texas A&M University has partnered with Pathstream to deliver this online program – The Data Analytics and Agile Leadership Certificate is a flexible program that can be completed in 9 months. You’ll be equipped with data and operations skills required for business leadership positions. The program will teach you how to frame business problems, wrangle data in spreadsheets, create data visualizations, and run data queries in SQL. You will learn how to use Tableau software and master Agile project management frameworks. This certificate is a Career Launch program, designed for employees with no prior experience. Expect to spend 10-15 hours a week, with individualized support along the way. Career Launch certificates provide in-demand skills AND result in college credits that can count towards a degree.
Course 1:
Business Analytics Fundamentals
Course 2:
SQL for Analytics
Course 3:
Data Visualization with Tableau
Course 4:
Agile Project Management
Course 1: Business Analytics Fundamentals
This course is designed to introduce you to the fundamentals of Business and Data Analytics. You will practice skills for data wrangling, data visualizations, descriptive statistics, exploratory data analysis, and data storytelling. The course culminates with a hands-on project in which you will perform an end-to-end exploratory data analysis (EDA). This course is designed for students with little or no background in business or analytics. Upon completion, you will be able to apply your new knowledge to make compelling business recommendations based on data. Watch your new insights come to life by making compelling data visualizations.
Learning Outcomes:
- Construct business framing applications for analytics problem-solving processes.
- Apply spreadsheet software to manipulate and prepare data for analysis.
- Communicate analysis insights to intended audiences, such as business stakeholders.
Course 2: SQL for Analytics
In this course, you will learn the fundamentals of SQL through a guided case study project, where you will act as a data analyst supporting the growth of the new company. You will build DDL (data definition language) and DML (data manipulation language) queries using MySQL workbench. You will assess the existing data infrastructure, apply appropriate changes to a database, and present insights to business stakeholders.
Learning Outcomes:
- Explain the role and structure of relational databases as they apply to data analytics.
- Extract meaningful insights from relational databases using Data Manipulation Language (DML).
- Design industry-standard relational database schemas using Data Definition Language (DDL).
- Revise database schema to meet criteria of normal forms (1NF, 2NF, & 3NF).
Course 3: Data Visualization with Tableau
In this course, you will learn the fundamentals of data visualization, including how to communicate insights from data. You will be learning in an online lab environment using real industry data sets and building directly in Tableau software embedded in the learning experience (no downloads required). You will create and design both static and dynamic tables, data visualizations, dashboards, and stories while incorporating visual design best practices. You will also connect multiple external data sources and optimize large data to efficiently wrangle and analyze industry data.
Learning Outcomes:
- Learn to use Tableau Software to visualize data.
- Build interactive tables by connecting, preparing, and customizing data in Tableau.
- Create data visualizations, dashboards, and Tableau Stories, to communicate insights to business stakeholders.
- Apply Tableau performance optimization to improve speed when working with large datasets.
Course 4: Agile Project Management
In this course you will learn the fundamentals of Agile project management methodologies. The learning experience is highly interactive and hands-on, providing you with the opportunity to learn by doing. You will begin by exploring the fundamentals of Agile, including frameworks such as Scrum, Kanban, and XP. You will then learn about Scrum in detail, covering key concepts, such as sprints, adaptive planning and estimation. You will also learn how to conduct daily scrums, retrospectives and other key meetings to successfully plan and manage a project. While learning these concepts and frameworks, you will practice key project management related soft skills, such as how to plan for unexpected challenges and proactively manage issues that arise on a team.
Learning Outcomes:
- Manage a technical project from start to finish using key Agile methodologies, concepts, tools and frameworks.
- Create and monitor a Kanban board to organize sprints and share information with the project team throughout the lifecycle of an Agile project.
- Initiate a Scrum project by decomposing a release plan into user stories and analyzing project risks.
- Plan a kickoff sprint in Asana by grooming a backlog, establishing a point structure, and committing to the sprint.
- Support a hypothetical Scrum team through executing a sprint by creating and analyzing a burndown chart.
- Continuously improve Scrum team efficiency throughout sprint cycles by analyzing and resolving velocity issues.
- Conduct a sprint review in Asana, and close a project by facilitating a retrospective.
Course 1:
Business Analytics Fundamentals
Learning Outcomes:
- Construct business framing applications for analytics problem-solving processes.
- Apply spreadsheet software to manipulate and prepare data for analysis.
- Communicate analysis insights to intended audiences, such as business stakeholders.
Course 2:
SQL for Analytics
Learning Outcomes:
- Explain the role and structure of relational databases as they apply to data analytics.
- Extract meaningful insights from relational databases using Data Manipulation Language (DML)
- Design industry-standard relational database schemas using Data Definition Language (DDL)
- Revise database schema to meet criteria of normal forms (1NF, 2NF, & 3NF)
Course 3:
Data Visualization with Tableau
Learning Outcomes:
- Learn to use Tableau Software to visualize data.
- Build interactive tables by connecting, preparing, and customizing data in Tableau.
- Create data visualizations, dashboards, and Tableau Stories, to communicate insights to business stakeholders.
- Apply Tableau performance optimization to improve speed when working with large datasets.
Course 4:
Agile Project Management
Learning Outcomes:
- Manage a technical project from start to finish using key Agile methodologies, concepts, tools and frameworks.
- Create and monitor a Kanban board to organize sprints and share information with the project team throughout the lifecycle of an Agile project.
- Initiate a Scrum project by decomposing a release plan into user stories and analyzing project risks.
- Plan a kickoff sprint in Asana by grooming a backlog, establishing a point structure, and committing to the sprint.
- Support a hypothetical Scrum team through executing a sprint by creating and analyzing a burndown chart.
- Continuously improve Scrum team efficiency throughout sprint cycles by analyzing and resolving velocity issues.
- Conduct a sprint review in Asana, and close a project by facilitating a retrospective.
After completing this program, you’ll be ready to:
- Frame business problems effectively
- Identify insights from data using exploratory data analysis and communicate insights to business stakeholders
- Learn SQL and design industry-standard relational database schemas
- Perform inferential data analysis and construct a simple predictive model
- Learn to visualize data using Tableau software
- Manage a technical project from start to finish using Agile methodologies, concepts, tools, and frameworks
- No required times to log in. Complete lessons at times during the week that work for you. Keep up with deadlines to stay on track and complete in 6 months.
- Complete real business projects in an online platform and get individualized support and feedback from instructors.
- Practice using data analytics and project management software directly in the learning platform. No separate downloads.
- Explore the real work that project managers and data analysts do on the job and apply those skills to your own career.
- Access individualized career coaching to help you get promoted and advance professionally.
FAQs
What is the schedule?
Can I work full-time while enrolled in this program?
What prerequisites do I need?
What industry certifications will I be prepared for?
What is Pathstream?
Pathstream is a provider of digital skills training based in Silicon Valley. We partner with leading tech companies and universities like the Reynolds and Reynolds Sales Leadership Institute at Texas A&M University to develop programs that prepare people for in-demand jobs.