DATA ANALYSIS & MODELLING COURSE
TUESDAYS & THURSDAYS
6:30 PM BST
13 AUG 2024 - 19 SEP 2024
DURATION:
6 WEEKS
TUESDAYS & THURSDAYS
6:30 PM BST
Set yourself up for success and lay your career foundations. Stand out from the crowd by learning the key day to day tools and skills you’ll need to excel as a Junior Data Analyst.
Stride ahead of the competition with Méabh Grogan, Lead Data Analyst, for a Data Analysis and Modelling course designed to cover topics from SQL and Python, to dashboarding and business acumen.
WHO THIS COURSE IS FOR
-
YOU ARE AN ASPIRING DATA ANALYST
Get ready to kick start your career by expanding your knowledge and equipping yourself with the specific tools you need. Deepen your interest in Data Analysis with lessons designed to guide you through the fundamentals of becoming a Data Analyst.
-
YOU ARE AN ANALYST WITH 1-2 YEARS EXPERIENCE
Learn how to optimise your current background and boost your skill set with new tools including SQL and Python. Stride out in a new direction as you pivot into data within your own company or as you enter a new role.
-
YOU WANT A 360 DEGREE UNDERSTANDING OF DATA ANALYSIS
Discover the multifaceted roles available to you as you’re guided through a 360 degree view of Data Analysis. Deep dive into specific tools, alongside getting familiar with business and ethical considerations. Gain the full suite of knowledge you need to start your career.
The global data analytics market is valued at over $300 billion
Map your career ascent or pivot into this vast, evolving industry by gaining the specific tools and knowledge you need to stand out. Understand the vital role of data analysis in today’s economic landscape and take a 360 degree approach to the fundamental skill set required.
Learn from an industry expert. Jump on board
Live, online lessons will be delivered alongside assignments, workshops and a final project. Get the opportunity to network with other data focussed professionals recognising the value of analysis and modelling.
Put new skills into practice. Complete 8 assignments designed to consolidate your learning and challenge your mindset. You’ll cover tasks such as solving SQL problems, manipulating data using Python, and designing and building dashboards.
Participate in 2 meticulously designed workshops to consolidate what you’ve learnt. Implement specific tools and skills, and measure your progress by taking part in quizzes and problem solving tasks. Grasp an understanding of how you will use the hard, soft and career skills you gain within a future role or workplace.
Every student will take part in a final project covering each key topic from your data journey. Designed to form the last lesson of the course, this project will draw together your knowledge and evaluate your understanding. Expect to work on all fundamentals; from speaking with stakeholders to dashboard design and data manipulation.
- Lead Data Analyst
- Works as a Data Analyst at one of the UK’s top 5 fintech companies
- Has a BSc in Computer Science & Software Engineering from Maynooth University
- Worked as a Technology Consultant at Accenture for 2.5 years
- Is a big fan of DIY fancy dress
- Pronounces her name “May-ve”. (“Méabh” is one of the least confusing variations of the spelling!)
Let’s get introduced to your instructor - Méabh Grogan, Lead Data Analyst at one of the UK’s top 5 fintech companies.
- Course structure
- Assignment structure & due dates
- Housekeeping
Get set up with the foundational knowledge you need to start off strong! Explore how, when and why data analysts work within a company and the core skills you’ll need to excel in your role.
- Role of the data analyst & example tasks
- Core skills required from data analysts including SQL, critical thinking & stakeholder management
- Fundamentals of data analysis
- Tool setup and assistance
Deep drive into relational databases and the foundational knowledge you’ll need to learn and implement SQL. Learn key terminology and explore the relationships between tables in RDMS.
- Terminology and data types
- Structure of tables in relational DB
- Primary vs Foreign keys
- Types of joins
- Normalisation
Assignment #1: Quiz
Learn to communicate in a whole new way with SQL. Grasp the basics and get hands-on experience practising simple queries with sample datasets.
- What is SQL?
- What is SQL used for?
- Basics
- Aggregations
- DML vs DDL
Continue your exploration of the key functions of SQL. Learn to join data from different datasets, get hands-on experience of more intermediate level SQL, and get familiar with formatting best practices.
- Joins
- Union
- Handling NULLS caused by joins
- Timestamp handling
- Subqueries & CTEs
- Formatting best practices
Assignment #2: Solving basic SQL problems
Rise up to the next level as you continue the conversation with SQL. Learn more advanced functions, understand how to optimise queries for large datasets - and learn to write efficient and elegant SQL, every time.
- Logical operators
- Window functions
- Optimisation of large data sets
- Common Table Expressions
- Common mistakes
Assignment #3: Solving more complex SQL problems
Test, test, test. Get to grips with the importance of testing your results and practice problem solving skills. Understand how to develop a process for root cause analysis and learn key techniques for testing and sanity checking data.
- Testing Queries
- Explore trends in data
- Workshop: Performing RCA analyses in groups, before working through the analyses in class.
Assignment #4: Debug given SQL queries
Use Python to manipulate and visualise data from multiple sources. Get creative by using the appropriate visualisations to display results, and start to dive deeper into trend root causes.
- Common libraries
- Manipulation using dataframes
- Visualisation using Python
Assignment #5: SQL and Python Use
Navigate a new path as you start to explore statistics. Grasp the fundamentals of the common statistical methods that are used in data analysis.
- Understanding descriptive statistics
- Sampling & inferential statistics
- Hypothesis testing
Soften things up and take a 360 look at the role of a data analyst. Explore the career skills you’ll need including stakeholder management, prioritisation and critical thinking.Get familiar with key and supporting metrics - and understand how to design for each.
- Understanding the role of the data analyst
- Key & supporting metrics design
- Critical thinking
- Stakeholder management
- Prioritisation
Assignment #6: Exercise in key & supporting metrics design.
When you’ve worked hard to get your data, you need to make sure you do it justice. Deep dive into dashboard design with an extensive overview of the most commonly used tools. Get confident about planning for the purpose of a dashboard, and appreciate the importance of knowing your audience.
- Dashboarding tools
- Planning a dashboard
- Dashboard design
- Selecting the appropriate visualisation
- How to speed up slow dashboards
Deepen your dashboard knowledge and get familiar with good dashboard design practices. Build storytelling and presentation skills with a focus on the role of readability, and the importance of aesthetics.
- Readability of dashboards
- Dashboard aesthetics
- Storytelling with dashboards
- Presentation
Assignment #7: Design and build a dashboard
Time to put your newly acquired skills to the test. Take part in tasks typical to those encountered in the real world by data analysts. Incorporate concepts and tools learnt throughout the course.
- Understand the problem
- Metric design
- Data discovery
- Data manipulation
- Dashboard design
- Dashboard build
- Deep Dive & RCA
- Dashboard Presentation Techniques
Assignment #8: Final Assignment
What our students say
MARKETING DIRECTOR
"It was such a great experience, well worth the course fee which I invested personally - I've learnt so much and feel much more confident in my role.."
"The course at ELVTR was a great investment in my career. The materials are top-notch, and the instructors provided excellent support."
"The knowledge. The teacher is very experienced. He is able to answer our questions in depth, and takes the time to do so."
"The course was very helpful in helping me expand my design toolkits by gaining a wealth of new knowledge and inside expertise to stay at the forefront in an age of rapidly developing technological and software advancements."
Fill in the form to start your ELVTR journey.
We will contact you to clarify all the details.