DINESH KUMAR

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 combined most of the useful dbt commands into an overview. dbt generic commands dbt init project_name – performs several actions necessary to create a new …

dbt(data built tool) commands cheat sheet Read More »

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 interaction between the visuals in Power BI will be wrong. So one needs to ensure the data model is correct when building dashboards. In PowerBI …

Data Modelling and optimization in PowerBI Read More »