Embedded Files
Please note that I am currently offering any of my Face to Face Courses as an online course, delivered through Microsoft Teams (or similar tool of your choice). The content will remain the same, although the way the material is presented, and how activities are completed, may change.
Data Access and Data Release Management
Data Access and Data Release Management
Aims:
Aims:
To explain why it is necessary to manage data access and data release
To define key terms and concepts
To describe the key roles involved within data access and data release management
To describe how to effectively manage access to data within an organisation
To describe how to safely and effectively release data from an organisation to a third-party organisation
Content:
Delivered via In the Know Ltd, this training session aims to highlight the importance of effectively managing data access and data release within an organization. As organizations handle increasing amounts of sensitive information, ensuring proper access and release protocols is crucial for protecting data, maintaining trust, and complying with legal and ethical standards. We will explore why these processes must be carefully managed to avoid risks that could lead to data breaches, legal penalties, or reputational harm.
Duration:
½ Day
Prerequisites:
None
John Varlow | Training and Consultancy - Data Access and Data Release Management
Introduction to MS Excel Macros
Introduction to MS Excel Macros
Aims:
Aims:
To introduce participants to Macros from the in-built menus
To be able to enable macros within a worksheet
To understand where different macros can be stored, and the implications for sharing with others
To understand how to record macros
To understand the value of absolute and relative references, and how combining them gives more powerful macros
To understand how to use keyboard shortcuts in macros, and the advantage of this
To understand how to look at, and resolve errors
To introduce participants to macros using VBA
To understand how macros are structured
To introduce participants to macros and VBA on the web
To introduce the concept of looping code
To be able to add control buttons to recorded macros
Content:
Content:
Workshop containing all major elements of using macros within Microsoft Excel effectively.
Duration:
½ Day
Prerequisites:
Knowledge of Microsoft Excel
Microsoft Excel installed on client machine
PC Skills – Keyboard and mouse skills
John Varlow | Training and Consultancy - An Introduction to MS Excel Macrosl
Power BI
Power BI
Aims:
Aims:
To give an overview of PowerBI and its features
To demonstrate how to read different data sources into PowerBI
To show how to format and merge data sources, and the benefit of automation
To highlight the use of Mcode and how coding steps help with knowing what has been done to your data
To look at the data model and how to build appropriate models using star schema
To demonstrate how Power BI can produce interactive visualizations
To introduce DAX coding
Content:
Power BI is a business analytics tool developed by Microsoft that allows users to visualize data and share insights across their organisations or embed them in apps or websites.
It offers a suite of services, including Power BI Desktop, Power BI Service (a cloud-based service), and Power BI Mobile, which work together to enable users to connect to various data sources, create interactive reports, and dashboards, and share them with others.
This workshop covers all the major elements of using Power BI effectively.
Duration:
1 Day
Prerequisites:
Knowledge of Microsoft Office packages, especially Excel
Power BI installed on client machine
John Varlow | Training and Consultancy - Power BI
Power Pivot and Power Query in MS Excel / Power BI
Power Pivot and Power Query in MS Excel / Power BI
Aims:
Aims:
To understand how to import different data types into Power Query, including SQL
To introduce the concept of MCODE
To understand how to use multiple files in Power Query
To be able to filter data
To be able to append data
To understand automatic updates within Power Query
To understand the key Power Query functions
To understand the different ways of “loading data”, including pivot table cache
To understand the concept of recurrency and how to deal with it
To understand operators (lookup and positional)
To understand how to merge file (replacing vlookup in Excel)
To understand how to append different file formats
To understand the concept of unpivoting data
To introduce the concepts of joins and merges
To understand grouping functions
To understand the “data model” and how to build relationships
To introduce the concept of DAX formulae
Content:
Content:
Workshop containing all major elements of using Power Query and Power Pivot with Microsoft Excel. Please note that this course does not look at DAX functions in detail.
Please Note: The principles taught in this session can be applied to both Microsoft Excel or Microsoft PowerBI
Duration:
Duration:
2 Days
Prerequisites:
Prerequisites:
Knowledge of Microsoft Excel
Microsoft Excel / Microsoft Power BI installed on client machine
PC Skills – Keyboard and mouse skills
John Varlow | Training and Consultancy - Power Pivot and Power Query in MS Excel / Power BI
Quantitative Analysis using Jamovi fronted R (Open Source)
Quantitative Analysis using Jamovi fronted R (Open Source)
Aims:
Aims:
To enable participants to utilise JAMOVI in simple database / spreadsheet setup and manipulation
To understand how JAMOVI can be utilised in analysing quantitative research data.
To apply statistical principle to data, and perform statistical tests on two groups
To enable participants to utilise add on modules to add functionality to JAMOVI
To understand how to write replicable code that can be used in R
To apply statistical principle to data, and perform statistical tests on three or more groups
To understand how to perform more complex analysis, including regression methods and time series
To understand how JAMOVI output can be shared with others
Content:
Jamovi is a “3rd generation” statistical spreadsheet. designed to be easy to use, It is a good alternative to costly statistical products such as SPSS and SAS. It is built on top of the R statistical language, giving access to the best the statistics community has to offer. It is ideal for those trying to learn R but who still like graphical menus and interactions. This workshop covers all the major elements of using the open source Jamovi package effectively.
Duration:
1 Day
Prerequisites:
Completion of Key Statistical Concepts, or similar understanding
Completion of Regression Methods or similar understanding
Completion of Time Series and Forecasting, or similar understanding
Jamovi, R and R Studio installed on client machine
PC Skills – Keyboard and mouse skills
John Varlow | Training and Consultancy - Quantitative Analysis using Jamovi fronted R (Open Source)
Quantitative analysis using SPSS
Quantitative analysis using SPSS
Aims:
Aims:
To enable participants to utilise SPSS in simple database setup and manipulation
To understand how SPSS can be utilised in analysing quantitative research data.
Content:
Content:
Workshop containing all basic elements of using the SPSS package effectively.
Duration:
Duration:
3 hours
Prerequisites:
Prerequisites:
Completion of Introduction to Descriptive Statistics session, or similar understanding
Completion of Introduction to Inferential Statistics session, or similar understanding
Completion of Analysing Your Data session, or similar understanding
PC Skills – Keyboard and mouse skills
John Varlow | Training and Consultancy - Qualitative Analysis using SPSS
Quantitative Analysis using SPSS - part 2
Quantitative Analysis using SPSS - part 2
Aims:
Aims:
To enable participants to utilise SPSS for more complex data manipulation
To understand how to write replicable code
To understand how to perform more complex analysis
Content:
Content:
Workshop containing more advanced features of SPSS, including executing syntax.
Duration:
3 hours
Pre-requisites:
Pre-requisites:
Completion of "Introduction to Descriptive Statistics" session, or similar understanding
Completion of "Introduction to Inferential Statistics" session, or similar understanding
Completion of "Analysing Data" session, or similar understanding
Completion of "Quantitative Analysis using SPSS - part 1" or similar understanding
PC Skills – Keyboard and mouse skills
John Varlow | Training and Consultancy - Qualitative Analysis using SPSS - part 2
Page updated
Google Sites
Report abuse