Data Analyst Career Accelerator Program
Unlock Your Potential: Become a Highly Sought-After Data Analyst
Accelerate your path to a successful career in data analytics with our 12-week instructor-led program. This structured training provides a comprehensive approach to mastering essential tools and techniques, fast-tracking your journey to a high-growth career in data analytics.
Why Choose Our Training Program?
- Hands-On Learning: Engage in practical, real-world projects that ensure you can apply your skills immediately.
- Expert Instructors: Learn from industry experts with years of experience in data and analytics.
- Comprehensive Curriculum: Our program covers everything you need to succeed, from basics to advanced techniques.
- Capstone Project: Showcase your new skills by completing real-world data analysis projects and receive personalized feedback from industry partners.
- Convenient Timing: Training hours will not interfere with your work schedule.
- After Training Support: Get support from industry experts and career coaches.
Program Schedule
Start Date: September 1st, 2024
Course Duration: 12 Weeks
Sat & Sun 8pm – 10pm (BST)
Bonus Benefits
- Tool competency reference on resume
- Build an Impressive and Eye-Catching Portfolio on GitHub
- Resume Review
- LinkedIn Review
- One Free Interview Prep
- Microsoft Power BI Certification Prep
- Resources for Continuous Learning
- Free Membership to Join a Vibrant Data Community
- Free Mentorship (3 months)
Who Should Attend?
This program is for anyone who wants to:
- Accelerate their career as a data analyst.
- Professionals seeking to advance their careers.
- Switch to a data analyst role, from a related or unrelated field.
- Business Leaders aiming to make data-driven decisions.
- Increase your employability: Acquire the skills employers are asking for
- Experience a structured and supportive approach to learning data analytics, beginning with the basics and progressing to advanced topics.
Course Curriculum
Discover Data Analytics for Business
-
Overview of data analysis
-
Roles in data
-
Responsibilities of a data analyst
-
Relevant skills, tools, and techniques for data analysis
-
Becoming a high performing Data Analyst
Data Analysis using Microsoft Excel
-
Data Analytics Using Microsoft Excel
-
Data Analysis Using Microsoft Excel
-
Intoduction to Microsoft Excel
-
Data Cleaning
-
Data Transformation
-
Data Compilation
-
Dashboard Creation and Data Visualization
SQL for Data Analysis
-
SQL For Data Analytics
-
Introduction to SQL
-
Restore, Backup, Filterng, Sorting, Ordering
-
Alias, Aggregate, Group By, Case Statement
-
Joins And Union
-
Subqueries, Views, Ctes, Index, String & Mathematical Functions
-
Date Time Functions, Pattern (String) Matching
-
Window Functions
-
Coalesce Function, User Access Control
Mastering Data Storytelling
-
Introduction To Data Storytelling
-
How To Create A Compelling Data Story
Data Visualization with Power BI
-
Prepare Data For Analysis
-
Data Import & Transformation
-
Data Modelling and Dax
-
Data Visualization
00:00 -
Power BI Service
-
Advanced Visualization
00:00
Resume and LinkedIn Review
-
Introduction to Resume and LinkedIn Optimization
-
Crafting an Effective Resume
-
Optimizing Your LinkedIn Profile
-
Customizing Applications for Job Roles
-
Practical Workshops and Real-world Examples
-
Additional Tools and Resources
Capstone Project: Solve Data Problems with Real-world Business Projects
Building a Project Portfolio
-
Introduction to GitHub
-
Setting Up Your GitHub Profile
-
Understanding Repositories
-
Documenting Your Projects
-
Adding and Managing Projects
-
Showcasing Projects with GitHub Pages
-
Keeping Your Portfolio Updated
-
Case Studies and Examples