Fundamentals of Data Analysis Expression DAX
What you'll learn
- In this course, you will get understanding of Data Analysis Expression DAX with examples and use cases
Requirements
- Microsoft Power BI installed (this course includes video on installing Power BI) an initial level understanding of data analytics and visualization
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.
Who this course is for:
- Anyone who have interest in learning of DAX for Data Analytics and Visualization
Instructors
- 4.1 Instructor Rating
- 571 Reviews
- 68,532 Students
- 9 Courses
I am a BI Developer | Instructor | Facilitator graduate in Business Finance and Computer Science.
Certified in Statistics, Data Analytics, Machine Learning, and 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.
Blogger on Microsoft Power BI Community
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, Openpyxl, matplotlib)
Database: SQL Server 2016 (ETL into Power BI), MYSQL
Project Management: Wrike, GetFlow, Jira.
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.
- 4.5 Instructor Rating
- 49 Reviews
- 12,553 Students
- 1 Course