Blog Archive​

dbt(data built tool) commands cheat sheet

Introduction dbt (data build tool)  is a transformation tool.  It doesn’t extract or load data, but it’s very useful at transforming data that’s already loaded into your warehouse. Here I

Machine Learning – Supervised – Linear Regression

Introduction Machine Learning is broadly classified into two types :  Supervised Learning Unsupervised Learning Supervised Learning In supervised learning, we will have our input and output variables defined and we

Data Modelling and optimization in PowerBI

What is Data Modelling? Data modelling is nothing but Entity-relationship diagrams that are used for better understanding of databases. If the relationship between the tables is not correct then the

JSON Data with Key in Power BI

What is API? API stands for Application Programming Interface. It is just an URL or link through which we can access the data. The data connectivity through API has a