July 2013

Using PIVOT operator in SQL Server

18. July 2013 Hans Esquivel SQL Server , Reporting Services Comments (0)

In this article we'll show you how to use SQL Server PIVOT operator. The PIVOT operator is useful when you want to generate cross-tabular views to summarize data. [More]

Get the last 5 Days, for each Month of the Year using MDX query

16. July 2013 Hans Esquivel Analysis Services , Analysis Services Tabular Mode , Multidimensional Expressions (MDX) Comments (0)

In this session I'll show you how to script a query in MDX to get the last 5 days, for each month of a chosen year. After we test the query, we'll validate aggregate values for the first couple of months using a basic MDX query. [More]

Source for Business Intelligence & Data Analytics

Using PIVOT operator in SQL Server

Get the last 5 Days, for each Month of the Year using MDX query

Extensible Clinical Research Data Mart and Data Analytics (Part 2) - Clinical Multidimensional Cube (SSAS)

Extensible Clinical Data Mart (CDM) and Data Analytics (Part 1) - UDM Design

Define Age Groups using Execute R Script in Azure ML

Azure Machine Learning Tutorial: Introduction to developing your first Azure Machine Learning Experiment

Using PIVOT operator in SQL Server

Get the last 5 Days, for each Month of the Year using MDX query

Installing and Configuring a new instance of SQL Server Analysis Services in Tabular Mode

InfoToad Consulting Achieves a Microsoft Silver Data Platform Competency.

Create Dashboards using PerformancePoint Dashboard Designer (SharePoint 2013)

Add conditional formatting to your PerformancePoint Services Analytic Grid, by defining a custom Scope calculation from within Analysis Services (SSAS)