Certificate in Data Analysis with Python

It follows a UK pet supplies retailer from messy order exports to answers its managers can act on. You start with a quick first answer, then sharpen the Python and Git that data work leans on before moving into pandas: selecting and filtering, loading from files, databases and APIs, cleaning, grouping and reshaping, and joining. Later modules cover dates and cohorts, charts and maps, explaining what changed and why, and turning a notebook into a report that reruns itself. A capstone on UK open data closes it.

Yes, the basics: variables, loops, lists, dictionaries and functions. If those are new to you, take Python Programming first and come back. The course opens with a refresher on the Python data work leans on, not a full introduction.

Just what the analysis needs. You'll write enough SQL to pull data from a database, and get a short primer on the statistics behind reading an A/B test. For SQL properly, take our SQL course, and for statistics from first principles, Data Science Fundamentals.

No. Python, VS Code, pandas and every other library in the course are free and open source, and the only accounts you need are free ones, such as GitHub.

Both. Excel for quick work and sharing with colleagues, Python when data gets large or messy, or when a report has to rerun every month. Python doesn't replace the spreadsheet; it takes the jobs the spreadsheet struggles with.

You don't need data from work. The lessons are built around a fictional pet retailer, and the capstone runs on free UK open data from sources such as the Food Standards Agency and the NHS Business Services Authority. Keep personal and company data out of practice work, especially anything you'd push to GitHub.

Yes, if you're allowed to install software on it. You need a Windows, Mac or Linux computer for Python, VS Code and Git, and a Chromebook won't run the scripting and testing lessons.

Yes. Pass the final assessment and you get an OBA certificate of completion that an employer can verify online. It isn't a vendor or professional qualification. The analysis you publish along the way is the other half of the proof.

Download the free info pack first. It walks you through every module, what you'll build and what you need before you start, so you can enrol knowing exactly what you're getting. If you'd like to talk it through, get in touch and we'll help you choose.