Hackers and Slackers

Data

All things data related. Pretty much redundant, considering this is a blog about data.

Create a REST API Endpoint Using AWS Lambda

Use Python and MySQL to Build an Endpoint

Now that you know your way around API Gateway, you have the power to create vast collections of endpoints. If only we could get those endpoints to actually receive and return some stuff.

We'll create a GET function which will

AWS Author imageTodd Birchard Author imagetodd Oct 29
Read

I Owe My Job to Mr. Robot

Entering the Dataverse

What's up data gang? If you've been reading along throughout this journey, you'll realize that all of my posts have something in common (other than Excel...smartass), they all assume that you're already working with data...even if it's just

Data Author imageMax Mileaf Author imagesnacks Aug 14
Read

Hacking Tableau to Handle ETL Workflows

Weaponizing APIs against tyrannical software

Before we get into the specifics of how to sadistically abuse Tableau, let's clear the air: there's something about inaccessible, expensive, proprietary enterprise software that tends to put me in a touchy mood. As we know, B2B software pricing has

Tableau Author imageTodd Birchard Author imagetodd Aug 03
Read

Data Could Save Humanity if it Weren't for Humanity

A compelling case for robot overlords.

A decade has passed since I stumbled into technical product development. Looking back, I've spent that time almost exclusively in the niche of data-driven products and engineering. While it seems obvious now, I realized in the 2000s that you could

Data Author imageTodd Birchard Author imagetodd Jul 20
Read

Extract Massive Amounts of Data from APIs in Python

Abusing APIs for all they’re worth

Taxation without representation. Colonialism. Not letting people eat cake. Human beings rightfully meet atrocities with action in an effort to change the worked for the better. Cruelty by mankind justifies revolution, and it is this writer's opinion that API limitations

Python Author imageTodd Birchard Author imagetodd Jul 04
Read

Yes...If(And))

Adventures in Excel

If you've been following along on our proverbial Hogwarts for budding Excel wizardry, you would know that we recently crossed an important Rubicon upon which all Excel, and indeed all computer programming languages are built: The mighty IF statement. Remember,

Excel Author imageMax Mileaf Author imagesnacks Jun 20
Read

Extending Your App with MongoDB Stitch

Building a JIRA Board Widget, Pt 2

Greetings and welcome to another episode of wasting your summer building apps. Today we'll continue our quest of embedding a JIRA Kanban board, but we'll be focused mostly on integrating with MongoDB Atlas and its seemingly undersold counterpart: MongoDB Stitch

NoSQL Author imageTodd Birchard Author imagetodd Jun 04
Read

JIRA Analysis in Tableau

Building a JIRA Board Widget, Pt 1

Greetings to all my feathered friends upon this fine Memorial day weekend. Seeing as how you're here, it appears as though we have a lot in common. Namely, we've chosen to spend our three-day weekends on the internet, as opposed

Tableau Author imageTodd Birchard Author imagetodd May 27
Read