AlterYX Online Training

AlterYX Online Training

0 STUDENTS ENROLLED

    Overview

    AlterYX Training makes you expert in Alteryx Designer, Alteryx Server and Gallery, Alteryx Connect, Alteryx Predictive Analytics for an intuitive workflow for data blending and advanced analytics that leads to deeper insights of traditional approaches include. Enroll & Become Certified.

    Course Content

    1.Introduction

    • Understanding Alteryx Designer
    • Alteryx designer Interface
    • User and Workflow settings

    2.Alteryx Designer

    • Tool Palettes
    • Configuration
    • Favourite Palettes
    • Workflow Canvas

    3.Restructing the data/Data processing

    Split data, skip records, use a record as field headings, pivot and unpivot data and trim and split fields using:

    • Input Data
    • DynamicRename
    • Text toColumns
    • Transpose
    • CrossTab
    • Formula
    • Directory
    • Cross Tab
    • Comment
    • Sample
    • ToolContainer
    • Select
    • Filter
    • Output Data
    • Record ID
    • Unique

    4.Join Data from Different Sources

    Join two tables from the same database, join the result to an Excel spreadsheet and view the output as a Pivot Table in Excel using:

    • Filter
    • Summarize
    • Browse
    • Union
    • Join Multiple
    • Input Data
    • Formula
    • Join
    • Output Data
    • Date Filter
    • Generate Row

    5.Handling Data

    • Missing data, Skip, Random sample, Append data
    • Impute Values
    • Data Cleansing
    • Formula
    • Append Field
    • Random % Sample
    • Unique
    • Running Total

    6.Create Static Reporting

    Create static reporting: Create a report including maps, charts and text all on the same pageusing:

    • Table
    • Charting
    • Layout
    • Date TimeNow
    • Email
    • Sort
    • Render
    • ReportMap
    • ReportText
    • Image

    7.Spatial Analysis

    Specify a trade area, match customers within the trade area to the nearest store and draw a map showing the store trade area and the customers using:

    • CreatePoints
    • SpatialMatch
    • FindNearest
    • TradeArea
    • Distance
    • SpatialInfo

    8.Pharse Data with Reg Ex

    Use REGEX to parse input data to create a new field, filter by a parsed REGEX expression, split a field into multiple fields, select and ignore fields, apply a sequence number to all rows, create spatial points, output as a Tableau Data Extract, create a polyline from the spatial points and browse the final result using:

    • Multi-Row Formula
    • Record ID
      Poly-Build
      RegEx
      Text to Columns

    9.Analytical App

    Create an Alteryx analytic application so that end-users without Alteryx Designer can run a workflow published to the Alteryx Public Gallery. When running the app users will be able to supply input values at run time to modify the result using:

    • List Box
    • Numeric UpDown
    • Check Box
    • Control Parameter
    • Action
    • Image
    • File Browse
    • Radio Button

    10.Macro

    Create a macro that will run through every record and then loop the records back through the workflow, repeating the entire process as many times as is specified, or until a condition is met:

    • Create standard macro
    • Batch macro
    • Macro Input
    • Macro Output
    • Dynamic Rename
    • Dynamic Input
    • Control Parameter
    • Action

    11.Join and Data Blend

    Introduces Alteryx tools to match customer data against a master list of customers and use G-NAF datafiles:

    • InputData
    • Union
    • Unique
    • Select
    • Formula
    • Browse
    • FuzzyMatch
    • Join
    • Filter
    • Auto Field

    12.Database Connections

    In-Database enables blending and analysis against large sets of data without moving the data out of a database and can provide significant performance improvements over traditional analysis methods. Traditional approaches require data to be moved out of the database into a separate environment for processing:

    • Join In-DB
    • Data Stream In
    • Data Stream Out
    • Select In-DB
    • Connect In-DB
    • Filter In-DB
    • Formula In-DB
    • Summarize In-DB

    13.Regression Techniques

    Investigate your data by visualisation, predict likelihood of donation and score before deciding on the number of university new donors to target with a donation campaign. This introduces the following Alteryx tools:

    • Score
    • Visualization
    • Lift Chart
    • Nested Test
    • Linear Regression
    • Logistic Regression
    • StepwiseRegression
    • Decision Tree

    14.Clustering

    • Partition records into “K groups” around centroids by assigning cluster memberships, using K-Means, KMedians, or Neural Gas clustering
    • Append Cluster
    • K-Centroids Analysis
    • Visualization

    15.Assignments

    These case studies are designed for the class to have the practice during the sessions, after discussion of each topic there will be a case study that audience has to develop in their machines.

    • Data will be shared with everyone before each case study
    • Blending Data
    • Preparing Data containing Date/Time fields
    • Preparing Data containing Date/Time fields
    • Data cleansing processes
    • Reading, Writing and Data Blending
    • Performing Analytical Ranking
    • Analytics Rolling Average
    • Using RegEx SocialMedia solution
    • RegEx Analytics
    • Data Prep and Blending using Fuzzy Matching
    • Parsing Data
    • Preparing Reporting
    • Reporting Solution for Excel
    • Building Analytical Apps in Alteryx
    • Create a Standard Macro
    • Create a batch macro
    • Spatial Trade Area Development
    • Find all customers within 30 miles of a store
    • Performing Partitioning Cluster Analysis

    16.Test and Preparation

    • Assesment

    Write a Review

    Your email address will not be published. Required fields are marked *

    Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. keen Technologies also verifies their technical background and expertise.

    We record each LIVE class session you undergo through and we will share the recordings of each session/class.

    If you have any queries you can contact our 24/7 dedicated support to raise a ticket. We provide you email support and solution to your queries. If the query is not resolved by email we can arrange for a one-on-one session with our trainers.

    You will work on real world projects wherein you can apply your knowledge and skills that you acquired through our training. We have multiple projects that thoroughly test your skills and knowledge of various aspect and components making you perfectly industry-ready.

    Our Trainers will provide the Environment/Server Access to the students and we ensure practical real-time experience and training by providing all the utilities required for the in-depth understanding of the course.

    If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within 48 hours of initial registration. Please make a note that refunds will be processed within 30 days of prior request.

    The Training itself is Real-time Project Oriented.

    Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.

    There are some Group discounts available if the participants are more than 2.

    As we are one of the leading providers of Online training, We have customers from USA, UK, Canada, Australia, India and other parts of the world.

    Course Reviews

    N.A

    ratings
    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    PRIVATE COURSE
    • PRIVATE
    • 4 weeks, 2 days
    Contact Us

    +1 475-212-0075

    Drop us a query

    Job Support

    Course Features

    Live Instructor-led Classes

    This isn't canned learning. Its dynamic, its interactive, its effective

    Expert Educators

    Only the best or they're out. We are constantly evaluating our trainers

    24&7 Support

    We never sleep. Need something answered at 3 am? No Problem

    Flexible Schedule

    You don't learn as per our calendar. We work according to yours.

    Customized Training's

    The most part self-managed and adaptable to suit a person's particular adapting technology needs

    Priority Based Training's

    Real-time Scenario based Assignments and Case Studies

    Disclaimer

    This web site or keentechnologies.com team is not associated with SAP AG or any other product. We are providing this service absolutely for Education and Training purpose only. We charge for the support services only, not for the actual SAP System access. All SAP Systems operate under INITIAL evaluation license. All trademarks mentioned on this web site belongs to their owners. We do not share or distribute ANY personal information we collect on this web site. For any additional information

    475-212-0075

    +91 9989754807

    trainings@keentechnologies.com

    Popular Courses


    Countries

    Keen Technologies offering training in cities: Bangalore, Hyderabad, Chennai, Delhi, Kolkata, UK, London, Texas, Chicago, San Francisco, Dallas, Washington, New York, Houstan, Atlanta, Orlando, Boston, Toronto, Ottawa, Windsor, Australia, Dubai, Leeds.


    ONLINE MEETING PARTNERS

    top
    COPYRIGHT © 2020 KEEN IT TECHNOLOGIES PVT.LTD, ALL RIGHTS RESERVED
    WhatsApp us whatsapp