(Livestream Replay) Demystifying Fabric's SQL Architecture & Best Practices - with Bogdan Crivat

DESCRIPTION 📄

Join Microsoft Azure's Corporate Vice-President (VP) Bogdan Crivat and I for this special livestream where we'll do a deep dive into the engineering behind the SQL architecture in Fabric, and how it's both similar and different from the SQL architecture you'd find in various Azure SQL databases. Plus he'll also demo and discuss some best practices for implementation of both Fabric Data Warehouses and Lakehouses. Tune in to learn more!

GUEST BIO 👤

Passioned about advanced analytics, machine learning, in-memory databases and parallel computing. His background is in Mathematics and Computer Science. Bogdan received a degree in Computer Science at University of Bucharest (1997) and a PhD degree from Universitatea Transilvania of Brasov, Romania (2011). He is also the author or co-author of 13 patents (and a number of pending applications), mostly in the areas of data mining, predictive analytics and in-memory analytics.

RELATED CONTENT 🔗

What is Data Warehousing in Fabric?
What is a Fabric Lakehouse?
Bogdan's LinkedIn

(Livestream Replay) Power BI Performance Tuning: Why is my report slow now? - with Eugene Meidinger

DESCRIPTION 📄

Your boss asks you the question: "Why is this report slow?". Ideally it would be a simple question, but it's not. Power BI is made up of multiple pieces of software, each with different techniques for benchmarking performance and for fixing issues. In this talk, we'll cover how to identify the source of the problem, measure performance, and make improvements. We'll cover tools like the built-in performance analyzer, DAX Studio, and SQL Server management studio. By the end of this livestream, you'll have a set of techniques and tools for optimizing your Power BI Reports.

GUEST BIO 👤

Eugene Meidinger works as an independent BI consultant and Pluralsight author, specializing in Power BI and the Azure Data Platform. He has been working with data for over 10 years and speaks regularly at user groups and conferences.

RELATED CONTENT 🔗

Blog
Courses
Social Media

(Livestream Replay) Managing Power BI, to Prepare for Fabric - with Alex Whittles

DESCRIPTION 📄

Power BI is in place in almost all organizations, with varying degrees of effectiveness in its implementation. The introduction of Fabric introduces a transformative shift, amplifying both the opportunities and complexities associated with Power BI. Consequently, it becomes imperative to proactively manage your Power BI ecosystem, focusing on key aspects such as structure, security, processes, and monitoring. This not only establishes a solid foundation for Power BI governance, but also paves the way for migrating your data engineering workloads into Fabric, while retaining full control, transparency, and governance over your data environment.

GUEST BIO 👤

Alex is a 9 year Data Platform MVP, and is the owner and principle consultant at Purple Frog Systems, a Microsoft Data Analytics consultancy in the UK with multinational clients in a variety of sectors. He specialises in the architecture and design of all aspects of data warehousing, ETL, cubes, Power BI and Machine Learning. He’s also the creator of Power BI Sentinel. Alex is on the organizing committee for the SQL Bits conference, and is a regular speaker at many data events around the world including SQL Bits, Data Relay, SQL Saturdays, Data Grillen, 24 HOP and the PASS Summit, and has a Masters degree in Business Intelligence.

RELATED CONTENT 🔗

LinkedIn
Purple Frog Website
Power BI Sentinel Website

(Livestream Replay) Create your own Power Query Connector for Power BI & Dataflows - with Miguel Angel Escobar

DESCRIPTION 📄

Ever wanted to connect to a data source that is not listed in Power BI or Dataflows? This session will show you everything that you need to know to better understand the landscape of connectors in Power BI and Dataflows, how to connect to sources not listed in Power BI and when / how to create your own connector for Power BI and Dataflows.

GUEST BIO (Miguel Angel Escobar) 👤

Born and raised in Panama City, Panama. I’m currently a Program Manager at Microsoft for the product that changed my life: Power Query. Before this Program Manager role, I was the Principal Consultant and President of my own company based in Panama called Powered Solutions which was a Microsoft Gold Partner in Data Analytics for many years. I'm a former Microsoft MVP, MCP, MCT and author of books related to Data Prep and Data Analytics.

RELATED CONTENT 🔗

Miguel's LinkedIn
Creating Your First Connector
Power Query SDK Overview