Datamart design for Reporting – Mind Mapping

Challenge & Selection

As a Business analyst, my responsible is preparing information from data warehouse based on business  requirement. When there is a project that to create a system to calculate credit and loss for  organization, I was require to create a Datamart that contains all the information that the system  required. However, Datawarehouse information is not enough for the project. Hence it requires to  involve third party assistance in order to gather enough information. For this project, I had chosen mind  mapping tool for the project. This tool is able to help me to categorize each information require in  respective group and able to see the linkage for each sub group of info.

Application

Based on the requirement, I had a brainstorming session with the system owner and few team members  on some questions. What is the timeline of the project?  What is the application require? What is the  information require? Which information that not applicable in data warehouse and which third party  require to be involved?  In the discussion, we had created the project based on bubble map, flow map  and tree map. We had created 2 main categories in bubble map which is application involve and party  involved. Based on each application, we had decided the tree map for what is the source for the  information and how is the extraction rules. As it involves few parties, each member had taken  responsible of gathered information for each application. After all information gathered, we had a  discussion again to combine all information and come out a final mapping and process flow on  information extractions. After prepared all the mapping and process flow, it easy for us to design the  program for the project.

Insight & Approach

Based on this project, I had learned a special way to gather information that simple and clear. Based on  the mind mapping tools, I can create the main thought for each project/issue in a simple map and then  split to more details. Is easy for me to see the relationship for each item and find out the next step  require easily. It should make our daily job become more fun and easier that we can list down as much  as idea that we have. As there are many types of mind mapping tools, I can discover in more details and  applied on my daily job functions. I think this will be a attractive journey when I expertise it.


Datamart design for Reporting – Mind Mapping Challenge & Selection As a Business analyst , my responsible is preparing information from data warehouse based on business requirement . When there is a project that to create a system to calculate credit and loss for organization , I was require to create a Datamart that contains all the information that the system required . However , Datawarehouse information is not enough for the project . Hence it requires to involve third party assistance in order to gather enough information . For this project , I had chosen mind mapping tool for the project . This tool is able to help me to categorize each information require in respective group and able to see the linkage for each sub group of info . Application Based on the requirement , I had a brainstorming session with the system owner and few team members on some questions . What is the timeline of the project ? What is the application require ? What is the information require ? Which information that not applicable in data warehouse and which third party require to be involved ? In the discussion , we had created the project based on bubble map , flow map and tree map . We had created 2 main categories in bubble map which is application involve and party involved . Based on each application , we had decided the tree map for what is the source for the information and how is the extraction rules . As it involves few parties , each member had taken responsible of gathered information for each application . After all information gathered , we had a discussion again to combine all information and come out a final mapping and process flow on information extractions . After prepared all the mapping and process flow , it easy for us to design the program for the project . Insight & Approach Based on this project , I had learned a special way to gather information that simple and clear . Based on the mind mapping tools , I can create the main thought for each project / issue in a simple map and then split to more details . Is easy for me to see the relationship for each item and find out the next step require easily . It should make our daily job become more fun and easier that we can list down as much as idea that we have . As there are many types of mind mapping tools , I can discover in more details and applied on my daily job functions . I think this will be a attractive journey when I expertise it .