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

Posted by on Mar 26, 2014 in Data Mining, Presentations | No Comments

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

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

Posted by on Mar 26, 2014 in ETL, MDS, Presentations, SSIS | No Comments

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

TechDays Hong Kong 2014; My Speaking Engagements

Posted by on Feb 18, 2014 in Presentations | No Comments

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

Scheduling Power Query ETL Runs

Posted by on Feb 16, 2014 in Power BI, Power Query | No Comments

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

Power Query Formula Language M : Table Functions Part 1

Posted by on Feb 10, 2014 in Power BI, Power Query | No Comments

In previous post you’ve learned about Formula language of the Power Query known as "M". you’ve learned that M is a functional language that apply data transformations through script. In examples of previous post you’ve learned some of table functions such as Table.AddColumn, Table.Sort, Table.Join, and Table.PrefixColumns. In this post we will discover more table ...

Read More

Power Query Formula Language: M

Posted by on Feb 7, 2014 in Power BI, Power Query | No Comments

In previous post, I described what is Power Query, and how we can use that for self service ETL. You’ve how to work with Power Query menus and connect to different data sources, and apply multiple transformations on the data. In this post I’ll go one step closer to the core of Power Query Formula ...

Read More