By Kumail Raza, Data Analytics

Fundamentals of Data Analysis Expression DAX

Language: English
All Levels
Fundamentals of Data Analysis Expression DAX

Course description

Data Analysis Expression DAX Tutorial which includes topics on; -Syntax -Row Context -Filter Context -Calculated Column -Measure -Implicit Filter -Explicit Filter -Iterators -Evaluation Context Examples of simple to complex functions including -SUM function -SUMX function -AVERAGEX function -CONCATENATEX function -FILTER function, -CALCULATE function -RELATED function -RELATEDTABLE function etc. These functions are discussed with reference to business logic, use cases and examples of visualization.

Related Skills

Course overview - 9

  • Introduction to Data Analysis Expression

  • Installing Microsoft Power BI

  • Calculated Columns with Example Functions

  • Measures in DAX

  • Filter Function in a Measure

  • All Function in a Measure

  • Iterators

  • Iterator Examples

  • Iterator Evaluation Context

Learners who have already enrolled in this course

Meet your instructor

Kumail Raza
Kumail RazaData Analytics
Love to help people out on Data Analysis Expression Power BI and Python Graduate in Business Finance and Computer Science I am a BI Developer | Instructor | Facilitator graduate in Business  Finance and Computer Science. Blogger on Microsoft Power BI Community | Complimentary Editor on Enterprise DNA Certified in Statistics, Data Analytics, Machine Learning, and Data Visualization. I have been supporting the data-driven decision, consulting, creating, implementing and automating Data Intelligence and Analytics Strategies while identifying KPIs in the process and how it affects the overall business strategy. Hands-on experience (Intermediate to advanced level) in using the following tools: Business Intelligence | Analytics: Microsoft Azure Machine Learning Studio, Microsoft Power BI, Mode Analytics, Microsoft Excel / Google Spreadsheet, Python (Pandas, Pillow, Openpyxl, matplotlib) Database: SQL Server 2016 (ETL into Power BI), MYSQL, MS SQL Server and Web ETL Documentation: Confluence, Dropbox Paper, Dropbox. Adobe Acrobat PDF, Microsoft Word, and Microsoft Excel. Diagram | Wireframe | Mockups: Balsamiq Mockups, Drawdotio, Microsoft Visio, Microsoft Excel, and Word Smart Art Graphic. Analyzed CRM Applications: ZOHO CRM, Rethink Residential and Commercial (Built on Salesforce Platform), Podio, Plan plus, ConvergeEnterprise, dotloop, Microsoft Dynamics NAV.