Do you want to expand your data analytics skills and streamline your analysis processes? Having a solid understanding of Python can help to boost your career and make data analysis and manipulation considerably more efficient.

This course builds on the previous two within this Data Analytics Using Python ExpertTrack to give you a better understanding of the possibilities of using Python.

Deepen your understanding of Python functions

On this course, you’ll familiarise yourself with the data wrangling, manipulation and exploration steps of the CRISP-DM methodology, and perform data ingestion using Python.

You’ll learn how to demonstrate transformation activities in Python to further your data analysis.

You’ll also explore SQL in relation to data analytics, including the fundamentals of databases using SQL to perform various data analysis operations.

By the end of this course, you’ll be better equipped to create database tables using the data definition language and add data records using data manipulation language.

You’ll have also practised how to query the data stored in those database tables, and demonstrate various data processing activities using data query language and data manipulation language.

What topics will you cover?

Data wrangling using Python
Designing databases
Introduction to SQL

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.
Impress employers with learning outcomes you can add to your CV.
Make your career dreams a reality.

Download a PDF

Learning on this course

You can take this self-guided course and learn at your own pace. 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...

Demonstrate data wrangling, manipulation and transformation activities in Python
Create database tables using the data definition language and add data records using data manipulation language
Query the data stored in those database tables
Demonstrate various data processing activities using data query language and data manipulation language

Who is the course for?

This course is suitable for:

business analysis or junior data analysts looking to develop advanced data analytics skills and programming capabilities to progress their careers in data analytics
someone with existing programming capabilities looking to enter the data analytics field
an individual lacking the programming capabilities to conduct more advanced data analysis and modelling

What software or tools do you need?

During the ExpertTrack we’ll be using Jupyter notebook. We recommend you use a computer to access these elements.

Who will you learn with?

Ed Marks

I truly believe that leveraging the correct technologies in the appropriate way can take us towards a more sustainable economy. My focus is on converging M&E Engineering with Data Science/Analysis.

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

Endorsed by

endorsed by

About this ExpertTrack

Develop the fundamental Python programming knowledge and skills required to complete advanced analytics.

Find out more

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

Start your free 7-day trial

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