Data is an integral part of every successful business, as companies increasingly make data-driven decisions. According to IBM, there were more than 2.7 million data jobs in 2020.
In the Data Analyst Accelerator, you will learn to use data analysis tools, make data-driven decisions to improve business performance, and learn to create data visualizations. No prerequisites or previous experience required to sign up!
Lesson: What is a Data Analyst, how do they use data, and what does a day in the life of a Data Analyst look like?
Task: Reflection on current skills and skills to develop to be a Data Analyst.
Lesson: What tools to Data Analysts use? How do each of these help Data Analysts?
Task: 1) Quiz on which tool is most useful for each task. 2) Get excel and tableau
Lesson: How to ask questions and framing the problem.
Task: Case study given to students with a business problem. Frame the problem and determine which data to collect
Lesson: Data comes from multiple sources. How to aggregate data
Task: Gather data from different sources and extract to Excel
Lesson: Importance of cleaning data, removing unnecessary data, and common techniques
Task: Normalise and standardise the data compiled on excel.
Lesson: Pivot Tables and Chart usage in Excel, how to create
Task: Create a Pivot Table and Chart for your case study
Lesson: Using Tableau to create dashboards and visualise data
Task: Connect excel to Tableau, and build a dashboard for your case study.
Lesson: Identifying your narrative and creating a story that is easy to follow with your data
Task: Create a report with your visualisations from Excel and Tableau to tell a story with your data.
Lesson: Using Narrative, Data and Visuals to tell a good data story
Task: Create a data story for your report and submit.
Lesson: Finding a dataset that interests you and framing the problem when it is not clearly defined.
Task: Selecting a data set of your choice and apply skills learned through the experience.