Data Analyst and Technical Consultant

Training Resources

Training resources used for a series of ‘lunch and learn’ sessions.

 

excel-101-anlaytics-tips-formulas-functions

Useful Formulas and Functions: PROPER, LOWER, UPPER, TRIM, CONCATENATE, FIND + REPLACE, RIGHT, LEFT, MID NOW / TODAY MAX / MIN, Removing Duplicates, Text to Columns

Logical Functions: AND, OR, NOT, IF Statements, Nested IFs, SUMIF, COUNTIF, AVERAGEIF, SUMPRODUCT

Useful Tools: VLOOKUP, Pivot Tables, Transpose, Conditional Formatting, Absolute and Relative References, Date handling

 

 

 

 


presenting-data-101-dashboard-design

Design: Organise the page, Colour, Typography

Display: Chart type, Chart styling

 

 

 

 

 

 

 


sql-101-ssms-query-statements-data

Basics – coding conventions, variables, temp tables

Functions

Joins

Stored Procedures

 

 

 

 

 


marketo-101

Pre build

Create a programme

Create an email: Snippets and tokens,  add images

Build send campaign and list

Final email checks

Build reports

 

 

 


salesforce-101

The Basics

Syncing Campaigns

Lead Source Details when loading lists

Sales Insights

Building Reports