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
10 days agoIvory
12 days agoThora
13 days agoSylvie
15 days agoPrecious
17 days agoEllsworth
23 days agoPrecious
27 days ago