Introduction One of the fascinating aspects of Hinduism is its complex and multifaceted approach to understanding the nature of reality, including the flow of time. …

Ever used “updated” or “yolo” as a commit message? Discover how we can harness OpenAI to craft insightful and engaging commit messages automatically. Dive in! We’ve all been there. 7 PM, eyes bleary, fingers tired, and just one more commit before closing the computer. But what to name it? “yolo”…

Explore how we used GitHub Actions and Google Cloud Run to simplify our workflow, transitioning from a traditional dev/prod environment to an efficient preview/prod one. Let’s dive in! Introduction Adapting to the rapidly evolving tech landscape calls for more fluid and robust deployment workflows. Traditional dev/prod environments, while standard in many…

Simplify pull request reviews with the power of OpenAI’s ChatGPT API and GitHub Actions. Automate code analysis, receive valuable recommendations and expedite the review process with ease. Introduction As a tech lead, one of the challenges you often face is reviewing numerous pull requests from engineers seeking your expertise. This process…

Discover how OpenAI can transform your investment strategy. From data extraction to insightful analysis, we’ll show you how to harness the power of artificial intelligence to optimize your portfolio. Introduction A few years ago, I delved into the fascinating world of cryptocurrencies and found myself captivated by the possibilities they offered…

This article showcases how to use natural language to build a simple mental health tracking app in Python. It demonstrates the use of Streamlit, SQLite, Plotly, and other libraries, and how they can be used to gather user input, perform analysis, and provide visualizations with guidance to the user. Introduction This…

A Step-by-Step Guide to Mastering Data Modeling through Effective Collaboration Data modeling, an essential skill in every data engineer’s toolkit, bridges the gap between technical and non-technical stakeholders. In this article, we’ll explore how to conduct effective workshops with business teams to create outstanding data models. …

In this article, we discussed the benefits and drawbacks of using SQL for Period Over Period analysis, including data consistency and limitations in flexibility. Setting Up the Example Dataset We’ll start by creating a fake table and populating it with random data to simulate a sales dataset. CREATE TABLE looker_scratch.sales_by_ticket ( store_id INTEGER NOT…

This article delves into entity-centric data modeling for analytics, showcasing its benefits in streamlining data processing and enhancing analytical capabilities. Through practical examples, we demonstrate how to create tables, calculate advanced KPIs, and optimize data structures for improved insights, ultimately empowering businesses to make data-driven decisions for success. Entity-centric data…