(Livestream Replay) Where to Find Data for your Power BI Practice? - with Roland Szirmai

ABSTRACT 📄

While it’s easy to download the official Advetureworks database from Microsoft to sharpen your Power Query / DAX / Dataviz skills in Power BI, it’s not always the most interesting data. If you truly want to immerse yourself in learning about how to transform less structured data, create measures that reflect more than just YTD Sales or practice how to best place your visuals on the canvas I reckon the most useful data is something that interests you!

In this livestream Roland and I will talk about 3 different examples where data can be found and if needed “created”.

Starting from a more structured, government issued dataset about road accidents in Australia. Then looking at a visitor information based on a shopping center data and visualizing busy areas and periods. And lastly, exploring resident information in a block of building, a dataset that anyone can easily replicate – even without any SQL skills.

Roland will also showcase that in our modern life we can find data everywhere and that could be used in our Power BI learning journey or to showcase some of your skills online or prep for a job interview.

GUEST BIO 👤

Roland Szirmai is an Analyst with 12+ years of experience in Financial, Commercial, and Operational reporting. Roland creates reports to express the true meaning behind numbers in an understandable way using modern tools such as Microsoft Power BI.

He uses his skill, knowledge, and expertise in Excel, Power Query, DAX, and Data Visualisation to help organizations transform from assumptions and guesswork to more informed, data-driven decisions making.

Roland is the creator of BI-Lingual Analytics a YouTube channel and blog dedicated to helping non-technical people learn more about and master Power BI.

People can find useful guides and videos on how to use this tool and sometimes just fun data-related articles. It’s all about helping business users to master Power BI and analytics – without too much IT involved.

RELATED CONTENT 🔗

BI-Lingual Analytics YouTube
BI-Lingual Analytics LinkedIn
BI-Lingual Analytics Twitter
Australian COVID-19 Lockdowns on Road Fatalities
Power BI Mall Hotspot Report
Use Data That's Close To Your Heart In Your Next DataViz Project

(Livestream Replay) Introducing TMDL for Power BI! - with Mathias Thierbach

ABSTRACT 📄

An early look at the Tabular Model Definition Language (TMDL), soon to be released by Microsoft as a public preview as part of the Tabular Object Model (TOM) libraries. TMDL was first presented at SQLBits in March 2023 and is the first of several new innovations and tools targeting the needs of Power BI Pro Developers.

It consists of new declarative format for tabular models, designed for readability and editability, as well as a standardized folder structure for those files (similar to tabular Editor's "Save-to-folder" format), enabling collaborative workflows. Mathias has implemented TMDL as part of the Power BI Contributor Program. He will present the key aspects of the language as well as its main benefits.

GUEST BIO 👤

Mathias is a Data Platform MVP and Head of Finance Systems at YouGov in London. He cares deeply about mature enterprise-grade development and delivery patterns and practices for Power BI. To that end, he has developed pbi-tools, which was released as an open source tool in October 2021. Furthermore,

Mathias has presented his learnings and best practices around Power BI DataOps, CI/CD, and Deployment Automation, but also talks on the organizational and managerial aspects of running a successful Poewr BI team at several international conferences and many user groups.

RELATED CONTENT 🔗

Mathias's Twitter
Mathias's LinkedIn
PBI Tools

(Livestream Replay) Report/Dataset Lifecycle Management for Power BI with Greg Baldini

ABSTRACT 📄

Everyone is familiar with the NASA countdown. T-minus-10, 9, 8... Anyone who has ever built a Power BI report knows how to publish that report. But ground control has a lot of work to do after liftoff. And a Power BI pro's work does not stop after they hit the 'Publish' button. The name for that work is operations. As Power BI matures, it is critical that we spend time and effort on operations. This work comprises monitoring, maintenance, user support, ongoing development, and change management among other things. Let's kick start the conversation around Power BI operations:
• What to do
• Out of the box features
• Tools you can build and buy to support operations in your organization

GUEST BIO 👤

He slices! He dices! When it comes to Power BI, Greg Baldini does it all, and he is here to show you how to, too!
Co-founder of Argus PBI, Greg has a decade of experience with DAX, Tabular, and the Power BI family of tools. His career has been spent in solving hard problems for clients and seeking deep understanding of the fundamentals of data analysis.

RELATED CONTENT 🔗

Company Website
Greg’s Blog
Greg’s Mastodon
Greg’s Twitter

(Livestream Replay) 5 Ways to Get Power BI Data into Excel! None are Copy Paste! - with Wyn Hopkins

ABSTRACT 📄

The reality is folks need / want their data in Excel at some point. While Power BI reduces that need, it still exists. Wyn’s demos will show how to connect using various approaches including a trick to create a connected table with the help of “create formatted table” feature of Power BI, and the largely unknown Featured Table option.

GUEST BIO 👤

Wyn Hopkins is a Microsoft MVP, trainer, consultant and author of the book “Power BI for the Excel Analyst”

Based in Perth, Western Australia, Wyn is the director of the Power BI and Excel consulting firm “Access Analytic”. Their YouTube channel has 40,000+ subscribers and he co-runs the Perth Power BI and Modern Excel meetup group. Once upon a time Wyn was a chartered Accountant with PriceWaterhouseCoopers but Wyn and team now spend their time delivering Power BI and Excel training along with reporting solutions for clients of all industries and sizes. Wyn’s claim to fame is that he suggested and campaigned for the creation of the XLOOKUP function.

RELATED CONTENT 🔗

Wyn's Book & Website
Wyn's Company Website
Wyn's Social Media Links