Tag: Data Science
-
R vs Python in Data Work: A Comprehensive Comparison

Today, I want to dive into a topic that often sparks lively debates in the data community: the comparison between R and Python for data work. Both languages have their distinct strengths and are valuable tools in a data professional’s arsenal. Having used both in various production contexts, I’ve seen firsthand how each can shine…
-
Simplify Data Ingestion from HubSpot to BigQuery with DLT Hub and Dagster

I want to dive into an exciting project I recently completed using DLT Hub, a Python library designed to simplify data ingestion and replication. In this project, I built a straightforward data ingestion pipeline that transfers data from HubSpot to BigQuery, leveraging the power of both DLT Hub and Dagster. This project turned out to…
-
Dagster with Spotify Ads API

I work at a marketing agency and reporting from janky marketing tools can be quite the challenge . Spotify Ads is one of those sources that previously required manual csv exports and formatting to report to the client. This process sucked up time that could be spent providing analysis or other higher level value add…
-
Demark Indicators Analysis

Demark Indicators are signals use to predict big trend reversals (buy the dip or sell the rip). The pattern is a very counterintuitive, you can read more here. An interesting person had to have come up with this. In any case, I was interested in this because of how strange it is. Also, as far…
-
Custom Maps with Python

If you’re anything like me, a strategy gamer. You’ve spent way too many hours staring at this view of the Mediterranean. A good map should draw you in. I’m going to give you a quick guide in making one using Python. Github Link The code to make maps is relatively simple thanks to the matplotlib…
-
World War II in the Pacific Visualized

The Story this tells The Importance of Oil Roger said it best. Japan needed oil to fuel their war in China. The decisions to invade Indonesia and attack America were because of oil. and Japan’s ultimate defeat was a result of their industrial capacity grinding to a halt. The Navy and Submarines Amateurs talk about…
-
Webscraping in 15 Minutes

Data Science in a business context, is about leveraging Computing, Statistics, and expert domain knowledge together to solve problems and get results. Using the right tool for the job is where computing comes into play. Process improvement and Automation is the easiest way to create value with Data Science skills especially if you are starting…
-
Taking your SQL to the Next Level

Often when people learn SQL on the job or in school the being with writing queries, doing joins and maybe some update statements. This post is for those that are trying to move to the next level. This post will touch on the concepts data modeling, data normalization, Connecting to a SQL Database with Python,…
-
Web Scraping Data in Python

The internet is a gold mine for data analysts. Whether you are using google trends to identify search patterns, social media postings to judge sentiment, or analyzing company data for a potential investment, it’s all there. The only problem is turning the data into a usable format. HTML (Hypertext Markup Language) is the language that…