Data Analysis Intensive
Join our Data Analysis Intensive course now
Sign up and secure your place today
2 COURSE FORMATS:
3 Week Evening Course @ Monument, London, Monday to Friday (15 sessions), 6:30pm to 8:30pm
2nd September 2019 – £795 + VAT
21st October 2019 – £795 + VAT
3 Week Remote Course, via Live Video Feed. Monday to Friday (15 sessions), 6:30pm to 8:30pm
2nd September 2019 – £500 + VAT
21st October 2019 – £500 + 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, August 2019