Syntax Basics in SQL

Aug 15, 2022 Quinn Serfass | www.thedataschool.co.uk

Last week, we had the honor to learn from the one and only 2022 Iron Viz champion, Will Sutton. Today, I will be reflecting on some of the SQL things we learned. I will be mostly focusing on the syntax of a SQL query and potential outputs by queries.

data-engineering,airbyte,data-integration,wrike,modern-data-stack

Some SQL Resources to Make Learning Fun

Aug 15, 2022 Tristan Kelly | www.thedataschool.co.uk

If it wasn’t evident in its name SQL, or Structured Query Language, is a language that will require practice to perfect. If you learn the basics but don’t implement consistent practice, you will likely forget much of what you have learned, and str...

data-engineering,airbyte,data-integration,wrike,modern-data-stack

Select, From, Where: SQL

Aug 15, 2022 Islande Derazin | www.thedataschool.co.uk

SQL is a query language that lets you manipulate data. SELECT will let you select data in a table.

data-engineering,airbyte,data-integration,wrike,modern-data-stack

SQL/Snowflake with Will Sutton

Aug 15, 2022 David Yang | www.thedataschool.co.uk

Last week we had the Iron Viz Champ Will Sutton teach us SQL. Will Sutton began with a demo on a tableau showing the percentage of Employer wanting a certain skill. Listed were Excel, SQL, Tableau, Python, and R. SQL was approximately 50%. This sh...

data-engineering,airbyte,data-integration,wrike,modern-data-stack

Project Manager - Day Two-Fin

Aug 15, 2022 Ozlem Sigbeku | www.thedataschool.co.uk

The hijinks in my week as project manager were too much for me to bare. But, DS32 delivered a great week of work. What remains is just a handover and this blog.

data-engineering,airbyte,data-integration,wrike,modern-data-stack

Project Manager - Day One

Aug 15, 2022 Ozlem Sigbeku | www.thedataschool.co.uk

Day one of me being a project manager for DS32’s week 10 client project. What hijinks will I get up to this week?

data-engineering,airbyte,data-integration,wrike,modern-data-stack

Outputting in Alteryx

Aug 15, 2022 Lauren Halliwell | www.thedataschool.co.uk

You can do more than simply output to a csv using Alteryx.

data-engineering,airbyte,data-integration,wrike,modern-data-stack

Multi-Field Formulas in Alteryx

Aug 15, 2022 Finn Charlton | www.thedataschool.co.uk

A beginner’s guide to the Multi-Field Formula tool in Alteryx!

data-engineering,airbyte,data-integration,wrike,modern-data-stack

Learning SQL in Snowflake

Aug 15, 2022 Eric Williams | www.thedataschool.co.uk

Snow flake is a relational database that enables data storage, processing, and analytic solutions that are faster, easier to use, and more flexible than most competitors.

data-engineering,airbyte,data-integration,wrike,modern-data-stack

IF/ELSE Conditional Formula in Alteryx

Aug 15, 2022 Carol Mhlanga | www.thedataschool.co.uk

A snippet of what you can do with the Formula Tool in Alteryx. In this example, we have an example of how to update a column as well as creating a new field and combining value from different columns/fields.

data-engineering,airbyte,data-integration,wrike,modern-data-stack

Helpful lesser-known functions of Alteryx

Aug 15, 2022 Frederik Egervari | www.thedataschool.co.uk

There are many different options and functions on how to optimize working with Alteryx Designer due to the mostly unknown features of the program. Since Alteryx offers so many different features, but not always the optimal usability, some of those...

Getting into DSNY1 from Eventbrite

Aug 15, 2022 David Yang | www.thedataschool.co.uk

You are an Enigma - Ann Jackson

data-engineering,airbyte,data-integration,wrike,modern-data-stack

Formula tool and what does it do?

Aug 15, 2022 Arnold Quarcoo | www.thedataschool.co.uk

A look at the formula tool and a snippet of one of the many things you can do.

data-engineering,airbyte,data-integration,wrike,modern-data-stack

Formula's: Countwords & Getword

Aug 15, 2022 Angelica Obi | www.thedataschool.co.uk

Individually, the countwords and getword formulas are hard. Trying to use them together is even worse……..Buuuuuut, I might be able to help you.

