April London #PowerBI User Group with Dr. Leila Etaati and Reza Rad

Tuesday, April 17, 2018 - 18:00
London Power BI Users Group

Please only register, if you can make it! Also please register on the skills matter event page (https://skillsmatter.com/meetups/10832-london-power-bi-april). This is a requirement from the venue, and it makes life a whole lot easier when you arrive.

Title: Row Leve Security Patterns in Power BI

Description: Security is different from Sharing, Sharing is about sharing the entire content with others, security is about authorizing different views of the content to others. In this session we go through many different Row Level Security patterns; Static Row Level Security, Dynamic Row Level Security, and many variations of the dynamic RLS, such as giving manager access as well as employee access, you will learn about user profile security scenarios, and hierarchical access levels. This session shows you how DAX and Power BI security comes together to play an important part of a Power BI project lifecycle: Row Level Security.

Title: Creating custom visuals with R and Power BI

Description: 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.json” and “capabilities.json”. The session has all demo and required steps to create custom visual using R.

About Reza:
Reza Rad is the world well-known name in the Microsoft BI field. Reza Rad is invited speaker in world’s best and biggest SQL Server and BI conferences such as PASS Summits, PASS Rallys, SQLBits, TechEds, Ignites, and so on. He is author of books on this topic, and he has more than 15 years’ experience in the Microsoft BI technologies. 10 years of his experience focused on training and consulting to the largest BI teams in the world. He is also Microsoft Certified Trainer for years. He is Microsoft SQL Server MVP (Most Valuable Professional) focused on BI and Data Analysis, He has been awarded MVP from Microsoft because of his dedication and expertise in Microsoft BI technologies. He is author of Power BI online book; from Rookie to Rock Star

About Leila:
Dr. Leila Etaati gained her PhD in University of Auckland. She is world well-known speaker in Machine Learning and Analytics topics, and spoke in world's best international conferences in Data Platform topics, such as; PASS Summits, PASS Rally, SQL Nexus, Microsoft Ignite, and so on. She has more than 10 years experience in Data Mining and Analytics. She is also Microsoft Most Valuable Professional (MVP) because of her dedication on Microsoft Analytics and Machine Learning technologies. She writes blog posts in RADACAD and also publishes YouTube videos in our channel. She also is an invited lecturer in universities such as University of Auckland, and Unitec, and some other universities. She worked in many industries including banking financial, power and utility, manufacturing, tourism, and so on.

Code Node

10 South Place EC2M 2RB