Data analytics course
Learn Excel, Python and SQL and how to analyse data using Power BI tools. Get Level 3 Diploma in Data Analytics and work with hypotheses and make predictions based on data to help businesses make decisions
Study face-to-face online
Top rated by Google users
by Victoria Hills
+ free bonus course
How to boost your career

Training duration

per week
50+ hours of course materials

You study at a technical university

The course will be suitable if:

You are a CEO or a business owner
You are a business analyst
You are a developer who wants to switch careers
Learn how to conduct analytical research, collect data and generate visual reports. Get a new career in demand remotely and start to work as a Junior Data analyst.
Take a fresh look at your business and explore your product's strengths and weaknesses. Learn how to make predictions for your business, develop your product and solve current issues based on analytics data.
Gain an understanding of how to apply your knowledge of programming to solve business needs. Learn the tools for analysis, data modelling and presentation for the client - and you'll become a more marketable specialist.
You will improve your knowledge of analytics, and learn the basics of Python programming. You will be able to work with the databases and Power BI, creating impactful presentations. Expand your competencies and become better at handling current tasks.
1. Work with analytics services and make detailed analytical reports
Study how to use data visualisation tools, Google Spreadsheets and Excel - and generate reports for clients. Learn to work with Google Analytics and collect data in a single window for quick access to the report.
You will learn to
2. Conduct research and make accurate conclusions
Study the mathematical basis of analysis, learn how to work with data sets and find patterns in numbers. Learn what performance metrics a business uses. Understand how to collect them and build hypotheses and assess business decision perspectives.
4. Use programming in analytics
Master the basics of Python programming to solve basic business problems. Learn how to build and manage SQL databases.
3. Work with analytics customers
Learn how to handle different types of analytical queries from businesses and present the results of your work in a convincing and understandable way to your colleagues. Use professional tools like Power BI, Tableau and web analytics.

Course programme


Participate in virtual classes or watch the recorded sessions
Ask questions and chat with a live expert
Study materials
Your lecturer will answer your questions personally
We provide our learners with resources and recorded lessons. Keep them to refresh your knowledge whenever you need to.
100% interactive course

Introduction to statistics

content and tools
You will learn
⦁ Statistical methods

⦁ Practical relevance

⦁ Criteria

⦁ Confidence interval

1. Formation of populations and samples
2. Application of statistical methods
3. Testing statistical hypotheses
4. One-way and two-way alternatives. Statistical and practical relevance
5. Ways to compare criteria
6. Confidence Interval
7. Normality Check Criteria
8. Normal parametric criteria: z, Student's t-tests
You will practice

Analytics Excel

content and tools
You will learn
⦁ Excel database

⦁ Data filtering

⦁ Formulas and functions

⦁ Macros and scripts

Quantity grid
Target audience analysis
1. Data import
2. Data formatting (conditional formatting)
3. Creating summary tables and applying sorts
4. Applying and configuring data filtering
5. Working with combined formulas and functions
6. Visualising data (dynamic charts and graphs)
7. Creation of macros and scripts: import from Google Calendar/Disk
8. Data control and validation
You will practice

Power BI

and tools
You will learn
⦁ Power BI

⦁ Data grouping

⦁ Averages functions

⦁ Dashboards

The Ladder Method
Content analysis
1. Data loading and preparation
2. Processing and conversion of data
3. Combining and merging data from various sources
4. Data operations available through Power Query
5. Grouping Data
6. Managing data relationships between tables
7. Creating and setting up a data model (DAX data analysis language)
8. Use Counting, Adding and Calculating Averages functions
9. Visualizing data, creating dashboards
10. Preparing reports for external users
You will practice


Additional modules

Web analytics

and tools
You will learn
⦁ Google Analytics

⦁ Website data

⦁ Hypotheses

⦁ Website optimization

Website concept
1. Working in Google Analytics
2. Setting up the counters on the website
3. Analyzing data from the website
4. Finding weaknesses and optimising website performance
5. Analyzing large amounts of data and making decisions based on the data
6. Defining key performance indicators for the business
You will practice


and tools
You will learn
⦁ Google Sheet

⦁ Multi-table queries

⦁ Cohort analysis

⦁ SQL tools

1. Creating databases with Google Sheet
2. Simple and complex data operations (grouping, filtering, sorting, functions, maximum and minimum search)
3. Connecting multiple databases and working with multi-table queries
4. Using SQL analytical functions to examine data
5. Editing and Deleting Data
6. Using Query in GoogleSheet
7. Cohort analysis
You will practice
and tools
You will learn
⦁ Python


⦁ Metrics

⦁ Graphs and histograms

Ideas generation
1. Knowledge of Python syntax
2. Application of logical, comparison, loop and operator operations to data analytics
3. Calculating Metrics
4. Grouping, sorting, analyzing and visualizing data (using Pandas)
5. Parsing data from the internet (websites + applications)
6. Hypothesis testing
7. Working with API
8. Creation of graphs and histograms (simple and interactive)
You will practice

