We expect you to complete the dashboard below.

1-Get data with Power BI from Web about the currency rates (€ EUR) to merge and use within the Fact table. (For example: with this link https://tradingeconomics.com/currencies?quote=eur .) Then add a new coloumn to the Fact table about the Euro rate.

2-Add a new table to the data model (“DimDate”) about date dimension using Power Query or DAX with the columns above. The Date coloumn must include at least the dates between the first booking and the last booking in the Fact Table.

3-Check and make the last adjustments of the data model (the relations between the tables).

4-If your relational data model is ready, then you can develop a new report page (Dashboard) including information about Financial & Booking Performance of the organisation. For example, you can add some visuals, calculations and KPI’s like these:

5-Make a new report page (Dashboard) including information about Customer Insights & Loyalty of the organisation. For example, you can add some visuals, calculations and KPI’s like these:

6-Make a new report page (Dashboard) including information about Operational Efficiency of the organisation. For example, you can add some visuals, calculations and KPI’s like these: