• FutureLearn logo

This course is part of the Data Analytics for Business ExpertTrack

New

Data Analytics for Business: Basic Analysis and Statistics

Gain an introduction to basic data analysis functions and statistical models to deliver insights for your business.

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

Do you want to build the most in-demand skills for today’s job market?

Data analysis has become an essential business skill in recent years. Learn the basics, expand your knowledge of Excel, and learn how to tell stories with data in this self-paced course.

You don’t need any prior knowledge to benefit from this course - just a desire to clarify and act on your organisation’s data.

Discover the benefits of data analysis

Data analytics is one of the most in-demand professions of the decade and forecasters expect the sector to grow even further.

This course will help you identify the benefits of data analysis, both to your organisation and your career. You’ll develop the skills, knowledge, and confidence to gain a competitive edge at your current job or in the job market.

Use Excel to achieve your objectives

It’s likely you already have one of the most powerful data analysis tools on your computer, and it’s also likely that you don’t use it to its full potential.

This course will help you identify the right Excel formula to achieve your objectives in importing, cleaning, analysing, and manipulating data sets.

Explore data analytics fundamentals and basic statistics

Data analysis employs a lot of statistics skills – even machine learning is often underpinned by fundamental statistical principles. This course will put you on firm mathematical grounding so that you can build your data analysis skills on a strong foundation.

Upon completion of this course, you’ll have a sound set of skills in basic data analytics, Excel, and statistics, and will be ready to move onto tidying data and creating databases.

Syllabus

  • Week 1

    Introduction to the course and data analytics

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

    • Introduction to data analytics

      In this activity you’ll explore the fundamentals of data and big data, learn about common data sources and discover different types of analytics available to an organisation.

    • Weekly Wrap-up

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

  • Week 2

    Processes and tools for data-driven decision-making

    • Introduction

      Introduction to the week's topics and outcomes

    • Data-driven decision-making

      Data-driven decision-making is the habit and process of making business decisions by analysing data. In this activity, we’ll look at what it means for an organisation to be data-driven, and how data can inform decisions.

    • Data analytics projects

      Analytics projects use a range of tools to get from a business problem to a data-driven solution. In this activity we’ll look at the steps in an analytics project and the tools for each stage.

    • Weekly Wrap-up

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

  • Week 3

    Introduction to fundamental statistics

    • Introduction

      Introduction to the week's topics and outcomes

    • Fundamental statistics 1

      In this activity you'll learn how to calculate the main components of descriptive statistics: measures of centre and measures of spread. We’ll also run through some mathematical notation you might encounter on analytics projects.

    • Weekly Wrap-up

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

  • Week 4

    Application of fundamental statistical techniques

    • Introduction

      Overview of the week's topics and learning outcomes

    • Fundamental statistics 2

      Now you know how to calculate measures of centre and measures of spread, let’s look at how we can visualise the data and interpret these measures to understand the ‘shape’ of it.

    • Spreadsheets for statistics

      In this topic we’ll cover the basic skills of using spreadsheets so you can comfortably navigate these applications and apply basic functions for data analysis.

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

  • Identify the benefits of data analysis
  • Articulate data analytics fundamentals including basics of statistics
  • Identify the correct Excel formula syntax to achieve an objective

Who is the course for?

This course is for professionals who require data analytics skills at work, and learners who are interested in moving to a data analytics career.

These may include:

  • Early-stage or aspiring data or business analyst looking to boost their qualitative and quantitative data analysis skills.
  • Business professional working in a role that requires data analytics skills.
  • Business or arts graduate 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