Notebooks

To know and not to do is not to know - Wang Yang Ming

Notebooks is an ongoing collection of coding exercises, analyses, and data-driven explorations using a range of analytical tools.

2022/09/16 Stock Management with Power Apps, Power Automate and Power BI (Part II)
2022/06/11 Stock Management with Power Apps, Power Automate, and Power BI (Part I)
2021/09/14 €0 Data Integration with Github Actions, FlatData and Neo4j Aura
2021/06/23 Exploring Spotify Play History
2021/01/31 Bootstrapping a Sport-Betting Assistant : Part II
2021/01/02 Bootstrapping a Sports-Betting Assistant : Part I
2020/09/20 ASP.NET Core 5 with MVC: Project Structure and Development Cycle
2020/06/11 LINQ: Method Syntax and Lambda Operators
2020/06/08 LINQ: Joining Queries
2020/06/06 LINQ: Basic Queries and Grouping
2020/03/28 Mars Settlement in Blazor: Part I
2020/02/18 Small Data is More Frustrating than Big Data - A Web Scraping Example
2019/12/16 Building a Bug/Issue Tracker with Shiny & PostgreSQL
2019/10/03 Building a Data Warehouse: R, PostgreSQL, bash, and Task Scheduler
2019/09/23 When are BI Tools Enough?
2019/09/01 Analytics Engineering with dbt and PostgreSQL
2019/08/23 Diving into JSON with the SpaceX API and purrr
2019/04/08 MongoDB via mongolite: Aggregations and Queries
2019/03/20 Database Explorations: PostgreSQL and MongoDB
2019/03/13 Matching Mood to Music: Sentiment Analysis of Chart Hits in the 70’s and 80’s
2019/03/07 Pop Music Geniuses: Stevie Wonder Trumped by Katy Perry?
2019/03/02 Importing Excel Files into PostgreSQL + Querying via R
2019/02/28 Exporting Data from Power BI to PostgreSQL (Powered by R)
2019/02/19 Using Power BI to Analyse 1.9 Million Rows of Call A Bike Data
2018/08/01 Historical Rainfall in Bremen, 1891-2015
2018/06/05 Card Sorting: Removing Replicates
2018/05/12 Territorial Expansion of Wolf Populations in Germany, 2000-2014
2018/03/15 Quick Visualisation: Massive Decline of Insect Abundance In Germany
2018/01/13 Wealth Inequality Can Arise Through Chance Alone: Part 2
2017/12/21 Wealth Inequality Can Arise Through Chance Alone: Part 1
2017/12/10 Wind and Waves in Cape Town: Part 3
2017/11/19 Wind and Waves in Cape Town: Part 2
2017/11/18 Wind and Waves in Cape Town: Part 1
2017/11/12 Bayesian Approaches on Tiny Data
2017/11/06 Computational Art: No 1
2017/06/19 Bulk Downloading German Weather Data