Creating Dynamic Power BI Reports with conditional formatting

Power BI’s fx buttons may look small, but they can make a big difference in your reports. In this demo session, I’ll show you how to use these buttons, situated in the Format pane, to make your visuals change based on your data and create reports that stand out.

We’ll go through clear examples, look at key DAX formulas, and explore the Format pane together to see how these tools work in real-life situations. You’ll leave with practical tips and fresh ideas to make your reports both useful and clean.

In this session, you will learn:

o How to use fx buttons to make your reports more dynamic.
o Simple DAX formulas that help you apply fx functionality.
o How fx buttons can change the way your visuals look and feel.
o Tips to create reports that are easy to use and look great.

This session will inspire you to take your Power BI reports to the next level!

Boost Your Data Career with Dashboard Challenges

Are you intrigued by dashboard challenges but feel hesitant to participate? You're not alone. Join us for an engaging non-tech session that uncovers the hidden potential of dashboard challenges, regardless of your experience level.

Overview:

Participating in 26 dashboard competitions has transformed my perspective on data, and now I'm on a mission to inspire you to explore the remarkable world of dashboard challenges. In this non-technical session, we'll explore how dashboard competitions can help you become a more skilled data storyteller.

What to Expect:

◻ Discover the power of dashboard competitions, regardless of your current skill level.
◻ Learn how to overcome the common doubts that stop you from submitting your dashboards.
◻ Dive into the 'what,' 'how,' and 'why' of participating in these competitions, with practical tips from my own experience.
◻ Boost your confidence in your abilities and see how participation can enhance your data storytelling skills.
◻ Share your thoughts and experiences through interactive polls.
◻ Get a sneak peek at a comprehensive challenge portfolio that can set you on your path to success.

Who Should Attend:

This session is for those who want to dive into Power BI dashboard building and explore the exciting world of dashboard challenges. It's also beneficial for experienced developers who may be hesitant to showcase their work.

Join me on this exciting journey to advance your data career through dashboard challenges. Don't miss out on the chance to fuel your passion for data without needing to be a technical expert.

I'm a passionate Challenge Dashboard builder. After submitting to 28 worldwide challenges and organizing yet 2 Power BI DashboardDuels, I'm convinced These challenges can boost your career and I love to convince others too!

Link to my portfolio
https://www.mavenanalytics.io/profile/Marjolein-Opsteegh/36654856

Link to our own challenges
https://inergy.nl/dashboard-duel/

I gave this session a couple of times in different settings. I always update my sessions regarding the audience and my own new experiences

The Pros and Cons of Building Accessible Reports

Have you ever wondered what it takes to build an accessible report? What does "accessible" really mean in this context? Is it worth the extra effort and cost? And most importantly, is it even necessary?

Join Valerie, Lonneke, Elena, and Marjolein—four professional report developers focusing on design, UX, and accessibility—as we dive into these questions.

In our daily work, we encounter various clients with different perspectives on accessibility. Some see it as a must-have, while others are less convinced. How do we provide guidance? And what happens when a client doesn’t think accessible design is worth the investment?

Join our table talk to hear our experiences, insights, and opinions on building accessible reports.

Step into the spotlight, write with confidence on LinkedIn

Have you ever felt unsure about sharing your thoughts or experiences on LinkedIn? Maybe you’ve wanted to share your personal journey but didn’t know where to start or were worried about how your posts would be received. This session is designed to help you overcome those doubts and unlock the power of personal storytelling.

In this session, I’ll inspire you to embrace your authentic voice on LinkedIn, showing you how to create engaging, genuine posts that connect with others. We’ll explore simple tools like ChatGPT and Canva to help you craft content that feels true to you, while also breaking down how the LinkedIn algorithm works to maximize engagement.

By attending this session, you will:

o Find your voice and gain the confidence to share personal stories on LinkedIn.
o Learn how to create posts that are authentic, engaging, and resonate with your audience.
o Understand the LinkedIn algorithm and how to use it to build meaningful engagement.
o Discover how to overcome self-doubt and maintain a consistent posting habit.
o Leave inspired and ready to share your story with the world.

Expect live demonstrations of how to use ChatGPT and Canva to streamline your content creation, leaving you with the tools you need to start sharing your journey confidently and consistently.

This session is all about inspiring you to start sharing your personal story, without focusing on professional goals or viral success, just authenticity and self-expression.

6 tips to build an End-User friendly dashboard

Creating a beautiful dashboard is only half the battle, ensuring it’s adopted and loved by your end-users is where the real challenge lies. In this session, based on real-world experience, I’ll share six practical tips that have helped organizations move from ignored dashboards to highly engaged users.

Drawing on insights from countless end-user workshops, I’ve seen the difference thoughtful design can make. One user navigates a dashboard like they built it themselves, while another struggles without guidance. The key? Structure, predictability, and usability.

This session will walk you through actionable strategies, such as:

o Using blank buttons to enable seamless navigation between pages.
o Leveraging tooltips to provide on-demand user assistance.
o Adding a homepage to improve accessibility and user experience.