data-engineering,airbyte,data-integration,wrike,modern-data-stack

DateTime Tool in Alteryx

Aug 15, 2022 Cammy Phillips | www.thedataschool.co.uk

How and why you might use the DateTime tool in alteryx

data-engineering,airbyte,data-integration,wrike,modern-data-stack

Alteryx & The Filter Tool: How to use it, and in what context does it wo...

Aug 15, 2022 Ben Winsey | www.thedataschool.co.uk

The filter action is a very powerful function within Alteryx’s arsenal of tool: the following article presents a bitesize example of how it works and why you would want to use it!

data-engineering,airbyte,data-integration,wrike,modern-data-stack

Alteryx: DateTime Summary

Aug 15, 2022 Hannah Laughton | www.thedataschool.co.uk

Some formats are obvious, but others - not so much. Therefore, to ensure that you get the correct output, I have created a summary.

data-engineering,airbyte,data-integration,wrike,modern-data-stack

A little about SQL

Aug 15, 2022 Yadwinder Pannu | www.thedataschool.co.uk

Unlike most sequel’s SQL is necessary.

data-engineering,airbyte,data-integration,wrike,modern-data-stack

Extending Airbyte: Creating a Source Connector for Wrike

Aug 15, 2022 Tamas Foldi | medium.com

The data ingestion tool business is anything but new, and there are many solutions on the market, all with different histories and superpowers. Airbyte claims to be one of the most extensible: using their programming language-agnostic open protoco...

data-engineering,airbyte,data-integration,wrike,modern-data-stack

New Viz: THE BEAST!

Aug 15, 2022 Kevin Flerlage (noreply@blogger.com) | www.flerlagetwins.com

 For Christmas, my father-in-law bought our entire family season passes to Kings Island, a huge amusement park in Cincinnati.  (Kings Island is owned by Cedar Fair which runs 17 amusement parks around the country including Cedar Point)...

Tableau

Sankey Diagramm und die Benutzung von Templates

Aug 14, 2022 Viktoria Von Laer | www.thedataschool.co.uk

Im vorletzten Customer Projekt hat sich der Kunde ausdrücklich gewünscht, dass wir ihm ein Sankey Diagramm bauen, damit er dieses dann nachbauen kann. Ein Sankey Diagramm bildet die Aufteilung von Kennzahlen ab, beispielsweise einen Stromfluss, de...

API’s: Alteryx or Python? Which one is more friendly user?

Aug 14, 2022 Ronaldo Licaj | www.thedataschool.co.uk

What is an API?

The difficult first (two) day(s) in a customer project

Aug 13, 2022 Heinrich Preuß | www.thedataschool.co.uk

Now that the halfway point of client projects is over, it’s a good time to look back and reflect on how things have gone so far. In this blog post, I don’t want to bore you with all the things that went well and that I’m happy with, but I do want ...

What did it take to get into DS34?

Aug 12, 2022 Lorna Brown | www.thedataschool.co.uk

DS34 have already been with us two weeks, and today’s project is them re-vizzing their final interview dashboard. So let’s take a look at what it took to get into DS34

Data

Week 2 presentation: what I did and why!

Aug 12, 2022 Ben Winsey | www.thedataschool.co.uk

A recap on week 2’s presentation, the task and how it went!

Data

Week 2: Project Time

Aug 12, 2022 Hannah Laughton | www.thedataschool.co.uk

Time to draw on what we have learnt this past week; data visualization best practice & calculations and techniques.

Data

