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

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.

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

Load CSV file from S3 to NEO4J

If you try to load data from S3 to NEO4J you are going to need to presing the file. So you need to expose the data to somebody that have the file. So, first you need to presing the file: aws s3 presign s3://rohank/actors.csv And then you can load the data on your NEO4J Instance:
Read More

Agro Analytics Datasets

Looking for data set to put into practice some knowledge about Agroanalytics, I find some interesting challenges: There are a lot of courses about it, for example, at Wageningen University (In fact, there are some exciting courses in @edXOnline) But, I’ve had some problems in getting valuable Agro Analytics datasets to work or play in
Read More

What is Whale Alert

Whale alert is a blockchain tracker, which reports interesting transactions. Especially the larger ones.  It is a process that follows the blockchain transaction to know if the transfer value exceeds a certain limit considered important. As Whale alert said on its webpage: “At Whale Alert we track these transactions made on various blockchains, convert them
Read More