From insight to impact: Leveraging data analytics to help organizations use data for good

Reading Time: 6 minutes

Imagine a telecom company monitoring the internet usage of its customers. It then uses this data to increase the network bandwidth and reduce the energy utilization for its delivery. It is a win-win scenario – for the company and the environment. The company is able to enhance customer service while minimizing energy consumption. It is a perfect example of how organizations can use their data for good.

Through the application of advanced data analytics across their data lifecycle, organizations can derive meaningful insights and convert them into positive social impact – the scope of data is extended beyond for-profit metrics and helps transform lives and even the planet.

There are numerous forms that “data for good” takes. A fashion brand can use its data to improve sustainability practices across its supply chain and reduce environmental impact. A pharmaceutical or healthcare company can enhance the accessibility and affordability of its medicines or services by evaluating social metrics. A nonprofit organization (NPO) can maximize its program effectiveness and fundraising efforts by understanding its data better.

Essentially, a data-for-good approach empowers enterprises to meet several goals, from environmental, social, and governance (ESG) to corporate social responsibility (CSR), and sustainability. Fosfor has been a committed partner in helping organizations use their data for good. One such remarkable example is how we helped The Salvation Army (TSA), an international charitable organization, transform its donor engagement by solving its data management challenges.

Fosfor+Snowflake: Revolutionizing donor management for The Salvation Army

The Salvation Army (TSA) has served communities in the USA for over 150 years. It has around 1.9 million members and volunteers in the country and serves nearly 24 million Americans annually. In 2022 alone, it raised over $2 billion to fund food, shelter, utility assistance, and several other programs. Being a large organization with such an expansive reach, the TSA deals with large volumes of data. Managing this data is crucial for the efficient allocation of resources and amplifying the impact of programs.

Fosfor helped TSA solve its data management challenges and revamped its donor engagement

When the TSA approached us, we observed that they faced problems in the overall digital transformation of their operations: outdated infrastructure, lack of real-time data updates, high resource utilization costs, and poor data quality. It was crucial to effectively address these challenges as each one of them comes with its own ramifications.

An outdated infrastructure limits data storage and processing capacity, restricts data accessibility, reduces integration potential with new technologies, and increases security risks. As a cascading effect, the availability of real-time data updates becomes severely limited. This leads to slower response time in the deployment of resources, limited monitoring of program performance, inefficient resource allocation, and loss of fundraising and donor engagement opportunities.

High resource utilization costs result in the inefficient delivery of program benefits, which in turn leads to negative perception among donors and reduced contributions. They also limit program scalability and flexibility, leaving a limited budget for spending on current programs or implementing new ones.

Finally, poor data quality serves as a roadblock throughout the data-to-decisions journey. From resource allocation to developing program strategies, decisions based on poor data can result in resource wastage. This not only leads to financial losses but also a loss of reputation – inconsistent or unreliable data reporting leads to a loss of trust, hurting the NPO’s reputation.

Fig 1: The TSA struggled with a complex technology ecosystem and disjointed data tools
TSA sought our assistance in migrating their traditional on-premises data warehouse to a cloud-native DW solution. The goal of this initiative was to centralize data access, streamline processes, and maximize the efficiency of their donor engagement programs.

Laying an AI-ready data foundation on Snowflake

When it comes to unlocking the value of an enterprise’s data, the partnership between Fosfor and Snowflake is a game-changer. Through our collaboration, we empowered TSA to overcome its data management challenges. We combined the Fosfor Decision Cloud’s GenAI capabilities with the Snowflake Data Cloud’s cloud-native features to build reliable pipelines.

First, the organization’s multi-source data had to be tackled. The Fosfor Decision Cloud was implemented to streamline its Extract, Load, and Transform (ELT) process. Next, Snowflake was seamlessly integrated to address data storage and downstream reporting requirements.

Fig 2: The modern data stack enabled for TSA, featuring the Fosfor Decision Cloud and the Snowflake Data Cloud
With our unique approach, we enhanced data quality and reduced latency in real-time data synchronization. We built advanced data models for processing vast volumes of historical and incremental data daily. This created an optimal data pipeline.

Fig 3: A new streamlined approach for TSA to enable data-driven insights and decision-making

Modernized data management enhanced donor engagement

