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

Presentation Materials: TechDays Hong Kong 2014, Deeper Data Insight and Prediction with Data Mining

Posted on March 26, 2014 by Reza Rad

Thanks to all attendees of my session in TechDays 2014 Hong Kong about Deeper Data Insight and Prediction with Data Mining. Here is session Title, Description, and presentation file; Title: Deeper Data Insight and Prediction with Data Mining Description: Data Mining is the art of data analysis, finding data models, and predicting future behaviour based Read more about Presentation Materials: TechDays Hong Kong 2014, Deeper Data Insight and Prediction with Data Mining[…]

Presentation Materials: TechDays Hong Kong 2014, ETL Architecture for Solving Data Warehouse Challenges

Posted on March 26, 2014 by Reza Rad

Thanks to all attendees of my session in TechDays 2014 Hong Kong about ETL Architecture for Solving Data Warehouse Challenges. Here is session Title, Description, and presentation file; Title: ETL Architecture for Solving Data Warehouse Challenges Description: Data Warehouses are heavily in use nowadays in most of businesses around the world. Data Warehousing brings higher Read more about Presentation Materials: TechDays Hong Kong 2014, ETL Architecture for Solving Data Warehouse Challenges[…]

TechDays Hong Kong 2014; My Speaking Engagements

Posted on February 18, 2014 by Reza Rad

TechDays Hong Kong 2014 is under way, It would be 11-13 of March 2014. and I am glad that I’ll present four sessions in this conference. Sessions are: Advanced Data Transformations with Power Query Deeper Data Insight and Prediction with Data Mining ETL Architecture for Solving Data Warehouse Challenges Power BI Data Visualization with Power Read more about TechDays Hong Kong 2014; My Speaking Engagements[…]

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

Data Dimension in Power Query – Public Holidays Fetched Live

Posted on February 15, 2014 by Reza Rad

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

Posted on February 14, 2014November 1, 2016 by Reza Rad

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

Writing Custom Functions in Power Query M

Posted on February 12, 2014 by Reza Rad

One of the most powerful features of M is that you can write custom functions to re-use part of your code. Custom functions can be single or multiple liner, they will be written in Lambda style syntax. In this post you will learn how to write functions and invoke them in M. Custom functions and Read more about Writing Custom Functions in Power Query M[…]

How to Get List of All Functions and Invoke Them in Power Query

Posted on February 12, 2014 by Reza Rad

Yesterday I’ve found a very awesome feature in Power Query (Thanks to Matt Masson). The feature is: you can see list of all functions in the Power Query with enumerations and option types with a keyword. I’m personally coming from a developer background, so that option for me looks like the Object Explorer in Visual Read more about How to Get List of All Functions and Invoke Them in Power Query[…]