Mar 7, 2021Member-onlyIntroduction to TerraformJust imagine you are a customer of a cloud provider and you want to spin up some machines, you can go into some web console, fill in some forms, click some buttons and then launch an instance. But you can also use Terraform. Terraform allows you to do the same…Terraform5 min read
Feb 21, 2021Member-onlyCloudFormation 101What is CloudFormation? CloudFormation is a tool which can spin up resources on AWS. If someone wants to be an AWS expert, CloudFormation is an essential service to master. Before we jump into writing a CloudFormation template, let’s have a brief history about how to manage AWS infrastructure before CloudFormation. Without CloudFormation, automating…Business Intelligence2 min read
Jan 6, 2021Member-onlyMedium-Hard Data Analyst SQL questions(Part 1)As we know, the first 70% of SQL is pretty straightforward but the remaining 30% can be pretty tricky. So, in this blog, some popular hard SQL interview questions will be covered for people to sharpen their skills. Self-Join Practice Problems Part 1: How much a key metric, e.g., monthly active users, changes…Sql1 min read
Dec 21, 2020Member-onlySome query samples to interpret Google Analytics data using BigqueryAs a BI Analyst working in an Online Travelling Agency company, interpreting customer behaviors data into meaningful insights is a Business As Usual task. Google Analytics is a popular web analytics service tracking website traffic. …Business Intelligence2 min read
Oct 8, 2020Member-onlySend Google Analytics payload length as a Custom DimensionThe maximum length of a Google Analytics payload is 8192 bytes. It is useful to check if you are approaching this value with some of your hits because if the payload length exceeds this, the hit is never sent to GA. How can we know the payload size with each hit? Today i will show you how to send the…Business Intelligence3 min read
Aug 31, 2020Member-onlyA Fundamental guide about Setting up PySpark For ETLDue to the massive volume of data, Spark is built to handle big data in many user cases. It is an open source project on Apache. Spark can use data stored in a variety of formats, including parquet files. What is Spark? Spark is a general-purpose distributed data processing engine that is suitable…Python3 min read
Jul 18, 2020Member-onlyWhy we need data integration and what can we do?The first question is why we need data integration? Let me give you an example here to answer this question. Every company has many departments, and different departments use different tools to store their data. For example, marketing team may use hubspot tool. Now, we have different departments which store different types of data in a company. However, insightful…Etl3 min read
Jul 3, 2020Member-onlyAn advanced SQL mind mapBefore, i wrote a blog about a basic SQL mind map for people who want to kick-start their career into business intelligence and data…Sql1 min read
Jun 21, 2020Member-onlySome Cloud Computing FundamentalsWhat is cloud computing? The practice of using a network of remote servers hosted on the Internet to store, manage, and process data, rather than a local server or a personal computer. On-premise: You own the servers You hire the IT people You pay or rent the real-estate You take all the risk Cloud…Cloud Computing2 min read
May 24, 2020Member-onlyHow to design a Data Warehouse(Part 1)Last blog I wrote why we need a Data Warehouse. First, what is the data warehouse? It is a centralized relational database that pulls together data from different sources (CRM, marketing stack, etc.) for better business insights. It stores current and historical data are used for reporting and analysis. However, here is the problem: How we can design a Data Warehouse? 1 Define…Business Intelligence3 min read
