Data Engineer's diary

Blog about Machine Learning and AI in Digital.

More
DAU

How to calculate Real Active Users. What are the numbers?.

Mike January 06, 2021 140 Comments

Have you ever wondered what are your real DAU numbers? How to identify linked user accounts and users cross using each other devices? Then this article is for you. MAU, DAU, Linked users and Retention: Google Data Studio template and SQL guide for datasets. Feedback is much appreciated. Thanks!

Continue Reading
Visit datastudioguides.com

Datastudioguides.com. How to guides and Data Studio tutorials.

Mike January 31, 2021 14 Comments

Tons of great content on Google Data Studio at Datastudioguides.com . Here, you’ll find what you need to get started. Google Data Studio is a fantastic tool for creating beautiful dashboards and reports. That’s it. It’s easy to use and, perhaps most importantly, completely free. Check their "How to guides".

Continue Reading
Big Query monitoring dashboard

Building a BigQuery monitoring dashboard.

Mike January 06, 2021 140 Comments

I've created a new Data Studio template for BigQuery usage monitoring with report labeling system. Feedback is much appreciated. Thanks!

Continue Reading
Blog Image

Retention and Daily Active Users Explained.

Mike January 06, 2021 140 Comments

I've created a new Data Studio template for User Retention with calendar charts. This is my new article "Retention and Daily Active Users Explained" which explains how to use it. It's a Data Studio guide and BigQuery tutorial for Firebase users, Machine Learning enthusiasts and Marketers. All you wanted to know. Feedback is much appreciated. Thanks!

Continue Reading
Blog Image

Building a static website with forms and blog. Part 3. Lambda commenting system.

Mike August 26, 2019 63 Comments

This is the first part of our tutorial on building web applications. We'll start with HTML5 and CSS basics aiming to build a blogging platfrom. I'll explain how to buy your domain name and put your website live. In the next parts you will learn how to add back end fetures, e.g. forms, blog comments and user authentication.

Continue Reading
Blog Image

Building a static website with forms and blog. Part 2. Lambda contact form.

Mike August 23, 2019 63 Comments

This is the first part of our tutorial on building web applications. We'll start with HTML5 and CSS basics aiming to build a blogging platfrom. I'll explain how to buy your domain name and put your website live. In the next parts you will learn how to add back end fetures, e.g. forms, blog comments and user authentication..

Continue Reading
Blog Image

Building a static blogger website. Part 1: Domain name. S3. SSL, HTTPS and Cloudfront.

Mike August 19, 2019 63 Comments

This is the first part of our tutorial on building web applications. We'll start with HTML5 and CSS basics aiming to build a blogging platfrom. I'll explain how to buy your domain name and put your website live. In the next parts you will learn how to add back end fetures, e.g. forms, blog comments and user authentication.

Continue Reading
Blog Image

Big Data analytics with Snowflake in 30 minutes. (Coming soon)

Mike August 17, 2019 35 Comments

This a quick tutorial on how to get into big data analytics with Snowflake just in 30 minutes. The article will take you through setting up an AWS account, connecting it to Snowflake managed service and creating your first tables.

Continue Reading
Blog Image

Building a recommender system with Recurrent Neural Network. (Coming very soon)

Mike August 22, 2019 48 Comments

This is the first Part of our Machine learning tuturial on building the recommender system from scratch. I will show you how to use Hierarchical Recurrent Neural Networks (HRNN) to predict things. This tutorial is based on Python and Tensorflow and represents an easy and concise intro to Deep learning.

Continue Reading
Blog Image

The beginners guide to SQL (Postgres) (Coming soon)

Mike August 18, 2019 124 Comments

This the first of our tutorial on SQL. I'll show how to start with data nalytics using Postgres SQL. In this seies you will learn everything about data definition, data manipulation language, SQL functions, stored procedures and the most advanced SQL queries and examples. The final part of this series will be about POSTGIS extension for postgres and I will show how you can use it to analise geo-spatial data.

Continue Reading
Blog Image

Serverless web application tutorial (Part 1). (Coming very soon)

Mike August 29, 2019 256 Comments

This tutorial will show how easy it is to create a serverless web app and deploy it with AWS lambda. I will talk you through how to build your own accounting application with database and connect it to HubSpot CRM and Quotient.

Continue Reading