Bespoke course for Met Police
Bespoke course for Met Police
Introduction to Alteryx - Basic navigation and industry usecases.
All the sections below will always be complemented with class hands-on examples and also some extra examples (with the respective solutions) for the student to then further practice his/her newly gained skills
Input/Output Tools - Basic of importing data from csv files, excel files and connecting to databases. Common pitfalls and troubles of data input will be emphasized.
Data Preparation Tools - Overview of the main logical tools including filtering, renaming, formula. Analogies with Excel operations will be shown emphasizing on the extra capabilities that Alteryx allows.
Data structuring - The summarize tools will be explored here. Crucial for data pivoting, verticalization and aggregation. These tools allow the efficient shaping of the incoming data streams resulting in the ultimate data model suitable for the businss problem in hand.
Joining - Blending different data sources is at the core of any data driven role. This section focuses on the type of data aggregation possibilities with a special emphasis on the usecases which are suitable for each.
Parsing tools - Overview of Regex operations will be given and integration of parsing data in Alteryx. This section of the course is focused on replicating what is normally doen in Python regarding data parsing of strings, dates etc
Macros - Building your own repeatable and customizable Macros that can be then packaged and used by other people within the organization. Some tips & tricks about overcoming limitations in native Alteryx tools with macros.
Reporting Tools - Leverage your data workflows to build plug-n-play reports. Focusing on both business reporting but also error reporting, data consistency and lineage.
Integration of Alteryx within a company - Server & Workflow automation