Sam Loves Coffee

My Titled Second Note

The description

05 December 2022

My Titled Note

The description

04 December 2022

Designing The Daily Scorecard (Part 2)

PowerBI

You can't win without a goal. Here's how I created a scorecard I could check each day to see if I was on track for my yearly focus.

28 February 2022

Designing My Yearly Theme

How I designed my personal goals to set myself up for success, using what I've learned about goal design from my experience working in business intelligence. It was helpful for me, and hopefully it'll be helpful for you too.(Part 1)

14 February 2022

How to connect PowerBI to a Tabular API (and why you shouldn't)

APIs PowerQuery Hacks PowerBI

You can get tabular REST APIs working through liberal use of custom PowerQuery code, and I'll show you how.

31 January 2022

I built a Pikachu classifier because there's way too many of them.

Jupyter Notebooks CNN

Using state-of-the-art convolutional neural networks, we can finally tell the difference between Pikachu and Plusle, Minun, Pachirisu, Emolga, Dedenne, Togedemaru, Morpeko....

18 January 2022

How to build a toggle-able window in PowerBI (even though that's not a feature)

PowerBI Hacks

One common UX issue I’ve had when building PowerBI reports is that stakeholders often want a lot of slicers. It makes sense, having a large read more...

03 July 2021

Does this coffee taste like dirt?

Machine learning SciKit Python Deep learning Jupyter Notebooks

Question: Given the aroma/bitterness/etc of a cup of coffee, can we predict if it will be a ‘good’ cup of coffee as rated by professional read more...

25 October 2019

Seattle is Burning (PowerBI)

PowerBI Visualization

A PowerBI visualization built on Seattle's Open Data Initiative. Looking at real-time fire department data. 🔥

30 September 2019

Automating Outlook and Excel with Python

Python Automation VBA Outlook Excel

One common task I’ve seen as part of an analysts responsibilities is to send out a daily status email about the sales numbers, fiscal projections, read more...

24 August 2019

Predicting rain with Scikit (Machine Learning)

Machine learning SciKit Python

In the olden days of yore, predicting the weather was near-impossible task reserved to fortunetellers and shamanistic figures. People would spend their lives, rather unfruitfully, read more...

13 August 2019

Automating an email log with PowerAutomate

Automation Email PowerAutomate

Love it or hate it, a lot of work is still done through email. Keeping a log of emails and responses can give a massive read more...

12 March 2019

Ethnographic Analysis - Japanese Freeter Culture

Capstone

Freeter (フリーター furītā) is a Japanese term for young individuals (18-35) who pursue only temp jobs, part-time jobs, or are jobless, and describes a unique read more...

29 January 2018

PicFix - A modern 311 app

Capstone

An app to modernize the 311 service request system. Informatics Capstone Project.

12 March 2017

445 Consulting Database

SQL

Fully functional relational database design for a fictional consulting company. Includes multiple stored procedures, business rules, views, and calculated columns. Built using SQL Server.

read more...

06 March 2017

Research Study

Examining the Perceived Credibility of Print vs Digital News. Designed & executed a small study to determine the trustworthiness bias of print & digital media, wrote a whitepaper detailing our findings.

13 December 2016