• An introduction to Python starting from initial setup and explaining foundational concepts like data types, variables, mathematical operators, flow control, and functions
• Using Python for data analysis including how to load data from different sources, drill down and segment, create pivot table style aggregations and explore data visualisation libraries.
• Automating Excel workflows using Python to write macros that can be run at the click of a button using the full power of the Python eco-system; and to create template reports that update live with the latest data.
• How to better interrogate a model, and partner with data scientists and others in an organisation to drive adoption and use of Machine Learning
• Understand the basic workings of a machine learning model and its relationship to data science, Big Data and Artificial Intelligence.
• Apply to real-world machine learning examples to meet practical objectives such as evaluating and improving the model, and error detection/correction.

Module 1 – Introduction to Python

In this module, the fundamental principles of coding are introduced using the Python programming language. From taking your first steps in coding to understanding data types to control flows, this module provides the essential elements needed for coding in Python.

Topics covered: ****

● Introduction to the Python programming language

● Using the Jupyter Notebook environment to run Python code

● Data types: strings, integers and floats; how information is created in Python

● Variables and containers: how information is stored in Python

● Mathematical operators and calculation in Python

● Control flows, logic and writing functions: how to automate processes using code.

Module 2 – Python for Data Analysis ****

Learn the basics of using Python for working with data. This module introduces pandas, a Python library that is widely used for powerful yet easy data manipulation. Learn to load data from different sources, drill down and segment, create pivot table style aggregations and explore various data visualisation libraries.

Topics covered: ****

● Introduction to working with third-party Python packages

● Working efficiently with large datasets using NumPy for numerical analysis

● Using pandas to read in, manipulate and analyse data

● Data visualisation using matplotlib and Seaborn

● Merging datasets and techniques for handling missing data.

Module 3 – Automating Excel using Python ****

Automation helps businesses to make regular reporting more efficient. In this module you will learn to automate commonly repeated Excel workflows using the xlwings Python library. Learn how to control Excel from Python and create template reports that update live with the latest data.

Topics covered :

● Introduction to xlwings: a Python library for interacting with live Excel spreadsheets

● Using pandas and xlwings to automate the generation of Excel-based business intelligence reporting

● Learn to automate Excel and give your Excel-based workflows access to the full power of the Python data scientific ecosystem of tools

Module 4 *– * Machine learning with Python

Introductory hands-on module covering the essentials of implementing a real-world machine learning project. Understand the basics of ML theory and its relationship to data science, Big Data and Artificial Intelligence.

Topics covered:

• Build a classifier algorithm for RFM modelling
• Build a machine learning system for category classification using decision trees, random forests and natural language processing
• Learn how to evaluate and tune machine learning algorithms, and how to prevent overfitting using cross-validation.