There are two questiones for each Question post comments, each answer should be 150 words,
So for Question 1: 150 words
So for Question 2: 150 words
Total 300 words
Question 1 :
A business with multiple operations sites and with grouping based on regions definitely needs a hybrid data mart with enough network capacity that would allow multidirectional data flow between the database and operational sites with shorter turnaround times (El Houari et el, 2017). Prioritizing how the data is stored in the must normalized manner avoiding redundancy is required to deliver a resourceful utilization with less cost of accessing and manipulating the database. Including different roles and accordingly role based access privileges that can be configured by the data administrator would help in clear access control to existing employees, to new employees being onboard and employees promoted into new designation which need additional or different access level or terminated.
Include identifiers and appropriate data structures to allow expand the data for future needs for further split of the existing four regions into possible divisions like north-east, south-west and so on would allow the infrastructure to be useful on the long run. Also include the flexibility to expand and further increase the categories of distribution and classification. Metadata designed in line with this in consideration will help make easy queries across hierarchy to print out reports based on region and branches, which would help both the corporate heads and the regional managers to make analysis of sales and employee performance (Krneta et al, 2016).
Proper documentation with enough description will make the work of future developers easy and faster. Big Data and cloud architecture will ensure relevance and availability through mobile applications when needed based on the scope for further development (Al-Aqrabi, 2016). A properly aligned discussion with business and stake holders will help in deciding the business requirement, data structure, data technologies to be used and the security guidelines to be framed and complied upon
Question 2:
In a market commanded by huge information and investigation, data mart are one key to effectively changing data into experiences. Data warehouse centers ordinarily manage huge informational collections, yet information examination requires simple to-discover and promptly accessible data.There are three sorts of data marts: dependent mart, independent mart, and hybrid data mart. In the event that business needs direct, various data mart can be combined to make a solitary, data warehouse center. This is known as the bottom-up development approach.
Dependent Data Marts
This is made from a currently existing enterprise data center with putting away all business information in one focal area, at that point extricates an obviously characterized bit of the information when required for examination.
Independent Data Marts
This Data mart is extricated from interior or outside information sources (or both), handled, at that point stacked to the data mart archive where it is put away until required for business investigation.
Hybrid Data Marts
A hybrid data mart consolidates information from a current information distribution center and other operational source frameworks. It joins the speed and end-client focal point of a top-down methodology with the advantages of the venture level combination of the bottom-up technique.
B. For my company I would suggest my team to set up a Hybrid Data Mart so that all the employees from all authority can utilize and extract and update information as need. For example, each branch can have its data put away in various marts for simple retrieval. Stored data can be ordered in various classes for example fund records, staff, deals, etc. Managers can utilize data from every locale to make execution examination and think of methodologies to improve organization execution. Stock records can likewise be utilized to figure out which things to restock in the distribution center. And thus can be also updated with new and updated information from both ways.