Introduction to Data Analyst | Short Course | Apprentify
Apprentices
Apprentices

Looking to gain an apprenticeship? This is the best place to start. Find out why an apprenticeship could be the right path for you.

Learn more
Assessment Centre
Assessment Centre
New

Our bespoke online Assessment center is just one of the many things that make us unique. Find out how we accumulate the best talent through these online sessions.

FAQs
FAQs

See some of the most frequently asked questions from our apprentices and gain a deeper insight into the apprenticeship world.

 

Vacancies
Vacancies

See all of our current vacancies across the whole of England and explore where these careers could take you

Success Stories
Success Stories

Watch some of Apprentify's success stories from apprentices and employers.

Employers
Employers

Thinking of hiring an apprentice? This is the best place to start. Find out how an apprentice could propel your organisation.

Learn more
How It Works
How It Works

Discover the process we go through to finding you the perfect apprentice and the support we provide from start - finish

Testimonials
Testimonials
New

Watch some of Apprentify's success stories from apprentices and employers.

Roles We Fill
Roles We Fill
New

Discover some of the roles we fill and find out more on how we find an ambitious, hard-working recruit to take your organisation into the future.

FAQs
FAQs
New

See some of the most frequently asked questions from our Employers and gain a deeper insight into the apprenticeship world.

Courses
Courses

View all of our courses and discover how we propel organisations through recruiting up-and-coming talent in the digital & technical world

Learn more
Digital Apprenticeships
Digital Apprenticeships
New

Discover the digital apprenticeships we have on offer. Ranging from digital marketing to junior content production. 

Path to Mastery
Path to Mastery

Find out more about our unique Path to Mastery options where you or your apprentice can partake in an additional area to fully hone your skills

Technical Apprenticeships
Technical Apprenticeships
New

View the technical apprenticeships we have on offer. These include roles such as software developer, data analyst and much more!

Short Courses
Short Courses

View some of the short courses we offer to help further your knowledge in specific areas. Delivered by professionals, for future experts.

About Us
About Us

Looking to learn more about Apprentify, the company and who we work with? Find out what makes us unique

 

Learn more
Meet the Team
Meet the Team
New

Discover more about the Apprentify team and gain an insight into some of our hard-working staff members careers.

Careers
Careers

Looking to start a career at Apprentify? Discover some of the options we are currently offering, or send us your CV for future opportunities

Policies
Policies

We’re an honest, transparent and loyal group of people – and we want to make it easy for anyone to find our company policies and procedures whenever they need them.

Safeguarding
Safeguarding

We are committed to providing a caring, friendly and safe environment for all our Apprentices so that they can learn in a relaxed and secure atmosphere. 

Insights
Contact
Short Courses

Introduction to Data Analyst

Back to Short Courses

Introduction to Data Analyst

Course Duration:
Course Qualification:
Overview

Start your data analytics journey while gaining exposure to excel, SQL, PowerBI and Python. Learn how Excel can be used to effectively analyse data sets using its built-in tools while preparing for the MOS Excel exam.   You will then delve into the use of SQL to effectively query data and being to gain relevant insights into raw data.  After SQL you will learn how to use PowerBI to visualise the data and bring your insights to life for a non-technical audience.  Python is a programming language that is being widely adopted for data analysis so you will learn the techniques you can use to achieve this. Finally, you will gain experience in the best methods to communicate your analysis and insights to a variety of audiences.  Throughout you will build a portfolio of evidence showcasing the skills you have developed throughout the course and have access to a wealth of examples to help you in future projects you may become involved with.

Apply for this course today

  • Learn how to using Excel (e.g. entering data, searching within workbooks)
  • Demonstrate how to convert tables/ranges, create charts and use quick analysis in Excel.
  • Understand and develop database designs and analyse data with SQL using Microsoft Access.
  • Identify the SQL Server database structure, using SELECT statements, the JOIN operator and UNION keyword.
  • Create visual interactions on reports and connecting to databases/using Query Editor within PowerBI.
  • Understand how to get data from services/content packs, build a data model and the different types of visualisations as well as how to choose between standard and using custom visualisations.
  • Create a simple Python Programme, understanding the difference between While and For Loops.
  • Create functions to reuse code
  • Understanding the relevance/importance of the communication cycle, and putting it all together.

On average, these courses cost £199 per day. However, with a recent scheme, we are able to offer these courses to anyone in the Greater Manchester area for absolutely free!

 

Will need to have internet access and a PC or laptop and the ability to install free software if required.

Our industry partners

JD Group
Liverpool
Pets at Home
Mag
Greater Manc Transport