VIDEO: Alteryx Demo

alteryx is a data cleansing and preparation software tool that lets data scientists and analysts prepare data for visualization export data workflows and automate self-service analytics if you're looking for a business intelligence solution you'll want to consider alteryx but if you're not sure where to start with your software search we can help use our product selection tool at technologyadvice.com to get a free short list of business intelligence software recommendations click the link in the description below to get started alteryx offers several different products which include alteryx designer server connect and more in this video we'll focus on alteryx designer alteryx designer is a data preparation and cleansing tool built for people with no coding experience though it does offer advanced capabilities for people who are comfortable with sql the system uses drag and drop functionality to let users build custom workflows on a digital canvas which can be automated to save time on reporting the workspace in alteryx designer is divided into five main panels a search bar in the top right corner a toolbar that runs horizontally near the top a configuration panel on the left side a workflow canvas in the center right and a results panel along the bottom left the search bar lets you enter queries to find answers to your questions across the systems tools community forum and help articles the toolbar grants you access to over 200 tools for cleansing wrangling and transforming data the canvas is a space to drag and drop tools for building workflows and the results panel shows you a preview of what your workflows produce before you export them building a workflow in alteryx designer begins with importing your data using the import tool you can add data from a file or database alteryx also integrates with a number of different software tools if you'd rather import data directly from say salesforce or marketo once your data is in alteryx you can begin applying changes to it using tools from the toolbar the system groups tools into multiple different categories and you can drag and drop them into the canvas and connect them to your data use the configuration panel to set specific actions for each tool and click the green run button at the top of the user interface to preview your workflow in the results panel if you can't find the tool you're looking for you can search for it using the search bar when you're satisfied with the workflow or workflow group share your findings with colleagues by using the built-in data visualization tool in alteryx you can build and customize charts and graphs reports and dashboards and share them via email pdf and excel the data visualization tool lets you create visualizations as you work which makes it easy to tweak your workflow as you go you can also export your data to a variety of file formats from there you can upload your data from alteryx to a data visualization tool like tableau microsoft power bi or click if you're using more than one tool after you prepare your data alteryx lets you export data in multiple file formats simultaneously preparing and blending data takes a long time which is why alteryx includes automation features once you've built some reports you can schedule them to be created at regular intervals and you can also set your data to automatically refresh on a certain schedule if you integrate alteryx with other data sources like salesforce this keeps you from having to manually search the right data in these systems every time you want to update a report in addition to standard reports alteryx also comes with no code advanced analytics just like the rest of the alteryx platform this feature is designed to be used by people with no coding knowledge though it can be augmented with custom python and r coding advanced analytics includes reports for predictive analytics linear and logistic regression a b testing network analysis and more just as with standard reporting advanced analytics are interactive and you can export data from advanced analytics to improve reports and dashboards and other data visualization and bi applications like click and tableau still not sure alteryx is right for you use our product selection tool at technologyadvice.com to get a free short list of business intelligence software recommendations click the button on the left to get started

This transcript was generated automatically from the video's captions and may contain errors.