Dax In Power Bi
Duration: 3 Days
Learn DAX : Data Analysis Expression
DAX is a Formula language written to a Pivot table.
DAX, has more than 200 function and counting. The rich DAX formula language includes libraries of incredible capabilities to perform computational gymnastics on your data and create powerful analytical data models.
The strength of Power Pivot comes from the DAX Language that can be used effectively on the Data Model to perform calculations on the data in the data tables. You can have Calculated Columns and Calculated Fields ( Measures )defined by DAX that can be used in the Power PivotTables and Power PivotCharts.
We start right from the Basics of DAX, understanding FILTER CONTEXT, CURRENT ROW CONTEXT, CONTEXT Transition, ALL, FILTER, RELATEDTABLE, CALCULATE, EARLIER, Relationships and much more.
How to Evaluate a DAX statement under different scenario’s, depending on your Data Model.
In the last phase of this course, you will learn about Time Intelligence and Date Tables. We will look at expressions such as TOTALYTD, SAMEPERIODLASTYEAR, DATESADD, DATESBETWEEN, CALENDERAUTO, and we will explore how many of these functions work using CALCULATE
Let’s take an example: Calculating the Sales for a Given Year, and to compare it with the Previous Year, on the basis of a Slicer.
This Advanced Excel Course will empower the participants to be able to do the following:
- Performing complex calculations more efficiently, using various Excel functions.
- Organizing and analyzing large volumes of data.
- Creating MIS reports.
- Designing and using templates.
- Consolidating and managing data from multiple workbooks.
Dax In Power Bi Course Module 1: Data Modelling
- Introduction to Data Models
- Normalization and Denormalization
- Star Schemas:
- Over Denormalization
Dax In Power Bi Course Module 2: DAX Language
- Introduction to DAX
- Calculated Columns and Calculated Fields (Measures)
- DAX Error Handling
- Overview of DAX Functions
- RELATED and RELATEDTABLE functions
- FILTER and ALL functions
- CALCULATE function
- Visual Totals and ALLSELECTED
Dax In Power Bi Course Module 3: Basic Time Intelligence
- What is Time Intelligence:
- Calendar Table:
- Counting Working Days
- Multiple Calendar Tables
- Aggregations Over Time
Dax In Power Bi Course Module 4: Creating Reports and KPI
- Using KPI in Power Pivot
- Advanced Excel Features for Power Pivot
Dax In Power Bi Course Module 5: Advanced DAX Concepts
- Important DAX Concepts
- Filter Context
- CALCULATE Row Context
- Evaluation Contexts and Relationships
- Context Transition ALLSELECTED
Dax In Power Bi Course Module 6: Advanced DAX Functions
- Advanced DAX Functions and Patterns
- Semi Additive Measures
- Event in Progress
I did online training for Power Query & DAX from Compufield. Our trainer Mr. Faiyaz is a thorough professional with complete knowledge of the subject, and he makes sure everyone has understood the concept before starting any new topic.
We had a training in HRIPL for power BI by Mr. Faiyaz Compufield. It was a great learning in power query, DAX and now we know how to talk to data. The trainer Faiyaz has a very good convincing and training skills and use examples as per your level. He understand the issues and give personal focus to each students. thanks for such a wonderful training.. will have more..
Attended Corporate Training for Power Bi & DAX by Mr. Faiyyaz. Excellent session, comprehensively delivered from the very basic concepts to the most advanced ones passionately while clearing all queries on the fly. Would highly recommend the session.
Amazing training. I was able to prepare excel dashboards for my organization with their teachings and methods. Even my doubts were solved. Special thanks to Sabiha ma'am and Shaziya ma'am for their training.
I am a student of Xavier Institute of Communications and I undertook a course on Microsoft Excel by Faiyaz Khairaz sir and it was super interactive and fun! The content is very relevant and the teaching style made it easy to comprehend. Would recommend to anyone looking to grab similar skills!
have done the online learning from Faiyaz on powerbi and power queries and I found his training extremely useful. Faiyaz explains the topic really well and he follows the problem solving method when teaching. This method is extremely effective when learning, remembering and applying the technique in the real world working environment. This has already made a lot of my routine tasks automated.