https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables
The SQL language offers the following types of JOIN:
INNER JOIN
OUTER JOIN
CROSS JOIN
The result of a JOIN does not depends on the presence of a relationship in the data model. You can use any column of a table in a JOIN condition.
In DAX there are two ways you can obtain a JOIN behavior. First, you can … Read More →
Introduction
In this article (Italian), we have already discussed Continuous Integration and DLM. We described the main reasons for putting a database under source control and for testing our databases. In this article, we are going to discuss a real scenario of SQL Server unit testing with the tSQLt framework.
What Is Unit Testing
In computer programming, unit … Read More →
Automating Analysis Services Tabular Projects - Part 1: Deployment
My team recently starting using Microsoft’s Tabular Model databases at work, as an intermediate layer between an operational data store and the end users who consume this data from Power BI. Tabular Models are an OLAP technology, providing an in-memory data cube, with measures being defined using … Read More →
We are going a step beyond the traditional methods of developing a data warehouse by adopting CI practices, which are more prevalent for API (.NET) based applications. It has been long pending for data warehouse teams to catch up on the modern software engineering practices. With the emergence of Visual Studio Online (VSTS) & SQL … Read More →
In Analysis Services, almost every object and workload is programmable, and often there is more than one approach to choose from. Options include writing managed code, script, or using open standards like XMLA and MSOLAP if your solution requirements preclude using the .NET framework.
What you can accomplish in code
Typical programming scenarios include server and database … Read More →
https://docs.microsoft.com/fr-fr/sql/analysis-services/tutorial-tabular-1400/as-adventure-works-tutorial?view=sql-server-2017
What you learn
How to create a new tabular model project at the 1400 compatibility level in Visual Studio with SSDT.
How to import data from a relational database into a tabular model project workspace database.
How to create and manage relationships between tables in the model.
How to create calculated columns, measures, and Key Performance Indicators that help … Read More →
What is BI?
Business Intelligence is the process of collecting raw data or business data and turning it into information that is useful and more meaningful. The raw data is the records of the daily transaction of an organization such as interactions with customers, administration of finance, and management of employee and so on. These data’s … Read More →
This is part 3 of a discussion about a new service in Microsoft Azure: Azure Analysis Services. Azure AS is a Platform-as-a-Service (PaaS) offering which is in public preview mode (as of December 2016).
Part 1: Why a Semantic Layer Like Azure Analysis Services is Relevant
Part 2: Use Cases for Azure Analysis Services
Part 3: Where Azure … Read More →
This is part 2 of a discussion about a new service in Microsoft Azure: Azure Analysis Services. Azure AS is a Platform-as-a-Service (PaaS) offering which is in public preview mode (as of November 2016).
Part 1: Why a Semantic Layer Like Azure Analysis Services is Relevant
Part 2: Use Cases for Azure Analysis Services {you are here}
Part … Read More →
This is part 1 of 3 about Azure Analysis Services (Azure AS) which was announced a few days ago. Azure AS is a Platform-as-a-Service (PaaS) offering which is currently in public preview mode at the time of this writing (late October 2016).
Part 1: Why a Semantic Layer Like Azure Analysis Services is Relevant {you are here}
Part … Read More →
Contents [hide]
1 Introduction
2 Prerequisites
3 REST API Concepts
4 Configure SSIS JSON Source to Read from REST API or local File
4.1 Configure Connection – Pass credentials
4.1.1 Configure HTTP Connection
4.1.2 Configure OAuth Connection
4.2 Example of JSON/REST API Source
5 Loading data from REST API to SQL Server
6 POST Data to ServiceNow API (Insert, Update or Delete)
7 Common Errors
7.1 Truncation related error
7.2 … Read More →
What is Multidimensional schemas?
Multidimensional schema is especially designed to model data warehouse systems. The schemas are designed to address the unique needs of very large databases designed for the analytical purpose (OLAP).
Types of Data Warehouse Schema:
Following are 3 chief types of multidimensional schemas each having its unique advantages.
Star Schema
Snowflake Schema
Galaxy Schema
In this tutorial, you will … Read More →
Power BI is an extremely powerful data and visualization tool. It has opened a new world for me. But, the first thing I always think about when looking at Microsoft products is that there must be a way to control this with PowerShell. I did not find any useful information about any PowerShell module on … Read More →
The biggest change in the Power BI August update is the new ability to export reports as a PDF file, a feature that was apparently the most-requested in Microsoft’s UserVoice. Other changes include the introduction of bookmark groups, theming being made generally available, improvements to Q & A, and a better experience when viewing content … Read More →
This is a training step by step video of Tableau. In this video we will try to understand What is Tableau, Basics concepts of BI, Connecting Data source with Tableau tool, Generating Simple report, Discussion about different shelves or cards.
Objective: To setup sample databases that we would use.
We would be exploring MDX on SQL Server Analysis Service platform. For queering we would use AdventureWorks Analysis Service database, therefore we will start by setting up AdventureWorks sample database. There are two ways to setup the AdventureWorks Cube.
Restoring from an existing backup
Deploying from Sql Server Analysis … Read More →
https://sql.sh/
Apprendre le SQL
Le SQL (Structured Query Language) est un langage permettant de communiquer avec une base de données. Ce langage informatique est notamment très utilisé par les développeurs web pour communiquer avec les données d’un site web. SQL.sh recense des cours de SQL et des explications sur les principales commandes pour lire, insérer, modifier et … Read More →
https://github.com/Microsoft/sql-server-samples
SQL Server Samples Repository
This GitHub repository contains code samples that demonstrate how to use Microsoft's SQL products including SQL Server, Azure SQL Database, and Azure SQL Data Warehouse. Each sample includes a README file that explains how to run and use the sample.
Note that certain features like In-Memory OLTP are edition specific for SQL Server … Read More →
World of MDX queries
http://www.learningmdx.com/
DOWNLOADS
http://www.learningmdx.com/downloads/