Tag: SQL for Power BI

Power BI Split Column By Delimiters In DAX

Power BI Split Column By Delimiters In DAX- Enterprise DNA

In today’s blog, you will learn how to use Power BI to split column by delimiters using DAX. This is something you would probably know how to do easily using Power Query, and that is generally the best way to do it.  But because of the dynamic nature of the problem and the specific considerations

Continue reading

SQL Temp Tables And Views For Power BI User

SQL Temp Tables And Views For Power BI User - Enterprise DNA

In this tutorial, we’ll discuss SQL temp tables and views. These two can be handy if you want to pull a specific set of data from a physical table for testing and debugging. We’ll also talk about the 2 types of temporary tables and their differences. With SQL temp tables and views, you can freely

Continue reading

Aggregate Functions In SQL And Their Usage

Aggregate Functions In SQL And Their Usage - Enterprise DNA

In this tutorial, we’ll be discussing the different aggregate functions in SQL and how we can use them. In SQL, aggregate functions are used to accumulate data from multiple rows into a single summary row.  Aggregate functions in SQL can be very helpful for analysts when doing data summarization. Commonly Used Aggregate Functions In SQL

Continue reading

Using DAX To Load Data From SSAS To Power BI

Using DAX To Load Data From SSAS To Power BI - Enterprise DNA

In this tutorial, you’ll learn about the queueing capability of DAX. You’ll learn how to use it to load data from the SQL Server Analysis Services (SSAS) to Power BI. In this example, a SQL Server data model has already been created. It contains tables for the Customer, Dates, Products, and Sales data. You’ll learn

Continue reading