Red Pill Analytics, Author at Red Pill Analytics

This captivating image showcases a symbolic interaction between a robotic hand and a human hand, forming a heart shape amidst a neon-lit, cyberpunk cityscape. It visually represents the harmonious blend of human creativity and advanced AI technology in the field of agile project management. The image highlights the theme of the blog, discussing how generative AI technologies are increasingly integrated into Scrum methodologies to enhance collaboration and innovation in project teams.

Generative AI’s Unexpected Romance with Scrum

by Kristi Smith Hey there! If you’re a Scrum team member in the software development world, you’ve probably found yourself knee-deep in Scrum meetings, wondering if there’s a better way to handle all those sticky notes and ceremonies. Even rock-star Scrum teams hit roadblocks — those marathon meetings, communication snafus, and admin work that steals precious time. […]

Generative AI’s Unexpected Romance with Scrum Read More »

Agile, AI, project management

A classic DeLorean DMC-12 flying through a snowy landscape, leaving behind glowing snowflake trails instead of traditional time-travel streaks. This visually represents the concept of Snowflake time-based tables, symbolizing dynamic data sequencing and structured time intervals in Snowflake’s cloud data platform.

How to Create Dynamic Time-Based Tables in Snowflake

By Deiby Gómez In data analysis and reporting, handling time-based data is crucial. Many workflows require the ability to generate and work with time sequences—such as creating calendar tables, tracking events at specific intervals, or managing detailed schedules. Snowflake, a cloud-based data warehousing platform, offers tools to handle these needs through its SQL capabilities. This

How to Create Dynamic Time-Based Tables in Snowflake Read More »

Cloud Computing, Data Warehousing, Snowflake, Snowflake Computing, SQL, Uncategorized

Grand hallway with a black and white checkered floor, symbolizing structured data and open data sources for analytics and business intelligence

Got Technology, Need Data? Here’s the Best Free Data Sources for Analytics & AI

Photo by Cristina Gottardi on Unsplash The Data Challenge Have you ever wanted to assess or explore a new BI, analytics, data visualization, data science, etc. technology, but struggled to find a data set to use for your assessment and exploration activities? Have you grown tired of analyzing the “typical” free data sources–think census, stock

Got Technology, Need Data? Here’s the Best Free Data Sources for Analytics & AI Read More »

Big Data, Business Intelligence, Data Integration, Data Visualization, Free Data Sources, General, Open Data, Public Data Sets, Tips

Silhouette of a person demonstrating how to combine filters in Looker with creative lighting effects.

How to Combine Advanced and Custom Filters in Looker Studio

By Kristi Smith Note: Looker, now part of Google Cloud’s Looker Studio, remains a powerful BI tool for creating dashboards. While this guide focuses on combining filters in Looker, the steps also apply to Looker Studio environments. Matches Advanced Filters I’m constantly impressed with the advanced filter functionality in Looker. It’s so convenient…and fairly intuitive,

How to Combine Advanced and Custom Filters in Looker Studio Read More »

Business Intelligence, Data Analytics, Data Visualization, Looker, Uncategorized

How to Connect to Oracle Database from an AWS Lambda using Thin mode

By Deiby Gómez After exploring How to Connect to Oracle Database using AWS Lambda in Thick Mode, we now move on to Thin Mode. With so many companies using AWS as their Cloud Provider, AWS Lambda is a popular solution to process Serverless Code. This guide was written to help people that need to work

How to Connect to Oracle Database from an AWS Lambda using Thin mode Read More »

AWS, Cloud Computing, Data Integration, Databases, Oracle, Technical Tutorials

Abstract image of floating numbers symbolizing data connectivity between AWS Lambda and Oracle Database

How to Connect to Oracle Database from an AWS Lambda Using Thick Mode

By Deiby Gómez Many companies use AWS as their Cloud Provider to implement solutions, and AWS Lambda is a popular choice for processing Serverless Code. In a world where data is king, it’s common to need to pull or push from Oracle Databases. For that reason, I wrote this guide to help anyone that needs

How to Connect to Oracle Database from an AWS Lambda Using Thick Mode Read More »

Cloud Solutions, Data Integration, Databases, Oracle, Oracle Technology Network, Technical Tutorials

Architectural blueprint and project planning tools for data project specifications, featuring measuring tapes, levels, and drafting equipment on a vibrant orange workspace.

Mastering Data Project Specifications: A Strategic Guide

by André Deroide Data projects are helping organizations gain insights, drive efficiency, and keep a competitive edge in the age of big data. However, the complexity inherent in these projects can easily lead to misunderstanding, delays, misaligned outcomes, and unexpected results. Data Project Specifications serve as a critical roadmap to avoid these pitfalls. This guide

Mastering Data Project Specifications: A Strategic Guide Read More »

project management, Red Pill Analytics Tips, Team Collaboration

Hand holding a rolled-up 20-dollar bill, symbolizing cost management in Snowflake credit consumption

How to Analyze Snowflake Credit Consumption for Cost Management

By Deiby Gómez Cloud-based data warehousing platforms like Snowflake have changed the way organizations store, manage, and analyze their data. But with this power and flexibility comes the challenge of managing costs, especially when it comes to Snowflake credit consumption. Snowflake’s pricing model can lead to unexpected expenses if credit usage is not monitored and

How to Analyze Snowflake Credit Consumption for Cost Management Read More »

Cloud Computing, Cost Management, Data Warehousing, Snowflake

How to Analyze Snowflake Warehouse Performance and Reduce Credit Waste

By Deiby Gómez In this article, we’ll explore how to analyze the load and usage of a Snowflake warehouse to uncover opportunities for reducing credit waste and identifying overloaded warehouses. We’ll use the Prismafy tool, which generates detailed reports in just a few minutes. Prismafy is free to use and supports external authentication, including username/password

How to Analyze Snowflake Warehouse Performance and Reduce Credit Waste Read More »

Data Analytics, Data Warehousing, Snowflake, Snowflake Computing

Turquoise 3D Snowflake icon on a black background, illustrating how to identify Snowflake ACCOUNTADMIN privileges using Prismafy.

How to Quickly Identify Users and Roles with ACCOUNTADMIN Privileges in Snowflake

By Deiby Gómez Wondering how to quickly identify Snowflake ACCOUNTADMIN privileges and the users or roles that hold them? This article will show you how to easily identify them using Prismafy, a free tool that generates detailed reports in just a few minutes. Prismafy supports external authentication, usernames and passwords, and MFA, making it secure

How to Quickly Identify Users and Roles with ACCOUNTADMIN Privileges in Snowflake Read More »

Databases, Security, Snowflake