Geek Logbook

Tech sea log book

Recent Posts

Categories

#50projectsIn50days AgroAnalytics Airflow Amazon Web Services AWS Azure Batch code Coders At Work Computer Science CSS Data Databases DataScience Django Edsger W. Dijkstra Excel Finantial Data Google Hellerstein Javascript Jinja Knowledge Transfer MVC Networking Networks Protocols Notes on Structured programming People Analytics 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

Month: November 2024

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