How to migrate dashboards from Tableau to dbt and Looker
Things you need to be aware Workflow Tableau uses structured and unstructured data to create visualizations and has the added features of storyboarding and Spatial File Connector. Looker creates customized visuals and also allows you to choose from a library full of blocks with pre-made dashboard and visualization templates. Being one of the first and […]
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 dataset so that we could gain confidence in every extracted […]
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 API documentation 3.2. Get data from Pokemon table 3.2.1. The […]
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 access to data is essential to protecting your data. […]
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 data to grow your team’s capabilities and deliver more […]
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 their customer data. A common theme I encountered during this […]
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 to poor outcomes and wasted resources and undermine future initiatives. […]
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, aka data modeling. The folks at Fishtown create an amazing […]
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 and more, and I started wearing different hats in […]