15、Star Schema Preparation in Power Query Editor

Star Schema Preparation in Power Query Editor

1. Business Requirement Clarification

In the discovery process, it’s essential to clarify several points with the business:
- Do they need to analyze the data for customers’ birth date?
- Do they need to have the BirthDate data at different date levels (Year, Quarter, Month, etc.)?
- Do they need to analyze the data for DateFirstPurchase?
- Do they need to show the DateFirstPurchase data at various date levels?
- What are the required levels of Date and Time for the OrderDate from the Sales table?
- What is the Date level for the DueDate and ShipDate columns from the Sales table?

In a sample scenario, the business doesn’t want to analyze customers’ birth dates or first purchase