Karl Pearson used to say that "statistics is the grammar of science." In a world where quintillion bytes of data are processed daily, statistics play an increasingly major role in many aspects of our life. In politics, they offer insights on such important events as the presidential race. In the US, shortly after the officials announced the preliminary election results, it became clear that it would be enough for Joe Biden to win in Pennsylvania to gain 270 electoral votes, the minimum required to win the presidency. As we all know now, the traditional support of the Democratic Party in Philadelphia and adjacent areas have secured the eventual results.
So today let’s look at the reasons why ex-president Trump has lost the battle of Pennsylvania. Why Pennsylvania though? The Keystone State is the closest state to the US average in terms of education and income, the important metrics when analyzing the voting process:
The median income
- In Pennsylvania, the median household income is average. Median across all states is $59.116 while it is $59.445 in Pennsylvania.
A bachelor's degree
- The state averages on people with four-year college degrees. The median is 31% - the same figure for Pennsylvania.
Let’s take a closer look at numbers. Here’s the voting history for the presidential race in Pennsylvania.
There is how Pennsylvanians voted in 2020:
Votes on the map graph
According to the state officials, about 71% of the state's population turned up to vote, a new record-setting outcome. Most likely, this high mark means the following:
1. Pennsylvanians en masse are unsatisfied with the incumbent office and want to speed up changes by voting.
2. Biden managed to reveal Trump's failures as a president and agitate both his supporters and non-defined voters to proactively participate in the elections.
3.Trump encouraged his supporters to participate in elections as well.
Let’s do the maths, shall we? The stats reveal that big counties tend to vote for Biden, in comparison with small and rural counties that mainly support Trump.
So there’s the dependency between what party the county aligns to and its demographics. For instance, counties below 140k in residents tend to vote for Trump. At the same time, counties with 140-300k in population vote for both Dems or Reps depending on local preferences in a particular county. It’s worth saying that Westmoreland, Berks, York, and Lancaster are unique so they should be reviewed separately depending on population diversity and their primary economic involvement. Finally, the counties with more than 300,000 citizens vote for Democrats only.
So, let’s check the population structure for blue counties. As it comes from the research of Pew Research Center, the same ethnical groups tend to support the same party throughout the years which results in a nearly constant percentage of registered voters. If we look at the composition of the population, we can see that blue counties have different ethnic proportion. The aforementioned counties have a higher part of people of color than other counties:
Most of these ethnic groups (especially Hispanic and Asian Americans) ardently support Democrats, and this trend has become even more evident during the last couple of years. At the same time, in Pennsylvania, white Americans generally prefer to vote for Republicans. Let’s check the percentage of voters for Republicans and Democrats correspondingly in 2020 and 1992 per main ethnicity groups:
In Pennsylvania, blue counties keep on growing and their part among all votes has increased from 55.3% in 2016 to 55.5% in 2020. In addition, the part of non-white voters has increased in these counties from 50.75% in 2016 to 54.83% in 2020. Joe Biden managed to obtain a high percentage from these counties.
Let's see what factors influenced the opinion of the undecided or could change their minds over the course of the election company. First, let’s observe how candidates ratings have been changing during the race:
- April 9th - Trump and Biden became presumptive nominees for their parties. Biden gets acknowledged as a nominee and his rating starts to grow both in the whole USA and Pennsylvania.
- May 25th - the death of George Floyd. Biden advocates that the current government is not capable of solving the problem with racism in state institutions. Trump’s rating gets down.
- May 29th - the death toll in the U.S. surpasses 100,000. The COVID-19 draws the border between candidates. Both candidates suggested very different approaches towards dealing with the problem. Biden proposed to go into a quick but complete lockdown while sending payments to closed businesses. Trump’s approach is partial lockdown and earlier opening of businesses. Biden’s rating goes up while Trump’s popularity decreases.
- June 24th - Dr. Anthony Fauci’s report on the coronavirus crisis claims that the US is “in a bad position”. The lowest point of Trump’s rating following the announcement that the US anti-COVID approach fails.
- October 2nd - Trump was diagnosed with COVID-19. The candidate had to stop public events, and that had a direct impact on the rest of his campaign. Trumps’ rating gets appr. -1.8 point down. After recovery, he started to gain the popularity of swing states due to the rally of events in those states and an effective media campaign.
Conclusion
We can conclude that the result of past elections in Pennsylvania often depended on two main patterns being commonplace in the large counties.
Demographics. The population in the largest counties vote for the Democrats on a permanent basis. Besides, more people of color vote for democrats, and this percentage of such voters (and their overall quantity) is growing. Thus, this trend is in favor of the Democrats, and it continues to grow.
The election race. Second, voters watch closely the election race, and how candidates react to the most significant challenges. The ex-president’s mistakes in his fight against the pandemic did not lower his rating that much - he still got support. This way, the voting preferences depend on more basic factors such as level of education, welfare, and sphere of activity. Thus, Trump’s supporters are more likely to vote for his ideas and personal qualities.
In his turn, Biden could attract those who did not go to the polls earlier or hesitated in their choice. He managed to wisely distance himself from Trump during the events of summer 2020, namely the BLM-driven protests and the pandemic crisis. However, Trump was somehow able to maintain the support of his voters.
One way or another, Biden is far less controversial than Trump. He is acceptable as the president to significantly more voters than Trump or the previous Democratic nominee Hillary Clinton.
Billing Automation for a SaaS Company with Low-Code
Our client needed a robust billing solution to manage hierarchical licenses, ensure compliance, and automate invoicing for streamlined operations.
The solution:
We developed a Retool-based application that supports multi-tiered licenses, automates invoicing workflows, and integrates seamlessly with CRM and accounting platforms to enhance financial data management.
The result:
- Achieved 100% adherence to licensing agreements, mitigating penalties.
- Automated invoicing and workflows reduced manual effort significantly.
- Dashboards and reports improved decision-making and operational visibility.
Retool Dashboards with HubSpot Integration
Our client needed a centralized tool to aggregate account and contact activity, improving visibility and decision-making for the sales team.
The solution
We built a Retool application integrated with HubSpot, QuickMail, and Clay.com. The app features dashboards for sorting, filtering, and detailed views of companies, contacts, and deals, along with real-time notifications and bidirectional data syncing.
The result
- MVP in 50 hours: Delivered a functional application in just 50 hours.
- Smarter decisions: Enabled data-driven insights for strategic planning.
- Streamlined operations: Reduced manual tasks with automation and real-time updates.
Lead Generation Tool to Reduce Manual Work
Our client, Afore Capital, a venture capital firm focused on pre-seed investments, aimed to automate their lead generation processes but struggled with existing out-of-the-box solutions. To tackle this challenge, they sought assistance from our team of Akveo Retool experts.
The scope of work
The client needed a tailored solution to log and track inbound deals effectively. They required an application that could facilitate the addition, viewing, and editing of company and founder information, ensuring data integrity and preventing duplicates. Additionally, Afore Capital aimed to integrate external tools like PhantomBuster and LinkedIn to streamline data collection.
The result
By developing a custom Retool application, we streamlined the lead generation process, significantly reducing manual data entry. The application enabled employees to manage inbound deals efficiently while automated workflows for email parsing, notifications, and dynamic reporting enhanced operational efficiency. This allowed Afore Capital's team to focus more on building relationships with potential founders rather than on administrative tasks.
Retool CMS Application for EdTech Startup
Our client, CutTime, a leading fine arts education management platform, needed a scalable CMS application to improve vendor product management and user experience.
The scope of work
We developed a Retool application that allows vendors to easily upload and manage product listings, handle inventory, and set shipping options. The challenge was to integrate the app with the client’s system, enabling smooth authentication and product management for program directors.
The result
Our solution streamlined product management, reducing manual work for vendors, and significantly improving operational efficiency.
Building Reconciliation Tool for e-commerce company
Our client was in need of streamlining and simplifying its monthly accounting reconciliation process – preferably automatically. But with a lack of time and low budget for a custom build, development of a comprehensive software wasn’t in the picture. After going through the case and customer’s needs, we decided to implement Retool. And that was the right choice.
The scope of work
Our team developed a custom reconciliation tool designed specifically for the needs of high-volume transaction environments. It automated the processes and provided a comprehensive dashboard for monitoring discrepancies and anomalies in real-time.
The implementation of Retool significantly reduced manual effort, as well as fostered a more efficient and time-saving reconciliation process.
Creating Retool Mobile App for a Wine Seller
A leading spirits and wine seller in Europe required the development of an internal mobile app for private client managers and administrators. The project was supposed to be done in 1,5 months. Considering urgency and the scope of work, our developers decided to use Retool for swift and effective development.
The scope of work
Our developers built a mobile application tailored to the needs of the company's sales force: with a comprehensive overview of client interactions, facilitated order processing, and enabled access to sales history and performance metrics. It was user-friendly, with real-time updates, seamlessly integrated with existing customer databases.
The result? Increase in productivity of the sales team and improved decision-making process. But most importantly, positive feedback from the customers themselves.
Developing PoC with Low Code for a Tour Operator
To efficiently gather, centralize, and manage data is a challenge for any tour operator. Our client was not an exception. The company was seeking to get an internal software that will source information from third-party APIs and automate the travel itinerary creation process. Preferably, cost- and user-friendly tool.
The scope of work
Our experts ensured the client that all the requirements could be covered by Retool. And just in 40 hours a new software was launched. The tool had a flexible and easy-to-use interface with user authentication and an access management system panel – all the company needed. At the end, Retool was considered the main tool to replace the existing system.
Testing New Generation of Lead Management Tool with Retool
Our client, a venture fund, had challenges with managing lead generation and client acquisition. As the company grew, it aimed to attract more clients and scale faster, as well as automate the processes to save time, improve efficiency and minimize human error. The idea was to craft an internal lead generation tool that will cover all the needs. We’ve agreed that Retool will be a perfect tool for this.
The scope of work
The project initially began as a proof of concept, but soon enough, with each new feature delivered, the company experienced increased engagement and value.
We developed a web tool that integrates seamlessly with Phantombuster for data extraction and LinkedIn for social outreach. Now, the company has a platform that elevates the efficiency of their lead generation activities and provides deep insights into potential client bases.
Building an Advanced Admin Portal for Streamlined Operations
Confronted with the need for more sophisticated internal tools, an owner of IP Licensing marketplace turned to Retool to utilize its administrative functions. The primary goal was to construct an advanced admin portal that could support complex, multi-layered processes efficiently.
The scope of work
Our client needed help with updating filters and tables for its internal platform. In just 30 hours we've been able to update and create about 6 pages. Following features were introduced: add complex filtering and search, delete records, styling application with custom CSS.
Together, we have increased performance on most heavy pages and fixed circular dependency issues.
Creating MVP Dashboard for Google Cloud Users
Facing the challenge of unoptimized cloud resource management, a technology firm working with Google Cloud users was looking for a solution to make its operations more efficient. The main idea of the project was to create an MVP for e-commerce shops to test some client hypotheses. Traditional cloud management tools fell short.
The scope of work
Determined to break through limitations, our team of developers turned Retool. We decided to craft an MVP Dashboard specifically for Google Cloud users. This wasn't just about bringing data into view; but about reshaping how teams interact with their cloud environment.
We designed a dashboard that turned complex cloud data into a clear, strategic asset thanks to comprehensive analytics, tailored metrics, and an intuitive interface, that Retool provides. As the results, an increase in operational efficiency, significant improvement in cost management and resource optimization.
Elevating CRM with Custom HubSpot Sales Dashboard
Our other client, a SaaS startup, that offers collaborative tools for design and engineering teams, was on a quest to supercharge their sales efforts. Traditional CRM systems were limited and not customizable enough. The company sought a solution that could tailor HubSpot to their workflow and analytics needs.
The scope of work
Charged with the task of going beyond standard CRM functions, our team turned to Retool. We wanted to redefine how sales teams interact with their CRM.
By integrating advanced analytics, custom metrics, and a user-friendly interface, our developers provided a solution that transformed data into a strategic asset.
In 40 hours, three informative dashboards were developed, containing the most sensitive data related to sales activities. These dashboards enable our customer to analyze sales and lead generation performance from a different perspective and establish the appropriate KPIs.
Building a PDF Editor with Low-Code
Our client, a leading digital credential IT startup, needed a lot of internal processes to be optimized. But the experience with low-code tools wasn’t sufficient. That’s why the company decided to hire professionals. And our team of developers joined the project.
The scope of work
The client has a program that designs and prints custom badges for customers. The badges need to be “mail-merged” with a person’s info and turned into a PDF to print. But what is the best way to do it?
Our developers decided to use Retool as a core tool. Using custom components and JavaScript, we developed a program that reduced employees' time for designing, putting the data, verifying, and printing PDF badges in one application.
As a result, the new approach significantly reduces the time required by the internal team to organize all the necessary staff for the conference, including badge creation.