Data School Roundup - July 11-31, 2022

by Andy Kriebel

There's so much to cover in this roundup as I was on holiday one week and fell behind the next. Oops! Either way, the team has provided so much to learn from include 55 Tableau tips and 32 Alteryx tips.

Tableau

  1. How To Add Customs Shapes/Icons On Tableau
  2. How to create "Reset Filters" button in Tableau
  3. Aggregate vs Non-Aggregate Fields
  4. Context Filters: What Are They?
  5. Data Types in Tableau
  6. Default Properties for Dimensions
  7. Default Properties for Measures in Tableau
  8. Filtering Blue vs Filtering Green
  9. Tableau Fundamentals: Live vs. Extracted Data
  10. The Tableau Platform
  11. Colour Quadrants
  12. Dynamically switching dates in Tableau
  13. How To Create Calendar Charts in Tableau
  14. How to Click & Sort with a Set Action | Tableau
  15. How to Create a Dynamic Moving Average in Tableau
  16. How to Make Line and Bar Chart in One Worksheet
  17. How to change date properties
  18. How to replace your data source in tableau
  19. How to set different color legends for columns in Tableau highlight table/heatmap
  20. Parameters: Creating Variable X and Y axes
  21. Playing around with Parameters
  22. Reference band vs Reference Line
  23. Show/Hide Containers Based On Filter Using Parameters - Tableau
  24. Switching Measures on the Fly in the Same View
  25. Table Calculation Functions: INDEX vs. FIRST vs. LAST
  26. Using Parameters to Manipulate Data (Percentage Increase)
  27. Why is the Parameter Action so essential to your Dashboard?
  28. Bar-in-Bar-Chart mit einer Achse
  29. Multiple Field Colours
  30. How to create a dynamic Rank scroll
  31. KPI's and Table Calculations 2: The Wrath of Window Functions
  32. Latitude & Longitude: X-Axis or Y-Axis?
  33. Making Dynamic KPI's using Table Calculations: part 1
  34. Quantile Models in Tableau
  35. Tableau Tutorials: Creating a Reset Button
  36. Tableau Tutorials: Current Year vs Previous Year KPI's with Table Calculations
  37. Tableau Tutorials: Exclude LOD
  38. Tableau Tutorials: Include LOD
  39. Using a Filter as a Go to Sheet Button
  40. Using window_*** in Tableau
  41. Year on Year (Level of detail expression)
  42. Show Missing Values vs Show Empty Columns
  43. Analytics Pane
  44. Analysis Using a Date Parameter
  45. Date calculations in Tableau
  46. Dynamic Table Calculations: Current and Previous Month Sales
  47. Is your order Late?
  48. KPIs: How to Create Them
  49. Show and Hide Filters in Tableau
  50. Table Calculations and Filters: Dynamically Comparing Values Over Time
  51. Tableau Date Functions
  52. Tableau dates exercise
  53. Adding a data source update time
  54. How Creative Can a Dashboard Be?
  55. How Do Relationships Differ From Joins?

Alteryx

  1. (Inter)FaceTime
  2. Alteryx 101: Analytical App
  3. How I solved Alteryx Challenge #5
  4. How to create a dropdown menu of values in Alteryx APPS
  5. How to make a dynamic sorting APP
  6. How to read in and sort a file using Alteryx interface tools
  7. Introduction to Analytical Apps in Alteryx
  8. The Date Interface Tool in Alteryx
  9. Alteryx Spatial: using Summarize tool and Formular tool to work with spatial object
  10. Test tool, a powerful quality assurance means
  11. Alteryx: Linear Regression
  12. Alteryx: Time series analysis
  13. Automatically dropping columns and rows with a selected number of missing values in Alteryx
  14. Clustering in Alteryx
  15. Data Transformation: Cross-Tabs and Transpose
  16. Forecasting- A Time Series
  17. How to perform a Social Network Analysis with Alteryx?
  18. Interpreting the results report of a linear regression
  19. Linear Regression in Alteryx
  20. Model Comparisons in Alteryx
  21. Multi-Row and Multi-Field Formulas - What's the difference?
  22. Confused yet?
  23. Iterative Macro in Alteryx Designer
  24. Macros: Navigating the Interface Designer
  25. Standard Macros
  26. User Input - Interface Tools in Macros
  27. What are 'Batch' Macros?
  28. What are Macros?
  29. What is the difference between the Q and the Lighting Bolt anchors in tools in Alteryx?
  30. Understanding Fuzzy Logic
  31. Creating Spatial Objects: Points, Lines and Polygons PART 1
  32. Creating Spatial Objects: Points, Lines and Polygons PART 2

Tableau Prep

  1. How to Union Multiple Tables in Tableau Prep Using a Wildcard.
  2. Tableau Prep Things
  3. Tableau Prep: Creating Fiscal Dates

Tableau Server

  1. Extracts in Tableau server
  2. Licenses and Pricing for Tableau (Cloud & Server)
  3. Live vs Extract connections
  4. Permissions on Server
  5. Permissions: The Default Folder
  6. Tableau Server - Site Management
  7. Tableau Server 101

Other

  1. Project management
  2. Requirements gathering in the kick off meeting
  3. Workshop Projektmanagement
  4. A customer project with DSDE2 – Data School Hamburg
  5. How to Join in SQL
  6. Schools out........ For the weekend?
  7. The End of the Beginning