• FutureLearn logo

This course is part of the Data Analytics for Business ExpertTrack

New

Data Analytics for Business: Manipulating and Interpreting Your Data

Move beyond basic data analytics to manipulate your data using SQL and consider causal relationships.

Data Analytics for Business: Manipulating and Interpreting Your Data
  • Duration4 weeks
  • Weekly study4 hours
  • 100% onlineTry this course for free
  • Included in an ExpertTrackCourse 3 of 3
  • Get full ExpertTrack access$39/month

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.

Syllabus

  • Week 1

    An introduction to the course and using SQL

    • Introduction to the course

      In this activity we’ll introduce you to the course and look at how the course is structured. You’ll also be introduced to the case study used throughout the course.

    • Retrieving information

      In this activity you’ll learn about the general structure and syntax of SQL statements, common styles for writing SQL, and how to query a database and limit the output.

    • Weekly Wrap-up

      To complete the week, let’s recap the key points covered so far.

  • Week 2

    More advanced SQL skills

    • Introduction

      An overview of the week's topics and learning outcomes

    • Manipulating data with SQL

      In this activity we’ll see how to aggregate, group, and sort data. Then you’ll learn how to create subqueries.

    • Working with multiple tables

      Joins are probably the most important and most powerful database operator. They bring together information that’s stored in different tables. In this activity you’ll learn how to join multiple tables in SQLite.

    • Weekly Wrap-up

      To complete the week, let’s recap the key points covered so far.

  • Week 3

    Diagnostic analytics and relationships in data

    • Introduction

      An overview of the week's topics and learning outcomes

    • Diagnostic analytics

      While descriptive analytics focuses on identifying what has happened or is happening in the data, diagnostic analytics is the process of asking “why” and “what” about your data to determine the causes of certain outcomes.

    • Relationships in data

      While there are many different types of relationships in data, we will be learning about direct and indirect relationships in regard to correlation.

    • Weekly Wrap-up

      To complete the week, let’s recap the key points.

  • Week 4

    Communicating findings of data analysis

    • Introduction

      An overview of the week's topics and learning outcomes

    • Documenting your analysis

      In this topic, you'll learn about how documenting your analysis in a clear and understandable way helps not only your audience and anyone who may need to further develop your work, but also yourself.

    • Course Wrap-up

      To complete the week and the course, let’s recap the key points.

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

The social learning platform with hundreds of online courses from a quarter of the world’s top universities.

In collaboration with

logo

About this ExpertTrack

Build your business analytics skills and learn to manage, wrangle, and analyse data with Excel and SQLite.

Start learning today - free 7-day trial

After your free trial you can:

  • Pay $39 per month to keep learning online
  • Have complete control over your subscription; you can cancel any time
  • Work at your own pace and set your own deadlines at every stage
  • Only pay while you’re learning; the subscription will cancel automatically when you finish
  • Complete online assessments to test your knowledge and prove your skills
  • Earn digital course certificates and a final award that you can share online, with potential employers, and your professional network
  • Keep access to the content of courses you complete even after your subscription ends