Your idea can become a change
You’ve been trying to make.
Let’s give it and you all possible
chances of success
The measures taken to address these challenges were:
Power BI was the suggestion and the preference of the client for the visualization of data based on their KPI’s. SSIS tool was used to integrate the data from different sources to extract, transform and load data to a new database structure.
We combined multiple sources of data to analyse all donors over multiple years. The data from different sources were collected in an ETL tool (SSIS) which helped in data warehousing and cleaning the unstructured data. Upon analysing donors’ responses, we developed distinct donor segments, providing a series of general and segment-specific opportunities to improve the organization’s marketing and fundraising effectiveness.