The solution combined the best of the Fosfor Decision Cloud and the Snowflake Data Cloud to enhance donor management for TSA. The modular, flexible platform accessible from any location served as a single source of truth, giving the organization better visibility of donor programs, optimized processes on cloud, and democratized insights at speed and scale. Some of its significant benefits were:

  • Enhanced visibility: Improved data transparency empowered data-driven decisions by the sales, marketing, and technology teams.
  • Reduced time-to-insight: Accelerating analysis and insights from donor engagement programs facilitated quicker decision-making and resource allocation.
  • Cost savings and increased productivity: Snowflake’s flexibility optimized data prior to ingestion into Tableau and increased workbook efficiency, resulting in up to a 30% cost reduction.

The solution helped house 15 TB of historical data on Snowflake with 200 GB of daily refresh. Additionally, it improved data-related process execution times by 55% and provided for a ~3X expected increase in donor program engagement.

Real-world possibilities

The benefits experienced by TSA can be translated to any organization and field – the possibilities of data’s use for good are limitless. A few use cases are:

1. Geographical data for resource allocation

Geographical data can be used to uncover patterns and actionable insights that can serve communities in causes such as fighting food insecurity. Organizations devoted to hunger relief can use data to identify areas with the highest food insecurity rates. This can help in the effective allocation of resources, resulting in a substantial decrease in food wastage, increased donor revenue, and successful fundraising.

2. Real-time insights for decision-making

The continuous flow of data can be used to gain real-time, actionable insights on critical issues such as protecting threatened and endangered species. Real-time data on wildlife sightings and illegal activities can help wildlife protection agencies improve patrolling by providing insights into critical routes and sensitive areas. A data-driven approach can help safeguard and increase the population of at-risk species.

3. A single pane of glass for problem-solving

The consolidation of data into a central, unified view can simplify how we tackle complex issues. For example, it can enable donors of educational organizations to directly identify schools in need of resources. The collection of school data on a centralized platform can provide donors with actionable insights into the immediacy of fund requirements across functions. It can also provide policymakers insights into areas within the education system that need prompt addressing.

Recently, Fosfor worked with GoldenSource, an enterprise data management leader, to help Financial Services companies analyze their ESG initiatives. Analyzing their data on a single pane of glass helped them delve deeper into the factors causing the most emissions and identify consumer discretionary as the prime cause. They were also able to pinpoint the geographies with the highest recent increase in contribution to emissions – the US and Europe. Moreover, they observed that while companies were becoming more greenhouse gas efficient in their own operations, the suppliers’ emission contribution had increased. Companies could now increase their regulatory focus on the supply chain, make necessary course corrections, and continue to use data for good.

A future of data-driven change

The adoption of data analytics provides organizations with a springboard to adopt new technologies that elevate their data-for-good strategy.

For example, GenAI can transform how organizations engage with their customers. It can help them analyze customer data and ascertain the ESG or CRS expectations that they have from a brand or company. GenAI can help them craft messages specifically targeted at individual customers to create awareness about the organization’s initiatives and help them get actively involved.

NLP could power volunteer matching for NPOs. By analyzing volunteer preferences and skills with the needs of a program, the right volunteer can be assigned to the right program. This will enhance volunteer engagement and retention and ensure that the programs are supported by the appropriate donors.

Predictive analytics can facilitate hyper-local interventions based on weather, hospitalizations, and social media activity to predict health scares and natural disasters. This could help a healthcare or pharmaceutical enterprise working towards public health improvement activate interventions at the local level with awareness campaigns and mobile vaccination drives, even before outbreaks occur.

In these ways, the confluence of data analytics, machine learning, and artificial intelligence, among other new and innovative technologies, could help organizations decipher everything about their communities using data and help them use data for good in the future as well.

The Fosfor Decision Cloud can empower enterprises to advance transformation and unleash their data’s power for good. If you want to witness first hand what the FDC can do for you, book a free trial here.

Author

John Praveen

Sr. Manager - Marketing & Communications, Fosfor

John is a seasoned marketer with over a decade of experience in the B2B SEO & Content Marketing spaces. With a keen eye for industry trends, John has penned insightful articles on Data Analytics, Cloud tech, Machine Learning and AI. As the Senior Manager - Content Marketing at Fosfor, he oversees crafting and executing impactful content distribution strategies for Fosfor’s thought leadership. John's expertise helps businesses understand the value of contemporary technologies in real-world contexts.

More on the topic

Read more thought leadership from our team of experts

Augmented decision intelligence + limitless cloud scale = pharma’s success playbook

Cloud technologies have now become a must in the pharmaceutical industry. Leading life-sciences companies are discovering the potency of cloud data in enabling analytics, shrinking innovation cycles, and standardizing processes across global operations, among other benefits. For example, Moderna delivered its first clinical batch of its COVID-19 vaccine candidate to the US National Institutes of Health for Phase I trial only 42 days after the initial sequencing of the virus by using cloud technology.

