Skocz do zawartości

Aktywacja nowych użytkowników
Zakazane produkcje

  • advertisement_alt
  • advertisement_alt
  • advertisement_alt
Courses2024

Udemy - Advanced DAX in Power BI

Rekomendowane odpowiedzi

73f30773aefb445e1e41385b297ffd9d.avif
Free Download Udemy - Advanced DAX in Power BI
Published: 3/2025
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Language: English | Duration: 7h 18m | Size: 3.14 GB
Advanced DAX in Power BI: Exploring Advanced Techniques, Context & Filter Management, and Performance Optimization

What you'll learn
Master DAX functions, including aggregation, time intelligence, and logical functions for complex calculations in Power BI.
Understand DAX engine components, including VertiPaq and DirectQuery, and their impact on performance.
Learn advanced filtering techniques with functions like CALCULATE, KEEPFILTERS, and context transitions.
Gain expertise in time intelligence functions, including YTD, MTD, and SAMEPERIODLASTYEAR calculations.
Build and optimize data models using table manipulation and relationship functions such as UNION, RELATED, and USERELATIONSHIP.
Requirements
A stable internet connection
A laptop, desktop, or any other device that allows you to access the course videos
Power BI
Basic knowledge of Power BI
Description
The Advanced DAX in Power BI course is designed for individuals looking to deepen their understanding of Data Analysis Expressions (DAX) within the Power BI environment. This comprehensive course covers a wide range of topics, starting with foundational Power BI concepts such as data tables, lookup tables, and cardinality, before moving into more advanced DAX techniques and functions.Key concepts explored in this course are filter flow, DAX operators, and the essential functions of the DAX engine, including the formula engine and the storage engine. Parti[beeep]nts will gain an in-depth understanding of the VertiPaq engine and DirectQuery and will learn about compression, encoding methodologies, and the relationships between VertiPaq and Power BI models.The course also covers DAX error handling, scalar functions, logical functions, and table manipulation functions like SELECTCOLUMNS, ADDCOLUMNS, and UNION. Additionally, you will learn about complex DAX functions such as CALCULATE, KEEPFILTERS, and context transitions with practical exercises that enhance real-world understanding.A strong focus is placed on time intelligence, where you'll explore date table creation, commonly used time functions like SAMEPERIODLASTYEAR, and patterns for calculating YTD (Year-To-Date) and MTD (Month-To-Date) values. Parti[beeep]nts will also become proficient in advanced table functions and relationship management, such as USERELATIONSHIP and CROSSFILTER, which are crucial for building complex models.By the end of this course, you will have gained the expertise needed to use DAX in Power BI efficiently, optimize reports, and tackle advanced analytical challenges. Whether you're looking to accelerate your decision-making processes or refine your Power BI models, this course will provide the tools and techniques needed to take your skills to the next level.
Who this course is for
Power BI users with a basic understanding of DAX who want to deepen their knowledge and tackle advanced analytics
Data analysts and business intelligence professionals looking to enhance their Power BI reporting and modeling skills
Any professional interested in optimizing Power BI performance through advanced DAX functions and efficient data modeling techniques
Anyone seeking to learn time intelligence, complex filtering, and dynamic calculations to improve their data analysis capabilities
Homepage:

Ukryta Zawartość

    Treść widoczna tylko dla użytkowników forum DarkSiders. Zaloguj się lub załóż darmowe konto na forum aby uzyskać dostęp bez limitów.



Ukryta Zawartość

    Treść widoczna tylko dla użytkowników forum DarkSiders. Zaloguj się lub załóż darmowe konto na forum aby uzyskać dostęp bez limitów.

No Password - Links are Interchangeable

Udostępnij tę odpowiedź


Odnośnik do odpowiedzi
Udostępnij na innych stronach

Dołącz do dyskusji

Możesz dodać zawartość już teraz a zarejestrować się później. Jeśli posiadasz już konto, zaloguj się aby dodać zawartość za jego pomocą.

Gość
Dodaj odpowiedź do tematu...

×   Wklejono zawartość z formatowaniem.   Usuń formatowanie

  Dozwolonych jest tylko 75 emoji.

×   Odnośnik został automatycznie osadzony.   Przywróć wyświetlanie jako odnośnik

×   Przywrócono poprzednią zawartość.   Wyczyść edytor

×   Nie możesz bezpośrednio wkleić grafiki. Dodaj lub załącz grafiki z adresu URL.

    • 1 Posts
    • 7 Views
    • 1 Posts
    • 9 Views
    • 1 Posts
    • 9 Views
    • 1 Posts
    • 7 Views
    • 1 Posts
    • 5 Views

×
×
  • Dodaj nową pozycję...

Powiadomienie o plikach cookie

Korzystając z tej witryny, wyrażasz zgodę na nasze Warunki użytkowania.