Week 2 Presentation: Reworking my application Viz with my current (minim...

Aug 12, 2022 Arnold Quarcoo | www.thedataschool.co.uk

A blog outlining the various changes that I made to my application viz using the new techniques I have learnt.

Data

Week 2 Presentation: My Application Viz and Improvements

Aug 12, 2022 Cammy Phillips | www.thedataschool.co.uk

Using everything I have learnt so far, I spent my second Friday at the data school adapting my application viz. So here are a few things that I have learnt and how I have implemented them into my viz.

Data

Out with the Old, In with the New.

Aug 12, 2022 Carol Mhlanga | www.thedataschool.co.uk

Implementing sets and parameters to improve our application Viz.

Data

Introduction to SQL

Aug 12, 2022 Imogen Emmett | www.thedataschool.co.uk

What is SQL and what is it used for?

Data

From then to Now

Aug 12, 2022 Lauren Halliwell | www.thedataschool.co.uk

Since I came to the data school almost 2 weeks ago, I have learned so much! I have prepared data in both Tableau prep and Alteryx, learned about data Architecture and why it is so important, and to go back to what we started with…we learned best p...

Data

Tableau Relationships: LODs

Aug 12, 2022 Sebastian Deptalla | interworks.com

LODs (Level of Detail expressions) are not the easiest topic in Tableau, though they are a glorious one! It took me some time to get the hang of it, but today I don’t want to miss them. What they do – in a nutshell –…The post Tableau Relationships...

Data

Can you build a dumbbell chart?

Aug 12, 2022 Donna Coles | donnacoles.home.blog

Week 32 of #WOW2022 and Kyle set this challenge to build a dumbbell chart (also sometimes referred to as a barbell chart, a gap chart, a connected dot plot, a DNA chart). I first built one of these a long time ago, and have built many since, so ch...

10 Methods for Displaying Variance with Bar Charts

Aug 11, 2022 VizWiz (noreply@blogger.com) | www.vizwiz.com

Using variance as a measure in bar charts helps you:Add context - You can answer the question “compared to what?”Make decisions - You can answer the question “what should we do next?”Alert you to areas that need focusIn this video, I show you 10 w...

alert,barchart,barinbar,bulletgraph,context,deviation,divergingbarchart,floatingchart,indicator,populationpyramid,sidebysidebar,sparkbars,sparklines,tableau,tip,variance

The Data School Deutschland startet durch!

Aug 11, 2022 Dirk Strobel | www.thedataschool.co.uk

Die Data School in Hamburg sucht stets neue Kollegen*Innen - sammelt jetzt Arbeitserfahrung im Bereich Data Analytics!

Data,TableauCalculations

Splitting Columns in Tableau

Aug 11, 2022 Cammy Phillips | www.thedataschool.co.uk

How to separate a column from installed data in tableau

Data,TableauCalculations

Reference Lines with Variance

Aug 11, 2022 Angelica Obi | www.thedataschool.co.uk

If you have a target you are trying to meet and you want to see your progress, you might want to create a chart with a reference line.

Data,TableauCalculations

#HowTo Sheet/Chart Swap Using Parameters

Aug 11, 2022 Carol Mhlanga | www.thedataschool.co.uk

Sheet swapping is useful when you want to switch between sheets with different chart types. Its also a fancy and effective way to save space on your dashboard!

Data,TableauCalculations

Dynamic Sorting

Aug 11, 2022 Hannah Laughton | www.thedataschool.co.uk

Dynamic sorting allows users to interact with the data by applying various filters simultaneously. Let’s see how this is achieved!

Data,TableauCalculations

Creating a Dynamic Reference Line

Aug 11, 2022 Finn Charlton | www.thedataschool.co.uk

Learn how to create a dynamic reference line, a simple use case for parameter actions.

Data,TableauCalculations

Combined vs Dual Axis

Aug 11, 2022 Arnold Quarcoo | www.thedataschool.co.uk

Main difference between a combined and dual axis & a short tutorial on how to create both.

Data,TableauCalculations

Calculating a Moving Average is better than Average

Aug 11, 2022 Lauren Halliwell | www.thedataschool.co.uk

Lets say you want to show a moving average on a line chart in tableau where you are able to change the number of days.

Data,TableauCalculations

ATTR, is all of the confusion worth it?

Aug 11, 2022 Ben Winsey | www.thedataschool.co.uk

An explanation of what the attribute function is, and how it can be useful.

Data,TableauCalculations

Tableau Join Calculations

Aug 11, 2022 Ollie Linley | onenumber.biz

How do you join two tables together in Tableau when they don’t share the same common field? Or what if that common field is slightly different in both tables? A Join Calculation can help solve a lot of those problems! In this video, we take a look...

Data,TableauCalculations

Ten Tips & Techniques: Round 5

Aug 11, 2022 Kevin Flerlage (noreply@blogger.com) | www.flerlagetwins.com

 Well, I’ve done four previous Ten Tableau Tips blog posts, how about a fifth one?  I hope at least one tip is something you’ve never seen before.Please note that some of these GIFs may appear small on screen.  They are, however, recor...

How-To,Tableau