Azure data service platforms overview
As you may know, Sql server is one of the first database management systems for both operation and analytical purposes in data warehouses. As time goes by, as more and more cloud service providers start to appear, people seem to forget where they started when…
SQL do’s and don’ts
Originally posted here SQL do’s and don’ts Why bother? When I first learned SQL, my mindset was mostly “Meh, if it runs, it’s done”. Over time and with some reality checks, I have gone to the opposite of the spectrum and learned to — for…
Data Deduplication with ML
Problem Statement Briefly, we work with a company and they allow their customer to sign up for account. The company has so many branches, and one customer can open one (or more) account(s) at any branch. As a result, duplication happens, so here we are….
RFM model and user segmentation built on Looker
As Data and Business analysts, we have all encountered situations where we need to segment customers based on their engagement with the business. An RFM model has a few benefits. It enables marketers to increase revenue by targeting specific groups of existing customers called “segments”….
Data modeling pitfalls and where to find them
There are many works related to the data modeling task – technical side and business side of things, below are some important lessons I have learned along the way implementing data projects, as DA and AE. This post aims to draw some conclusions on the…
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…
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…