Read more

Boosting Decision Intelligence with Lumin on the AWS cloud

Data management and insight generation are the lifelines for any modern-day business. Today, many organizations struggle to manage their data efficiently. Unfortunately, the turnaround time from data to insights to decision to execution takes several days or weeks. This cycle delays efficient business insight generation, thereby incurring significant resource misuse.

Read more

Broker performance analysis solution: Analyzing broker performance as an insurance carrier

Most, if not all, large insurance and re-insurance carriers today work with brokerage agencies to grow their books and ensure a healthy stream of business. Depending on the carrier size, they might often work with dozens of agencies spread across the globe, each with its own operating processes and ways of working. For broker managers, monitoring agency performance and working with them to target the right lines of business, suitable policies and the right customers can be a nightmare. The need to be able to quickly analyze broker performance and take corrective actions to meet submissions. As such, underwriting targets is critical. Lumin's Decision Intelligence capabilities make this task considerably simpler. Let’s dive in.

Read more
We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. View more
Cookies settings
Accept
Privacy & Cookie policy
Privacy & Cookies policy
Cookie name Active

What is a cookie?

A cookie is a small piece of data that a website asks your browser to store on your computer or mobile device. The cookie allows the website to “remember” your actions or preferences over time. On future visits, this data is then returned to that website to help identify you and your site preferences. Our websites and mobile sites use cookies to give you the best online experience. Most Internet browsers support cookies; however, users can set their browsers to decline certain types of cookies or specific cookies. Further, users can delete cookies at any time.

Why do we use cookies?

We use cookies to learn how you interact with our content and to improve your experience when visiting our website(s). For example, some cookies remember your language or preferences so that you do not have to repeatedly make these choices when you visit one of our websites.

What kind of cookies do we use?

We use the following categories of cookie:

Category 1: Strictly Necessary Cookies

Strictly necessary cookies are those that are essential for our sites to work in the way you have requested. Although many of our sites are open, that is, they do not require registration; we may use strictly necessary cookies to control access to some of our community sites, whitepapers or online events such as webinars; as well as to maintain your session during a single visit. These cookies will need to reset on your browser each time you register or log in to a gated area. If you block these cookies entirely, you may not be able to access gated areas. We may also offer you the choice of a persistent cookie to recognize you as you return to one of our gated sites. If you choose not to use this “remember me” function, you will simply need to log in each time you return.
Cookie Name Domain / Associated Domain / Third-Party Service Description Retention period
__cfduid Cloudflare Cookie associated with sites using CloudFlare, used to speed up page load times 1 Year
lidc linkedin.com his is a Microsoft MSN 1st party cookie that ensures the proper functioning of this website. 1 Day
PHPSESSID ltimindtree.com Cookies named PHPSESSID only contain a reference to a session stored on the web server When the browsing session ends
catAccCookies ltimindtree.com Cookie set by the UK cookie consent plugin to record that you accept the fact that the site uses cookies. 29 Days
AWSELB Used to distribute traffic to the website on several servers in order to optimise response times. 2437 Days
JSESSIONID linkedin.com Preserves users states across page requests. 334,416 Days
checkForPermission bidr.io Determines whether the visitor has accepted the cookie consent box. 1 Day
VISITOR_INFO1_LIVE Tries to estimate users bandwidth on the pages with integrated YouTube videos. 179 Days
.avia-table-1 td:nth-of-type(1):before { content: 'Cookie Name'; } .avia-table-1 td:nth-of-type(2):before { content: 'Domain / Associated Domain / Third-Party Service'; } .avia-table-1 td:nth-of-type(3):before { content: 'Description'; } .avia-table-1 td:nth-of-type(4):before { content: 'Retention period'; }

Category 2: Performance Cookies

