Exploratory Data Analysis (EDA) using SQL and Datagrip
Exploratory Data Analysis (EDA) is something that we do pretty frequently. This is the first and foremost step to do at the beginning of any project, before we jump into more sophisticated work like refactoring or modeling. It’s like saying ‘hi’ to your fellow lovely…
How to make basic API requests with Postman
Note: This article is meant for those with little to no knowledge on how to call an API. 1.Purpose 2. Overview 2.1. What is an API? Why using API? 2.2 Types of API 3. Demo: How to call API with Postman 3.1. Structure of an…
Best Practices for Managing Data Access to BigQuery
What to know in terms of security when setting up a data environment in BigQuery. As we rely more and more on our data to make better decisions, data is becoming a critical asset for any organization. So like any other asset of a company, controlling…
How to Measure Your Organization’s Data Maturity
Written by Alex Bratton Most organizations today are struggling with how to advance in their use of data (see our recent article on. The good news is that it’s straightforward (and doesn’t require huge investments in tech and lots of new tech hires) to use…
How to identify the best customers using RFM based segmentation
Written by Satish Chilakala The best customers are not always what we call the high-value customers With some free time at hand in the midst of COVID-19 pandemic, I decided to do pro bono consulting work. I was helping a few e-commerce companies with analyzing…
How and When to Use AI to Augment Traditional Analytics
by Chris Pouliot Every business wants to be more data-driven, and artificial intelligence technologies are an important way to augment traditional statistical analysis. But don’t let the hype around AI persuade you to force it onto problems where it’s not needed. That will only lead…
How to Deploy dbt to Production using GitHub Actions
Written by Tuan Nguyen While dbt Cloud is great, if you want more control for your dbt pipeline, here’s all you need to know. With the rise of the Modern Data Stack, more and more people use dbt as the main tool for data transformations,…
6 Steps To Deal With Daily Email Hurdle
Email is still the core mode of communication in our work and personal life for many of us. When I started with my career, dealing with email is not an issue since I did not get that many emails. However, they started coming in more…
8 Tips to Greatly Enhance Your VSCode Productivity
Getting your way around an IDE is a vital part, whether you are an engineer or an analyst. Watching a senior developer jumping around in Vim or VSCode can be intimidating for people with less familiarity. However, I assure you that there is no magic…
8 Ways Banks Use AI and Machine Learning to Serve You Better
Banks are more sophisticated than ever, using the best technology. Here’s how they’re using AI to make your life easier. You may have seen Pepper the robot in the news. She has been introduced as HSBC Bank’s in-branch greeter and banking assistant. She currently provides…