Designed With a Focus on Real-World Relevance
Concentrate on the most important tools for performing data analysis on the job. GA’s analytics advisory board curates the best practices and innovative teaching approaches of our entire expert network to meet evolving employer demands. Its work ensures that students graduate ready to tackle the challenges they’ll face in the field.
Translate Data Into Meaningful Insights
Designed for students with a variety of professional backgrounds and experience levels — including beginners — this course takes a deep dive into the data analytics process: collection, cleaning, analysis, and visualisation. Get hands-on experience with Excel, SQL, and Tableau, and transform raw data into a critical decision-making tool.
Data Cleaning and Aggregation with Excel
Practice using Excel to conduct basic data cleaning, aggregation, analysis, and visualization.
- The Value of Data + Data Narratives
- Excel Fundamentals
- Data Referencing
- Data Aggregation
- Data Visualization in Excel
- Statistics in Excel
Querying and Organizing Data with SQL
Practice using SQL to conduct advanced data querying, cleaning, and aggregation.
- Foundations of Databases and SQL
- Combining Data in SQL
- Cleaning Data and Creating Multiple Joins in SQL
- Using Logic in SQL
- Applying SQL Functions
Data Narratives and Visualization with Tableau
Practice using Tableau to visualize and map data, and connect data across Excel, SQL, and Tableau.
- Visualizing and Mapping Data in Tableau
- Text Manipulation in Tableau
- Designing Data Dashboards in Tableau
- Working with Data across Excel, SQL, and Tableau