Get Bonus Downloads Here.url

  001 Hello Altery - Introduction.en.srt

  002 Important - before you start.html

  004 2 Alteryx - Lets explore the interface.en.srt

  005 3 How to get our data into alteryx.en.srt

  006 4 How to connect to a SQL database in practise.en.srt

  007 5 How to use the browse tool and saving cleaned data.en.srt

  008 6 Select tool - all you need to know.en.srt

  009 7 Auto Field - let Alteryx figure out the correct datatype.en.srt

  010 8 Data Cleansing fast and efficient.en.srt

  011 9 The Filter tool - a deep dive.en.srt

  012 10 The formula tool and how to use it.en.srt

  013 11 Data Preparation with Generate Rows in Alteryx.en.srt

  014 12 Data Preparation - Imputation - Dealing with missing values.en.srt

  015 13 Data Preparation - Binning in Alteryx.en.srt

  016 14 Data Preparation - Multiple Calculations at once in Alteryx.en.srt

  017 15 Data Preparation - Multi Row Formula Tool and where to use it.en.srt

  018 16 Data Preparation other useful tools in Alteryx.en.srt

  019 17 Data Preparation - Classifying your data in Tiles in Alteryx.en.srt

  020 18 Combining Data - How to use the Union Tool in Alteryx.en.srt

  021 19 Cleaning data with the Find and Replace Tool in Alteryx.en.srt

  022 20 Using the Append Tool in Alteryx with caution.en.srt

  023 21 How to use the Make Group aka make Friends tool in Alteryx.en.srt

  024 22 How to match fields which do not match in Alteryx - fuzzy match.en.srt

  025 23 Joining in Alteryx - available options.en.srt

  026 24 Parsing Tools and how to use them in Alteryx 1.en.srt

  027 25 Parsing Tools and how to use them in Alteryx 2 Regex.en.srt

  028 26 Transforming Data in Alteryx Arrange and Count Records.en.srt

  029 27 Pivoting and Unpivoting - Cross Tab and Transpose in Alteryx.en.srt

  030 28 Alteryx Cummulative Sales - Running Total and how it works.en.srt

  031 29 Aggregation with Summarize - Most important tool.en.srt

  032 30 Weighted Average Calculation in Alteryx.en.srt

  033 31 Dynamics - Additional useful tools in Alteryx.en.srt

  034 32 How to combine multiple excel tabs into alteryx.en.srt

  035 33 Webscraping - How to get foreign exchange rates in Alteryx.en.srt

  036 34 Bonus - Webscraping - Getting Tables from Websites with Python in Alteryx.en.srt

  037 NEW - A free resource for bonus videos tips and tricks.html

  039 35 Final Words and Case Study.en.srt

  Bonus Resources.txt

   Alteryx Python Webscraping.txt

   Friends.xlsx

   Game.xlsx

   GamesneedHeaders.xlsx

   Hotels 1-5.xlsx

   Product Info Clean.xlsx

   SalesRep.xlsx

   TileSalesRep.xlsx

    Pokemon.csv

    Transactions Aug19.csv

    Transactions Feb19.csv

    Transactions Jul19.csv

    Transactions Mar19.csv

    Transactions Nov19.csv

    Transactions Sep19.csv

   missing sales numbers.xlsx

   weights.xlsx

   Alteryx Python Webscraping.txt

   EnergydrinkSales2.xlsx

   FuzzyFriends.xlsx

   Games_Join.xlsx

   Headers.xlsx

   Join Games.xlsx

   Product Info.xlsx

   Streaming.xlsx

   Transactions Apr19.csv

   missing sales numbers.xlsx

   weights.xlsx