original schemaI have an assignment which I cannot understand due to several reasons:
-Assignment itself says we have 2 fact tables
-At the same time it is needed to create Star Schema
I have no idea how I can make a Star Schema out of basically Snowflake schema. I tried to merge 2 fact tables on CompanyName..
Maybe I misinterpreted an assignment?
Please help to find my mistake.
**Assignment:
**
Input data description.
There are 3 excel files in Data folder:
-
“SpendCategories.xlsx” contains dimensions of 2-level spend categorization. “Spend Categories” sheet defines parent level. “Spend Subcategories” sheet defines the lowest level of granularity and has a reference to parent category identifier.
-
“CompanySpends.xlsx” contains fact data about companies’ spending transactions over time. “Spend Transactions” sheet defines the actual spends. “Company Budgets” sheet shows the defined company spend budgets (broken down by quarters).
-
“CompanyIncomes.xlsx” contains fact data about companies’ incoming transactions (paid by the customers they work with) “Income Transactions” sheet defines the actual incoming transactions. Has a reference to customer. “Customers” sheet defines customers dimension and additionally includes the customer’s Country & City. Country & City values have been exported from a third-party system and not yet preprocessed for analytics purposes (it will be needed for page 4 which is optional)
- Load data from excel files. It is necessary to clean the garbage in some tables (for example, empty lines in spend transactions). Clean the data not in Excel, but in the Power BI transformations (Power Query).
**Build Power BI data model with all necessary relations. Use Star Schema **
I tried to merge 2 fact tables (Spend Transactions and Income Transactions on CompanyName)..