Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
What is the best practice for a company:
- Create a single data set and base all reports on it
- create a data set based on
Solved! Go to Solution.
The best practice for managing datasets within a company can vary depending on the specific needs and requirements of the organization. Both approaches you mentioned have their advantages and disadvantages, and the choice between them should be made considering factors like data volume, data complexity, scalability, and business goals. Let's explore both options:
Create a Single Data Set and Base All Reports on It:
Advantages:
Disadvantages:
Create Multiple Data Sets Based on Use Cases:
Advantages:
Disadvantages:
In practice, many organizations adopt a hybrid approach, combining the two strategies:
Centralized Data Warehouse: Maintain a centralized data warehouse or data lake where raw data is stored and transformed into a common dataset. This common dataset can serve as a foundation for important enterprise-level reporting and analysis.
Specialized Datasets: Create specialized datasets or data marts for specific departments or use cases. These can be derived from the central dataset and customized to meet specific requirements.
Data Governance: Implement strong data governance practices to ensure data quality, security, and compliance across all datasets.
The choice between these approaches should be driven by the organization's unique needs, resources, and goals. It's important to regularly review and adapt the data management strategy as the company evolves and its data requirements change.
If I answered your question, please mark my post as solution, Appreciate your Kudos !
Hello @RomainB ,
What I would recommend is to get the data that matches the requirments you want to acheive.
Also as long as you can do the transformations in the data source, then do them there else do them in Power query.
also build your data Model schema as a star schema https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡
Proud to be a Super User! | |
The best practice for managing datasets within a company can vary depending on the specific needs and requirements of the organization. Both approaches you mentioned have their advantages and disadvantages, and the choice between them should be made considering factors like data volume, data complexity, scalability, and business goals. Let's explore both options:
Create a Single Data Set and Base All Reports on It:
Advantages:
Disadvantages:
Create Multiple Data Sets Based on Use Cases:
Advantages:
Disadvantages:
In practice, many organizations adopt a hybrid approach, combining the two strategies:
Centralized Data Warehouse: Maintain a centralized data warehouse or data lake where raw data is stored and transformed into a common dataset. This common dataset can serve as a foundation for important enterprise-level reporting and analysis.
Specialized Datasets: Create specialized datasets or data marts for specific departments or use cases. These can be derived from the central dataset and customized to meet specific requirements.
Data Governance: Implement strong data governance practices to ensure data quality, security, and compliance across all datasets.
The choice between these approaches should be driven by the organization's unique needs, resources, and goals. It's important to regularly review and adapt the data management strategy as the company evolves and its data requirements change.
If I answered your question, please mark my post as solution, Appreciate your Kudos !
Thank for your response, i think that i have find my solution
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
86 | |
86 | |
84 | |
67 | |
49 |
User | Count |
---|---|
131 | |
110 | |
97 | |
71 | |
67 |