Data Analyst (Data Analytics) Training

Course 01: Diploma in Data Analysis at QLS Level 5

Course 02: Diploma in Business Data Analysis at QLS Level 5

Course 03: SQL Masterclass: SQL For Data Analytics

Master retail Data analytics for data-driven decisions.

Uncover consumer behavior with retail psychology.

Enhance retail performance through data analytics.

Apply data-driven strategies for retail planning.

Optimise inventory and product assortment in retail.

Opportunity to earn a certificate endorsed by the Quality Licence Scheme.

Get a free student ID card! (£10 postal charge will be applicable for international delivery)

Get instant access to this Data Analyst (Data Analytics) course.

Learn Data Analyst (Data Analytics) from anywhere in the world

Data Analyst (Data Analytics) is affordable and simple to understand

Data Analyst (Data Analytics) is entirely online, interactive lesson with voiceover audio

Lifetime access to the Data Analyst (Data Analytics) course materials

Data Analyst (Data Analytics) comes with 24/7 tutor support

FREE certificate on Data Analyst (Data Analytics) accredited by CPDQS

Get instant access to this Data Analyst (Data Analytics) course.

Learn Data Analyst (Data Analytics) from anywhere in the world

Data Analyst (Data Analytics) is affordable and simple to understand

Data Analyst (Data Analytics) is entirely online, interactive lesson with voiceover audio

Lifetime Access to the Data Analyst (Data Analytics) course materials

Data Analyst (Data Analytics) comes with Data Analysis

Assignment & MCQ Based

60% Marks to pass

Instant Assessment

QLS Endorsed Certificate (additional cost)

CPD Approved Certificate

Course 01- Data Analysis: Modifying a Worksheet 25:59 1: Insert, Delete, and Adjust Cells, Columns, and Rows Preview 10:08 2: Search for and Replace Data 08:38 3: Use Proofing and Research Tools 07:13

Working with Lists 37:47 4: Sort Data 10:03 5: Filter Data 09:49 6: Query Data with Database Functions 09:02 7: Outline and Subtotal Data 08:53

Analyzing Data 12:33 8: Apply Intermediate Conditional Formatting 06:50 9: Apply Advanced Conditional Formatting 05:43

Visualizing Data with Charts 38:03 10: Create Charts 13:18 11: Modify and Format Charts 12:16 12: Use Advanced Chart Features 12:29

Using PivotTables and PivotCharts 44:25 13: Create a PivotTable 13:28 14: Analyze PivotTable Data 12:00 15: Present Data with PivotCharts 07:35 16: Filter Data by Using Timelines and Slicers 11:22

Working with Multiple Worksheets and Workbooks 24:00 17: Use Links and External References 12:24 18: Use 3-D References 05:51 19: Consolidate Data 05:45

Using Lookup Functions and Formula Auditing 30:28 20: Use Lookup Functions 12:45 21: Trace Cells 09:05 22: Watch and Evaluate Formulas 08:38

Automating Workbook Functionality 35:27 23: Apply Data Validation 13:28 24: Search for Invalid Data and Formulas with Errors 04:06 25: Work with Macros 17:53

Creating Sparklines and Mapping Data 07:19 26: MapData 07:19

Forecasting Data 27:54 27: Determine Potential Outcomes Using Data Tables 08:47 28: Determine Potential Outcomes Using Scenarios 09:16 29: Use the Goal Seek Feature 04:16 30: Forecasting Data Trends 05:35

Course 02- Module 1: Introduction to Retail Analytics 32:03 31: Introduction to Retail Analytics Preview 32:03

Module 2: Retail Psychology 07:06 32: Retail Psychology 07:06

Module 3: Retail and Data Analytics 12:00 33: Retail and Data Analytics 12:00

Module 4: Benefits of Retail Analytics 16:26 34: Benefits of Retail Analytics 16:26

Module 5: Retail Strategy 09:44 35: Retail Strategy 09:44

Module 6: Retail Buying and Merchandising 11:27 36: Retail Buying and Merchandising 11:27

Module 7: Forecasting 23:27 37: Forecasting 23:27

Module 8: Retail Pricing 16:30 38: Retail Pricing 16:30

Module 9: Analytics Software 19:37 39: Analytics Software 19:37

Module 10: Supply Chain Management in Retailing 07:37 40: Supply Chain Management in Retailing 07:37

Module 11: The Sales Process and Dealing with Customers at the Checkout 04:57 41: The Sales Process and Dealing with Customers at the Checkout 04:57

Module 12: Selling in Multiple Channels 12:40 42: Selling in Multiple Channels 12:40

Module 13: Taking Trends and Targeting Customers Effectively 05:38 43: Taking Trends and Targeting Customers Effectively 05:38

Assessment (Optional) 12:00 44: MCQ Question 12:00

Order Your Certificate 02:00 45: Order Your CPD Certificate 01:00 46: Order Your QLS Endorsed Certificate 01:00

Data Analyst: £25,000 - £50,000

Junior Data Scientist: £30,000 - £60,000

Senior Data Analyst/Scientist: £50,000 - £100,000

Data Analytics Manager: £60,000 - £120,000

119 GBP inside the UK

129 GBP (including postal fees) for International Delivery

29 GBP for Printed Hardcopy Certificate inside the UK

39 GBP for Printed Hardcopy Certificate outside the UK (International Delivery)