Sean Analytics

There are three main types of data models: conceptual, logical, and physical. Each model serves a distinct purpose, primarily determined...

I got confused with the concept of a pipeline and data flow when I just started to create ETL jobs in Azure Data Factory (ADF). Both of...

When data engineers are handling multiple files or sources, it is quite common to use parameters in data pipelines. With parameters, data...

Data transformation can be a time-consuming process, especially when dealing with unfamiliar data or encountering multiple issues within...

Introduction In the data analytics process, the first thing to do is always to check what your data look like. If there are some unclean...

SELECTEDVALUE https://learn.microsoft.com/en-us/dax/best-practices/dax-selectedvalue For example, Australian Sales Tax = IF(...

10 Quick Tips for Effective Power BI Data Modeling Data Model Planning: Start with clear business questions to guide your planning....

Every Power BI developer has their own date table and I have one as well. The following code is used to generate date table in designated...