Data Analyst Apprenticeship


About the Apprenticeship: Pringle PCS' Data Analyst Level 4 apprenticeship programme will provide apprentices with the necessary capabilities and knowledge of data analytics.

They will be able to study, organise and manipulate data in order to provide the highest level of support solutions to businesses.

The programme will be delivered by a professional data analyst, who has developed, supported and organised complex databases for large corporations such as Nissan and Renault.

We also deliver training courses and support the South Yorkshire Police’s Data Intelligence Analysts with their data, and how they can improve their data handling.

We provide this excellent level of service and support for apprentices throughout the duration of the programme, through hands-on learning, workshops and online learning.

Data Analyst Role Summary:


The main responsibilities of the Data Analyst are to collate, organise and study business data. Once they’ve reviewed and analysed the data, they’ll manipulate the information to create reports and recommend ways to improve corporate strategies/performance.

    Certifications

    Upon successful completion of the apprenticeship programme, the following qualifications are achieved:
  • Data Analyst Level 4
  • BCS Level 4 Certificate in Data Analysis Tools
  • BCS Level 4 Certificate in Data Analysis Concept

  • Course Benefits

  • Learning the latest data analytical programs
  • The fundamentals of data structures
  • Identifying and interpreting data
  • Manipulating data
  • Migrating data
  • Questioning and updating data
  • Checking and cleansing data quality
  • Statistical analysis
  • Creating dashboards
  • Data visualisation

  • Associated Job Roles

  • Data Analyst
  • Data Intelligence Analyst
  • Data Architect
  • Data Manager
  • Data Engineer
  • Data Modeller
  • Data Scientist
  • Data visualisation

Course Outline:


Our Data Analyst apprenticeship programme will give delegates the fundamental skills to excel in their role as a data analyst.

The modules will be delivered as a combination of intense classroom and online training sequencers, allowing apprentices to be able to demonstrate the required understanding to progress their careers.

Our Pluralsight online training portal will provide apprentices with the supportive material to revisit topics covered in the classroom. The website also gives users the ability of writing their own notes which will improve the learning process.

Apprentices will complete nine modules during the programme. Each of the modules shown below will be incorporated into the apprenticeship training in order for delegates to gain the maximum benefits by developing their abilities in a wide range of technical aspects of data analytics.

    Training Modules

  • Module 1: Introduction to a Database | Duration: 3 Days
  • Module 2: Microsoft Access & SQL | Duration: 2 Days
  • Module 3: Databases with Excel | Duration: 2 Days
  • Module 4: Fundamentals with Tableau & Apache Spark | Duration: 1 Day
  • Module 5: Power BI | Duration: 1 Day
  • Module 6: Python | Duration: 1 Day
  • Module 7: Business Analysis – PMI-PBA® Certification Path | Duration: 1 Day
  • Module 8: Data Science with R | Duration: 1 Day
  • Module 9: Problem Solving Workshops | Duration: 1 Day

  • Online Training Support

    Together with the classroom learning and one-to-one development support, each apprentice will have access to supporting material from Pluralsight.

    The Pluralsight courses can be accessed from your own PCs, or apprentices can book a timeslot at our offices to use our Learning Hub facility. They will have access to our high-spec PCs, including free technical support as well as tea and coffee.

    Microsoft Office Scheduled Courses

  • Microsoft Excel: Introduction, Intermediate & Advanced
  • Microsoft Word: Introduction, Intermediate & Advanced
  • Microsoft PowerPoint: Introduction & Advanced

Module Breakdown:


The advanced course expands on your existing knowledge of this program, by introducing more advanced document management and set up techniques.

Through the use of styles, delegates will be able to automatically create a table of contents to provide a structure at the beginning of long documents.

Mail merge will be refreshed and built on with the introduction of filters.

