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.
/6571 learners
4, 6
Study with a live teacher online!
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.
/6571 learners
4, 7
Study with a live teacher online!

Training duration

12
classes
per week
busy
months
week
course
2
12
50+ hours of course materials


Request a call back
We will contact you within 15 minutes to give you all the information you need.
By clicking on the button, you agree to the privacy policy.
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

Junior

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

1
content and tools
You will learn
⦁ Statistical methods

⦁ Practical relevance

⦁ Criteria

⦁ Confidence interval

Tools
Agile
Briefing
Trello
Asana
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

2
content and tools
You will learn
⦁ Excel database

⦁ Data filtering

⦁ Formulas and functions

⦁ Macros and scripts

Tools
Quantity grid
Storytelling
References
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

3
content
and tools
You will learn
⦁ Power BI

⦁ Data grouping

⦁ Averages functions

⦁ Dashboards


Tools
Interviewing
Questionnaires
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

Senior

Additional modules

Web analytics

4
content
and tools
You will learn
⦁ Google Analytics

⦁ Website data

⦁ Hypotheses

⦁ Website optimization

Tools
Prototyping
Mindmap
Website concept
Figma
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

SQL
analytics

5
content
and tools
You will learn
⦁ Google Sheet

⦁ Multi-table queries

⦁ Cohort analysis

⦁ SQL tools

Tools
Adaptability
Composition
Anchors
Modules
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
Python
analytics
6
content
and tools
You will learn
⦁ Python

⦁ API

⦁ Metrics

⦁ Graphs and histograms


Tools
Focus
Ideas generation
Brainstorming
Testing
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:

1
content
and tools
Task
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.
Practice

Case study 2

2
content
and tools
Task
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.
Practice

Case study 3

3
content
and tools
Task
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.
Practice

Case study 4

4
content
and tools
Task
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.
Practice

Case study 5


5
content
and tools
Task
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
£300
£1500
£1300
7693
£37000
Vacancies are open in UK
Junior Data Analyst earns first year
Victoria
Hills
CEO & Founder Inspire HR Solutions
Experience
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.
Experience
Victoria
Hills
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.
Community


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.

Qualification

Personal certificate
Your CV right after the course

Key competences:

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 Indeed.co.uk 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
74%
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
Dates
7 - 9 p.m
12 weeks
Timing
Days
Duration
Form
December 2021
Tues, Thurs
Virtual learning with face-to-face sessions
FAQ:
Why can you choose to study with the ICS?
The International Career School (ICS) is an international network of training centres operating across 5 countries and 58 cities. Since 2010, over 70,000 students have trained with us. We offer 234 courses in the fields of beauty, digital marketing, business, design, media, and IT development. Each course is the distillation of practical knowledge from more than 600 reputable practitioners, each of whom has worked to create our programmes. Training takes place in two formats: online, as face2face webinar meetings with homework, and classrooms located in your city.
How do you deliver your course?
Courses for 4, 5 and 8 weeks are delivered online via the ICS eLearning platform and interactive Zoom sessions. Level 3-4 courses have a blended model delivery: it means you will have in-class sessions for practical modules and online sessions for the theory.
Once you are enrolled on the programme, you can access lessons and study materials on the ICS eLearning platform. To login into your Zoom session, use the links available inside the lesson block.
During live sessions with a teacher, you will practise your new skills remotely. You can get feedback about your home assignments during and between lessons.
How to get a consultation about this course?
To get a free consultation about our programmes, fill out the sign-up form, submit your contact details, or use the Chat widget. One of our team will contact you by phone call, messenger or email to proceed with the detailed information about the course and enrollment in the upcoming group.
How to enrol on this course?
Once you fill out a sign-up form for the course, you'll get access to our eLearning platform. There you can choose the course for you. Once you make sure that the start date and time are convenient for you, proceed to the payment option and follow the instructions.
How can I pay for the course?
You can pay with a debit/credit card or Paypal. All payments are secured and processed by either Paypal or Stripe systems.

Please note, some of the courses have practical lessons. They require access to professional software that is not included in the course fee.

Remember, we tolerate a 100% refund policy. You can claim a refund anytime before the course starts.
How can I take advantage of the instalment plans?
We propose several payment schemes: for 2, 4 and 6 months. If you would like to pay in instalments, please, contact our Registration team on the eLearning platform.
What if I miss my class?
If you are attending one of our online short courses:
Please, don't worry. We provide lesson recordings the next day after a live session. You can watch your lesson later at your convenient time.
If you are not able to join live sessions, you may watch recorded videos, prepare homework and communicate with your teacher on the eLearning platform.
If you have any unexpected circumstances preventing you from participating in your live classes, please let us know by contacting our support team via the eLearning platform to talk about solutions.
If you are attending Level 2 or 3 VTCT courses:
Your attendance is monitored and required for successful completion. In case you cannot attend an online session, you will be able to catch up by watching the class recording.
Will I get a certificate after the course?
Yes, on the last day of your course, you will receive a certificate or diploma of completion after completing home assignments and assessment. It will confirm your new skills.
What should be on a kit list?
· It is necessary to have access to a laptop or PC with a stable internet connection

· Preinstalled The Zoom app

· Access to the Figma tool (free editing software Figma)

· The Chrome web browser
Instalment payments are provided by Splitit.

✔ For Visa and MasterCard credit cards only.

✔ Equal monthly instalments.

✘ No credit check.

✘ No interest fee.


* Valid for credit cards with an expiration date
of 6 months minimum.


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
Useful Links
Locations
Kemp House, 152 - 160 City Road, London EC1V 2NX
Coronavirus (COVID-19)
Our school intends to continue providing training courses during this outbreak. We want to reassure our students that we can provide them with quality learning even during forced closures, including through online learning.
© 2010-2021 International Career School
Contacts
Mail info@intcareersch.co.uk
Phone 020 45 77 12 79
ICO registration
B INT PARTNERS
Reference number:
16103096