• FutureLearn logo

This course is part of the Data Analytics for Business ExpertTrack

New

Data Analytics for Business: Creating Databases

Grow your understanding of business analytics by building your first database.

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

This second course in Data Analysis for Business ExpertTrack builds on the basics and teaches you how to tidy your data and build databases to enhance your business analytics.

Apply critical thinking skills to data and learn how to use Excel and SQLite to tidy, organise, and manipulate data sets.

Perform data analysis in Excel

You will use Excel to perform data analysis, learning frequently used functions and formulas to crunch and combine data.

This course will transform your basic knowledge into powerful methods of analysis, techniques, and tools.

Tidy your data for better outcomes

Tidying data refers to tying the structure of your data set back to its meaning, which includes matching up rows, columns, and tables with your observations, variables, and types.

Tidy data tells a clearer story and allows you to draw comparisons and apply formulas or visualisations more easily.

Create your first database with help from SQLite

Articulate how to create a database and understand how function impacts form as part of the process.

The formatting and organisation of a database has an impact on how easily the data can be used. You will use SQLite to import tables and adjust them for your needs.

Syllabus

  • Week 1

    Introduction to course and exploratory data analysis

    • 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.

    • Data wrangling

      In this topic we’ll focus on the first three stages of the analytics process: importing, tidying and transforming data. Collectively these steps are known as ‘data wrangling’.

    • Weekly Wrap-up

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

  • Week 2

    Introduction to exploratory visualisations

    • Introduction

      Overview of learning outcomes for the week

    • Exploratory visualisations

      Visualising data helps you to identify patterns and trends. In this activity you’ll look at the types of charts we use to visualise data in an exploratory analysis.

    • Weekly Wrap-up

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

  • Week 3

    Introduction to databases

    • Introduction

      Introduction to the week's topics and outcomes

    • Designing databases

      Being able to work with databases and SQL are fundamental skills for a data analyst. Databases offer a quick, convenient way to store and manage large amounts of data, and SQL a clear, concise syntax to access, clean, and analyse.

    • Weekly Wrap-up

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

  • Week 4

    Introduction to SQL

    • Introduction

      Introduction to the week's topics and outcomes

    • Using SQL

      In this topic you’ll learn about structured query language (SQL), which is a popular language for working with databases. You’ll learn how to set up an SQLite database and the basic commands for inserting and selecting data.

    • Course Wrap-up

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

What will you achieve?

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

  • Articulate how to perform basic analysis in Excel
  • Outline the steps involved in tidying data
  • Identify the correct ERD for a dataset
  • Articulate how to create a database and import tables using SQLite

Who is the course for?

This course is for anybody who needs data analytics skills at work, or would like to progress to a job where they’re desirable or necessary.

This may include early stage or aspiring analysts who would like to improve their qualitative or quantitative skills, or a business professional in a role that requires data analytics. You may also be a business or arts graduate who would like to move into a professional role and stand out from the competition by adding 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