(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

Hiding Measures from [DAX] Intellisense!

Video by: Reid Havens

When creating datasets with build permissions (shared datasets), many of us know to hide fields from the data pane. But did you know you can also "hide" measures from the intellisense list in DAX? In this video learn how to use tabular to configure a table property to hide any measures inside of that table, from any DAX intellisense when writing measures. Further increasing usability when creating shared datasets in the Power BI service!

PLEASE NOTE this is not (officially supported) by Microsoft. But is a relatively safe setting to modify. Just be aware Microsoft doesn't provide support for this. More info below at the tabular editor link

RELATED CONTENT 🔗

Data Goblin Report Layer Article
Tabular Editor Private Setting

(Livestream Replay) Power BI Governance (Why Should I Care) - with "Ásgeir Gunnarsson"

ABSTRACT 📄

For many the mention of governance gives them images of massive effort and inconvenience for themselves and end-users. It´s a hindrance and waste of time. But it doesn´t have to be that way. Yes, governance is an ongoing effort that doesn´t end and yes depending on industry it might get complicated but getting started and getting far can be done in as little as few weeks. In this session we will talk about how we can start to tackle Power BI governance. We will look at a few things you can get started with very quickly that will get you far in setting up your governance strategy.

Power BI developers and consumers are normally only on the receiving end of governance decisions. But they should care, and they should understand it if they want to influence the process. If you know what it´s about and, at least, how it works in broad terms, you can influence it. If your admins turn a feature off or limit what you can do, know exactly what it means might help you understand why or influence them to change it (if it´s the wrong decision).

We will look at the main components of a Power BI governance strategy, what they mean and why Power BI developers should care.

GUEST BIO 👤

Ásgeir is a highly accomplished Business Intelligence professional with over 15 years of experience and recognition as a Microsoft Data Platform MVP. He is skilled in utilizing the complete Microsoft BI stack, including Azure Synapse Analytics and Power BI, to design and develop innovative solutions. Ásgeir is a sought-after speaker at both domestic and international events and is a co-organizer of several industry-leading conferences such as Power BI Cruise, Power BI Next Step, and Data Platform Next Step. He is also a co-author of two notable books, "Pro Power BI Administration" from APRESS and the "Power BI MVP" book. With a passion for data and a love for solving problems with BI, Ásgeir is dedicated to delivering outstanding results for his clients.

RELATED CONTENT 🔗

Ásgeir’s Blog
Ásgeir’s LinkedIn
Ásgeir’s Twitter

(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