Introduction to Data Analyst | Short Course | Apprentify
Apprentices
Employers
Courses
About Us
Short Courses

Introduction to Data Analyst

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.

  • 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