Hello,
I have been reading this forum for years and have found amazing amount of valuable information presented in a clear way, many thanks for every contributtor for that. Now I have started to study Power BI and I have already faced some difficulties while trying to build my data model.
The problem I'm trying to solve is the following:
I have multiple Excel files (20ish) and each of them contains 3 to 5 worksheets.
In each of them the sheets are named using same coding (S01-S05).
S01 is always identical to the S01 in other workbooks and so on but worksheet S01 to 05 are all different, i.e. they are indentically structured files with difference between worksheets.
S01 always contains the identifier data which is the name of the reporter and other codes on other rows. Other sheets besides S01 contain no reporter identifier.
What I'm trying to achieve is a model that would allow me to compare reporting of different users. E.g. I would like to see a list of data reported in worksheet S03 row 20 column 40 for all the 20 different reporters.
Do you think this kind of model should be built using Power BI or Access if I have to occasionally update a new Excel file from one of the 20 users to replace the former?
Hopefully I managed to present this problem in a way that can be understood by some of you at least.
Thank you in advance if someone is able to provide some help with this issue!
I have been reading this forum for years and have found amazing amount of valuable information presented in a clear way, many thanks for every contributtor for that. Now I have started to study Power BI and I have already faced some difficulties while trying to build my data model.
The problem I'm trying to solve is the following:
I have multiple Excel files (20ish) and each of them contains 3 to 5 worksheets.
In each of them the sheets are named using same coding (S01-S05).
S01 is always identical to the S01 in other workbooks and so on but worksheet S01 to 05 are all different, i.e. they are indentically structured files with difference between worksheets.
S01 always contains the identifier data which is the name of the reporter and other codes on other rows. Other sheets besides S01 contain no reporter identifier.
What I'm trying to achieve is a model that would allow me to compare reporting of different users. E.g. I would like to see a list of data reported in worksheet S03 row 20 column 40 for all the 20 different reporters.
Do you think this kind of model should be built using Power BI or Access if I have to occasionally update a new Excel file from one of the 20 users to replace the former?
Hopefully I managed to present this problem in a way that can be understood by some of you at least.
Thank you in advance if someone is able to provide some help with this issue!