Industry
e-commerce
Skills
data-visualization
Tools
power-bi
Learning Objectives
Understand and apply DAX formulas to create new calculated columns within Power BI
Utilize Date-Related Function
Implement Logical Conditions
Handle and manage blank values in calculations
Overview
The scenario focuses on using DAX (Data Analysis Expressions) in Power BI to analyze delivery performance at GlobalMart, an e-commerce company. Learners will explore how to create calculated columns to determine the delivery period of orders, evaluate order statuses, and categorize deliveries based on timeliness. The content emphasizes the importance of accurate data representation and logical evaluation in the context of business metrics.
Prerequisites
- Basic understanding of Power BI and its interface.
- Knowledge of how to work with tables and columns in Power BI.
- An understanding of basic data analysis concepts and metrics.
- Familiarity with DAX functions and their syntax.