Reza Rad

Reza Rad is an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 15 years’ experience in databases, programming and development mostly on Microsoft technologies. He is a Microsoft Data Platform MVP for seven continuous years (from 2011 till now) for his dedication in Microsoft BI.


PRECON: Power BI Deep Dive Tips from RADACAD


The team of RADACAD (Reza and Leila) will come to present a full day of deep dive training of Power BI. This day is not a typical training of Power BI. You will learn master tips of Power BI all through demos and hands on examples. We’ll take all 400 and 500 (deep dive) level content from our training and blog posts with live demos for this pre-con training day. Best would be brining your laptop with the latest version of Power BI Desktop installed to get the most of this course. Agenda is included, but not limited to:

  • Power Query advanced data transformations
  • M scripting tips and tricks
  • Custom functions in Power Query
  • Running Machine Learning R algorithms with Power BI
  • Best practices of Modelling in Power BI
  • DAX functions (Filters, Aggregations, Time Intelligence, Path, relationships) Deep Dive
  • Advanced Data Visualization Tips
  • Creating Custom Visuals with R and Power BI
  • R and Power BI Deep Dive
  • Gateway and types of Connections in Power BI; mastery tips
  • Sharing and Row Level Security patterns (Static, Dynamic, Manager level access, users and profile, organizational hierarchy…)
Leila Etaati  Precon 

M and Microsoft Power Query: The lightsaber for a data Jedi



Microsoft Power Query is the transformation engine in Power BI. This is the engine that you do all data preparation before loading data into the model. This is the keystone of your Power BI solution. In this session, you will learn what Power Query can do. You will learn how M, the language behind the scene of Power Query, can be more beneficial than the Power Query graphical interface. You will see demos of transformations that you can do with M Code. You will learn about functions, parameters, generators and many other amazing features of this tool. Prepare to be amazed by what Power Query can do in this demo-filled session!