Practical modules

Case study 1:

and tools
1. Set up the formatting according to the given conditions.

2. Creating a summary table, sorting and filtering by conditions.

3. Analyzing the cross tabbed data and writing conclusions on the data.

4. Add data from other sources to the table and cleanse it from repetition.

5. Relate the data to each other and find correlations in the data.

⦁ Students need to go to a website with population surveys for their city/country and find an array of collected data. The array is arranged by the student in an Excel spreadsheet and solves problems with the data.
*The teacher prepares several sources, a set of tasks and exercises for students to work with.

Case study 2

and tools
1. Make a sales forecast for the next year

2. Check that the data is correct by cross-checking

3. Prepare a report and recommendations to the manager on the seasonality of sales of popular products.

⦁ An annual sales database for the year is being prepared for the students.

Case study 3

and tools
1. The use of tables, graphs and charts are mandatory. The same data should be presented to the manager and the sales department, visualised with maximum efficiency for each user.
⦁ Prepare visualisations for multiple users in Power BI using ready-made data sets.

Case study 4

and tools
1. Information security testing

2. Group workshop:
The group's task is to draw up a six-month planning exercise to increase the company's revenue by 20%
⦁ A baseline of typical departmental tasks, KPIs and budgets is given. The group should prioritise the tasks, set control points and write up six-month planning for the company.

Case study 5

and tools
1. Outcome: a development plan for yourself over the next 3 years
⦁ Mapping out skills and career trajectory for yourself
Participate in virtual classes or watch the recorded sessions
Ask questions and chat with a live expert
Study materials
Your lecturer will answer your questions personally
100% interactive course
We provide our learners with resources and recorded lessons. Keep them to refresh your knowledge whenever you need to.
Study and earn
Data analysts can work in all sectors where data is generated or processed including but not limited to retail, banking, education, health, media and manufacturing.
The main aim of the profession is to source, format and represent data securely in a relevant way for analysis using various tools, analyse structured and unstructured data to support business, blend data from multiple sources and apply various hypotheses for better outcomes.
Be self-employed: check some rates for freelancers
Landing page creation from
Online store design from
Logo creation from
Vacancies are open in UK
Junior Data Analyst earns first year
CEO & Founder Inspire HR Solutions
Using her 20 years of expertise in HR, Victoria perfectly knows how to drive upgrades in the corporate world in effective ways. She is always on hand to offer insight and perspective to best practice and delighted to share her thoughts on how to increase the benefits of the professional skills.

The course is accredited
by HR experts

Using her 20 years of expertise in HR, Victoria perfectly knows how to drive upgrades in the corporate world in effective ways. She is always on hand to offer insight and perspective to best practice and delighted to share her thoughts on how to increase the benefits of the professional skills.
CEO & Founder Inspire HR Solutions
The course is accredited
by HR experts

The webinar with Victoria Hills "How to update your CV and raise your income with your new skills"
The gift for our learners:
The eLearning platform

How are classes delivered?
Virtual classes
Home tasks
During your course, you will get practical and written tasks to complete outside of the scheduled lessons (home study). Our expert tutors will check your work and give you regular feedback, which will go towards your accredited certification.

We keep our students constantly motivated by providing them with regular feedback and a direct channel of communication with each other and our practising experts. Live tutors share professional up-to-date information and will help you keep on track to complete your qualification with confidence.
As soon as your course starts you'll get access to the educational platform where you will find your study materials. You will also be able to communicate with tutor and other learners in your class.
You do virtual face-to-face training with a tutor in a small group. You ask questions and get answers. Training is also available in the recording if you miss the class but the live participation stimulates your progress.
A Personal Certificate will be presented to you after you have completed the course.


Personal certificate
Your CV right after the course

Key competencies:

Basic customer development: generating and validation of hypotheses

Landing page designing, including adaptive website designs creation

Web interface prototyping and designing

Website customer journey map engineering: user script planning

Conducting UX analysis of a project

A/B hypothesis testing

Working with visual layout elements in Figma
Job opportunities

557 vacancies were scanned on based on the current market demand to create this course. We guarantee that your skills are up to date.
of our learners were able to find a new job or increase their income within 6 months after the course
British HR-specialists recommends us
There is no doubt that the ICS is an excellent place to study. You'll be able to boost your career and raise your salary by learning skills from the ICS courses.
George Evans
HR-specialist in Digital Farm
Course schedule
7 - 9 p.m
12 weeks
December 2021
Tues, Thurs
Virtual learning with face-to-face sessions
Enrol on this course
Leave an enquiry and our manager will get back to you as soon as possible and get the course programme by email
Instalment plans are provided by Splitit.

By clicking the button you give your consent to process your personal data on the terms and for the purposes determined by the Privacy policy