Performance cookies, often called analytics cookies, collect data from visitors to our sites on a unique, but anonymous basis. The results are reported to us as aggregate numbers and trends. LTI allows third-parties to set performance cookies. We rely on reports to understand our audiences, and improve how our websites work. We use Google Analytics, a web analytics service provided by Google, Inc. (“Google”), which in turn uses performance cookies. Information generated by the cookies about your use of our website will be transmitted to and stored by Google on servers Worldwide. The IP-address, which your browser conveys within the scope of Google Analytics, will not be associated with any other data held by Google. You may refuse the use of cookies by selecting the appropriate settings on your browser. However, you have to note that if you do this, you may not be able to use the full functionality of our website. You can also opt-out from being tracked by Google Analytics from any future instances, by downloading and installing Google Analytics Opt-out Browser Add-on for your current web browser: https://tools.google.com/dlpage/gaoptout & cookiechoices.org and privacy.google.com/businesses
Cookie Name Domain / Associated Domain / Third-Party Service Description Retention period
_ga ltimindtree.com Used to identify unique users. Registers a unique ID that is used to generate statistical data on how the visitor uses the web site. 2 years
_gid ltimindtree.com This cookie name is asssociated with Google Universal Analytics. This appears to be a new cookie and as of Spring 2017 no information is available from Google. It appears to store and update a unique value for each page visited. 1 day
_gat ltimindtree.com Used by Google Analytics to throttle request rate 1 Day
.avia-table-2 td:nth-of-type(1):before { content: 'Cookie Name'; } .avia-table-2 td:nth-of-type(2):before { content: 'Domain / Associated Domain / Third-Party Service'; } .avia-table-2 td:nth-of-type(3):before { content: 'Description'; } .avia-table-2 td:nth-of-type(4):before { content: 'Retention period'; }

Category 3: Functionality Cookies

We may use site performance cookies to remember your preferences for operational settings on our websites, so as to save you the trouble to reset the preferences every time you visit. For example, the cookie may recognize optimum video streaming speeds, or volume settings, or the order in which you look at comments to a posting on one of our forums. These cookies do not identify you as an individual and we don’t associate the resulting information with a cookie that does.
Cookie Name Domain / Associated Domain / Third-Party Service Description Retention period
lang ads.linkedin.com Set by LinkedIn when a webpage contains an embedded “Follow us” panel. Preference cookies enable a website to remember information that changes the way the website behaves or looks, like your preferred language or the region that you are in. When the browsing session ends
lang linkedin.com In most cases it will likely be used to store language preferences, potentially to serve up content in the stored language. When the browsing session ends
YSC Registers a unique ID to keep statistics of what videos from Youtube the user has seen. 2,488,902 Days
.avia-table-3 td:nth-of-type(1):before { content: 'Cookie Name'; } .avia-table-3 td:nth-of-type(2):before { content: 'Domain / Associated Domain / Third-Party Service'; } .avia-table-3 td:nth-of-type(3):before { content: 'Description'; } .avia-table-3 td:nth-of-type(4):before { content: 'Retention period'; }

Category 4: Social Media Cookies

If you use social media or other third-party credentials to log in to our sites, then that other organization may set a cookie that allows that company to recognize you. The social media organization may use that cookie for its own purposes. The Social Media Organization may also show you ads and content from us when you visit its websites.

Ref links:

LinkedInhttps://www.linkedin.com/legal/privacy-policy Twitterhttps://gdpr.twitter.com/en.html & https://twitter.com/en/privacy & https://help.twitter.com/en/rules-and-policies/twitter-cookies Facebookhttps://www.facebook.com/business/gdpr Also, if you use a social media-sharing button or widget on one of our sites, the social network that created the button will record your action for its own purposes. Please read through each social media organization’s privacy and data protection policy to understand its use of its cookies and the tracking from our sites, and also how to control such cookies and buttons.

Category 5: Targeting/Advertising Cookies

