Move beyond basic data analytics and apply the working knowledge of SQL to query and transform a database.

333 enrolled on this course

Someone using a stylus on a tablet with charts on screen.
  • Duration

    4 weeks
  • Weekly study

    4 hours

Do you want to expand your career options?

The demand for data analysis skills is projected to grow at over four times the rate of the overall labour market. Expand your career options and earning potential by improving your knowledge and skills in this area.

This course builds on the previous two within this Data Analysis for Business ExpertTrack to round off your knowledge and prepare you to use these skills in a professional environment.

Filter and aggregate data with basic SQL queries

Expand your SQL knowledge to group and modify functions that appear within your database.

Understanding these queries will allow you to hone in on specific parts of your data set and carry out deeper interrogation of your business analytics.

Differentiate between correlation and causation

It’s impossible to deduce a causal relationship between two variables purely based on the association.

On this course, you’ll learn the difference between correlation and causation, and the potential pitfalls in making assumptions in this area. You will then explore ways to draw firmer conclusions from your data.

Calculate correlation using Pearson’s coefficient

You’ll explore techniques to measure relationships between items within your datasets, including Pearson’s coefficient which measures linear correlation between two data variables.

What topics will you cover?

  • Introduction to using SQL
  • More advanced SQL skills
  • Diagnostic analytics and relationships in data
  • Communicating findings of data analysis

Learning on this course

On every step of the course you can meet other learners, share your ideas and join in with active discussions in the comments.

What will you achieve?

By the end of the course, you‘ll be able to...

  • Identify the correct syntax for basics SQL queries (filter, aggregate)
  • Identify the correct join type to use
  • Calculate correlation using Pearson's coefficient
  • Differentiate between correlation and causation

Who is the course for?

This course is for professionals who require data analytics skills in the workplace including:

  • Early-stage or aspiring data or business analysts looking to boost their qualitative and quantitative data analysis skills.
  • Business professionals working in a role that requires data analytics skills.
  • Business or arts graduates looking to start their first professional role by adding required quantitative skills such as data analysis.

What software or tools do you need?

During the course we’ll be using DB Browser for SQLite and Excel. If you don’t have Excel, you might find this online version useful.

We recommend you use a computer to access this course.

Who will you learn with?

As a certified Data Analyst and holder of a Chartered Global Management Accountant designation I provide a unique set of skills in the fields of data, analytics, finance, and accounting.

Who developed the course?

FutureLearn

FutureLearn is a leading social learning platform and has been providing high quality online courses for learners around the world over the last ten years.

In collaboration with

logo

Endorsers and supporters

endorsed by

Coventry University logo

Learning on FutureLearn

Your learning, your rules

  • Courses are split into weeks, activities, and steps to help you keep track of your learning
  • Learn through a mix of bite-sized videos, long- and short-form articles, audio, and practical activities
  • Stay motivated by using the Progress page to keep track of your step completion and assessment scores

Join a global classroom

  • Experience the power of social learning, and get inspired by an international network of learners
  • Share ideas with your peers and course educators on every step of the course
  • Join the conversation by reading, @ing, liking, bookmarking, and replying to comments from others

Map your progress

  • As you work through the course, use notifications and the Progress page to guide your learning
  • Whenever you’re ready, mark each step as complete, you’re in control
  • Complete 90% of course steps and all of the assessments to earn your certificate

Want to know more about learning on FutureLearn? Using FutureLearn

Learner reviews

Learner reviews cannot be loaded due to your cookie settings. Please and refresh the page to view this content.

Get a taste of this course

Find out what this course is like by previewing some of the course steps before you join: