Geek Logbook

Tech sea log book

Recent Posts

Categories

#50projectsIn50days Amazon Web Services AWS Azure Batch CAP code Coders At Work Computer Science cron Data Databases Data Format DataScience Django Docker Eda Edsger W. Dijkstra Excel Git Google Hadoop Hellerstein Javascript Knowledge Transfer Learning Linux Networking Networks Protocols 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

Category: Data

Test different data providers to understand the data they give to us and as how to work correctly with this. We have some evaluation about data providers: APIs, enterprise, trading and other tools.

Handling Null Values in Data: Algorithms and Strategies

Null values are a common challenge in data analysis and machine learning. Dealing with them effectively is essential to ensure the reliability of your insights and models. In this post, we’ll explore various strategies and algorithms to handle null values, ranging from simple techniques to advanced methods. 1. Removing Null Values This is the simplest
Read More

Adding Custom Columns to Your Date Table in Power BI

Introduction A Date Table is an integral part of building robust and insightful Power BI reports. While a basic Date Table allows for time-based filtering and analysis, custom columns can add even more depth and flexibility. This blog post will guide you through adding custom columns to your Date Table using DAX. 1. Why Add
Read More

Counting Word Frequency in a SQL Column

Sometimes, you may need to analyze text data stored in a database, such as counting the frequency of words in a text column. This blog post demonstrates how to achieve this in SQL using a practical example. Problem Overview Let’s assume you have a table named feedback with a column comentarios that contains text data.
Read More

Are Indexes a Good Strategy for Analytical Databases?

Indexes are a well-known optimization technique in database management, often associated with improving query performance. However, whether they are a good strategy for analytical databases depends on the specific use case and database architecture. Let’s delve into the topic to understand where indexes shine and where they may fall short in analytical workloads. Indexes: Designed
Read More

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

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 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

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
Read More

Creating a Custom Column with a Random String in Power BI Using DAX

Introduction In Power BI, customizing your dataset by adding calculated columns can significantly enhance your data analysis capabilities. One common need is to generate random strings or categories for testing purposes, simulating scenarios, or assigning values like branch names, IDs, or categories to your data. In this post, we’ll explore how to create a custom
Read More

Resource from Vanguard ETF

Looking for vanguard ETF data is not an easy task. Because there are a lot of pages that need to subscribe or even purchase a subscription. So, we can’t access to free information. I don’t know if this behavior is normal across the industry, or I am thinking wrong about that. Because the composition of
Read More