SGDPUG | #DataSessions Episode 301

SG Data Platform UG | #DataSessions Episode 301
When: Thursday, April 28, 2022
Teams Meeting Short Link: bit.ly/SGDataSessions301
Session 01(7:00 pm - 7:50 pm SGT)
Title: Cracking the Power BI performance!
Speaker: Nikola Ilic | @DataMozart

Session 02(8:00 pm to 8:50 pm SGT)
Title: Intro to Advanced Analytics in Power BI
Speaker: Nisal Mihiranga | @nisalm

Session Details:
Session 01(7:00 pm - 7:50 pm SGT)
Title: Cracking the Power BI performance!
Description:
Congratulations! You've built your shiny fancy Power BI report and your charts look terrific. But, your data refresh takes forever...Or, your report is utterly slow when interacting with visuals...You switch to DirectQuery mode to make things better, just to discover that the report performance sucks even more...
And, if you feel lost, I don't blame you - I've also been there!
That's why this session is for you: we will examine potential bottlenecks in your Power BI report - starting with defining the best practices for data model size optimization, understanding the importance of query folding feature, all the way to identifying culprits for your slow report rendering. We will wrap it up with learning when and why (not) to use DirectQuery mode, and how to apply improvements on the data source side to make things faster in the Power BI.
And, I'll tell you a little secret: there are no slides in this session - from the beginning to the very end, we'll be only in Power BI Desktop!

Speaker: Nikola Ilic | @DataMozart
I'm making music from the data! PowerBI and SQLServer addict, Microsoft Data Platform MVP, Pluralsight Author, blogger, speaker...Interested in everything related to data - always eager to extract valuable info from raw data in the most effective way. Multi-year experience working with (predominantly) Microsoft Data Platform (SQL Server, SSAS, SSIS, SSRS, and Power BI). Father of 2 and true football (and Barca) fan!

Session 02(8:00 pm to 8:50 pm SGT)
Title: Intro to Advanced Analytics in Power BI
Description:
Microsoft Power BI is a market-leading self-service BI tool that is constantly evolving. Aside from standard data pre-processing, modeling, and visualization, advanced analytics also can be performed. Knowing how to execute advanced analytics with Power BI is quite useful since it allows organizations to provide more meaningful insights in order to make better business decisions. In this talk, I'll illustrate how to perform advanced analytics with live demos.

Speaker: Nisal Mihiranga | @nisalm
Big Data engineering and Business Intelligence Professional who has overall 10 years of experience in IT domain, and 8+ years of exposure to the Microsoft Business Intelligence/Analytics stack and data-driven culture. I'm very passionate about Data Engineering/Data Science/ Machine Learning, related tools, and technologies. In my professional life currently, working as an Architect - Data Science & Machine Learning at Zone24x7 where I mainly focus on building data products and advanced analytics solutions to allow customers to make business decisions more effectively and efficiently. I'm a Microsoft Certified Trainer with experience in conducting technical training programs. As a tech community contributor, I share my knowledge with the community by writing technical articles, speaking at tech forums and conferences locally and overseas.