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:

[…]

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.

[…]

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[…]

Power BI Now Available For Free!

Posted on January 28, 2015 by Reza Rad

It is really good news that Satya Nadella announced Power BI service will be available for free. I believe this is to compete with BI tools in the market and Microsoft seeks for wider range of customers. From my point of view this is a great change, because as a BI Consultant I’ve worked with Read more about Power BI Now Available For Free![…]

Configure Data Management Gateway from Azure Portal

Posted on January 25, 2015 by Reza Rad

Today I’ve faced an issue; when the Power BI Admin Center does not work I want to configure and set up Data Management Gateway. Data Management Gateways is a service that install on your machine or any on premises server, and allow cloud services (such as Power BI or Azure Data Factory) to connect to Read more about Configure Data Management Gateway from Azure Portal[…]

Power BI Pre-Con; from Rookie to Rockstar

Posted on January 8, 2015 by Reza Rad

Have you heard about Power BI? Do you know Power BI Components? Have you worked with Power Query Formula language called M? Do you know what are strong capabilities of this language and tool? Have you build PowerPivot models with strong DAX expressions and deployed in Power BI site? Do you know different types of Read more about Power BI Pre-Con; from Rookie to Rockstar[…]

Presentation Materials: TechDays Hong Kong 2014, Power BI Data Visualization with Power Map and Power View

Posted on March 26, 2014 by Reza Rad

Thanks to all attendees of my session in TechDays 2014 Hong Kong about Power BI Data Visualization with Power Map and Power View. Here is session Title, Description, and presentation file; Title: Power BI Data Visualization with Power Map and Power View Description: Power BI is the most recent BI technology and tool provided by Read more about Presentation Materials: TechDays Hong Kong 2014, Power BI Data Visualization with Power Map and Power View[…]

Presentation Materials: TechDays Hong Kong 2014, Advanced Data Transformation with Power Query

Posted on March 26, 2014 by Reza Rad

Thanks to all attendees of my session in TechDays 2014 Hong Kong about Advanced Data Transformations with Power Query. Here is session Title, Description, and presentation file; Title: Advanced Data Transformations with Power Query Description: Power Query is the self-service data consolidation tool of the Power BI embedded in Excel. Power Query has ability to Read more about Presentation Materials: TechDays Hong Kong 2014, Advanced Data Transformation with Power Query[…]

Scheduling Power Query ETL Runs

Posted on February 16, 2014 by Reza Rad

In previous posts I’ve mentioned that Power Query is a self-service ETL tool. One of the most fundamental functions of an ETL tool is ability to schedule ETL run. In the other words you would require to populate data from operational data stores on a schedule basis to feed into your Data Model. Power Query Read more about Scheduling Power Query ETL Runs[…]