0 - General dbt Fundamentals dbt Developer Hub 1 - Who is an Analytics Engineer? Traditional Data Teams Data Engineers Data Engineers are in charge of building the infrastructure that data is hosted on, usually databases. DE also manage the ETL process to ensure data is where it needs to be, and in tables for Data Analysts to query. Skill set for Data Engineers include SQL, Python, java, other functional programming languages....

I read about some social rules on the internet, and thought this would be a good idea to collect some of these general ideas, and organise my thinkings in this area. According to Wikipedia , Social Rules, or Social Norms, are shared standards of acceptable behaviour by groups. Social norms can both be informal understanding that govern the behaviour of members of a society, as well as codified into rules and laws....

TL;DR Early preparation and repeat communications are the keystones for high team engagement. A 2-days Team off-site is a good balance between team engagement, agenda and budget. Relative loose agenda will help the team to know each other better, especially people from different offices. Organising Team Off-site for multiple offices is not an easy job, it needs lots of planning, preparation, coordination, and contingency plan. Sponsorship from external vendor is not essential, but good to have....

This week I got a task to randomly generate pairs based on a name list. After googling on the internet, I found a perfect solution to achieve my goal. Here are the detailed steps to achieve a random pair of two, and it’s easy to adjust to your specific needs. All the example data and formula can be found in this Google Sheet: Random Pairs . Steps Step 1 - Generate random numbers using RAND() Firstly, we need to generate a random number against each name, we can use the RAND() function to achieve that....

In the previous post around Effective Meetings in Workspace , I talk about some general best practice about a productive meeting. Normally a meeting can be organised based on following phrases. In this page, I am going to write down some practical tips for facilitating a productive workshop. Before meeting kick-off In the meeting Post meeting follow-up Before Kick-Off Preparation. Get to the meeting room if you have. Get yourself a cup of water if you need....