Course Outline – Python for Data Analysis

Objectives
This is a one-day gentle introduction to Python. Delegates will finish the course with a broad understanding of Python; its history and philosophy, the basics of the language and how to use Python for data analysis.

Course Schedule
Session 1 – Introduction to Python
Python History and philosophy. What makes Python different from other languages, and why has it become so popular? Python packages and eco-system.

Session 2 – Getting Started
We’ll write our first very simply Python script. In doing so we’ll learn a lot about the Python environment and editing and running Python code.
Exercise: Write a “Hello Python” script.

Session 3 – Python Basics
We’ll learn the basics of the language; control flow, functions and a few popular data structures such as lists and dictionaries. We will look at a couple of essential packages, numpy and matplotlib
Exercise: Write Python scripts that will consolidate knowledge of these basics.

Session 4 – Python for Data Analysis
We will learn about the pandas package for data analysis and the seaborn package for visualisation.
Exercise: Write Python scripts to import a public dataset, clean, transform then visualise it.

Session 5 – Python and Power BI
Power BI is a very popular business analytics tool from Microsoft that now integrate well with Python.
Exercise: Use Python within Power BI to transform data and to produce a dashboard.

Practical Details and Joining Instructions
This is a practical course with many guided exercises – please bring your own laptop. We’ll send out joining instruction before the course how to install Python and Power BI Desktop (both free) on your laptop. If this is not possible, we can supply a remote desktop with all software installed – just let us know beforehand,
We will provide snacks and coffee at breaks and sandwiches at lunch.