Geek Logbook

Tech sea log book

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

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

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

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

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

Understanding Stateful vs. Stateless Firewalls in AWS

When working with network security, it’s crucial to understand the difference between stateful and stateless firewalls. In AWS, this understanding is particularly important when configuring security groups and network access control lists (ACLs). Stateless Firewalls A stateless firewall handles each packet independently, without remembering any information about previous packets. This means that you must explicitly

Creating a Custom Column with SWITCH in Power BI

In Power BI, creating custom columns based on multiple conditions is a powerful way to enhance the analysis and presentation of your data. One of the most versatile functions for this purpose is SWITCH, which allows you to apply different transformations or categorizations based on specific values in another column. In this blog post, we