Create the fact table of a test database.
Budget: $10 – $30 USD
I'm looking for someone to help me draw the fact table (with Pentaho or some other tool) from the following database:
https://www.mysqltutorial.org/mysql-sample-database.aspx
This fact table will be used later for the implementation of the data warehouse. (You don't have to implement the data warehouse, just generate the fact table using star or snowflake.)
The fact table must be designed so that the company can know how its sales are evolving over time and what type of demand is associated with each of the products.
I also need help answering the following theoretical questions (no code or implementation needed).
1. Specifies the steps the company must follow to implement its data warehouse for the sales department.
2. As a business intelligence expert, what guidelines would you give the company to implement its business intelligence model?
3. In your opinion, should the company invest in qualified personnel for the process?
4. What tools do you recommend to the company to implement its business intelligence model?
https://www.mysqltutorial.org/mysql-sample-database.aspx
This fact table will be used later for the implementation of the data warehouse. (You don't have to implement the data warehouse, just generate the fact table using star or snowflake.)
The fact table must be designed so that the company can know how its sales are evolving over time and what type of demand is associated with each of the products.
I also need help answering the following theoretical questions (no code or implementation needed).
1. Specifies the steps the company must follow to implement its data warehouse for the sales department.
2. As a business intelligence expert, what guidelines would you give the company to implement its business intelligence model?
3. In your opinion, should the company invest in qualified personnel for the process?
4. What tools do you recommend to the company to implement its business intelligence model?