Become a Data Analytics
Expert with InsightMakers
· 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.
Master In-Demand Skills for the Modern Workforce
Skills Set: Our program will train you to develop an all-encompassing skills set that includes Excel, Power BI, SQL, and Python. This is the essential quartet of data analytics skills that will prepare you add value to the companies you work for and will provide you with the capability you need to open doors to a successful career in Data.
Accelerate Your Learning with an Intensive
20-Week Program
Timeline: With an intensive 20-week program, you will be immersed in the world of data analytics and learn at a rapid pace. This program is designed to provide you with the necessary knowledge and skills in a shorter amount of time so that you can begin your career as soon as possible *Please note it is possible to complete the training in a shorter timeframe (10 Weeks is possible) if you can dedicate more time to it.
Pivot Your Career and Become a Data Analyst
Career Switch: If you are looking to switch careers, our program is perfect for you. With our hands-on approach, you willl gain real-world experience through working on actual Data Analysis projects and gain an internship. This experience will give you the confidence to enter the job market and start your new career with ease.
Data analytics
program details section
- 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 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
- 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
- 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
- Job Search Strategy that works
- CV/Resume/Linkedin Profile Reviews
- Interview Practice
Why become a data analyst
Future-proof career
AI-proof career
Recession-proof industry
High earning potential:
Why Choose Insight makers
At Insight Makers, webelieve 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 Insight Makers, 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 Insight Makers is
unique for aspiring Analysts
At Insight Makers, 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
Insight Makers 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
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor
incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam.
Analyst course
Claim 210$ discount when you pay upfront for course, one time payment.
-
Complete 12 week Analyst Course
-
Excel, SQL, Power BI
-
3 CPD certificates
-
Course Project build your portfolio
Analyst course
Initial payment of $1500 followed by 3 payments of $699 every 4 weeks
-
Complete 12 week Analyst Course
-
Excel, SQL, Power BI
-
3 CPD certificates
-
Course Project build your portfolio
Latest analytics tools training
Comprehensive project portfolio
Internship for hands-on experience
Real-world project experience
Job guarantee (terms apply)
Affordable tuition fees
Experienced mentorship and support
Flexible schedule
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
