FIFA 2014 World Cup Data Analysis with Power BI

Posted on April 16, 2015April 16, 2015 by Reza Rad

Fifa 2014 is not a hot topic these days, but it was the headline news June 2014. With new capabilities in Power BI Designer I tempted to use FIFA 2014 Worldcup data as a demo of it, and play with the tool to see how it works. Fortunately I was able to build some interesting dashboards with it. The demo work was interesting enough to say that I probably would write detailed information about how to build such demo, and would use it in some of my conference speakings.

I’ve used data from official Fifa.com website for most parts of this demo. you can reach FIFA.com official site for 2014 Brazil from here:

[…]

Azure Data Factory – Updates: March 2015

Posted on April 13, 2015April 13, 2015 by Reza Rad

Previously in another post I’ve mentioned what Azure Data Factory is and a sample scenario of data transfer with it.

Microsoft recently published a new version of it, which has really interesting features. In a nutshell features are:

New Version of Data Management Gateway
On Premises File System Linked Services
On Premises Oracle Linked Services
Encoding options for text files on Azure Blog storage
Invoking Stored Procedures with additional parameters.

Have a read in details about these new features below;

[…]

Power BI Now Available Worldwide

Posted on April 7, 2015 by Reza Rad

December last year Power BI with new great features was announced to be only available for United States. Recently Microsoft announced that Power BI is now available worldwide (Preview yet), which is great news. In this post I would like to share some facts about Power BI; Power BI is cloud BI service of Microsoft. Read more about Power BI Now Available Worldwide[…]

Full Day Training Pre-Con: Power BI from Rookie to Rockstar

Posted on March 30, 2015March 31, 2015 by Reza Rad

Full Day Training of Power BI with the title of Power BI from Rookie to Rockstar has been ran in SQL Saturday Vienna.

RADACAD presented one pre-con on Power BI, and couple of sessions; A Journey to Power BI by Leila, and ETL on Cloud? Azure Data Factory by Reza.

Power BI pre-con includes Power Query, Power Pivot, Power View, Power Map, Power Q&A, and the new Power BI Designer.

[…]

Our Session at SQL Rally: Azure Data Factory vs SSIS

Posted on March 30, 2015August 27, 2015 by Reza Rad

Reza’s Session at SQL PASS Rally Nordic 2015 was about Comparing Azure Data Factory and SSIS. Listen to session recording above. Session details listed below:

[…]

SQL Rally RADACAD Session: Show Me Potential Customers: Data Mining Approach

Posted on March 30, 2015May 10, 2015 by Leila Etaati

SQL Rally is the PASS gathering of Nordic countries which happens annually. Listen to Leila’s presentation above about Data Mining. Details of session listed below;

[…]

SQL Saturday Vienna 2015- A Journey to Power BI

Posted on March 9, 2015May 9, 2015 by Leila Etaati

To download the Session slides click below link : A-Journey To Power BI My session God turn out in SQL Saturday Vienna An Interesting Keynote speech by Mark Souza Have fun the day after SQL Saturday around Vienna with other Speakers I have Talked about Power BI in SQL Saturday Vienna , Special Read more about SQL Saturday Vienna 2015- A Journey to Power BI[…]

SQLBits is Awesome, But I cannot Attend! Why?!

Posted on February 21, 2015September 16, 2015 by Reza Rad

It is with all regret that I cannot attend at the conference that is the largest SQL event in Europe, and always compared to SQLPASS Summit because of the high quality of content and large number of audience. I was honored to be selected to speak for couple of sessions in SQLBits 2015, and I Read more about SQLBits is Awesome, But I cannot Attend! Why?![…]

Referring SSIS Variables from SSIS Script Task

Posted on February 15, 2015September 16, 2015 by Reza Rad

Today I got a very valued feedback from a reader of my SSIS 2012 book, and based on that feedback I’ve found that I had a mistake in one of the exersizes of the book. an important note was not mentioned there. So in this post I want to mention that and applogize for any Read more about Referring SSIS Variables from SSIS Script Task[…]

Introduction to Azure Data Factory

Posted on January 29, 2015September 16, 2015 by Reza Rad

Many of you worked with SSIS and are familiar with term of ETL. Azure Data Factory is Microsoft Cloud based ETL technology, which has ability to work with large volume of data, working with data sources such as SQL Server on premises, SQL Server Azure, or Azure Blob storage. Data can be transformed with Azure Read more about Introduction to Azure Data Factory[…]