Our Solution
The measures taken to address these challenges were:
- User authentication different users.
- Restricting access based on a user’s need.
- Recording data access histories and meeting other compliance regulations.
- Proper use of encryption on data in-transit and at rest.
- Merging relevant reports and providing proper access
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.