0
Views
Microsoft Excel. Level 8. In-depth study of the Power Pivot model and the DAX language - course RUB 23,990. from Specialist, training, Date: December 2, 2023.
Miscellaneous / / December 05, 2023
You already have experience working with a Power Pivot model within Microsoft Excel or Power BI Desktop and at the same time realize that analytics requires knowledge of writing more complex formulas in the language DAX. When creating simple formulas, DAX formulas may seem very similar to Excel formulas, but this is far from true. Learning DAX on your own is very difficult. During the course, you will learn to distinguish between row and filter contexts, create measures based on data from related tables, and understand and correctly work with different types of relationships between tables. Knowledge of the DAX language opens up excellent opportunities for data analysis, building complex Power Pivot models and, as a result, reports with the necessary analytical data.
The course is of interest to all those involved in analytics: sales and purchasing managers, financial analysts, banking specialists, business consultants, marketers, entrepreneurs, business analysts, PR specialists, etc. The ability to work with data and provide reports on complex data models is a valuable and in-demand skill in the market labor.
This class will provide you with a deep dive into DAX. You will learn in detail how to work with linked tables and look at practical scenarios using DAX. Once trained, you will be able to create complex PowerPivot models and become fluent in the DAX language.
The minimum Excel version for this course is 2016. You must additionally install DAX Studio
-Create complex data models
-Distinguish between string and filter contexts
-Create measures based on data from related tables
-Understand and work with different types of relationships between tables
-Create measures with text results
-Use DAX Studio to understand calculation processes
Special purpose teacher, holder of prestigious international status Microsoft Certified Master. Graduate of Moscow State Technical University named after N.E. Bauman.
In his classes, Fedor Anatolyevich puts the principle at the forefront “Look to the root!” - it is important not only to study the operation of the mechanism, but also to understand why it works this way and not otherwise.
A generalist in the field of software design and development. He has many years of experience as a development team leader and chief architect. Specializes in enterprise application integration, web portal architecture development, data analysis systems, deployment and support Windows infrastructure.
The combination of engineering and natural science presentation styles allows students to convey the passion and creative approach of the teacher. Fedor Anatolyevich invariably receives the most enthusiastic reviews from his grateful graduates.
Experienced and demanding teacher, focused on high results. Author of the only authorized Microsoft Excel training courses in Russia. The training manuals compiled by Olga Vladimirovna have been established by Microsoft as a training standard...
Experienced and demanding teacher, focused on high results. Author of the only authorized Microsoft Excel training courses in Russia. The tutorials compiled by Olga Vladimirovna have been established by Microsoft as the Excel training standard.
He sees his task as a teacher in so that you can say: “I can do it!” I know how to do it! Achieving this result requires extensive teaching experience. Add to this passion for your work, and you get the formula for an ideal teacher!
Graduate of Moscow State Technical University named after N.E. Bauman. Regularly attending conferences gives her a deep understanding of the products taught, revealing the most relevant areas of application of their capabilities. Work experience allows us to achieve the target result in mastering the material with students of various levels of preparedness, ages, professions and interests. Practical assignments allow you to make learning Microsoft Office programs as interesting and effective as possible for each student. The original examples used for training are focused on solving current problems of the modern office.
Olga Vladimirovna implements educational projects of any complexity for leading Russian and foreign companies. Among its more than 14,000 graduates are employees of such companies as Loreal, Tetra Pak, Schneider Electric, Volkswagen Group Rus, Gedeon Richter-Rus, Moscow Interbank Currency Exchange, Australian Embassy, Walt Disney Company CIS, Samsung Electronics Rus Company, BANK URALSIB, MICHELIN Russian Company tire production, Nexia Pacioli Consulting, Air Rianta International Duty Free, Diva, Mobile TeleSystems, Housing Mortgage Lending Agency, Janssen Pharmaceuticals N.V., Robert Bosch, MegaFon, Johnson & Johnson, BSH Household Appliances, Colgate-Palmolive, Mosenergo, Tetra Pak CJSC, Home Credit and Finance Bank LLC, and a lot others.
Olga Vladimirovna is the author of publications:
Author of the Microsoft Excel 2019/2016 course. Level 6. Business analytics using Power Pivot, Power Query and 3D Map.
Author of teaching materials for Microsoft Excel courses:
Module 1. The main stages of working with the Power Pivot model (1 ac. h.)
-Loading data
-Creating relationships between tables
-Calculated columns and fields (measures)
-Hierarchies
-KPI
Module 2. Scalar functions in DAX (1 ak. h.)
-Numeric, logical and string functions
-Simple functions for working with the calendar
-Analytical calendar functions
-Other scalar functions in DAX
Module 3. Context for evaluating DAX expressions (2 ak. h.)
-Aggregation functions
-The concept of context
-What is affected by context?
Module 4. Filtering and context management (4 ac. h.)
-Filtering functions: ALL, FILTER, CALCULATE
-Problem solving: ranking, calculation of shares, etc.
Module 5. Relationships between tables (2 ac. h.)
-One-to-one connections
-One-to-many relationship
-Many-to-many relationship
-Inactive connections: causes and solutions using the USERELASHIONSHIP function
Module 6. Context and filtering in related tables (4 ac. h.)
-Selecting related rows from multiple tables using the RELATED and RELATEDTABLE functions
-Context in linked tables: Applying filters to linked tables Using filtering and linking functions together
-Applying filters to related tables
-Shared use of filtering and linking functions
-Filtering related tables: Context management when moving between tables Various scenarios for applying filters
-Context management when moving between tables
-Various scenarios for using filters
Module 7. Non-standard solutions in pivot tables (1 ac. h.)
-Using measures in PivotTable slicers
-Create measures with text results
Module 8. Introduction to DAX Studio (1 ac. h.)
-DAX Studio – measure and filter testing tool
-Query structure in DAX Studio
-Analysis of query results
Subscribe
YOU MIGHT ALSO LIKE