hanykowska

All things data and more by Hanna Nykowska

  • Home
  • About
  • Tableau
  • Alteryx
  • Videos
Created by potrace 1.16, written by Peter Selinger 2001-2019

How to turn macros into custom Alteryx tools

If you like to build macros to make your life easier and want to take it to the next level, you’re in the right place! Learn how to turn macros into custom tools.

The Information Lab Blog The Information Lab Blog

How To in Alteryx: Multi-Row Formula Tool for Rank

Not sure how to leverage Multi-Row Formula Tool? In this short video, I’ll show you how to use it to rank data. First published on The Information Lab YouTube channel

The Information Lab YouTube The Information Lab YouTube

How To in Alteryx: Multi-Row Formula Tool for Filling Missing Data

New to Multi-Row Formula Tool? Or maybe not new but still a bit confused? Learn how to use it to fill in missing data in 5 minutes! First published on The Information Lab

The Information Lab YouTube The Information Lab YouTube

Python Tool in Alteryx: Deduplicating Images

New to python tool in alteryx or python in general? Here’s a step by step description of how I built an app that identifies duplicate images and moves them to a new location.

The Information Lab Blog The Information Lab Blog

The Index Trick - London TUG Summer Sessions

Briefly explaining what the Index Trick is all about during London TUG Summer Sessions. First published on YouTube

YouTube YouTube

Tableau Tip: The INDEX Trick

I wanted to share something that I have found very useful in the past year. What I have in mind, is something I call ‘the Index trick’. First published on The Information Lab

The Information Lab Blog The Information Lab Blog

How to build Chord Chart in Tableau with Table Calculations and LODs

Want to build a chord chart but don’t have access to fancy data preparation tools? I got you covererd! First published on The Information Lab Blog.

The Information Lab Blog The Information Lab Blog

Connect to Spotify API with Alteryx

The authentication process for Spotify API is a bit tricky. I thought I’d make your life easier so that you could start using this API yourself! First published on The Information Lab Blog.

The Information Lab Blog The Information Lab Blog

Tableau Tip: Highlight Table with Info Icons

Oh, so you want detailed data in form of highlight table that includes info button for each row? I got you covered! First published on The Information Lab Blog.

The Information Lab Blog The Information Lab Blog

How to: Automated Alteryx Reports

Say you have data that gets regularly updated and you need to send those updates to multiple people. Build automated reports with Alteryx! First published on The Information Lab Blog.

The Information Lab Blog The Information Lab Blog

DS13 seating analysis

As we have finished our final presentations, there is one thing that’s left. The seating plan. First published on The Data School Blog.

The Data School Blog The Data School Blog

Tableau (Server) Tip: Intro to User Filters

What are user filters and how can you start using them. First published on The Data School Blog.

The Data School Blog The Data School Blog

The peaks of the Data School

It’s the very last week of training for DS13. It was a crazy ride but fun at that, so here are my top moments of being at the Data School so far. First

The Data School Blog The Data School Blog

Tiny Tableau Tip: how to use a colour palette with a dummy field

Can you use the saved colour palettes without picking the screen colour or copying the hex codes? Keep on reading. First published on The Data School Blog.

The Data School Blog The Data School Blog

What’s it like being a Project Manager: let’s get personal

In one of my previous blog posts, I wrote some tips on project management. But I didn’t really share my personal experience. Let’s get personal. First published on The Data School Blog.

The Data School Blog The Data School Blog

Tableau LODs: include and exclude

Continuing on my post on FIXED LODs, I wanted to shed some light on INCLUDE and EXCLUDE Level of Detail expressions. First published on The Data School Blog.

The Data School Blog The Data School Blog

How to Start with Alteryx Designer

A few people have asked me how to start their journey with Alteryx and so I decided to write down what I know. First published on The Data School Blog.

The Data School Blog The Data School Blog

16 Practical Tips on Project Management

The practical lessons I’ve learnt during my time as project manager. First published on The Data School Blog.

The Data School Blog The Data School Blog

Dashboard Week Day 2: Annihilation by Infographic

Dashboard week day 2! Looking at deaths among the avengers while building an infographic. First published on The Data School Blog.

The Data School Blog The Data School Blog

Intro to Tableau LODs (fixed)

Trying to understand Level Of Detail (LOD) expressions in Tableau? You’re in the right place. First published on The Data School Blog.

The Data School Blog The Data School Blog

Custom shapes in Tableau (hand-drawn and downloaded with Alteryx)

How to get custom shapes in Tableau using hand-drawn images and those downloaded in bulk with Alteryx. First published on The Data School Blog.

The Data School Blog The Data School Blog

Teaching Tableau

My experience with teaching Tableau to others: public and another cohort in person, and public via webinar. The Good, the Bad and Lessons Learnt. First published on The Data School Blog.

The Data School Blog The Data School Blog

Makeover Monday 2019w16 – bars bars (bars)

Looking at #makeovermonday 2019w16: word use in the ‘Info we Trust’ book by RJ Andrews First published on The Data School Blog.

