Skip to content

Data Analyst

6 Courses Bundle Training | Accredited by IAO | 24/7 Career Support| 97% Flash Sale


One Education

Summary

Price
Save 97%
£39 inc VAT (was £1,599)
Offer ends 08 December 2021
Study method
Online, self-paced
Duration
35 hours
Access to content
12 months
Qualification
No formal qualification
Additional info
  • Exam(s) / assessment(s) is included in price
  • Tutor is available to students

6 students purchased this course

Add to basket or enquire

Overview

By 2022, World Economic Forum predicts that Data Analysts will be one of the top emerging jobs. Organisations view data analysis as one of the most crucial future specialities due to the value that can be derived from data. Explore and acquire the quantitative Data Analyst skills with R and Python that you will typically need to succeed as a Data Analyst. You'll learn how to prepare data for analysis and visualise these data to tell a story. Moreover, you will learn advanced excel, Data Analytics with Tableau, programming language, machine learning and many more.

This Data Analyst bundle package includes:

  • Data Analyst - Analysis In Excel
  • Data Analyst - Diploma in Data Analytics with Tableau
  • Data Analyst - Google Data Studio
  • Data Analyst - Advanced Excel Course (Formula, VLOOKUP & Power Query)
  • Data Analyst - R Programming for Data Science
  • Data Analyst - Data Science & Machine Learning with Python – One Education

Dedicated tutor support and 24/7 customer support are available to all students with this premium quality Data Analyst bundle. Get the help you require and the answers to all your queries throughout the comprehensive syllabus of this Data Analyst bundle.

This premium online course titled Data Analyst ensures your professional development with IAO accreditation. You’ll have the privilege of learning in your own time, at your own pace and earning an accredited certification.

This Data Analyst bundle is developed by industry experts and is packed with several insightful modules to properly understand Data Analyst skills and allow you to accelerate your career.

What you will learn from this Data Analyst bundle course

  • Explain the data analysis in excel in this data analyst bundle course
  • Learn the data analyst skills with Tableau
  • Understand how to use Google Data Studio
  • Describe the different types of data structures, file formats, and sources of data
  • Learn the programming language in this data analyst bundle course
  • Describe the process and tools for gathering data, wrangling data, mining and analyzing data, and visualizing data with our data analyst bundle course
  • Work with data in Python, including reading and writing files, loading, working, and saving data with Pandas
  • Learn how to interpret data in Python using multi-dimensional arrays in NumPy, manipulate DataFrames in pandas, use SciPy library of mathematical routines, and execute machine learning using Scikit-Learn
  • Perform data analytics using popular Python libraries in this data analyst bundle

Why People Love And Enrol The Data Analyst bundle From One Education

  • Eligibility for IAO-accredited certificates on successful completion of each of the courses in this Data Analyst bundle
  • Learning materials of our Data Analyst bundle contains engaging voiceover and visual elements for your comfort
  • Freedom to study at your own pace
  • 24/7 access to the Data Analyst bundle materials for 12 months
  • Full Tutor support on weekdays (Monday – Friday)

The learning path in this Data Analyst course is specifically designed to give you the tools you need to be successful in Data Analytics and help you obtain a competitive edge. Data analyst examines information using data analysis tools and helps their teams develop insights and business strategies. You’ll need skills in the programming language, communications, and working with tools designed to do data analytics and data visualization. Explore this high-demand career.

This Data Analyst online training bundle has been designed by industry experts and will give you an in-depth understanding of this topic. The Data Analyst bundle features easy-to-digest modules that break down each topic and ensure all our students receive an unrivalled and thorough learning experience.

If you want to work in this rapidly growing sector and stand out from the competition, then our Data Analyst bundle is the perfect place to kickstart your dream career.

On the Data Analyst bundle, we guarantee that you will gain relevant skills and acquire tremendous knowledge on the subject. The certificate you’ll achieve after completing the Data Analyst bundle will help you land the job you want in a related field.

Course media

Description

Curriculum of Data Analyst Course

***Data Analyst In Excel***

Data Analyst Module 01 Modifying a Worksheet

  • Data Analyst - Insert, Delete, and Adjust Cells, Columns, and Rows
  • Data Analyst - Search for and Replace Data
  • Data Analyst - Use Proofing and Research Tools

Data Analyst Module 02 Working with Lists

  • Data Analyst - Sort Data
  • Data Analyst - Filter Data
  • Data Analyst - Query Data with Database Functions
  • Data Analyst - Outline and Subtotal Data

Data Analyst - Module 03 Analyzing Data

  • Data Analyst - Apply Intermediate Conditional Formatting
  • Data Analyst - Apply Advanced Conditional Formatting

Data Analyst - Module 04 Visualizing Data with Charts

  • Data Analyst - Create Charts
  • Data Analyst - Modify and Format Charts
  • Data Analyst - Use Advanced Chart Features

Data Analyst - Module 05 Using PivotTables and PivotCharts

  • Data Analyst - Create a PivotTable
  • Data Analyst - Analyze PivotTable Data
  • Data Analyst - Present Data with PivotCharts
  • Data Analyst - Filter Data by Using Timelines and Slicers

