Anaytics, Big Data, Cloud

Improving query performance in Snowflake and its related costs

In the previous blog we understood how to Optimally use Snowflake Warehouse and Tables. So let’s continue the blog series, where we will now focus on improving the performance in Snowflake and its associated costs. As we know, Snowflake tables are micro-partitioned, which significantly improves query performance. However, over time, you may experience slowness in […]

May 15, 2023

Big Data, Data & Analytics, Industry Buzz

Our experience through Data Engineering Summit 2023 in Bengaluru

AI is everywhere, but there’s less attention to the engine running behind it. Data Engineering is what makes the right data available at the right time for all these AI use cases. Happy that someone thought about it and organized this 2-day event DES2023, focused on Data Engineering in Bengaluru, where we got to hear […]

May 4, 2023

Anaytics, Big Data, Cloud

Optimal use from Snowflake Warehouse and Tables

In the previous blog, we discussed the Best practices to be followed while Data loading into Snowflake from Stages. Continuing the snowflake blog series lets us understand how to use Snowflake Warehouse and Tables optimally. Snowflakes Virtual Warehouses Virtual Warehouses is one of the critical components in Snowflake architecture and deciding the correct configurations for […]

March 30, 2023

Anaytics, Big Data, Cloud

Best practices and hacks for Data Loading in Snowflake from Stages

Continuing our Snowflake blog series, after learning about setting up a  Snowflake account using System-defined Roles, we will explore the best practices for loading data from a file into Snowflake. Let’s begin.. Snowflake supports file-based data ingestion through Internal and External stages.  However, there are various factors to consider when performing data ingestion, including the […]

March 16, 2023

Anaytics, Big Data, Cloud

Snowflake Account setup using System defined roles

This is the first blog in a series that will focus on Snowflake, where we’ll cover best practices for using Snowflake, explore various Snowflake functionalities, discuss how to maximize the benefits of Snowflake, and address the challenges that come with its implementation or migration. In this blog, we’ll start by discussing setting up a Snowflake […]

February 16, 2023

Data & Analytics

Ticket Classification System

1. Introduction With the increase in mobile users, customers are contacting businesses through a variety of channels, including social media sites, review websites, email, and live chats at any time of day, which increases the number of requests and complaints generated. When a problem or support request arrives at the ITSM Ticketing tool, it must […]

February 12, 2023

Anaytics, B2B, Big Data

GA4 Migration – Step up your Analytics Game

What’s up with this Google Analytics 4? Is it worth implementing? How exactly will it enhance our existing processes? How to get started with it?  Announcing GA4, Google had this to say: “To help you get better ROI from your marketing for the long term, we’re creating a new, more intelligent Google Analytics that builds […]

April 7, 2022

Anaytics, Big Data, Data & Analytics

GA4 vs Universal Analytics: What is the Difference?

With the arrival of Google Analytics 4, there is a new ecosystem in the world of Google Analytics. With the current Google Analytics Universal Analytics firmly established as the most used Analytics platform, it is a challenge for most businesses with existing Universal Analytics setup and also new businesses who want to implement a new […]

March 31, 2022

Anaytics, Big Data, Data & Analytics

GA4 vs Universal Analytics – Can you migrate to GA4?

Google Analytics Universal Analytics is largely an ecosystem that is session based. Meaning that it tracks user activities in a single sitting. This single sitting is defined as the time a user spends sitting on his/her computer and performing activities on your website. This single sitting spans for a time period before the user turns […]

March 24, 2022