(Livestream Replay) [DAX] Window Functions & Tabular Editor 3 - with Daniel Otykier

ABSTRACT 📄

The Power BI December 2022 update included some exciting new DAX functions, that are all the buzz recently. Let’s explore these new functions using Tabular Editor 3’s DAX debugger to see what we can learn from them.

GUEST BIO 👤

Daniel is a Microsoft Data Platform MVP and CTO of Tabular Editor ApS – the company behind the tool. Tabular Editor is a popular tool for managing and editing Microsoft Power BI, Analysis Services, and Azure Analysis Services models. With a background in data analysis and business intelligence, Daniel has a strong understanding of the challenges and needs of BI professionals. He developed the Tabular Editor as a solution to streamline the process of managing and editing tabular models, and it has since become a go-to tool for many in the industry.

RELATED CONTENT 🔗

Tabular Editor Site
Daniel's Twitter
New DAX Functions (Dec ‘22 Power BI Release)

(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

(Livestream Replay) Best Practices for Report Design & DAX in Power BI - with Gustaw Dudek

ABSTRACT 📝

Microsoft Power BI tool consistently provides new features and capabilities to transform the raw data into meaningful insights. Effective UI/UX solutions can be driven by various different functionalities such as, but not limited to: built-in visual-related formatting options (including conditional formatting). In particular contexts, those options can be enhanced ever further by incorporating strategic DAX techniques. By using a combination of the following approaches, including design practices and DAX solutions, it is possible to create reports and dashboards that tell compelling stories from our data in a highly interactive way!

This presentation will demonstrate several practical design & DAX techniques that helps increase report transparency and user experience through the application of certain functionalities, interactions and formatting options.

GUEST BIO 👤

Gustaw Dudek works as the Head of Business Intelligence at the Polish Company (Enterium). He has multiple years of experience in the field of data analytics and business intelligence. In addition he's one of the resident Enterprise DNA Experts, having created multiple showcase reports for various EDNA contests. Despite of designing most of showcase reports in dark-mode, Gustaw is a huge advocate of IBCS chart standards and really enjoys exploring both the art and science of report design.

RELATED CONTENT 🔗

LinkedIn
NovyPro Portfolio

Introducing the Measure Killer (External Tool) for Power BI!

Learn about an up and coming external tool that makes it easy to identify and KILL unused measures and columns from a Power BI dataset (PBIX). Gregor Brunner will walk us through how to use this great tool, how it works, and more. Tune in to find out!

GUEST BIO 👤

Gregor Brunner is 34 years old, has a background in Economics but moved into Business Intelligence in 2016. Originally from Austria, he moved to Switzerland in 2020 and started Brunner BI, a boutique IT company that specializes in Microsoft Power BI development and consulting.

RELATED CONTENT 🔗

Measure Killer (Site)
Measure Killer (Microsoft Store)
Website