#UKBankCustomerBaseline #StoryLine #InteractiveDashboard #Bins&Parameters #Annotations
- The majority of bank customers, 54%, are from the United Kingdom.
- The UK customer base primarily consists of white-collar workers, constituting 70% of their clientele. This could be attributed to London's status as the economic hub of Europe.
- A significant majority of our customers are older individuals, with males making up the predominant group at 72%.
- Majority of the customers are more blue collar workers(48%), very few white - collar workers.
- Majority of customers are predominantly Females(74%) and maximum bank balance is below 35k within the age group of 28 - 30.
- In contrast to the general baseline, there's a distinct pattern in the distribution of balances. While the baseline shows a decrease, the "whales" category initially experiences an increase before eventually declining.
- The data for Wales indicates a higher-than-average presence of mid-sized balances.
#Groups #GeographicalRoles #CalculatedField #Highlighter #Clustering #KmeansClustering #CrossDatabaseJoin #ThreeDimensionalModeling #TrendLine
- Average Revenue per city, Average Marketing Spend per city, Average Revenue on marketing investment per city (Revenue / Marketing Spend).
- Top 10 New locations having the best potential for the company to invest more funds into marketing.
- https://sds-platform-private.s3-us-east-2.amazonaws.com/uploads/P1-StartupExpansion.xlsx
- https://sds-platform-private.s3-us-east-2.amazonaws.com/uploads/P1-US-Cities-Population.csv
- Region 2 has better returns on marketing spend compared to Region 1.
- Two new cities are situated within the lower-clustered cities, characterized by high marketing expenses but relatively low revenue. Therefore, it is advisable to allocate investments towards the higher-clustered cities, where marketing expenditure is moderate and revenue is consistently above average.
Refined our analysis by cross joining the 2nd Dataset (Population), now inference from 2nd Challenge.
- Red Trendline: With every dollar spent on marketing, the company generates revenue of $0.94. Consequently, in this cluster or group of cities, the company is operating at a loss.
- Orange Trendline: With every dollar spent on marketing, the company generates revenue of $7.32. Consequently, in this cluster or group of cities, the company is profitable.
- Blue Trendline: With every dollar spent on marketing, the company generates revenue of $3.17. Consequently, in this cluster or group of cities, the company is profitable.
- Recommend that WeWashUSleep increase its marketing efforts in three new orange cities: California, Illinois, and New Jersey.
#ImportSpacialDataFromOpenSourcePlatforms #ImportpdfFile #JoinSpacialPdf #CleanData #RemoveDuplicates $CreategeographicalPolygons
- https://sds-platform-private.s3-us-east-2.amazonaws.com/uploads/P1-nyc-park-crime-stats-q1-2018.pdf
- https://sds-platform-private.s3-us-east-2.amazonaws.com/uploads/P1-NYC-Parks-and-Public-Spaces-Spatial-Files.zip
#Filters #CalculatedFields #DataCleaning #RemoveDuplicates $TooltipVisualization
