• FutureLearn logo

This course is part of the Data Analytics for Business ExpertTrack

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% onlineLearn at your own paceHow it works
  • Included in an ExpertTrackCourse 2 of 3
  • Get full ExpertTrack access$39/monthFind out more

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.

Prove you're job ready

Highlight the new, job-relevant skills you’ve gained and supplement existing qualifications with a hard-earned, industry-specific digital certificate – plus one for every course within your ExpertTrack.

  • Learn the latest in your chosen industry or subject.
  • Complete each course and pass assessments.
  • Receive certificates validated by the educating organisation.
  • Create a shareable certificate link for your CV and LinkedIn.
  • Impress employers with learning outcomes you can add to your CV.
  • Make your career dreams a reality.

Download a PDF

Share your certificate

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

FutureLearn is jointly owned by The Open University and The SEEK Group and has been providing online courses for learners around the world over the last eight years.

In collaboration with

logo

Endorsed by

endorsed by

Coventry University logo

About this ExpertTrack

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

Learning on FutureLearn

Your learning, your rules

  • Courses are split into weeks, activities, and steps, but you can complete them as quickly or slowly as you like
  • 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

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

Do you know someone who'd love this course? Tell them about it...