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

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

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

Configure Data Management Gateway from Azure Portal

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

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

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

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

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

Data Dimension in Power Query – Public Holidays Fetched Live

In previous post I’ve generated a date dimension with Power Query M script. In this post I will add public holidays to the date dimension from live websites. This post only considers New Zealand public holidays, but once you’ve learned how to deal with data, you can apply similar transformations with small changes to any Read more about Data Dimension in Power Query – Public Holidays Fetched Live[…]

Script to Generate Date Dimension with Power Query M – With Financial Columns

  There are many date dimensions scripts on the internet, and even there are some scripts for the Power Query (Thanks to Chris Webb for his very early version of the date dimension, and also to Matt Masson for his version of Date Dimension). I’ve built a date dimension from scratch (not a copy or Read more about Script to Generate Date Dimension with Power Query M – With Financial Columns[…]