Geek Logbook

Tech sea log book

Recent Posts

Categories

#50projectsIn50days Amazon Web Services AWS Azure Batch code Coders At Work Computer Science cron Data Databases DataScience Django Eda Edsger W. Dijkstra Excel Git Google Hadoop Hellerstein Javascript Jinja Knowledge Transfer Learning MVC Networking Networks Protocols Notes on Structured programming PHP Power Bi Powershell Python Redash Social Skills Software Developer Spark: The Definitive Guide SQL SSH Testing The Elements of Programming Style The humble programmer Traversy Media Understanding Distributed Systems Web Development Yaml

Archives

Understanding the Evolution of Data Warehousing: From Codd’s Relational Model to Modern Data Warehouses

Data management has undergone significant transformations since the advent of the relational model by Edgar F. Codd. Today, data warehouses stand as a cornerstone of modern data analytics. This blog post explores the differences between Codd’s relational model and data warehouses, highlighting their unique roles and applications in data management. The Relational Model: A Brief
Read More

Troubleshooting Import Errors in Python: A Case Study

Python’s modular design allows developers to break their code into smaller, reusable components. However, import errors can often disrupt the flow, especially in complex projects. In this post, we’ll discuss a real-world example of resolving an import error while working on a Python project. The Scenario The project’s directory structure is as follows: The file
Read More

How to Rename a Git Branch Locally and Remotely

Renaming Git branches can be necessary when adhering to naming conventions or correcting errors. This guide will walk you through the process of renaming a branch locally and remotely. Scenario: You accidentally pushed a branch named old-branch-name to the remote repository but realize it should follow the convention feature/new-branch-name. Steps to Rename the Branch 1.
Read More

Creating Dynamic Dates in Excel: A Practical Guide

When working with Excel, you may encounter situations where you need to dynamically generate a date using the current year, a specific month, and a day. This post will guide you through creating such dates effectively using Excel formulas. The Challenge: Generating a Dynamic Date Suppose you want to dynamically generate a date representing November
Read More

How to Simulate Column Headers Without Selecting from a Table in SQL

In some cases, you may want to produce a result set with specified column names and values without querying an actual table. This is often used for testing purposes, documentation, or even when preparing expected structures for applications that expect specific column headers. Here’s how to do it effectively. Sample Query: Returning Named Columns Without
Read More

How to Create a Date Table in Power BI Using DAX

Introduction In Power BI, a Date Table is essential for working with time series data effectively. A well-structured Date Table simplifies time-based analysis, allowing you to filter by specific periods, calculate year-over-year changes, and much more. This guide will walk you through creating a Date Table from scratch using DAX. 1. What is a Date
Read More

Parsing Complex Data from HTML Tables with Python

When working with web scraping, you often encounter scenarios where HTML content is nested or contains encoded data within JavaScript attributes. This post walks through parsing player statistics from a complex HTML table, utilizing Python and the BeautifulSoup library to streamline the extraction of JSON data hidden in JavaScript functions. Project Overview We have an
Read More

Comparative Investment Analysis of Invesco and Blackstone Using Python

Introduction In this post, we’ll explore how to use Python programming to compare the performance of two investment firms, Invesco and Blackstone. Invesco is known for its focus on public asset management, while Blackstone specializes in private equity, actively acquiring and managing companies. We’ll examine some key performance and risk metrics to understand how these
Read More