Posts filed under DAX

IBCS Styled Bullet Chart for Native Tables in Power BI!

Video by: Reid Havens

Learn how to utilize an SVG image template to add an IBCS (International Business Communication Standards) inspired bullet chart to your native matrix or table visuals in Power BI Desktop.

RELATED CONTENT πŸ”—

IBCS Bullet Chart
InfoRiver Matrix (IBCS Certified)

Posted on March 21, 2023 and filed under Intermediate, Visualizations, DAX.

(Livestream Replay) [DAX] Best Practices 101 for Optimization & Performance - with Alberto Ferrari

ABSTRACT πŸ“„

Despite being usually very fast, DAX can be optimized, like any other computer system. Optimizing DAX requires a deeper understanding of the internals of the engine, because most optimizations are not intuitive. We will talk about the basics of optimizations, looking at some examples of code and discussing together ideas and options to make the code faster.

GUEST BIO πŸ‘€

Alberto started working with SQL Server in 2000 and immediately his interest focused on Business Intelligence. He and Marco Russo created sqlbi.com, where they publish extensive content about Business Intelligence.

Alberto published several books about Analysis Services, Power BI, and Power Pivot. He is a Microsoft MVP and he earned the SSAS Maestro title, the highest level of certification on Microsoft Analysis Services technology.

Today, Alberto's main activities are in the delivery of DAX and data modeling workshops for Power BI and Analysis Services all around the world. Alberto offers consulting services on large and complex data warehouses to provide assessments and validation of project analysis or to perform specific problem-solving activities.

Alberto is a well-known speaker at many international conferences, like PASS Summit, Sqlbits, and Microsoft Ignite. He loves to be on stage both at large events and at smaller user groups meetings, exchanging ideas with other SQL and BI fans. When traveling for work, he likes to engage with local user groups to provide evening sessions about his favorite topics. Thus, you can easily meet Alberto by looking up local Power BI user groups during scheduled courses.

Outside of SQLBI, most of Alberto's personal time is spent practicing video games, in the vain hope of eventually beating his son.

RELATED CONTENT πŸ”—

SQLBI Website

(Livestream Replay) Inside Bravo for Power BI - with Marco Russo

ABSTRACT πŸ“„

Explore the features available in Bravo for Power BI: Analyze Model, Format DAX, Manage Dates, and Export Data. In particular, we will see how it is possible to customize and deploy a date table for an entire organization!

GUEST BIO πŸ‘€

Marco Russo wrote several books about DAX and data modeling for Power BI and Analysis Service with Alberto Ferrari. Marco regularly publishes new content on sqlbi.com and teaches DAX around the world.

RELATED CONTENT πŸ”—

Bravo for Power BI
SQLBI Website
Marco's Twitter
Marco's LinkedIn

Posted on January 27, 2023 and filed under Livestreams, Beginner, Data Modeling, DAX, External Tools.

(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)

Posted on January 6, 2023 and filed under Livestreams, External Tools, DAX.