FreeCourseLab com Udemy - Alteryx Masterclass for Data Analytics ETL and Reporting

1. 01 Introduction/001 Welcome to the course.mp431.7MB
2. 02 Case study and Alteryx Installation/001 The Problem Statement.mp444.61MB
3. 02 Case study and Alteryx Installation/002 This is a milestone!.mp420.7MB
4. 02 Case study and Alteryx Installation/003 Installing Alteryx.mp442.37MB
5. 02 Case study and Alteryx Installation/004 Alteryx Interface.mp443.13MB
6. 03 DATA EXTRACTION_ Extracting tabular data/001 Manually entering data into Alteryx.mp444.19MB
7. 03 DATA EXTRACTION_ Extracting tabular data/002 Importing Data from a CSV (Comma Separated Values) file.mp431.6MB
8. 03 DATA EXTRACTION_ Extracting tabular data/003 Importing Data from a TXT (text) file.mp431.98MB
9. 03 DATA EXTRACTION_ Extracting tabular data/004 Importing Data from an Excel file.mp427.74MB
10. 03 DATA EXTRACTION_ Extracting tabular data/005 Importing Data from a ZIP file.mp421.82MB
11. 03 DATA EXTRACTION_ Extracting tabular data/006 Importing Data from multiple files in a folder.mp449.72MB
12. 04 DATA EXTRACTION_ Extracting non-tabular data/001 Extracting from XML.mp430.93MB
13. 05 Extracting from an SQL table/001 Plan for importing sales Data.mp411.9MB
14. 05 Extracting from an SQL table/002 Installing and setting up PostgreSQL.mp458.65MB
15. 05 Extracting from an SQL table/003 Creating Sales table in SQL.mp455.34MB
16. 05 Extracting from an SQL table/004 Extracting from an SQL table.mp448.61MB
17. 06 Storing and Retrieving Data from Cloud storage/001 Storing Data on AWS S3.mp443.24MB
18. 06 Storing and Retrieving Data from Cloud storage/002 Importing data from AWS S3.mp427.61MB
19. 07 Merging Data Streams/001 Union tool - Merging Customer Data.mp443.16MB
20. 08 Data Cleansing and improving data quality/001 Find and Replace Tool.mp440.15MB
21. 08 Data Cleansing and improving data quality/002 Data Cleaning Tool.mp448.77MB
22. 08 Data Cleansing and improving data quality/003 Autofield and Select Tool - For controlling Field order and data type.mp479.67MB
23. 09 Merging Sales and Product data/001 Select and Unique Tools- For Removing duplicates from product data.mp433.85MB
24. 09 Merging Sales and Product data/002 Date Parse - Changing Date format.mp442.3MB
25. 09 Merging Sales and Product data/003 Select and union - Merging Sales data.mp473.49MB
26. 10 Sampling Data/001 Select Records Tool.mp436.74MB
27. 10 Sampling Data/002 Sample Tool.mp422.71MB
28. 10 Sampling Data/003 Random Percent Sample Tool.mp432.95MB
29. 10 Sampling Data/004 Train-Validation-Test Split sampling.mp445.25MB
30. 11 Data Preparation/001 Multifield binning and Tile Tool - To create customer age categories.mp479.66MB
31. 11 Data Preparation/002 Sort tool - Sorting customer Data based on ID.mp426.23MB
32. 11 Data Preparation/003 Formula Tool - Conditional Formula for giving category titles.mp450.4MB
33. 11 Data Preparation/004 Formula Tool - Sales order date & ship date.mp445.11MB
34. 11 Data Preparation/005 Multifield Formula tool - Converting multiple currency fields.mp456.58MB
35. 11 Data Preparation/006 Filtering and Sorting - Positive number of days.mp452.26MB
36. 11 Data Preparation/007 Text to Columns - Splitting Product ID into 3 columns.mp441.94MB
37. 12 Outputting Cleaned Data/001 Outputting Clean Customer & Product Data.mp441.45MB
38. 13 Merging tables to create a datamart/001 The Joining Tool - Adding customer and Product data to Sales table.mp4145.77MB
39. 13 Merging tables to create a datamart/002 Extracting more info from the Date values.mp450.28MB
40. 14 Performing Analytics_ Transformation on Datamart/001 The Summarize tool.mp438.09MB
41. 14 Performing Analytics_ Transformation on Datamart/002 Running Total Tool.mp470.49MB
42. 14 Performing Analytics_ Transformation on Datamart/003 Crosstab tool for creating Pivot tables.mp440.05MB
43. 14 Performing Analytics_ Transformation on Datamart/004 Transpose Tool - the opposite of Cross Tab tool.mp451.32MB
44. 14 Performing Analytics_ Transformation on Datamart/005 The Count tool.mp417.5MB
45. 15 Creating a report in Alteryx/001 Introduction to Reporting.mp415.96MB
46. 15 Creating a report in Alteryx/002 Interactive Chart tool - Bar chart to show region-wise sales.mp444.76MB
47. 15 Creating a report in Alteryx/003 Interactive Chart tool - Line chart to show Sales trend.mp477.83MB
48. 15 Creating a report in Alteryx/004 Table Tool - Formatting the Pivot table.mp452.65MB
49. 15 Creating a report in Alteryx/005 Text Tool - Adding static text to a report.mp431.12MB
50. 15 Creating a report in Alteryx/006 Visual Layout tool - Arranging charts, text and tables in a report.mp449.01MB
51. 15 Creating a report in Alteryx/007 Header tool - Adding header in a report.mp423.4MB
52. 15 Creating a report in Alteryx/008 Footer tool - Adding footer to a report.mp421.23MB
53. 15 Creating a report in Alteryx/009 Rendering tool - rendering report as a PDF, HTML or PNG.mp445.09MB
54. 15 Creating a report in Alteryx/010 Email Tool - Sending email with Alteryx.mp478.75MB
55. 15 Creating a report in Alteryx/011 Image tool - Adding image to a report.mp419.15MB
56. 15 Creating a report in Alteryx/012 Layout tool - Arranging charts, text or tables in a report.mp437.21MB
57. 16 Scheduling a workflow in Alteryx/001 Schedule and Automate Alteryx workflow.mp473.57MB
58. 17 Bonus Section/001 The final milestone!.mp411.86MB