The Data School Blog The Data School Blog

Scheduling Alteryx workflow that updates data used in Tableau

How to schedule Alteryx workflow and keep your Tableau dashboard up-to-date? First published on The Data School Blog.

The Data School Blog The Data School Blog

Unzipping files in Alteryx

How to automatically unzip files in Alteryx using download tool and dynamic input First published on The Data School Blog.

The Data School Blog The Data School Blog

Makeover Monday 2019w14: 2 metres of cotton buds

Looking at makeovermonday 2019w14: the good the bad and how to improve First published on The Data School Blog.

The Data School Blog The Data School Blog

Makover Monday 2019w13 – What do Millennials spend their money on?

Looking at makeovermonday 2019w13: the good the bad and how to improve First published on The Data School Blog.

The Data School Blog The Data School Blog

Alteryx Certification: Designer Advanced Exam

Describing my experience with passing the Alteryx Designer Advanced Certification, together with some tips for interested. First published on The Data School Blog.

The Data School Blog The Data School Blog

Tiny Tableau Tip: How to get rid of the map background

A tiny tableau tip on getting rid of the map background, very useful when you’re building a dashboard with a coloured background. First published on The Data School Blog.

The Data School Blog The Data School Blog

MakeoverMonday 2019w12

My first blog on makeover monday; describing the good and the bad of original viz and how I tried to make it better First published on The Data School Blog.

The Data School Blog The Data School Blog

Attending VizForSocialGood Hackathon – what is it and why is it worth going to

A description of viz for social good hackathon from the perspective of an attendee: what is it and why is it worth going to. First published on The Data School Blog.

The Data School Blog The Data School Blog

Tableau Tip: Map Drill-Down

Tableau tip on creating a drill down map using a simple filter action. First published on The Data School Blog.

The Data School Blog The Data School Blog

Alteryx Certification: Designer Core Exam

Short summary of Alteryx Designer Core Exam from my perspective and what helped me pass it. First published on The Data School Blog.

The Data School Blog The Data School Blog

Tableau Tip: Tooltip Viz

Short tutorial on how to create a tooltip viz that is susceptible to dashboard actions First published on The Data School Blog.

The Data School Blog The Data School Blog

Alteryx Challenge: Macros

Alteryx Challenge update: I’m describing the macros-related weekly challenges. First published on The Data School Blog.

The Data School Blog The Data School Blog

Tableau Tip: dynamic date level aggregation

Quick way of creating a dynamic date level aggregation using a parameter. First published on The Data School Blog.

The Data School Blog The Data School Blog

Preppin’ Data: Week 2 Recap

Summary of the week 2 Preppin’ Data challenge. First published on The Data School Blog.

The Data School Blog The Data School Blog

Alteryx Challenge: Data Cleansing

Tips for Data Cleansing challenges and an update on Alteryx Challenge (finishing all Weekly Challenges by the end of DS training) First published on The Data School Blog.

The Data School Blog The Data School Blog

Tableau Tip: Calendar View (Part 4)

If you want to build a 12-month calendar in one view in Tableau, you’ve found the right place. (I even explain how to add month labels!) First published on The Data School Blog.

The Data School Blog The Data School Blog

Tableau Tip: Calendar View (Part 3)

3rd in the series, this blog post describes how to deal with missing data in dates. For a 12-month calendar tutorial, go to Part 4 (link in this post as well) First published

The Data School Blog The Data School Blog

Tableau Tip: Calendar View (Part 2)

Part 2 of calendar magic AKA tutorial on creating a horizontal calendar view. First published on The Data School Blog.

The Data School Blog The Data School Blog

Tableau Tip: Calendar View (Part 1)

A tutorial on creating a calendar view to visualise your date-related data. First published on The Data School Blog.

The Data School Blog The Data School Blog

Tableau Tip: copy and paste data from a data source already in Tableau

Why and how would you copy and paste part of a dataset that is already loaded to Tableau? Keep reading. First published on The Data School Blog.

The Data School Blog The Data School Blog

Alteryx Challenge: Dates

Second in the Alteryx Challenge series. Tackling my experience with dates. First published on The Data School Blog.

The Data School Blog The Data School Blog

Alteryx Challenge: Intro to Alteryx

First post in the Alteryx Challenge series, where I describe the tools I’ve used for Weekly Challenges and some tricks I’ve learnt. First published on The Data School Blog.

The Data School Blog The Data School Blog

Week 1 done, 15 more to go

Intro to Alteryx Weekly Challenges and a challenge I created for myself. First published on The Data School Blog.

The Data School Blog The Data School Blog

Overambition, fear of failure and impostor syndrome: welcome to my brain

Seemingly, listening to other people talk about their struggles and how they deal with or even overcome them is actually quite helpful. With that in mind, I thought I’d share some of my

The Data School Blog The Data School Blog
hanykowska © 2021
Proudly published with Jekyll & GitHub Pages using Jasper2
Latest Posts LinkedIn Twitter