FreeCourseWeb Udemy - Alteryx - Data processing Data Manipulation and Analytics

1. 11. Data Wrangling – Creating a new column with Formula Tool. Using Filter tool/2. Creating a new column (Categorical Variable) with if then else condition.mp476.52MB
2. 1. Trainer & Course Introduction/1. Agenda Video.mp48.01MB
3. 1. Trainer & Course Introduction/2. Trainer Introduction, Industry and Training experience.mp419.19MB
4. 1. Trainer & Course Introduction/3. Alteryx Course outline.mp440.01MB
5. 1. Trainer & Course Introduction/4. What’s in it for the trainees.mp440.56MB
6. 2. Significance of data/1. Why data is becoming so popular now a days.mp441.77MB
7. 2. Significance of data/2. Jargons used in Database engineering and Data Analytics Part I.mp474.36MB
8. 2. Significance of data/3. Jargons used in Database engineering and Data Analytics Part II.mp463.64MB
9. 2. Significance of data/4. Core concepts of Relational database.mp468.33MB
10. 3. What is ETL and Analytics/1. Agenda of this section.mp42.83MB
11. 3. What is ETL and Analytics/2. Introduction to core concept of ETL & data processing tools.mp435.25MB
12. 3. What is ETL and Analytics/3. Introduction to core concept of Analytics & analytical tools.mp447.8MB
13. 3. What is ETL and Analytics/4. Application of Analytics.mp429.69MB
14. 4. Downloading Alteryx. Getting familiar with Alteryx environment and Alteryx Serve/1. Agenda for Lesson 04.mp47.05MB
15. 4. Downloading Alteryx. Getting familiar with Alteryx environment and Alteryx Serve/2. Downloading Alteryx Designer - 14 day trial version.mp428.11MB
16. 4. Downloading Alteryx. Getting familiar with Alteryx environment and Alteryx Serve/3. Alteryx at a Glance.mp460.17MB
17. 4. Downloading Alteryx. Getting familiar with Alteryx environment and Alteryx Serve/4. Alteryx Servers and platforms.mp411.08MB
18. 4. Downloading Alteryx. Getting familiar with Alteryx environment and Alteryx Serve/5. A deep dive into Alteryx - Options available in Alteryx Tool.mp468.93MB
19. 5. What is Alteryx And Why Organizations are using Alteryx/1. What is Alteryx.mp450.86MB
20. 5. What is Alteryx And Why Organizations are using Alteryx/2. Why Organizations are using Alteryx.mp437.31MB
21. 6. Data extraction Raw files and Databases/1. Data extractionImporting from raw files Part I.mp460.25MB
22. 6. Data extraction Raw files and Databases/2. Data extractionImporting from raw files Part II.mp470.45MB
23. 6. Data extraction Raw files and Databases/3. Data Import from databases and creating data manually with Text Input Tool.mp443.47MB
24. 6. Data extraction Raw files and Databases/4. Types of data variables in Alteryx.mp443.23MB
25. 7. Saving Datasets and work flow. File and data formats in Alteryx/1. Saving Workflow and formats.mp461.18MB
26. 8. Efficient management of data space in tables with Auto field tool/1. Auto field tool.mp470.54MB
27. 9. Browse Tool to view all records/1. Browse tool and its implications.mp451.79MB
28. 10. Know your data – Types of variables/1. Quantitative & Qualitative data.mp447.66MB
29. 11. Data Wrangling – Creating a new column with Formula Tool. Using Filter tool/1. Creating a copy of variables.mp462.26MB
30. 11. Data Wrangling – Creating a new column with Formula Tool. Using Filter tool/3. Filtering records with single and multiple conditions using AndOR operators.mp474.95MB
31. 12. Data Wrangling – Selecting few variables and Mending variable attributes using S/1. Data transformation and selecting few variables into new datasets.mp460.88MB
32. 13. Numeric functions/1. Creating a numeric variable with Numeric Operators (+, -,,).mp453.54MB
33. 13. Numeric functions/2. Creating a numeric variable with numeric function.mp458.61MB
34. 14. Character functions/1. What are Char functions. Video on Scan function.mp461.99MB
35. 14. Character functions/2. Substring function to extract text string on the basis of position of text.mp457.75MB
36. 14. Character functions/3. Uppercase, lower case and trim function. Using Nesting functions.mp454.51MB
37. 14. Character functions/4. Concatenating text strings and variables.mp421.72MB
38. 14. Character functions/5. Replace function to replace text string.mp425.15MB
39. 14. Character functions/6. Findstring function and Application of function.mp460.16MB
40. 15. Handling dates and other formats/1. Converting a variable into date data type.mp440.86MB
41. 15. Handling dates and other formats/2. Using Date functions.mp426.94MB
42. 15. Handling dates and other formats/3. Handling a currency variable.mp431.98MB
43. 16. Summarize Tools - Functions in Alteryx to derive insightful data/1. Summarizing the data with Summarize tool.mp467.57MB
44. 16. Summarize Tools - Functions in Alteryx to derive insightful data/2. Cumulative total with Running totals.mp439.52MB
45. 17. Arranging data - Sorting & Cascade sorting/1. Sorting a numeric variable and character variable.mp425.81MB
46. 17. Arranging data - Sorting & Cascade sorting/2. Cascade Sorting – sorting by 2 variables.mp424.97MB
47. 18. Handling duplicate observations and duplicate variable values with Unique Tool/1. Removing duplicate records.mp447.12MB
48. 18. Handling duplicate observations and duplicate variable values with Unique Tool/2. Finding unique values of a single variable.mp433.62MB
49. 18. Handling duplicate observations and duplicate variable values with Unique Tool/3. Application – Use case scenario of Unique tool.mp443.86MB
50. 19. Sampling and Creating Unionconcatenation of data using Sample and Union tools/1. Sampling and Union Tool.mp452.38MB
51. 20. Joining tables with a common key/1. Concept of Joins.mp442.52MB
52. 20. Joining tables with a common key/2. Left Join.mp465.43MB
53. 20. Joining tables with a common key/3. Right, Inner and Outer Join.mp423.61MB
54. 21. Transposing data/1. Long to wide transpose.mp432.57MB
55. 21. Transposing data/2. Wide to long transpose.mp424.53MB
56. 22. Frequency of categorical variables/1. One way frequency with frequency table tool.mp450.27MB
57. 22. Frequency of categorical variables/2. N way frequency with contingency table tool.mp441.47MB
58. 23. Automating the workflows with Macros and Global Constants/1. Need for Macros as reusable workflow.mp421.22MB
59. 23. Automating the workflows with Macros and Global Constants/2. Automation of Process – CreatingCompiling a Macro workflow Step I.mp425.92MB
60. 23. Automating the workflows with Macros and Global Constants/3. Automation of Process – CallingExecuting a Macro workflow Step II.mp424.63MB
61. 23. Automating the workflows with Macros and Global Constants/4. Global Constants Make a dynamic process with input constants as dynamic.mp448.66MB
62. 24. Replacing Missing values/1. Replacing missing values – Simple approach.mp436.83MB
63. 24. Replacing Missing values/2. Replacing missing values for cohorts with 1 variable averages.mp439.54MB
64. 24. Replacing Missing values/3. Replacing missing values for cohorts with more than 1 variable averages.mp448.38MB
65. 25. Intro to Data Analytics and decision making/1. Agenda for the Lesson.mp43.68MB
66. 25. Intro to Data Analytics and decision making/2. What is Analytics.mp438.96MB
67. 25. Intro to Data Analytics and decision making/3. Use case of Analytics in E-commerce company.mp452.28MB
68. 25. Intro to Data Analytics and decision making/4. Types of Analytics.mp425.62MB
69. 25. Intro to Data Analytics and decision making/5. Industry specific examples and use cases of Analytics.mp432.23MB
70. 26. Linear and Logistic Regression - Running Statistical models with Predictive Tool/1. Understanding of Boston Data for Linear Regression.mp426.17MB
71. 26. Linear and Logistic Regression - Running Statistical models with Predictive Tool/2. Linear Regression with Alteryx Running Model and selecting significant variab.mp444.78MB
72. 26. Linear and Logistic Regression - Running Statistical models with Predictive Tool/3. Making predictions with Score Tool.mp431.67MB
73. 26. Linear and Logistic Regression - Running Statistical models with Predictive Tool/4. Understanding Need for Logistic Regression with banking data.mp435.13MB
74. 26. Linear and Logistic Regression - Running Statistical models with Predictive Tool/5. Logistic Regression with Alteryx - Running Model and selecting significant.mp439.45MB
75. 26. Linear and Logistic Regression - Running Statistical models with Predictive Tool/6. Logistic Regression with Alteryx - Making predictions and defining cut off.mp435.02MB
76. 27. Machine Learning Algorithms/1. Support Vector Machine.mp417.34MB
77. 27. Machine Learning Algorithms/2. Using SVM Algorithm with Alteryx.mp428.12MB
78. 27. Machine Learning Algorithms/3. Decision Tree.mp416.51MB
79. 27. Machine Learning Algorithms/4. Using DT Algorithm with Alteryx.mp430.31MB
80. 28. Time Series Modelling/1. What is time series data.mp422.22MB
81. 28. Time Series Modelling/2. Stationary and Non Stationery Data.mp415.87MB
82. 28. Time Series Modelling/3. Applicability of the time series modelling.mp49.95MB
83. 28. Time Series Modelling/4. Statistical methodologies.mp417.53MB
84. 28. Time Series Modelling/5. ARIMA Tool.mp435.41MB
85. 28. Time Series Modelling/6. ETS Tools.mp427.45MB
86. 28. Time Series Modelling/7. TS compare tool to compare the different models.mp426.49MB