alteryxppt-210615093855836639337363738.pptx

Alteryxppt

1. ALTERYX

2. INDEX ALTERYX OVERVIEW ADVANTAGES OF ALTERYX Why Alteryx ? Data Cleaning tools Transformation ETL Transformation Workflow Reporting Tools Work Flow

3. ALTERYX OVERVIEW Alteryx is a data analytics and visualization platform that offers a wide range of tools to help businesses make sense of their data. With Alteryx, users can perform complex tasks such as predictive modeling, geospatial analysis, and advanced reporting in a user-friendly interface. It can also automate workflows, saving time and effort for users.

4. ADVANTAGES OF ALTERYX It can generate reports, schedule reports, and do auto email reports. This is a drag-and-drop tool which is easy-to-use and yet can be customize. Alteryx speeds up the time to obtain business answers/insights on data. Data acquisition, accessing all types of data services no matter the format, vendor or platform, you can connect, read and process the data. Data blending and descriptive, creating consolidated data sets, such as joins, unions, summarize, and all basic and advanced data manipulation tasks. Advanced analytics, like predictive and prescriptive analysis, are very good tools. Spatial operations and analytics are super powerful for analysis which requires these types of models/operations.

5. Why Alteryx ? Alteryx is one stop shop. Provides solutions for ETL, Visualisation and Data/Statistical Analysis.

6. Alteryx Tools Data Cleaning Transformation Tools ETL Transformation Tools Reporting Tools

7. Data Cleaning Transformation Data Cleansing Append Tool Find And Replace Imputation

8. Tools Description Data Cleansing - The Data Cleansing tool performs basic data cleansing operations such as replacing null values, removing punctuation, and modifying capitalization. Append Fields - Append the fields from a source input to every record of a target input. Each record of the target input will be duplicated for every record in the source input. Find and Replace - Search for data in one field from one data stream and replace it with a specified field from a different stream. Similar to an Excel VLOOKUP. Imputation - Update specific values in a numeric data field with another selected value. Useful for replacing NULL() values.

9. ETL Transformations Cross – Transpose Tool Summarize Tool Fuzzy Match Tool Running Total Tool Random Sample Count Tool

10. Tools Description Cross-Tab - Pivot the orientation of the data stream so that vertical fields are on the horizontal axis, summarized where specified. Transpose Tool - Pivot the orientation of the data stream so that horizontal fields are on the vertical axis. Fuzzy Match - Identify non-identical duplicates in a data stream. Summarize Tool - Summarize data by grouping, summing, counting, spatial processing, string concatenation, and much more. Running Total - Calculate a cumulative sum per record in a data stream. Random Sample - Generate a random number or percentage of records passing through the data stream.

11. Alteryx Transformations : Reporting

12. Tools Description Table - Create a data table for output via the Render tool. Charting - Create a chart (Area, Column, Bar, Line, Pie, etc.) for output via the Render tool. Report Header - Add a header to a report for output via the Render tool. Report Footer - Add a footer to a report for output via the Render tool. Report Text -Add and customize text for output via the Render tool. Layout - Arrange two or more reporting snippets horizontally or vertically for output via the Render tool.

13. Alteryx Capabilities

14. THANK YOU !