Skip to main content

Week of 3/19 webinars: Advanced Tricks on manipulating structured JSON with Flow and Enhance Power BI Visualization with R

Headshot of article author Charles Sterling

Two great and very technical webinars for your viewing pleasure this week!

  1. Advanced Tricks on manipulating structured JSON with Flow and Enhance by John Liu
  2. Power BI Visualization with R by Leila Etaati

Advanced Tricks on manipulating structured JSON (and XML) data with Flow by John Liu

If you are using Flow as a Serverless middleware platform to manipulate objects to connect between endpoints and services, from Office 365 to Dynamics, PowerApps to PowerBI, then you need to be familiar with the techniques of structured data manipulation in Microsoft Flow – how to read it, how to debug it, and how to master it.  This session will give that information -and more!  This session covers these building block techniques:!



When: 3/20/2018 2pm PST (note: this is different than my normal time!)

  • Create ad-hoc objects, add/edit/removeProperties

  • First tip: Colour

  • Coalesce, Union

  • Select (map), filter-array, join

  • Parse-JSON action – why you need this, and why most of the time you don’t.

  • Compare variables and compose.

  • Discuss roles of XML, XPath and Flow-Each technique.

  • JSON Pivot

  • Will finish with Liquid templates



Enhance Power BI Visualization with R Script by Leila Etaati


Power BI visualization is a holistic visualization tool. You can draw most of the popular charts with it. However, there is always some needs for specific charts that may not be available in Power BI standard visualizations of the marketplace. There is a possibility to extend the visualization capabilities using R language. There are two ways to use R to extend the visualization possibilities. The approach was introduced in 2015 as “R” custom visual that you can draw chart by writing R scripts. Drawing chart by writing R codes inside Power BI is so easy. However, the editor for writing R was not that was good and also the end-user able to see the R code behind the chart. The second approach for using R to have more chart in Power BI has been introduced in mid of 2017 that is about creating Custom visual file (pbiviz file) using R and JASON language. In this seminar, I am going to show how you can create any custom visual by writing R codes. You able to create a custom visual that has a specific icon, name, and input variables by changing some files like “script.r”, “pbiviz.jason” and “capabilities.jason”. The session has all demo and required steps to create custom visual using R.


When: 3/22/2018 10AM PST

About Leila Etaati

Image result for Leila Etaati

Leila is Data Scientist, PhD, MVP, and BI Consultant, and Speaker. She has over 10 years’ experience working with databases and software systems. She was involved in many large-scale projects for big sized companies. Leila has PhD of Information System department, University of Auckland, MS and BS in computer science.

She worked in Industries including banking financial, power and utility, manufacturing … She is a lecturer and trainer in Business intelligence and data base design course in University of Auckland.

Leila speaks in international SQL Server and BI conferences such as Microsoft Ignite, PASS Summit, PASS Business Analytics, PASS Rally, and many SQL Saturdays in USA, Europe, Australia, and New Zealand on Machine Learning and Analytics topics.

Ask Leila about these technologies and areas;

  • Machine Learning

  • Advanced Analytics

  • Predictive, Prescriptive, and Descriptive Analytics

  • Azure Machine Learning

  • R

  • Python

  • On-Prem Machine Learning with SQL Server, R and Python

  • Power BI and R

  • Power BI

  • Stunning Visualization with R

  • Microsoft BI Suite in SQL Server

  • Azure Stream Analytics

  • IOT

  • Real-time Streaming