Tag: SQL tutorial

Subquery In SQL For Power BI Users

Subquery In SQL For Power BI Users - Enterprise DNA

In this tutorial, we’ll learn and understand how we can utilize a subquery in SQL. A subquery is a query within another query. We can also call it a nested query within a larger query. It must be enclosed with a bracket and mostly used in a WHERE clause. We can utilize subqueries in SQL

Continue reading

Query Folding And Connecting To SQL Server

Query Folding And Connecting To SQL Server

In this tutorial, we’ll learn how to connect to SQL server. We’ll also discuss how query folding works in Power Query and how we can run SQL commands in Power BI. Inside Power Query, we can extract and manipulate data from various sources. With query folding, we can offload data transformations to the source instead

Continue reading

SQL Server Download And Installation

SQL Server Download and Installation

In this blog, we’ll talk about preparing the environment by installing SQL Server (Developer Edition), and SSMS (SQL Server Management Studio). We’ll also have a little practice by downloading and restoring AdventureWorks databases (Practice Databases). SQL Server is system from Microsoft for managing databases. It’s completely free and a full-featured DBMS for developers. After installing

Continue reading

Connect DAX Studio To Power BI And SSAS

Connect DAX Studio To Power BI And SSAS

In this tutorial, you’ll learn how to connect DAX Studio to Power BI and to the different variations of the SQL Server Analysis Services. This demo will go through four processes: Connecting DAX Studio to Power BI Connecting DAX Studio to the PowerPivot Model in Excel Connecting DAX Studio to SQL Server Analysis Connecting DAX

Continue reading

How To Install SQL Server For Power BI

Installing SQL Server for Power BI

In this tutorial, you’ll learn how to install SQL server for Power BI. This includes a step-by-step demonstration on how to download and install the SQL server management tool and the Contoso database. Installing SQL server comes with a variety of advantages. You won’t need to delete a part of your column. You’ll also have

Continue reading