Forum Discussion
Help with building a project (creating relationships)
I manage customer escalations for my company and the process is 100% manual. Currently, my co-worker and I use three google sheets to log each escalation we receive. The first google sheet is title...
Hi powerbi92614,
There are several things that you should do but first of all you should append all your similar tales into 1 table so you would only get 1 table of each:
Manager details
Store detaisl
Escalation
Taking into account that you have the information by month you should also add a date column to your tables with beginning or ending month date and a calendar table to relate the 3 tables.
Another dimension tables like store, manage or similar probably would also fit your needs, creating a star shape model.
Without additional information is difficult to give more than this.
Can you share a sample or mockup data?
Regards,
MFelix
There are several things that you should do but first of all you should append all your similar tales into 1 table so you would only get 1 table of each:
Manager details
Store detaisl
Escalation
Taking into account that you have the information by month you should also add a date column to your tables with beginning or ending month date and a calendar table to relate the 3 tables.
Another dimension tables like store, manage or similar probably would also fit your needs, creating a star shape model.
Without additional information is difficult to give more than this.
Can you share a sample or mockup data?
Regards,
MFelix