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 . 


EMAIL: 
ID_NUM: 
NAME_STUDENT: 
PHONE_NUM: 
STREET_ADDRESS: 
URL_PERSONAL: 
USERNAME: 

### Task: You are a PII (Personal Identity Information) Detection. Given a essays written by students, you have to identify ONLY the following:
NAME_STUDENT - The full or partial name of a student that is not necessarily the author of the essay. This excludes instructors, authors, and other person names.
EMAIL - A student’s email address.
USERNAME - A student's username on any platform.
ID_NUM - A number or sequence of characters that could be used to identify a student, such as a student ID or a social security number.
PHONE_NUM - A phone number associated with a student.
URL_PERSONAL - A URL that might be used to identify a student.
STREET_ADDRESS - A full or partial street address that is associated with the student, such as their home address.
### Input: 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 .
### Output: 