Become a Data Analytics
Expert with Earn and Excel
- Intensive 20-week program with flexible study options
- Gain practical experience with real analyst projects
- Internship offered to boost your career prospects
The Analyst Program
Are you ready to take your data analytics skills to the next level? Our program offers a comprehensive curriculum designed to equip you with the tools and knowledge necessary to succeed as an analyst. With a focus on real-world experience and hands-on learning, you will gain practical skills that will set you apart in the competitive job market.
Data analytics
program details section
Excel
Beginner to Intermediate- Intro to Excel, Saving and
- File Types
- Moving and selecting without the mouse
- Deleting and Inserting
- Formula Basics
- Charts – Bar Chart
- Text Analysis
- Data Validation
- A Masterclass on utilising the VLOOKUP to find information
- Why the long boring list is crucial to your analytical success
- Creating a Dashboard with Lookup techniques
- Building business logic with IF, AND & OR
- Analysis techniques to deal with Text based data
- Combining lookup, logic and text to build a powerful model
- The XLOOKUP is superior to VLOOKUP but…
- The most important Dynamic Array functions explained in depth
- COUNTIF and UNIQUE are a brilliant combination
- SUMIF and COUNTIF to summarise for Senior managers
- Summarising with Dynamic Pie Charts
- Using Combination charts to generate Analytical discussion
- Dynamic Multiple Criteria Pie Charts
- A thorough breakdown of Pivot Tables – beginner to advanced
- Power Query the most improtant ways to wrangle data
- The road to becoming a trusted advisor with your outputs
- The Two Types of Visual Analysis
- Introduction to the Supply Chain Dashboard
- Utilisng Dials for comaprative excellence
- Cluster Bar Comparison techniques
- Resource Analysis with Dynamic Charting
- Dashboard Design Principles and considerations
- Building a Project Management Dashboards that truly helps deliver
- Why,when and how to automate for enhancing your career
- A complete primer on getting started with VBA
- Building Logic with the IF statement and SELECT CASE
- The Five levels of looping on route to effective automation
- A complete workflow of gathering data via templates
- The importance of being able to control MS PowerPoint
- Programming in PowerPoint for significant time savings
- A complete workflow of gathering data via templates
- The importance of being able to control MS PowerPoint
- Programming in PowerPoint for significant time savings
Power BI
Power BI Fundamentals- Power BI in the Modern Data Analysis Stack
- Setting up PBI
- Power BI Dashboard Inspiration
- Power BI Table Visual _ Slicer
- Adding More Data, PQ Transformations _ Data Model
- More Power Query Transformations, Custom Columns and Data Modelling
- An Overview of Star Schema Data Modelling
- Line Chart, Treemap, Visual Classes
- Dashboard Build- Design _ Table
- Dashboard Build- Slicers _ Interactive Card
- Dashboard Build- Design, Grouping, Buttons, Finalise
- Practical DAX Intro- Measures, Calculated Columns
- DAX Time Intelligence- SAMEPERIODLASTYEAR _ Variance _ Conditional Formatting
- Conditionally Formatting Bar Chart Column Colour by Rules _ DAX
- Custom Visuals Deep Dive
- The Advanced Editor in Power Query
- Power Query Tips from the Real World
- Icons and Images to download for your Final Project
- Navigation Page Build
- Details Dashboard Page Build
- Navigation Page Build
- Final Challenge Brief
SQL
SQL Fundamentals- Downloading and setting up SQL server and SSMS
- Working with the SELECT statement
- Filtering with the WHERE Clause
- Conditional Logic with the Case Expression
- Creating Tables, Inserting & Updating Data
- SQL Joins Explanation with Venn Diagrams
- Building Tables with UNION ALL
- Value Window Functions- LAG _ LEAD
- Creating Tables Efficiently with SELECT INTO
- A Comprehensive Guide to Stored Procedures
- Enforcing Data Integrity with Constraints
- Coding Constraints in T-SQL
- Creating Grand Totals in Query Results
- Splitting Substrings into Rows with STRING_SPLIT
- Glue Two Row Sets Vertically with UNION ALL
- Thinking Like a Data Analyst
Python
Python Fundamentals- Install Anaconda to start using Python
- Understand how Notebooks work in coding
- Working with different data types
- Creating logic with IF, While an For
- Utilising Dictionaries to achieve more with ease
- Creating custom lists for convenience
- How to work with Libraries
- Getting more advanced by understanding Mathematical Arrays
- Utilising Slicing, Iterating, Join, Split, Search and Sort
- Get into the thick of Analytical work by using Pandas to crunch data with ease
- Working easily with incomplete data
- Working with Columns, Rows and joining Dataframes
- Start to visualize your Pandas data with Matplotlib
- Create the core visuals such as Line, scatter, Bar and Pie charts
Career Services
Career Coaching- Job Search Strategy that works
- CV/Resume/Linkedin Profile Reviews
- Interview Practice
Why become a data analyst
At Earn and Excel, we believe that learning should be fun, engaging, and rewarding. We offer a unique learning experience that combines practical skills, hands-on projects, and personalized support from industry experts. Our community of learners is diverse, supportive, and always eager to share their knowledge and insights. By choosing Earn and Excel, you are not just joining a program, you are joining a family of data enthusiasts who are passionate about making a difference in the world.
Why Earn and Excel is unique for aspiring Analysts
At Earn and Excel, we are focused on guiding individuals without any prior experience in data analytics towards a successful career transition in this field. We are aware of the unique challenges and concerns that professionals face when switching from a different industry and aim to offer tailored support and guidance throughout the program. Our flexible course structure accommodates the busy schedules of individuals, while our expert mentors and advisors provide personalized coaching to ensure you succeed in your journey. With our comprehensive training and job guarantee, you can confidently take the first step towards a new career in data analytics.
Student Success Stories
Inspiring change with real life outcomes. Hear our student stories
Admission Criteria
Earn and Excel is committed to helping individuals with a genuine interest in data and analytics to achieve their career goals. We believe that the best way to do this is by providing a comprehensive learning experience that includes both theoretical knowledge and practical application. To ensure that our students are fully equipped to take on the challenges of a career in data analytics, we have set some criteria that we believe are essential.
We are looking for individuals who have a strong interest in data and analytics. This means that you should have some prior knowledge or experience in this field, and a genuine curiosity about how data can be used to drive business decisions.
We understand that our students have busy lives, and that’s why we require a commitment of at least 10 hours a week to study. This ensures that you have enough time to fully engage with the course material and complete the projects.
We expect our students to be able to commit to a minimum of 1-2 hours a week of live tuition, where you will have the opportunity to interact with our experienced mentors and ask questions about the course material.
To ensure that you are able to apply the knowledge you learn in the course to real-world scenarios, we require regular submission of projects. This helps you to develop your skills in data analysis, visualization, and communication
Price and payment options
Take The Analyst Quiz!
Take our quiz to assess your skills and find out if our program is right for you and book a call with one of our super friendly course advisors to discuss your results and learn more about cohort dates, flexible payment plans, and scholarships.
FAQ
Yes our course is entirely online and you can access your lessons at any time of the day or night. Alongside your online self paced learning you will have access to a personal mentor and weekly live tutor sessions.
We provide you with 3 CPD certificates, which are globally recognised certificates
Our Analyst programme is a broad all encompassing programme to give you the access to the widest possible roles as an Analyst.
We aim to get you through the course in 12 weeks, but your job search will begin as early as week 5 once you have mastered the initial stage of the training.
Absolutely, with the number of vacancies exponentially rising, this is the hottest career ticket in town.
We provide a no obligation 14 day refund policy. After this period any refund will be issued on a pro rata basis. See our terms and conditions for more details.
We would like to be open and transparent when it comes to our Career Support. It is designed to be simple, easy to understand and most importantly to help you get your first role as an analyst.You’re eligible for the Career Support when:
- You’ve successfully completed 100% of your program as well attended all our career mentor sessions and interview preparation courses
- You’re applying to at least five relevant jobs a week.
- You live in a city area with a population above 200,000 people in any of the following countries: USA, Canada, EU, UK, Australia, or New Zealand (or you’re willing to relocate).
If you have any questions about career support or the eligibility criteria, simply get in touch with us and we can answer any questions you have.
