Why We Need A No-Code DAX Solution? Writing DAX measures can be overwhelming and time consuming, specially writing time intelligence ones. I personally had a love-hate relationship with DAX and always looked for smarter ways of writing repetitive functions. If you share the same pain and want to better your DAX experience, let me show
Summary DAX measures in Power BI play crucial role by offering aggregation and calculations on top of facts, that can be visualized and sliced by dimensional fields. Problem: The list of measures can grow rapidly and become cumbersome to organize, maintain and discover. Specially in a self serve model, analysts can get confused and overlook
Addressing The Elephant In The Room For decades, there has been no competition to Microsoft’s Excel, virtually every human ever worked on a computer screen, knows about it. Some are experts and others are just using it for basic data analysis tasks. But, with the rise of Power BI in the last few years and
Problem Statement The Scenario Say you have a vast pool of SQL Servers and Databases storing thousands of database objects, including tables, views, stored procs and many more, for the purpose of landing data area or warehousing. On the other hand you have number of user groups, such as, Data Analysts, Business Analysts, Data Engineers,
Summary “Shape the raw data to suit your data model, make it your own“ Data shaping is a process of transforming schema and format of data, it is a set of data transformations applied in a defined sequence to result in the desired data shape. Why it is important? Data sources contain generic data structures,
Introduction “Dirty data in, dirty analytics out” Traditional data sources such as, SQL Server Warehouse or raw file feeds, tend to contain dirty data, which is often in a raw form and needs cleansing and massaging. In this stage, you need to check the health and state of data to transform it into a useful
Watch The Full Video Covering This Blog Introduction Have you just started building a Power BI Dataset and your initial tasks are importing, cleansing, shaping, transforming and preparing the data for Data Modelling? Here are 5 best tips for data transformation, that you can use as a checklist to make sure you don’t miss any
Learning Resources Learning Utilities & Downloads Power Query Microsoft Power Query DocsMicrosoft Power Query M Formula Language Docs Buy Book DAX Microsoft DAX DocsDAX GuideSqlBIBuy Book DAX Studio DownloadDAX FormatterDAX Patterns Tabular Editor Tabular Editor Download Power BI Microsoft Power BI DocsBuy Book Power BI Desktop Download Power BI Report Builder Microsoft Docs Download Certification
Why We Need A No-Code DAX Solution? Writing DAX measures can be overwhelming and time consuming, specially writing time intelligence ones. I personally had a love-hate relationship with DAX and always looked for smarter ways of writing repetitive functions. If you share the same pain and want to better your DAX experience, let me show
Summary DAX measures in Power BI play crucial role by offering aggregation and calculations on top of facts, that can be visualized and sliced by dimensional fields. Problem: The list of measures can grow rapidly and become cumbersome to organize, maintain and discover. Specially in a self serve model, analysts can get confused and overlook
Addressing The Elephant In The Room For decades, there has been no competition to Microsoft’s Excel, virtually every human ever worked on a computer screen, knows about it. Some are experts and others are just using it for basic data analysis tasks. But, with the rise of Power BI in the last few years and
Problem Statement The Scenario Say you have a vast pool of SQL Servers and Databases storing thousands of database objects, including tables, views, stored procs and many more, for the purpose of landing data area or warehousing. On the other hand you have number of user groups, such as, Data Analysts, Business Analysts, Data Engineers,
Summary “Shape the raw data to suit your data model, make it your own“ Data shaping is a process of transforming schema and format of data, it is a set of data transformations applied in a defined sequence to result in the desired data shape. Why it is important? Data sources contain generic data structures,
Introduction “Dirty data in, dirty analytics out” Traditional data sources such as, SQL Server Warehouse or raw file feeds, tend to contain dirty data, which is often in a raw form and needs cleansing and massaging. In this stage, you need to check the health and state of data to transform it into a useful
Watch The Full Video Covering This Blog Introduction Have you just started building a Power BI Dataset and your initial tasks are importing, cleansing, shaping, transforming and preparing the data for Data Modelling? Here are 5 best tips for data transformation, that you can use as a checklist to make sure you don’t miss any
Learning Resources Learning Utilities & Downloads Power Query Microsoft Power Query DocsMicrosoft Power Query M Formula Language Docs Buy Book DAX Microsoft DAX DocsDAX GuideSqlBIBuy Book DAX Studio DownloadDAX FormatterDAX Patterns Tabular Editor Tabular Editor Download Power BI Microsoft Power BI DocsBuy Book Power BI Desktop Download Power BI Report Builder Microsoft Docs Download Certification