Data Analysis Intensive

Apply for our Data Analysis Intensive course now

SQL, Python and Tableau – the key technologies taught on our 3 week Data Analysis course

3 week evening course @ Monument, London, Monday to Friday (15 sessions), 6:30pm to 8:30pm

4th March 2019 – £745 + VAT (NOW FULL)

22nd April 2019 – £745 + VAT

By the end of this course:

You will design Tableau dashboards, moving from start to finish through the Data Analysis pipeline.

Select, create and update data stored in a database with SQL. Learn the core libraries of Python including Pandas for analysing data in various formats. Prepare beautiful visualisations in Tableau.

All of which add value to your employer. 

Example Tableau dashboards produced in the class, looking at 1) a UK bank’s client distribution, 2) profit margins amongst competing Australian companies.

Our Teaching:

We firmly believe in classroom-based study versus online learning, because it ensures your teacher is always on-hand to help you with the challenges you encounter.

We also teach through projects of your choice, allowing you to choose the direction of your learning at a pace that suits you.

Our Teachers:

Our teachers are Data Analysts and Data Scientists who exhibit a real passion for this field.

They come with years of commercial and academic teaching experience –

Meet Stefan Marwah

Stefan is a Step Function Data Analysis teacher who works in London’s finance sector as a Quantitative Analyst. Stefan has used Python for 6 years and has taught both the Step Function Data Analysis course and Introduction to Python course on several occasions.

 

 

Stefan’s extensive knowledge of Python, SQL and Tableau ensures strong outcomes for our students.

Student Review:

 

“I had a very positive experience as a student of Step Function’s Data Analytics Intensive course. I wanted a career changed so I joined the course to learn the needed skills to transition into a new career. It was challenging but was taught by a very knowledgeable instructor who went through every step in detail. I did learn a lot at SF and left with the skills needed to teach myself new programming languages. This is an incredibly useful skill-set to have. Stefan was a fantastic instructor and very invested in the success of the class. He was very informative and supportive.”

 

FAWAZ POPOOLA (NHS) – August 2018 Course

 

“I wanted to drop you a note to tell you how pleased I was with the content and the teaching. Both Stefan and the curriculum were fantastic. Thank you!”

 

YOANA MATEEVA – (TRACTABLE – AI for accident recovery) – January 2019 Course

Data Analysis Intensive Course Syllabus

WEEK 1 - Data Analysis Fundamentals with Python

Introduction

  • From database to knowledge: the data analysis pipeline
  • Future-proofing your data: the three “normal forms” of database design
  • Setting up your environment
  • Procedural vs. declarative programming: Python vs. SQL

 

Python

  • Fundamental structures and types
  • Logic and Control flow
  • Structuring your code
  • Functions
  • Core libraries
WEEK 2 - Pandas and NumPy, SQL

Python

  • Python for Data Analysis
  • Pandas
  • NumPy

 

SQL

  • Introduction to SQL: selecting, creating and updating data
  • Tables vs. views
  • Joining tables
WEEK 3 - SQL and Tableau

SQL

  • Handling the messy reality of real-world data
  • Complex join expressions
  • Aggregation
  • Subqueries

 

Tableau

  • Getting data into Tableau
  • SQL concepts in Tableau
  • Preparing your data for visualisation
  • Powerful story-telling with data: reader-oriented data visualisation

Please note that the details of this Introduction to Python Course syllabus are accurate at the time of printing. There may be some variation in the final syllabus that is taught.

Step Function, October 2018

Apply for our Data Analysis Intensive course now

Newsletter sign up

Interested in a lucrative and fulfilling career in python and data analytics?

Sign up for FREE career and training info.

Sign up