talk-data.com

Seasoned Experts Alberto Ferrari and Marco Russo Help You Master DAX for Superior Business Intelligence Solutions The Definitive Guide to DAX is an authoritative resource for mastering the DAX language, which is pivotal for creating measures for semantic models in Microsoft Power BI, Fabric, Analysis Services, and Excel. With years of experience since the inception of Power Pivot, the authors offer a comprehensive reference that navigates through the unique and complex concepts of DAX, making it an essential tool for BI professionals. This third edition updates you with the latest features and provides a framework for writing efficient DAX code, enhancing your ability to customize calculations in data models. You will gain the skills necessary to understand and apply advanced DAX concepts, structure code in user-defined functions, and leverage new calendars for time intelligence calculations. By reading this book, you will: Understand the foundational concepts of DAX and its unique language structure Master the use of evaluation contexts to enhance data analysis Utilize CALCULATE and CALCULATETABLE functions effectively Implement variables to simplify complex DAX expressions Leverage classic and new calendar based time intelligence functions Work with iterators to perform advanced calculations Apply visual calculations to improve report interactivity Create and manage calculation groups for dynamic reporting Handle complex hierarchies and relationships in data models Author DAX queries for testing and troubleshooting About This Book For BI professionals and Excel power users eager to deepen their understanding of DAX and enhance their data modeling capabilities with advanced techniques For data analysts and IT specialists seeking to optimize their use of Microsoft Power BI, Fabric, Analysis Services, and Excel for more efficient and insightful data analysis

¡EVENTO PRESENCIAL Y CON AFORO LIMITADO!

POR FAVOR, NO TE INSCRIBAS SI NO TIENES PREVISTO ASISTIR PARA QUE EL ASIENTO QUEDE LIBRE PARA PERSONAS INTERESADAS. ¡GRACIAS! 😊

Para asegurar tu asistencia, es importante inscribirse con anticipación debido al aforo limitado. No te pierdas esta oportunidad de aprender de uno de los mejores expertos en el sector.

El tema:

Composite models, that is the ability to extend an existing Power BI or Azure AS data model with new tables, columns and relationships, is the holy grail of self service business intelligence. In this session we describe the feature along with some details about how to implement it in your existing infrastructure. Then, we extend the knowledge beyond the basics, understanding the technical details of composite models, so to build efficient systems.

Hi, awesome Data People!

We have to announce the next big event at short notice because we have the chance to have one of the top DAX & Power BI experts in town, Alberto Ferrari from SQLBI. And, yes, he agreed to give a really cool talk.

And many thanks to Computer Futures for spontaneously offering us a venue! You people are amazing!

• 18:00 Open door and warm up networking round
• 18:15 Intro
• 18:30 Talk
• 20:00 Open discussion about Power BI/DAX & your data
• 21:00 The End...

Understanding visual calculations in Power BI

Visual calculations are a new 2024 feature in Power BI, aiming at making it simpler for users to develop calculations at the visual level. Visual calculations are implemented through a new set of DAX functions and the VISUAL SHAPE clause in DAX queries. In this session, we introduce the feature, and then we quickly go down to discover how it is implemented, when to use it, and what not to expect from the feature, so to make educated choices about when to use it or not.

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.

We are pleased to be able to offer you a Deep Dive Session Level 400 with Alberto Ferrari as part of our regional group meeting of the RG Rheinland.

As we unfortunately have to limit the places for this event to 9 participants, you should register early.

Understanding composite models in Power BI - Level 400

Provided that you already know what a composite model is, do you also know what the technical details to produce fast and efficient composite models are? In this very technical session we extend the knowledge beyond the basics, understanding the technical details of composite models, so to build efficient systems. We see in detail good and bad practices.

When learning DAX you will soon discover, that it is both, “easy, but hard” (© Alberto Ferrari).

On the one hand, the syntax of this language is very close to Excel formulas and easy to understand. On the other hand, the semantic of some functions is very challenging.

In this talk Markus will share the challenges he faced when learning the language and how overcame them. You will get a proper understanding of the differences between calculated columns and measures and you will learn of the concept of context and how to manipulate the context to achieve advanced calculations.

About the speaker:

Markus Ehrenmueller-Jensen

Markus Ehrenmüller-Jensen is the founder of Savory Data and works as a project leader, data engineer and BI architect since 1994. He is an educated software-engineer, graduated business educator and professor for databases and project engineering at HTL Leonding (technical college) and certified as MCSE Data Platform and MCSE Business Intelligence. Markus speaks regularly on international conferences (eg. SQL PASS Summit, SQLBits London, Power Platform Worldtour, SQL Saturdays, SQL Days, SQL PASS Austria, ...) and writes articles for well-known journals. In 2013 he co-founded SQL PASS Austria and in 2016 Power Platform Usergroup Austria (both were merged into Data Community Austria in 2021) and organizes Data Community Austria (fka. SQL Saturdays & Data Saturdays) in Vienna since 2014. For his technical leadership in the community he was awarded repeatedly as a Microsoft Data Platform MVP since 2017.

About the event:

• All presented times are Lisbon Time
• Meetup will be hosted in English

If you have any questions, please feel free to contact us.

Now expanded and updated with modern best practices, this is the most complete guide to Microsoft's DAX language for business intelligence, data modeling, and analytics. Expert Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. You'll learn exactly what happens under the hood when you run a DAX expression, and use this knowledge to write fast, robust code. This edition focuses on examples you can build and run with the free Power BI Desktop, and helps you make the most of the powerful syntax of variables (VAR) in Power BI, Excel, or Analysis Services. Want to leverage all of DAX's remarkable capabilities? This no-compromise "deep dive" is exactly what you need. Related Content Video: Introduction to Microsoft Power BI (Video), Data Analysis Fundamentals with Excel (Video) Perform powerful data analysis with DAX for Power BI, SQL Server, and Excel · Master core DAX concepts, including calculated columns, measures, and calculation groups · Work efficiently with basic and advanced table functions · Understand evaluation contexts and the CALCULATE and CALCULATETABLE functions · Perform time-based calculations · Use calculation groups and calculation items · Use syntax of variables (VAR) to write more readable, maintainable code · Express diverse and unusual relationships with DAX, including many-to-many relationships and bidirectional filters · Master advanced optimization techniques, and improve performance in aggregations · Optimize data models to achieve better compression · Measure DAX query performance with DAX Studio and learn how to optimize your DAX

This comprehensive and authoritative guide will teach you the DAX language for business intelligence, data modeling, and analytics. Leading Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. You’ll learn exactly what happens under the hood when you run a DAX expression, how DAX behaves differently from other languages, and how to use this knowledge to write fast, robust code. If you want to leverage all of DAX’s remarkable power and flexibility, this no-compromise “deep dive” is exactly what you need. Perform powerful data analysis with DAX for Microsoft SQL Server Analysis Services, Excel, and Power BI Master core DAX concepts, including calculated columns, measures, and error handling Understand evaluation contexts and the CALCULATE and CALCULATETABLE functions Perform time-based calculations: YTD, MTD, previous year, working days, and more Work with expanded tables, complex functions, and elaborate DAX expressions Perform calculations over hierarchies, including parent/child hierarchies Use DAX to express diverse and unusual relationships Measure DAX query performance with SQL Server Profiler and DAX Studio