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.
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 →
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 →
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
Over the last two decades organizations have widely used the data generated from internal and external sources to derive intelligence that would help them grow and gain competitive advantages. According to the 2013 technology report by Gartner, ‘Business Intelligence & Analytics’ is the number one priority for CIOs to address. Yet many organizations are struggling to implement … Read More →
Effective integration of testing in the implementation process builds trust and confidence among business users as they make crucial strategic decisions, based on the BI data generated.
Testing of Data Warehouse/Business Intelligence (DW/BI) applications is a little different than testing traditional transactional applications as it requires data-centric testing approach.
The typical challenges an enterprises faces while testing … Read More →