The course also covers the customisation of word, allowing you to create your own menus and buttons.

    The modules included in this programme are:


    Module 1: Introduction to a Database | Duration: 3 Days
  • Introduction to a Databases
  • What is a Database
  • A Relational vs. Flat Database
  • Questioning a Database
  • Different File Types
  • Importing and Exporting
  • A Flat Database
  • Excel and Pivot Tables
  • Understanding what data is, and why it’s needed
  • Data Protection Act
  • Understanding Data – what, why, where, who, when
  • What is? SQL | Python | VB | Dax | Tableau

  • Module 2: Microsoft Access & SQL | Duration: 2 Days
  • Tables | Forms | Queries | Reports
  • Importing & Exporting
  • Introduction into SQL
  • Queries and Views in SQL

  • Module 3: Databases with Excel | Duration: 2 Days
  • Advanced Combined Formulas
  • Queries in Excel
  • Excel PowerPivot
  • Text to Columns
  • Using CSV Files
  • Using VBA

  • Module 4: Fundamentals with Tableau & Apache Spark | Duration: 1 Days
  • Introduction to Tableau & Apache Spark
  • Terminology
  • Questioning Your Data
  • Dashboards
  • Calculations
  • Sharing Your Work

  • Module 5: Power BI | Classroom Learning | Duration: 1 Day
  • Create a Report with Visualisation
  • Modify and Print a Report
  • Create a Dashboard
  • Ask Questions about your Data
  • Share Data with Colleagues and Others
  • Use Power BI Mobile Apps & Desktop
  • Query Editor
  • DAX Language
  • Introduction to DAX Formulas
  • Advanced DAX Calculations
  • Graphing and Dashboard Design

  • Module 6: Python | Duration: 1 Day
  • Introduction to Python Data Analysis
  • Installing and Executing Python Scripts
  • Summary
  • Collecting Stock Market Data
  • Introduction to Collecting Data
  • IEX Trading Platform Data
  • Writing Data to Files
  • Understanding Python Data Structures
  • Persisting Data in Databases and Files
  • SQL Python Basics

  • Module 7: Business Analysis – PMI-PBA® Certification Path | Duration: 1 Day
  • Introduction to Business Analysis & Needs Assessment
  • Planning for Business Analysis
  • Discovering Business Analysis Information Through Elicitation
  • Conducting Business Analysis & Developing Requirements
  • Monitoring Requirements & Evaluating Business Analysis Solutions

  • Module 8: Data Science with R | Duration: 1 Day
  • Introduction to R
  • Working with Data
  • Creating Descriptive Statistics
  • Creating Data Visualisations
  • Creating Statistical Models
  • Handling Big Data

  • Module 9: Problem Solving Workshops | Duration: 1 Day
  • Workshop: Excel
  • Workshop: Access
  • Workshop: SQL
  • Workshop: Power BI
  • Workshop: VBA
  • Workshop Apache

  • Online Training Support


  • Data Analytics: Hands On | Duration: 5 Hours
  • Big Data: The Big Picture | Duration: 2 Hours
  • Data Science: The Big Picture | Duration: 1 Hour
  • Understanding and Applying Numerical Optimisation Techniques | Duration: 4 Hours
  • Analysis Techniques and Random Numbers | Duration: 8 Hours
  • Data Analysis Fundamentals with Tableau | Duration: 5 Hours
  • Beginning Data Exploration and Analysis with Apache Spark | Duration: 2 Hours
  • Big Data Analytics with Tableau | Duration: 4 Hours
  • Getting Started with Power BI | Duration: 5 Hours
  • Getting Started with Data Analysis Using Python | Duration: 3 Hours
  • Business Analysis – PMI-PBA | Duration: 14 Hours
  • Data Science with R | Duration: 3 Hours
  • Exploratory Data Analysis with R | Duration: 3 Hours
  • R Programming Fundamentals | Duration: 7 Hours
  • Apache Spark Fundamentals | Duration: 5 Hours

Online Training Support:


Together with the classroom learning and one-to-one development support, each apprentice will have access to supporting material from Pluralsight.

The Pluralsight courses can be accessed from your own PCs, or apprentices can book a timeslot at our offices to use our Learning Hub facility.

