(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) No More Data Quality Surprises! - with Dave Ruijter

ABSTRACT 📄

Do you know your data? Do you have confidence in the data of your Power BI solutions, no matter what? And do you already actively monitor for deviations from those expectations? Being in control of your data (quality) is essential for any solution, and it can be quite difficult to achieve in Power BI. In this demo-rich session you will learn how you can implement a framework for data validation and monitoring! We'll leverage an open source library called Great Expectations to quickly get up-and-running. Become in control of the data quality of your solutions!

GUEST BIO 👤

Dave is a hands-on solution and platform architect, and implements solutions using Power BI and the Azure Data Platform. He brings a vast amount of consultancy experience to the table and is always eager to take things to the next level. Dave has received the Microsoft MVP Award twice for his deep knowledge of Microsoft products and services and community leadership.

RELATED CONTENT 🔗

Great Expectations
Dave’s Blog
Dave’s LinkedIn
Dave’s Twitter
Dave’s GitHub

Guided Tour of My Office, Battle Station, and Home!

Video by: Reid Havens

I've been making videos for over three years now. With that in mind, I wanted to share a little more about myself and where I work, make videos, and live on a day-to-day basis. Tune in to get a grand tour!

(Livestream Replay) Top Secrets of Power BI Report Design! - with Mara Pereira

ABSTRACT 📝

A lot of the focus on Power BI report development goes to the backend (transforming and cleaning data, data modelling, DAX…). However, most people that will use your reports will not be able to see that backend, they will be interacting with the frontend. So, a question came up: why are most Power BI Developers not putting a lot of effort into the frontend of their reports? The answer was surprising: developers didn’t feel they were very creative, they struggled to understand what good/bad looks like. During this session, we will be discussing how to approach frontend development in Power BI, and we will be learning about some of the tricks that you can use to make sure your designs always look great! You will learn how you can get ideas for creativity, how to apply those ideas, and no, you don’t need to be a Picasso!

GUEST BIO 👤

Mara is the Founder of Data Pears. You might know her from her blog and YouTube channel, where she regularly posts blogs and videos about Power BI, Data Visualization and Data Analytics. Mara loves everything around data visualization and report design and her main goal is to change the world of reporting, one report at a time. She believes that effective reporting solutions are more than just data and charts, they are a beautiful combination of data, insights, and user experience. After working with Power BI for 6+ years, she decided to embark on an entrepreneurship journey, with the focus on guiding enterprise customers and individuals on their Power BI journeys. Before that, she was a Cloud Solutions Architect for Data & AI at Microsoft.

RELATED CONTENT 🔗

YouTube
Blog
LinkedIn
Twitter