Data Analyst - Module 06 Working with Multiple Worksheets and Workbooks

  • Data Analyst - Use Links and External References
  • Data Analyst - Use 3-D References
  • Data Analyst - Consolidate Data

***Data Analyst - Diploma in Data Analytics with Tableau***

Data Analyst - Module 01: Introduction to the Course

  • Data Analyst - Introduction to the Course
  • Data Analyst - What is Tableau? An Introduction to Tableau.
  • Data Analyst - How the Course is Structured
  • Data Analyst - Install the 14 days free, full trial of Tableau

Data Analyst - Module 02: Project 1: Discount Mart (Sales and Profit Analytics)

  • Data Analyst - Project Brief for Discount Mart
  • Data Analyst - Connecting and Preparing Data for Discount Mart
  • Data Analyst - Building Charts on Tableau for Discount Mart (Part 1)
  • Data Analyst - Building Charts on Tableau for Discount Mart (Part 2)
  • Data Analyst - Creating Headline Cards on Tableau for Discount Mart
  • Data Analyst - Building and Publishing Dashboards on Tableau

Data Analyst - Module 03: Project 2: Green Destinations (HR Analytics)

  • Data Analyst - Project Brief for Green Destinations
  • Data Analyst - Building Charts on Tableau (Part 1) for Green Destinations
  • Data Analyst - Building Charts on Tableau (Part 2) for Green Destinations
  • Data Analyst - Creating Headline Cards on Tableau
  • Data Analyst - Building a Dashboard for Green Destinations
  • Data Analyst - Publish your Dashboard to Tableau Public

Data Analyst - Module 04:Project 3: Superstore (Sales Agent Tracker)

  • Data Analyst - Project Brief for Super Store
  • Data Analyst - Building Charts on Tableau (Part 1) for Super Store
  • Data Analyst - Building Charts on Tableau (Part 2) for Super Store
  • Data Analyst - Building a Dashboard
  • Data Analyst - Publish your Dashboard to Tableau Public

Data Analyst - Module 05: Northwind Trade (Shipping Analytics)

  • Data Analyst - Project Brief for Northwind Trade
  • Data Analyst - Building Charts on Tableau for Northwind Trade
  • Data Analyst - Building and Publishing Dashboards for Northwind Trade

Data Analyst - Module 06: Project 5: Tesla (Stock Price Analytics)

  • Data Analyst - Project Brief for Tesla
  • Data Analyst - Building Charts on Tableau for Tesla
  • Data Analyst - Building Headline Cards
  • Data Analyst - Building a Tesla Dashboard
  • Data Analyst - Publish your Dashboard to Tableau Public

***Data Analyst - Google Data Studio***

  • Data Analyst -Module 01: Introduction to GDS
  • Data Analyst -Module 02: Data Visualization
  • Data Analyst -Module 04: A Socio-Economic Case Study

***Data Analyst - Advanced Excel Course (Formula, VLOOKUP & Power Query)***

Data Analyst - VLOOKUP: Master Excel Formula VLOOKUP in 60 minutes!

  • Data Analyst - Looking to the Left with Excel Vlookup
  • Data Analyst - 2-Way Lookup
  • Data Analyst - Comparing Lists with Excel Vlookup
  • Data Analyst - Microsoft Excel Vlookup Tips and Trick

***Data Analyst - R Programming for Data Science***

Data Analyst - Unit 01: Data Science Overview

  • Data Analyst - Introduction to Data Science
  • Data Analyst - Data Science as a Process
  • Data Analyst - Data Science Toolbox
  • Data Analyst - Data Science Process Explained
  • Data Analyst - What’s Next?

Data Analyst - Unit 02: R and RStudio

  • Data Analyst - Engine and coding environment
  • Data Analyst - Installing R and RStudio
  • Data Analyst - RStudio: A quick tour

Data Analyst - Unit 03: Introduction to Basics

  • Data Analyst - Arithmetic with R
  • Data Analyst - Variable assignment
  • Data Analyst - Basic data types in R

Data Analyst - Unit 04: Vectors

  • Data Analyst - Creating a vector
  • Data Analyst - Naming a vector
  • Data Analyst - Arithmetic calculations on vectors
  • Data Analyst - Selection by comparison

Data Analyst - Unit 05: Matrices

  • Data Analyst - What’s a Matrix?
  • Data Analyst - Analyzing Matrices
  • Data Analyst - Naming a Matrix
  • Data Analyst - Adding columns and rows to a matrix
  • Data Analyst - Selection of matrix elements
  • Data Analyst - Arithmetic with matrices

Data Analyst - Unit 06: Factors

  • Data Analyst - What’s a Factor?
  • Data Analyst - Categorical Variables and Factor Levels
  • Data Analyst - Ordered Factors

Data Analyst - Unit 07: Data Frames

  • Data Analyst - What’s a Data Frame?
  • Data Analyst - Creating Data Frames
  • Data Analyst - Selection of Data Frame elements
  • Data Analyst - Conditional selection
  • Data Analyst - Sorting a Data Frame

