Power BI World Tour in San Francisco ran on 4th and 5th of October in Bay Area (Microsoft Sunnyvale). As a speaker, it is always a great opportunity for me and Leila to speak in such events and meet new people in the community. In San Francisco world tour, Leila and I presented 4 topics in total and received a lot of great feedback from the audience. It has been a pleasure to speak in this event. Here in this post you will read details of our presentations, and links to download slide deck of presentations. If you have any questions; please feel free to ask in the comment area below.
Title: Deep Dive into Power Query and M
Speaker: Reza Rad
Description: 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 things Power Query can do. M is the language behind the scene of Power Query, you will learn how M 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. This session is full of live demos. Prepare to be amazed by what Power Query can do with heaps of demos in this session.
Reference Links
Append vs Merge in Power Query
Choose the Right Merge Join Type in Power Query
#shared Keyword to get All Functions
Custom Functions Made Easy in Power BI
Date Dimension Part 1: Calendar Columns
Date Dimension Part 2: Fiscal Columns
Date Dimension Part 3: Public Holidays
Power BI online Book
https://radacad.com/online-book-power-bi-from-rookie-to-rockstar
Download Session Slides
Download the slides from here:
Title: Power BI for Developers
Speaker: Reza Rad
Description: Power BI is not just a self-service tool for business analysts. Power BI has many features that help developers to build their reporting solution. Power BI Embedded, real-time streaming with Power BI, along with all powerful analytical engine of Power BI, helps developers to take their reporting to the next level. Come to this session to learn about all features that Power BI provides for developers.
Reference Links and Materials
Integrate Power BI into Your Application – Part 1: Register your APP
Integrate Power BI into Your Application – Part 2: Authenticate
Integrate Power BI into Your Application – Part 3: Embed Content
Integrate Power BI into Your Application – Part 4: Refresh Dataset
Integrate Power BI into Your Application – Part 5: Data Source Management
Sample Projects
https://github.com/Microsoft/PowerBI-developer-samples
Power BI online Book
https://radacad.com/online-book-power-bi-from-rookie-to-rockstar
Download Session Slides
Download the slides from here:
Title: Endless Possibilities with R and Power BI
Speaker: Leila Etaati
Description: R integration with Power BI provides more flexibility for users. People are able to have more visualizations which not exist currently in Power BI such as normal distribution chart, column width chart, different types of subplots in a map, five dimensions' chart with facet chart and so forth. Moreover, writing R scripts inside power query and Power BI Visualization enables users to do machine learning using R code. The other possibilities that recently added, people able to create custom R visual with the plotly package to make their visualization much more interactive, accessible and more flexible. In this session, first I will show how to create some interesting charts using ggplot2 package inside Power BI. Then, I will show how to do Machine Learning inside Power query by following machine learning process: data gathering, data cleansing, feature selection, model creation, data sampling, and finally; prediction. Also, I will show the main process to create a custom R visual (pbiviz) file through the installing Power BI tools. Finally, a brief demo of currently available R visual produces by Microsoft team will be presented.
Analytics with Power BI and R: Book
https://radacad.com/online-book-analytics-with-power-bi-and-r
Slides:
Title: Take Power BI Visualization to the Next Level
Speaker: Reza Rad
Description:
Demo Links
Interaction of Visuals in Power BI
Book: Power BI from Rookie to Rock Star
Power BI book from Rookie to Rock Star is absolutely free, download it and you will have full details of demos and much more materials to study through.
Download Session Slides
Download the slides from here:
Reza is author of more than 14 books on Microsoft Business Intelligence, most of these books are published under Power BI category. Among these are books such as Power BI DAX Simplified, Pro Power BI Architecture, Power BI from Rookie to Rock Star, Power Query books series, Row-Level Security in Power BI and etc.
He is an International Speaker in Microsoft Ignite, Microsoft Business Applications Summit, Data Insight Summit, PASS Summit, SQL Saturday and SQL user groups. And He is a Microsoft Certified Trainer.
Reza’s passion is to help you find the best data solution, he is Data enthusiast.
His articles on different aspects of technologies, especially on MS BI, can be found on his blog: https://radacad.com/blog.