Hi. I'm Erik Hanson.
This is my Data Analytics Portfolio.
Check out my recent projects here.
This is my Data Analytics Portfolio.
Check out my recent projects here.
Python, SQL, Google Sheets, and Excel
A compact Python script for fetching data via a GraphQL query and writing it to a CSV file.
Fulamingo needed to place a big order from our favorite Miso-makers. To know what to purchse, I had to aggregate the Shopify sales history from our two sales channels and then clean it up quite a bit.
I made this spreadsheet tool to help a small business save time on their monthly inventory of labelling and packing materials. I'm happy to report that this ended up saving the team hours of tedious work each month!
Data analysis, business solutions, operations, management, and consulting
A multi-channel Japanese Grocery, Sake and Homewares retailer, based in Portland, OR. As a managing partner, I get to work in all aspects of our small multi-channel retail business including management, data analyitics, operations, customer service, purchasing, budgeting, workflow automations, and web admin.
.
A multi-channel specialty grocery retailer, with multiple Oregon locations. As a consultant, I have done various projects including sales and inventory data analysis, inventory management, training, operations consulting, data cleanup, and POS systems administration.
A Japanese konbini-styled deli and retail shop, well known for their deliciously fluffly egg sando. As part of my role as assitant manager, I adminstrated the Shopify POS, performed pricing analysis, assisted in all aspects of operations from product ordering, customer service, sales, food production, marketing, and catering operations.