Introduction to Data Analyst

• 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.

To be funded, learners must meet all the following criteria:

• must be aged 19 or older, or will reach their 19^th birthday on or before 31 August 2022 and
• have the right to work in the UK. This can be checked on gov.uk/view-right-to-work and
• meet residency requirements. Suppliers should refer to the  Residency Eligibility section of the AEB funding rules before accepting an individual onto a Skills Bootcamp and
• live in England
• Not attended another Skills Bootcamp within 12months

Employed participants:

Skills Bootcamps will be co-funded at 30% by the employer where the employer is training their own existing employees (defined as someone directly employed by the employer, not a worker, sub-contractor, or freelancer). This is reduced to 10% where the employer is a small or medium sized enterprise (SME) (defined as an employer with less than 250 employees) training their own existing employees, towards the cost of training. Courses are fully funded by Government for individuals not being co-funded by their employer, and for the self-employed. There must be no charges to the individual learner.

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