Introduction to Data Analyst

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.

Learning Objectives

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.

Pricing and Availability

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

BL0, BL1, BL11, BL2, BL3, BL4, BL5, BL6, BL7, BL78, BL8, BL9

M1, M10, M11, M12, M13, M14, M15, M16, M17, M18, M19

M2, M20, M21, M22, M23, M24, M25, M26, M27, M28, M29

M3, M30, M31, M32, M33, M34, M35, M38

M4, M40, M41, M43, M44, M45, M46

M5, M50, M52

M6, M60, M61

M7, M8

M9, M90, M99

OL1, OL10, OL11, OL12, OL14, OL15, OL16

OL2, OL3, OL4, OL5, OL6, OL7, OL8, OL9, OL95

SK1, SK10, SK12, SK13, SK14, SK15, SK16, SK17

SK2, SK22, SK23

SK3, SK4, SK5, SK6, SK7, SK8, SK9

WA12, WA13, WA14, WA15, WA16

WA3, WA6, WA7

WN1, WN2, WN3, WN4, WN5, WN6, WN7, WN8

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

Short Courses

Introduction to Data Analyst