The Data School Blog

An Overview of the Different Types of Macros

An Overview of the Different Types of Macros

Macros are an interesting part of Alteryx that falls under the program's 'Interface' tool branch. They allow you to create customized tools that perform a specific analytic process repeatedly without the need for its' replication and can be saved and used across...

read more
Presentations – Best Practices: Part II

Presentations – Best Practices: Part II

Getting Ready for Presentations: Part II Quite some time ago now I made one of my first blog posts. This blog post explored my initial thoughts about presentation preparation best practices when first joining the data school. I hope to now improve on those initial...

read more
What did Donald say?

What did Donald say?

What did Donald say? Today was presentation day. The task was to connect to some data via an API and extract some of Donald Trumps most famous quotes. My goal once I had extracted the data was to build a dashboard showcasing some metadata surrounding the quote. I...

read more
Overview of Appends, Joins, and Unions in Alteryx

Overview of Appends, Joins, and Unions in Alteryx

Data comes in many shapes, sizes, and forms, and one of the most common occurrences of its' presentation is when it's provided for analysis in a multitude of different tables. This is once it has already been cleaned and transformed in a way that makes sense and is...

read more
How to use APIs in Alteryx

How to use APIs in Alteryx

Introduction APIs are an essential tool for accessing data and at first glance may seem extremely confusing.  I thought so at least and up until this last week at The Data School I was dreading having to learn about APIs.  However, I was pleased to find out that they...

read more
Important DAX Functions – How and When to Use Them

Important DAX Functions – How and When to Use Them

DAX DAX is an important query language used in Power BI that we've been learning during the last week of our training. While it's been difficult to wrap our heads around it exactly, the hope is that as we continue to use it, we'll get more and more comfortable with...

read more
My Three Favourite 25 Days of DAX (Power BI)

My Three Favourite 25 Days of DAX (Power BI)

Introduction Continuing on from last weeks blog on context in Power BI, this week our presentation was to choose one of the 25 days of DAX challenges and present our solution.  In this blog I will go through the solutions for three of my favorite DAX challenges. ...

read more