First Dashboard about FIFA World Cup data that I cleaned it and made The proper ETL to load (Year / Host country / champion / Runner-up / Final score / No. of teams) and made visuals about
* The number of times the championship hosted by host country on a map
* Top 5 countries win the world cup
* Number of teams participated in each championship.
* The table shows all the fields in a proper order.
e. I should be able to filter the dashboard by year.
Second Dashboard about AdventureWorks2019 contains Dimension tables about (DimProduct that made by left join between product table , Product subcategory table , Product category table) & DimTerritory & DimShipMethod & DimStatus & DimDate & Sales.vsalesperson(view) & Fact tsble that contains (Sales.SalesOrderHeader & Sales.SalesOrderDetail) and model the data into star schema and contains userelationship-or-role-playing-date dimension that contains one active Relationship and two inactive Relationship between (DueDate , OrderDate , ShipDate in facttable and datekey in Dimdate)
and contains measures about
No. of Orders
Total SubTotal Measure
Total Tax Measure
Total Freight Measure
Total Due Measure
Qty
# Orders by Status
# Orders by Shipmethod
# Orders by Category, SubCategory, Product
# Orders by FlagOnlineOffline
# Orders and TotalDue by Territory
Top 10 Sales Perosns (# Orders)