They will have access to our high-spec PCs, including free technical support as well as tea and coffee.

    The modules included in this programme are:


    Module 1: Introduction to a Database
  • Data Analytics: Hands On | Duration: 5 Hours
  • Big Data: The Big Picture | Duration: 2 Hours
  • Data Science: The Big Picture | Duration: 1 Hour

  • Module 2: Microsoft Access & SQL
  • Understanding and Applying Numerical Optimization Techniques | Duration: 4 Hours

  • Module 3: Databases with Excel
  • Analysis Techniques and Random Numbers | Duration: 8 Hours

  • Module 4: Fundamentals with Tableau & Apache Spark
  • Data Analysis Fundamentals with Tableau | Duration: 5 Hours
  • Beginning Data Exploration and Analysis with Apache Spark | Duration: 2 Hours
  • Big Data Analytics with Tableau | Duration: 4 Hours

  • Module 5: Power BI
  • Getting Started with Power BI | Duration: 5 Hours

  • Module 6: Python
  • Getting Started with Data Analysis Using Python | Duration: 3 Hours

  • Module 7: Business Analysis
  • Business Analysis – PMI-PBA | Duration: 14 Hours

  • Module 8: Data Science with R
  • Data Science with R | Duration: 3 Hours
  • Exploratory Data Analysis with R | Duration: 3 Hours
  • R Programming Fundamentals | Duration: 7 Hours

  • Module 9: Problem Solving Workshops
  • Apache Spark Fundamentals | Duration: 5 Hours

Online Live Training


Course Code: ITS13 | Duration: 1 Day | Level: Intermediate

This course introduces more complex features. By the end of this course delegates will be in a position to use some of Excel’s most beneficial functions such as If, Sumif, Countif, And, Or, Vlookup, and Hlookup and is an introduction to using combined formulas. In addition, PCS will also look at more advanced data analysis techniques with combined formulas such as Pivot tables.


    Course Requirements

  • The delegate needs to have attended the previous level of the Excel course at Pringle PCS or at least, have the equivalent working knowledge.

  • Course Content

  • Refresher Workshop
  • Editing (Custom Fills / Conditional Formatting)
  • Advanced Linking Spreadsheets (Formula Linking)
  • Data (Pivot Tables / Custom Filtering / Subtotals / Validation / Lists / Protection)
  • Formulas (IF Statements / CountIF & SumIF / Vlookup / Hlookup)
  • Nested IFs: =IF(A1=1,"Yes",IF(A1=2,"No",IF(A1=3,"Good",IF(A1=4,"Bad","Naughty"))))
  • AND / OR Formulas
  • What IF Analysis (Goal Seek / Scenario Manager)
  • PMT (Repayment of a Loan)
  • Introduction to Combined Formulas
  • Text Formulas (Len / Left / Right / Mid / Find / Proper / Upper / Lower)
  • Introduction to Combined Text Formulas: =Proper(Left(D1,1)&" "&Right(D1,Len(D1)-Find(" ",D1,1)))
  • Problem Solving Workshops
  • Question and Answers

Prices


Course Code: ITS13 | Duration: 1 Day | Level: Intermediate

This course introduces more complex features. By the end of this course delegates will be in a position to use some of Excel’s most beneficial functions such as If, Sumif, Countif, And, Or, Vlookup, and Hlookup and is an introduction to using combined formulas. In addition, PCS will also look at more advanced data analysis techniques with combined formulas such as Pivot tables.


    Course Requirements

  • The delegate needs to have attended the previous level of the Excel course at Pringle PCS or at least, have the equivalent working knowledge.

  • Course Content

  • Refresher Workshop
  • Editing (Custom Fills / Conditional Formatting)
  • Advanced Linking Spreadsheets (Formula Linking)
  • Data (Pivot Tables / Custom Filtering / Subtotals / Validation / Lists / Protection)
  • Formulas (IF Statements / CountIF & SumIF / Vlookup / Hlookup)
  • Nested IFs: =IF(A1=1,"Yes",IF(A1=2,"No",IF(A1=3,"Good",IF(A1=4,"Bad","Naughty"))))
  • AND / OR Formulas
  • What IF Analysis (Goal Seek / Scenario Manager)
  • PMT (Repayment of a Loan)
  • Introduction to Combined Formulas
  • Text Formulas (Len / Left / Right / Mid / Find / Proper / Upper / Lower)
  • Introduction to Combined Text Formulas: =Proper(Left(D1,1)&" "&Right(D1,Len(D1)-Find(" ",D1,1)))
  • Problem Solving Workshops
  • Question and Answers
<

Copyright © 2020 | All Rights Reserved Pringle Computer systems Limited