(Livestream Replay) AI Assistant for Tabular Editor - Andrzej Leszkiewicz

DESCRIPTION 📄

Discover how to enhance your Power BI workflow with Tabular Editor and the OpenAI API. This presentation demonstrates how, with a few simple C# scripts, you can directly access the OpenAI API from Tabular Editor to create a custom AI assistant with full access to your Power BI report’s data model—including tables, columns, relationships, measures, calculation groups, and more. Use this assistant to comment on DAX code, generate model documentation, write measures, and more, harnessing the full power of the latest OpenAI models—all without the need for Power BI Premium or Fabric capacity. An OpenAI API subscription is required, and Tabular Editor 3 is necessary.

GUEST BIO (Andrzej Leszkiewicz) 👤

Andrzej is a Power BI and data visualization developer and consultant, data explorer, explainer, and visualizer. He creates highly customized, interactive visualizations using the Vega visualization grammar and Deneb. Andrzej has introduced IBCS-styled data visualizations, embedded into Power BI's built-in Table, Matrix, and Card visuals. An IBCS® Certified Analyst, he is a passionate advocate of IBCS standards. With a background as an IT project manager and CIO in non-IT companies, Andrzej has been a full-time independent freelance Excel and VBA developer and consultant since 2011, focusing entirely on Power BI and data visualization since 2020. Through his YouTube channel, LinkedIn, and other social media, Andrzej shares his knowledge and passion for data visualization and related topics.

RELATED CONTENT 🔗

Tabular Editor
Open AI API
Andrzej's Youtube
Andrzej's LinkedIn
Andrzej's Blog
Andrzej's GitHub

(Livestream Replay) Semantic modeling in VS Code? Introducing the TMDL Extension - Sid Vemuri

DESCRIPTION 📄

In this video, we’re diving into the power of Tabular Model Definition Language (TMDL) and showing you how it can level up your data modeling and development workflow. TMDL is a valuable tool for anyone working with semantic models, and we’ll start by discussing what it is and why it’s worth incorporating into your process.

We’ll then explore the VS Code extension for TMDL, including the motivation behind its creation and the suite of features it offers. From a streamlined editing experience to source control capabilities, this extension brings a lot to the table. In a live demo, we’ll edit a semantic model together, highlighting essential aspects like setting up a smooth development workflow with workspace Git Integration, leveraging the rich editing features, and using the built-in source control in VS Code for version control and collaboration. We’ll even explore how GitHub Copilot can boost productivity with some practical use cases.

Finally, we’ll wrap up with a Q&A session to answer your questions live, helping you make the most out of TMDL and VS Code. Ready to see it all in action? Watch along as we build a semantic model from the ground up and showcase the latest tools and best practices to optimize your development experience.

GUEST BIO 👤

Sid Vemuri is a Technical Program Manager at Power BI that is focused on building features for Power BI Developers. He received his master’s in computer science with a specialization in machine learning from Georgia Tech in 2023 and has dived into all things data including data science, data visualization, data modeling, and, of course, business intelligence. In his free time, Sid enjoys adventure travel, training in mixed martial arts, outdoor activities, and board games.

RELATED CONTENT 🔗

TMDL Extension on VS Marketplace
Tabular Model Definition Language (TMDL) | Microsoft Learn
Power BI Desktop developer mode documentation - Power BI | Microsoft Learn
Siddhartha (Sid) Vemuri | LinkedIn

(Livestream Replay) Semantic Model Ideation for Power BI - Leslie Welch

DESCRIPTION 📄

Building a performant star schema semantic model for Power BI enables simpler DAX, improved load time and responsiveness, and ensures that you are able to use the visuals that will best communicate your data. When starting with a snowflake, disparate data sources, or one big table, it can be a challenge to build something from the start that is going to fit your user requirements.

Enter the semantic model ideation process. My team and I use this process to help clients create performant secure data models aligned to a star schema and Power BI best practices. Attendees will walk away with an understanding of what information they need to start this process, how to work through the steps, and how to validate the proposed model will support their visuals. We will work backwards from what data you need to support the user questions, what Power BI needs to support the visuals, and an overview of the approach to building out your medallion architecture technical requirements for Synapse or Databricks to enable Power BI semantic models.varius morbi.

GUEST BIO 👤

Leslie Welch is the Principal Fellow of AI & Analytics at Excella with over 16 years of experience in automation, data analysis and visualization, and strengthening organizations’ knowledge of data. Leslie has worked end to end in the data arena from capture and ETL to database design/engineering to analysis and dashboard design to ML use cases with a focus on improving productivity, performance, and data quality. She has extensive experience in enterprise deployment of Power BI, both as an admin and Power BI architect and a trainer and technical community organizer. She is passionate about data governance, truth telling in data, and responsible application of ML/AI. Leslie is co-organizer of Power BI DC, and frequently attends and speaks at data community meetups in the DC metro area. Leslie was recognized as a 2023 New Power Woman in Tech by DCA Live, and made the 2024 RealLIST Engineers for her role in helping the DMV tech ecosystem grow.

RELATED CONTENT 🔗

Leslie's LinkedIn
Meetup Group

(Livestream Replay) Power BI Developer Mode: Connecting the Dots and Merging the Chaos! - Miguel Felix

DESCRIPTION 📄

Ever feel like Power BI is throwing you into a maze of connections and scattered reports? Fear not! In this fun and interactive session, we’ll dive into Power BI's Developer Mode to demystify the process of updating connections on your models and seamlessly merging two reports into one masterpiece. No more data juggling or report chaos—just a smooth path to Power BI harmony! Whether you're a data wrangler or a curious BI enthusiast, this session will have you laughing, learning, and connecting all the right dots.

GUEST BIO 👤

Miguel Félix is a Lead BI Architect, with a background in finance with experience in several different areas like banking, events, manufacturing, wholesale, services. Data analysis was always a part of his daily tasks and the change from Excel to Power BI was a step in the right direction allowing him to change to consulting in BI in 2021. The engagement with the community was also a natural and he is a Super User in the Fabric community since the start of the program back in 2018 that allowed him to achieve a Microsoft MVP for the first time in 2019, after that came the blog and the presentations about everything related with Power BI and Fabric.

RELATED CONTENT 🔗

Linkedin
Blog
Twitter
GitHub