Introduction to Data Analysis using Excel for Absolute Beginners
Want to learn data analysis but not sure where to start? This course is for you.
Duration
3 weeks
Weekly study
5 hours
Included in an ExpertTrack
Course 1 of 4
Get full ExpertTrack access
Find out more
Accreditation
More info
Data analysis skills are in high demand, but can be hard to grow if you don’t have a solid basis in maths or data literacy. This course has been designed for people of all ages to provide a solid introduction to data concepts and structures.
Start building your data literacy
You’ll start to build foundational knowledge of data, from simple data literacy through to analysing data and understanding the environments where data exists at work and in our lives in general. You’ll then move on to understanding what ‘telling stories with data’ actually means and how you can do it.
Begin a journey to a career in data or just understand the data landscape
You can use this course to get started on the path to becoming a data analyst, or you can use it to become more data literate so that you can understand how businesses use your data, why that may be a problem, and which aspects of your own data are important.
Gain an introduction to data analysis and foundation for further learning
Throughout the course, we’ll reference additional courses and learning paths you can take to continue on your data knowledge journey. Once you’ve completed this course, you will have the skills and confidence to continue learning and building on the core concepts explained within.
Week 1
Course Introduction
About this Course
This activity introduces you to the course outline, learning outcomes, as well as information on navigating the course on the FutureLearn platform and your CloudSwyft Hands-On Labs.
Our Data-Driven World
This activity will explore the increasingly important role of data analysis in modern life, society, and technology. You'll be taken through hands-on examples so that you can develop some experience and intuition on the topic.
Data Fluency
This activity will help you develop literacy and fluency in data analytics. There are a few review questions for you to complete so that you can consolidate this information.
Your First Data Walkthrough
In this activity, you'll dive into your first Hands-On data analytics task. You'll analyse a data set involving cars and identify factors linked with better gas mileage.
Unpacking the Walkthrough
This activity will unpack the data walkthrough you have just gone over. It will give in-depth explanations of an average, factors, scatterplots, and the correlation coefficient.
Wrapping up the Week
You've made it through your first week! Well Done! Let's recap what we've just covered and look at the content for Week 2.
Week 2
Data Structure, Analysis and Visualisation
Data Structures
In this activity, you'll familiarise yourself with where data comes from and where it goes to.
Data Anatomy
In this activity, we will review data anatomy and storage of a data set. You'll look at how data is categorised into different types, and how nearly anything can be thought of as data.
Data Joins
In this activity, we will learn how to combine multiple related data sets into a single table and look at four different methodologies for doing this, depending on the specific needs of a project.
Data Analysis Methods
In this activity, you'll gain some basic maths and statistical skills that will prove extremely useful in the field of data analysis.
Data Visualisation
In this activity, you'll explore various ways of visualising data with graphs, charts, dashboards, and more.
Wrapping up the Week
You've made it through your second week! Well Done! Let's recap what we've just covered and look at the content for Week 3.
Week 3
Data Analysis in Context
Data Analysis in Context
In this activity, you will examine the complex real-world ecosystems in which data shows up. Data doesn't exist in a vacuum!
Data Ethics
In this activity, you will examine the ethical and moral concerns of data analytics, this new frontier of the 21st century. How should you govern yourself responsibly in this growing field?
Career Paths
In this short activity, you will take a look at some of the jobs and career paths available to you as you grow your data analysis skillsets.
Wrapping Up the Course
This activity will wrap up the course. You will have the opportunity to complete your final assessment, as well as give feedback on the course.
More courses you might like
Learners who joined this course have also enjoyed these courses.