We use tracking and targeting cookies, or ask other companies to do so on our behalf, to send you emails and show you online advertising, which meet your business and professional interests. If you have registered on our websites, we may send you emails, tailored to reflect the interests you have shown during your visits. We ask third-party advertising platforms and technology companies to show you our ads after you leave our sites (retargeting technology). This technology allows us to make our website services more interesting for you. Retargeting cookies are used to record anonymized movement patterns on a website. These patterns are used to tailor banner advertisements to your interests. The data used for retargeting is completely anonymous, and is only used for statistical analysis. No personal data is stored, and the use of the retargeting technology is subject to the applicable statutory data protection regulations. We also work with companies to reach people who have not visited our sites. These companies do not identify you as an individual, instead rely on a variety of other data to show you advertisements, for example, behavior across websites, information about individual devices, and, in some cases, IP addresses. Please refer below table to understand how these third-party websites collect and use information on our behalf and read more about their opt out options.
Cookie Name Domain / Associated Domain / Third-Party Service Description Retention period
BizoID ads.linkedin.com These cookies are used to deliver adverts more relevant to you and your interests 183 days
iuuid demandbase.com Used to measure the performance and optimization of Demandbase data and reporting 2 years
IDE doubleclick.net This cookie carries out information about how the end user uses the website and any advertising that the end user may have seen before visiting the said website. 2,903,481 Days
UserMatchHistory linkedin.com This cookie is used to track visitors so that more relevant ads can be presented based on the visitor’s preferences. 60,345 Days
bcookie linkedin.com This is a Microsoft MSN 1st party cookie for sharing the content of the website via social media. 2 years
__asc ltimindtree.com This cookie is used to collect information on consumer behavior, which is sent to Alexa Analytics. 1 Day
__auc ltimindtree.com This cookie is used to collect information on consumer behavior, which is sent to Alexa Analytics. 1 Year
_gcl_au ltimindtree.com Used by Google AdSense for experimenting with advertisement efficiency across websites using their services. 3 Months
bscookie linkedin.com Used by the social networking service, LinkedIn, for tracking the use of embedded services. 2 years
tempToken app.mirabelsmarketingmanager.com When the browsing session ends
ELOQUA eloqua.com Registers a unique ID that identifies the user’s device upon return visits. Used for auto -populating forms and to validate if a certain contact is registered to an email group . 2 Years
ELQSTATUS eloqua.com Used to auto -populate forms and validate if a given contact has subscribed to an email group. The cookies only set if the user allows tracking . 2 Years
IDE doubleclick.net Used by Google Double Click to register and report the website user’s actions after viewing clicking one of the advertiser’s ads with the purpose of measuring the efficiency of an ad and to present targeted ads to the user. 1 Year
NID google.com Registers a unique ID that identifies a returning user’s device. The ID is used for targeted ads. 6 Months
PREF youtube.com Registers a unique ID that is used by Google to keep statistics of how the visitor uses YouTube videos across different web sites. 8 months
test_cookie doubleclick.net This cookie is set by DoubleClick (which is owned by Google) to determine if the website visitor’s browser supports cookies. 1,073,201 Days
UserMatchHistory linkedin.com Used to track visitors on multiple websites, in order to present relevant advertisement based on the visitor’s preferences. 29 days
VISITOR_INFO1_LIVE youtube.com 179 days
.avia-table-4 td:nth-of-type(1):before { content: 'Cookie Name'; } .avia-table-4 td:nth-of-type(2):before { content: 'Domain / Associated Domain / Third-Party Service'; } .avia-table-4 td:nth-of-type(3):before { content: 'Description'; } .avia-table-4 td:nth-of-type(4):before { content: 'Retention period'; }
Third party companies Purpose Applicable Privacy/Cookie Policy Link
Alexa Show targeted, relevant advertisements https://www.oracle.com/legal/privacy/marketing-cloud-data-cloud-privacy-policy.html To opt out: http://www.bluekai.com/consumers.php#optout
Eloqua Personalized email based interactions https://www.oracle.com/legal/privacy/marketing-cloud-data-cloud-privacy-policy.html To opt out: https://www.oracle.com/marketingcloud/opt-status.html
CrazyEgg CrazyEgg provides visualization of visits to website. https://help.crazyegg.com/article/165-crazy-eggs-gdpr-readiness Opt Out: DAA: https://www.crazyegg.com/opt-out
DemandBase Show targeted, relevant advertisements https://www.demandbase.com/privacy-policy/ Opt out: DAA: http://www.aboutads.info/choices/
LinkedIn Show targeted, relevant advertisements and re-targeted advertisements to visitors of LTI websites https://www.linkedin.com/legal/privacy-policy Opt-out: https://www.linkedin.com/help/linkedin/answer/62931/manage-advertising-preferences
Google Show targeted, relevant advertisements and re-targeted advertisements to visitors of LTI websites https://policies.google.com/privacy Opt Out: https://adssettings.google.com/ NAI: http://optout.networkadvertising.org/ DAA: http://optout.aboutads.info/
Facebook Show targeted, relevant advertisements https://www.facebook.com/privacy/explanation Opt Out: https://www.facebook.com/help/568137493302217
Youtube Show targeted, relevant advertisements. Show embedded videos on LTI websites https://policies.google.com/privacy Opt Out: https://adssettings.google.com/ NAI: http://optout.networkadvertising.org/ DAA: http://optout.aboutads.info/
Twitter Show targeted, relevant advertisements and re-targeted advertisements to visitors of LTI websites https://twitter.com/en/privacy Opt out: https://twitter.com/personalization DAA: http://optout.aboutads.info/
. .avia-table tr {} .avia-table th, .flex_column .avia-table td { color: #343434; padding: 5px !important; border: 1px solid #ddd !important; } .avia-table th {background-color: #addeec;} .avia-table tr:nth-child(odd) td {background-color: #f1f1f1;}
Save settings
Cookies settings