Power BI and EDI Experience | Dataford Interview Questions

Are you familiar with Power BI, and what EDI experience do you have? If so, what EDI programming have you worked with?

For the SQL portion, use the supplied DHL Supply Chain EDI partner and message tables to prepare a report suitable for Power BI.

Output

One row per EDI partner and reporting month, including partners with no in-scope messages.
Columns: partner_code, partner_name, reporting_month, total_messages, successful_messages, failed_messages, and success_rate_percent.
Include messages received from January 1 through March 31, 2025. Order by partner code, then reporting month, with partners having no messages last.

edi_partners

Column	Type	Description
partner_idPK	INT	Internal identifier for the EDI trading partner
partner_code	VARCHAR(20)	DHL Supply Chain trading partner code
partner_name	VARCHAR(100)	Trading partner name
edi_standard	VARCHAR(20)	EDI standard used by the partner

edi_messages

Column	Type	Description
message_idPK	INT	Unique EDI message identifier
partner_id	INT	Partner associated with the message
message_type	VARCHAR(20)	EDI transaction type
received_at	TIMESTAMP	Timestamp when the message was received
status	VARCHAR(20)	Processing result for the EDI message

Your question is Power BI and EDI Experience. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.