Author: Reza Rad

Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 20 years’ experience in data analysis, BI, databases, programming, and development mostly on Microsoft technologies. He is a Microsoft Data Platform MVP for 12 continuous years (from 2011 till now) for his dedication in Microsoft BI. Reza is an active blogger and co-founder of RADACAD. Reza is also co-founder and co-organizer of Difinity conference in New Zealand, Power BI Summit, and Data Insight Summit. Reza is author of more than 14 books on Microsoft Business Intelligence, most of these books are published under Power BI category. Among these are books such as Power BI DAX Simplified, Pro Power BI Architecture, Power BI from Rookie to Rock Star, Power Query books series, Row-Level Security in Power BI and etc. He is an International Speaker in Microsoft Ignite, Microsoft Business Applications Summit, Data Insight Summit, PASS Summit, SQL Saturday and SQL user groups. And He is a Microsoft Certified Trainer. Reza’s passion is to help you find the best data solution, he is Data enthusiast. His articles on different aspects of technologies, especially on MS BI, can be found on his blog: https://radacad.com/blog.

Presentation files for Hong Kong TechDays 2013 : Choosing the Right Data Visualization with Microsoft Business Intelligence

Posted on by Reza Rad

Thank you all for attending at my presentation in TechDays 2013 Hong Kong at morning of 3rd day of conference. here you can find presentation file of my speaking session about Choosing the right Visualization Tool with Microsoft Business Intelligence Title: Choosing the Right Visualization Tool with Microsoft Business Intelligence (MSBI) Description: Microsoft BI stack Read more about Presentation files for Hong Kong TechDays 2013 : Choosing the Right Data Visualization with Microsoft Business Intelligence[…]

Presentation files for Hong Kong TechDays 2013 : SSAS Tabular Modeling

Posted on by Reza Rad

Thank you all for attending at my presentation in TechDays 2013 Hong Kong at 2nd day of conference. here you can find presentation file of my speaking session about SQL Server Analysis Services Tabular Modelling Title:  SQL Server Analysis Services Tabular Modelling Description:  SQL Server 2012 provided another method for modelling BI presentation named SSAS Tabular Modelling. Read more about Presentation files for Hong Kong TechDays 2013 : SSAS Tabular Modeling[…]

DQS Error : Cannot connect to server – A .NET Framework error occurred during execution of user-defined routine or aggregate “SetDataQualitySessions” – SetDataQualitySessionPhaseTwo

Posted on by Reza Rad

If you faced this error when you want to connect Data Quality Services (from Data Quality Client or from SSIS DQS Cleansing component); Cannot connect to server – A .NET Framework error occurred during execution of user-defined routine or aggregate “SetDataQualitySessions” – SetDataQualitySessionPhaseTwo You can fix it in following way; Why this happens: When .NET Framework Read more about DQS Error : Cannot connect to server – A .NET Framework error occurred during execution of user-defined routine or aggregate “SetDataQualitySessions” – SetDataQualitySessionPhaseTwo[…]

SSAS Tabular – Microsoft Technical Articles

Posted on by Reza Rad

Yesterday in New Zealand Business Intelligence users group, attendees asked some questions that encouraged me to provide some links to Microsoft Articles written on SSAS Tabular. Here you can read more about these articles; Using DirectQuery in the Tabular BI Semantic Model Choosing a Tabular or Multidimensional Modeling Experience in SQL Server 2012 Analysis Services Read more about SSAS Tabular – Microsoft Technical Articles[…]

Presenting at TechDays Hong Kong 2013

Posted on by Reza Rad

I will present three sessions at upcoming TechDays conference in Hong Kong at 12-14 March 2013.  My sessions are :  SQL Server Analysis Services Tabular Modeling Data Cleansing with SQL Server 2012 Data Quality Services Choosing the Right Visualization Tool with Microsoft Business Intelligence (MSBI)  Here are description of my sessions: SQL Server Analysis Services Read more about Presenting at TechDays Hong Kong 2013[…]

Execute Process Task – SSIS 2012 Tutorial Videos

Posted on by Reza Rad

  I’ve created another video of SSIS 2012 Tutorial Videos series. In this video samples of Execute Process Task illustrated. Execute Process Task provide ability to run executable files from SSIS package. In this Video there are two samples of working with Execute Process Task: Compressing Files (Archiving) into zip files formatted with date and Read more about Execute Process Task – SSIS 2012 Tutorial Videos[…]

Web Service Task – SSIS 2012 Tutorial Video

Posted on by Reza Rad

This is a video tutorial about how to use Web Service Task in SSIS. In this tutorial you will learn how to use Web Service Task to send parameters to web service methods and get response and save response into xml file. this video has samples of work with World Cup 2010 Football Championship web Read more about Web Service Task – SSIS 2012 Tutorial Video[…]

File System Task – SSIS 2012 Tutorial Video

Posted on by Reza Rad

This tutorial video is part of SSIS 2012 Tutorial Videos. This tutorial video of SSIS 2012 Tutorial Videos illustrates how to use File System Task to do file operations like copy file and folder operations like create directory. as an example you will see how to create a package that checks for existance of an Read more about File System Task – SSIS 2012 Tutorial Video[…]

Script for Creating and Generating members for Date Dimensions: General Purpose

Posted on by Reza Rad

Date Dimension can be found in every Data Warehouse, because Date dimension is one of the most important factors of each operational system that users like to view reports based on date dimension. So the importance and requirement to a date dimension persuade me to write a t-sql script to generate records for date dimension. Read more about Script for Creating and Generating members for Date Dimensions: General Purpose[…]

How to get rid of TESTING CONNECTIVITY at the time of Opening SSIS packages in SSDT

Posted on by Reza Rad

SSDT has an option to test connectivity of connection managers at the time of opening the SSIS package. You can change this behaviour with WORK OFFLINE option. When you have many connection managers in SSIS package, you may face a halt at the time of opening each package with a “testing connectivity” message. This will Read more about How to get rid of TESTING CONNECTIVITY at the time of Opening SSIS packages in SSDT[…]