You need to recommend a strategy to consistently define the business unit, department, and product category data and make the data usable across reports.
I'm feeling option A. A shared dataset for each standardized entity is straightforward and easy to understand. Plus, it's probably the most secure option, right?
Option D is interesting, but I'm not sure storing the data in OneDrive is the best idea. What if someone accidentally deletes it or makes unauthorized changes? I'd stick with a more centralized solution.
Hmm, option C looks good to me. Having a single shared dataset with the standardized data for all reports sounds like it would make things really easy to manage.
I think option B is the way to go. Creating dataflows for the standardized data and making them available for all imported datasets seems like the most efficient and scalable approach.
Katina
Ivory
2 days agoThora
3 days agoSylvie
5 days agoPrecious
7 days agoEllsworth
13 days agoPrecious
17 days ago