Tag: SQL tutorial

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

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: Before proceeding with this, make sure you’ve successfully installed SQL server along with its client tool and database. If you haven’t, go through the

Continue reading