Data School Roundup - August 1-14, 2022

Check out these tips from our Data School consultants covering the first two weeks of August.

Alteryx

1. A Snapshot of Alteryx
2. Alter-cations, Alter-ations, Alter-yx
3. Alteryx vs Python - Day 1 of Alteryx Training
4. How not to Alteryx
5. How to Write Multiple Excel Sheets in Alteryx
6. My first day of Alteryx
7. Wildcard in Alteryx (*)
8. Alteryx vs Tableau Prep - Battle of the Preps
9. Testing statistical significance in tableau and Alteryx
10. Joining by Range in Alteryx
11. Unionising and Joining Data in Tableau Prep and Alteryx
12. Helpful lesser-known functions of Alteryx
13. API’s: Alteryx or Python? Which one is more friendly user?
14. How to access data from a pdf file in as little as 7 steps?
15. A solution to Alteryx Weekly Challenge #7 & Insights into the output data

Tableau

1. How to Make a Quadrant Scatterplot
2. How to Calculate Z-scores in Tableau pt. 1
3. How to make Z-Score in Tableau
4. Building a sankey chart
5. Average vs Weighted Average
6. Swapping Sheets on a Dashboard
7. Containers Design in Tableau
8. Containers 101
9. Containers in Tableau
10. Containers/Excalidraw
11. How To: Dashboard Design (Containers)
12. Recreating Dashboards: Containers
13. Replicating a Dashboard with Containers
14. How To Sheet/Chart Swap Using Parameters
15. ATTR, is all of the confusion worth it?
16. Calculating a Moving Average is better than Average
17. Combined vs Dual Axis
18. Creating a Dynamic Reference Line
19. Dynamic Sorting
20. Reference Lines with Variance
21. Splitting Columns in Tableau
22. Sankey Diagramm und die Benutzung von Templates
23. How to Create a Dumbbell Chart
24. Two ways to create the chart type switch button in Tableau (Part1)
25. Two ways to implement the chart type switch button in Tableau (Part2)
26. Parameters, A better way to filter Data
27. How to use parameters to add interactivity?

Tableau Prep

1. Cleaning Data in Tableau Prep
2. Joining Tables in Tableau Prep
3. Why should I care about Tableau Prep? - Day 1 of Tableau Prep
4. How to remove duplicates in tableau prep

Life @ The Data School

1. Day 1 = Culture shock
2. Banter and Networking
3. Distant Pasts and Hopeful Presents
4. I've found home
5. Worried about the application process? Don't be
6. Recommended Eating Spots Near Watling Street
7. 5 things I have gained in my first week of the Data School
8. Organisation is key
9. ‘Why should you apply early to The Data School New York?’
10. Imposter syndrome
11. Music Blog: Unique Guitarists
12. From then to Now
13. Out with the Old, In with the New.
14. Week 2 Presentation: My Application Viz and Improvements
15. Week 2 Presentation: Reworking my application Viz with my current (minimal) knowledge
16. Week 2 presentation: what I did and why!
17. Week 2: Project Time
18. The difficult first (two) day(s) in a customer project
19. Application Revisited: Improvising Dashboard

Other

1. Day Two: Clinical Trials Data Management
2. Modern Analytics Architecture
3. Modern Architecture... no not the buildings.
4. Stats 101: Average vs. Weighted Average
5. Modern Data Architecture: What is it, and why is it so important?
6. Some things to consider when creating data visualisations
7. Introduction to SQL
8. Fields Parameters in Power BI
9. The Decade of Data
10. Climbing the ladder