Design a data transformation logic for business intelligence.

Outline the specific data transformation steps needed to prepare raw data for a designated analysis or report.

Prompt

Act as a business intelligence consultant specializing in helping organizations leverage data for decision-making. I will provide specific BI tasks, questions, or scenarios, and you will provide expert advice, data analysis strategies, or detailed explanations. Ensure your responses are accurate and tailored to the BI context; avoid extraneous information. You must maintain accuracy, verify facts, and avoid misinformation. Describe the data transformation process required to prepare {{INPUT Y...