Challenge:

I am part of a data analytics team in a banking industry and the problem we face is that the data structure we use in our team is not that organized. We get our data from different sources, meaning from different systems of the bank that stores data. Since we store different data from different sources, we consume a lot of data space on our system and we don’t know if there are duplicates in these data. This also leads us to a chaotic data analysis and longer generation of insights. So I was tasked to create data mart, where I need to consolidate the data and create a documentation of all those data, and create a “Data Dictionary”.

Selection:

With this project given to me, I selected the Mind Mapping as a tool to create this data dictionary. Mind mapping is a creatve and visual process to capture the mind/s of myself and of my customers, which are the users of these data dictionary, and create a clear patterns that will generate insights.

Application:

I mentioned that what I created involves a lot of data, and these data have different uses for different analytics studies and reports. Thus, I gathered first what are those uses from the different persons who uses them and identified all the data and variables involved. After I gathered all those information, I made a mind map, I drew all the data uses, data variables and data sources, and from there I encircled all duplicate variables and same uses. And I connected all variables to a specific use that uses those variables. There I created a pattern and insights that summarizes all the uses and all the need variables for that specific use.

Insight:

By applying the mind mapping process, I trimmed down the huge data we have and remove all duplicate variables and uses. I had a clear mind of all the data needed, and data uses. Mind mapping is a really great process especially if you are dealing with huge data coming from different sources and different insights from different customers.

Approach:

Knowing that mind mapping helped me deals with huge data, I can apply this process on my future analytic studies. Also this can be useful in automating a process in our department.


Challenge : I am part of a data analytics team in a banking industry and the problem we face is that the data structure we use in our team is not that organized . We get our data from different sources , meaning from different systems of the bank that stores data . Since we store different data from different sources , we consume a lot of data space on our system and we do n’t know if there are duplicates in these data . This also leads us to a chaotic data analysis and longer generation of insights . So I was tasked to create data mart , where I need to consolidate the data and create a documentation of all those data , and create a “ Data Dictionary ” . Selection : With this project given to me , I selected the Mind Mapping as a tool to create this data dictionary . Mind mapping is a creatve and visual process to capture the mind / s of myself and of my customers , which are the users of these data dictionary , and create a clear patterns that will generate insights . Application : I mentioned that what I created involves a lot of data , and these data have different uses for different analytics studies and reports . Thus , I gathered first what are those uses from the different persons who uses them and identified all the data and variables involved . After I gathered all those information , I made a mind map , I drew all the data uses , data variables and data sources , and from there I encircled all duplicate variables and same uses . And I connected all variables to a specific use that uses those variables . There I created a pattern and insights that summarizes all the uses and all the need variables for that specific use . Insight : By applying the mind mapping process , I trimmed down the huge data we have and remove all duplicate variables and uses . I had a clear mind of all the data needed , and data uses . Mind mapping is a really great process especially if you are dealing with huge data coming from different sources and different insights from different customers . Approach : Knowing that mind mapping helped me deals with huge data , I can apply this process on my future analytic studies . Also this can be useful in automating a process in our department .