Data Analyst - Unit 08: Lists

  • Data Analyst - Why would you need lists?
  • Data Analyst - Creating a List
  • Data Analyst - Selecting elements from a list
  • Data Analyst - Adding more data to the list

Data Analyst - Unit 09: Relational Operators

  • Data Analyst - Equality
  • Data Analyst - Greater and Less Than
  • Data Analyst - Compare Vectors
  • Data Analyst - Compare Matrices

***Data Analyst - Data Science & Machine Learning with Python***

  • Data Analyst - Introduction to Machine Learning - Part 1 - Concepts , Definitions and Types
  • Data Analyst - Introduction to Machine Learning - Part 2 - Classifications and Applications
  • Data Analyst - Learn Basics of NumPy - NumPy Array
  • Data Analyst - Learn Basics of NumPy - NumPy Data
  • Data Analyst - Learn Basics of NumPy - NumPy Arithmetic
  • Data Analyst - Learn Basics of Matplotlib
  • Data Analyst - Learn Basics of Pandas - Part 1
  • Data Analyst - Learn Basics of Pandas - Part 2
  • Data Analyst - Understanding the CSV data file
  • Data Analyst - Load and Read CSV data file using Python Standard Library
  • Data Analyst - Load and Read CSV data file using NumPy
  • Data Analyst - Load and Read CSV data file using Pandas
  • Data Analyst - Dataset Summary - Peek, Dimensions and Data Types
  • Data Analyst - Dataset Summary - Class Distribution and Data Summary
  • Data Analyst - Feature Selection - Introduction
  • Data Analyst - Feature Selection - Uni-variate Part 1 - Chi-Squared Test
  • Data Analyst - Feature Selection - Uni-variate Part 2 - Chi-Squared Test
  • Data Analyst - Feature Selection - Recursive Feature Elimination
  • Data Analyst - Feature Selection - Principal Component Analysis (PCA)
  • Data Analyst - Feature Selection - Feature Importance
  • Data Analyst - Refresher Session - The Mechanism of Re-sampling, Training and Testing
  • Data Analyst - Algorithm Evaluation Techniques - Introduction
  • Data Analyst - Algorithm Evaluation Metrics - Confusion Matrix
  • Data Analyst - Algorithm Evaluation Metrics - Classification Report
  • Data Analyst - Algorithm Evaluation Metrics - Mean Absolute Error - Dataset Introduction
  • Data Analyst - Algorithm Evaluation Metrics - Mean Absolute Error
  • Data Analyst - Regression Algorithm Spot Check - Support Vector Machines (SVM)

Who is this course for?

The Data Analyst bundle is ideal for highly motivated individuals who want to enhance their professional skills and train for the job they want! This Data Analyst bundle also suits people aspiring for some in-depth knowledge on this topic and keep up to date with the latest information.

Study the Data Analyst bundle today and increase your professional skillset from the comfort of your home!

Certificate of Achievement

Endorsed Certificate of Achievement from the Quality Licence Scheme

After successfully completing the following courses under the Data Analyst bundle, learners will be able to order endorsed certificates as proof of their achievement:

  • Data Analyst In Excel (within the UK: £109, International: £119)
  • Diploma in Data Analytics with Tableau (within the UK: £119, International: £129)
  • Advanced Excel Course (Formula, VLOOKUP & Power Query) (within the UK: £89, International: £99

Hardcopy of these certificates of achievement endorsed by the Quality Licence Scheme can be ordered and received straight to your home by post, by paying the certificate prices mentioned besides the respective course’s name.

IAO Accredited Certification from One Education

Once you have finished the Data Analyst bundle, you will be eligible to apply for IAO-accredited certificates for each of the courses inside this bundle as proof of your new skills and your continued professional development. Certification is available in both PDF & hardcopy format, which can be received by paying —

  • PDF Certificate: £9
  • Hardcopy Certificate (within the UK): £15
  • Hardcopy Certificate (international): £15 + £10 (postal charge) = £25

Requirements

There are no formal entry requirements for the Data Analysis bundle, with enrollment open to anyone! Anyone and everyone with a knack for learning can enrol on this course without any hesitation.

Learn online from any internet device, including your computer, tablet or smartphone. Study when it suits you and complete the Data Analysis bundle at your own pace.

All students must have a passion for learning and literacy and be over the age of 16.

Career path

Studying the Data Analyst bundle is designed to help you get the job of your dreams, or even that promotion you’ve always wanted. Learn the essential skills and knowledge you need to exceed in your professional life with the help & guidance from our Data Analyst bundle. You will grow your career in such field:

  • Junior data analyst
  • Data analyst
  • Senior data analyst

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs

What does study method mean?

Study method describes the format in which the course will be delivered. At reed.co.uk courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

What are CPD hours/points?

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on reed.co.uk, many of which can be completed online.

What is a ‘regulated qualification’?

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

What is an ‘endorsed’ course?

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body’s logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.