identify single fact schema, logical schema. Populate sample date is mySQL. Provide OLAP queries

Hello Am a data warehousing professional - I have good experience in data models & data warehousing projects. Single fact will require identification of dimensions for your OLAP queries. I am guessing your would need a star schema as you need to do reporting. Requirement is not very clear. -how many attributes do the fact have -how many dimensions would be required -how many sample rows will be required -how many OLAP queries are required & their complexity High level Effort estimate (in hrs) Requirement & Analysis - 2 Design - 2 Coding - 4 Testing - 4 Deployment - 0.5 Limited Warranty Support - duration of 2 weeks after delivery (in case there are minor changes & help needed) Total - 12.5 hr * 10 GBP = 125 GBP Thanks - Deep David.

Hello there, I can identify fact and dimensions from your business description or database, and i can do OLAP queries to extact and load informations from database to datamart and populate that with data. Feel free please and contact me for details. Regards!