You’ll see real-world demos that illustrate how small changes in design can make a huge difference for end-users. These tips are tailored for dashboard builders of all skill levels who want to create dashboards that are intuitive, clutter-free, and highly effective in driving engagement.

By attending this session, you will:

o Learn practical techniques to make your dashboards easier for users to navigate and understand.
o Discover how structured, predictable design improves user satisfaction and adoption.
o See real-world examples of dashboards transformed into tools users rely on daily.
o Gain insights you can apply immediately to your own projects.

Join me to take your dashboards to the next level and ensure they deliver value by being loved, not overlooked.

Consistent Power BI reports with templates and themes

Do you find yourself spending a significant amount of time preparing your Power BI report canvas and defining your visual characteristics, repeatedly? Struggling to maintain consistency throughout?

Working neatly, clutter-free, and consistently is important, but it can also give you a lot of headaches.

Did you know it is relatively easy to extract your theme from Power BI and manipulate it to eliminate rework?

Combined with a standard background template, this will save you a lot of time and make consistency much easier.

In this session, we will first take a look at dashboard design best practices and explore the standard functionalities of Power BI. Next, we will briefly examine how to prepare background templates in Figma. Finally, I will guide you through everything you need to know about JSON design themes.

We will cover:

- How to set up a Power BI theme checker file
- How to use the checker
- How to extract and manipulate a JSON file
- How to quickly start a new project.

Furthermore, I will provide a set of background templates, my theme checker, and some JSON files to assist you in implementing what you've learned.

Unlocking Power BI's Full Potential for Business Users

Discover how to get the most out of your Power BI dashboards in this session tailored for business professionals who don't build reports but want to make the most of them. We'll share practical tips and strategies to enhance your experience as an end user.

We will explore a variety of topics, including:

🟢 How to use tooltips for deeper insights
🟢 Ways to interact with reports for better data exploration
🟢 Different filtering options and how to use them effectively
🟢 The difference between drill down and drill through features
🟢 How to sort tables and visuals for clearer data presentation
🟢 Creating bookmarks to quickly access your favorite views

Whether you're new to Power BI or looking to sharpen your skills, this session offers practical knowledge you can use right away.

It's perfect for those in a viewer role and developers interested in understanding user experience challenges. Join us to fully unlock the potential of your Power BI dashboards!

10 tips to build an end-user friendly dashboard

In this session, I will give you 10 tips to build a dashboard "they won't ignore".

Even if you have built such a beautiful dashboard, if your users ignore it, or if the users don’t know what hidden functionalities it contains, it won’t be a success.

During end-user workshops, I‘ve seen huge differences in the speed of adaptation. One clicks around as if he built it himself while the other needs to be taken by the hand and a manual for later.

It is very important to build your dashboard in a structured and predictable way, clutter-free, so the user experience is positive.

In this interactive session, we look at the various options that you have, as a dashboard builder, to make the use of the dashboard easier for all end-users.

This session is intended for dashboard builders and is suitable for all skill levels.

Think about,

✔ The critical importance of alignment in design

✔ How to maintain consistency in color and fonts for a polished look

✔ Effective use of blank buttons for seamless page navigation

✔ Leveraging tooltips to provide user guidance

✔ The significance of adding a homepage to enhance dashboard accessibility

Don't miss out and take your dashboard projects to the next level!

Explore vs explain, when do you build which dashboard and how?

Session Overview:
When it comes to creating impactful data dashboards, design choices matter. In this engaging session, we'll dive into the world of dashboard design and explore the key decision of whether to craft an exploratory or explanatory dashboard.
You'll gain a deep understanding of the differences, their respective advantages, and how to effectively set them up. Whether you're new to data visualization or a seasoned pro, this session will provide valuable insights into creating dashboards that deliver results.

What to Expect:
◻ Dashboard Basics: Learn the fundamental concepts of dashboard design, and discover the power of exploratory and explanatory dashboards.
◻ Advantages Unveiled: Understand the strengths and weaknesses of each dashboard type, and when to use them for data analysis and presentation.
◻ Practical Design Tips: Gain hands-on knowledge as we delve into the principles of effective dashboard design, including consistency, clarity, and layout.
◻ Enhance Your Skills: Improve your data visualization skills and become more proficient at designing dashboards that communicate your data effectively.
◻ Interactive Q&A: Engage in a lively Q&A session and participate in discussions to address your specific questions and explore best practices in dashboard design.

Who Should Attend:
◻ Data analysts, scientists, and professionals seeking to improve their data visualization and dashboard design skills.
◻ Business intelligence and data reporting professionals looking to create more impactful dashboards.
◻ Anyone interested in understanding the critical choices involved in dashboard design and how to make informed decisions

Join us for this illuminating session and unlock the potential of data dashboards in your work. Whether you're a data enthusiast or a data professional, this is a valuable opportunity to refine your dashboard design skills and take your data presentations to the next level.

This was my first public session at the Dutch Power BI user group.

I love this session and improved it for SQLBits in March 2024 where I go to present this 50-minute version.