8000 GitHub - Keithleo9008/BI_Insights_Challenge: BI_Insights_Challenge · GitHub
[go: up one dir, main page]

Skip to content

About

BI_Insights_Challenge

Resources

Stars

0 stars

Watchers

0 watching

Forks

Repository files navigation

BI_Insights_Challenge

Q1 - Birthdays

Analyzing the dispersion of ages we can see that the ages represent a bell curve with a long tail to the right. This tells us about the general demographic profile of customers. The clientelle of the company. Are mostly between the ages of 45 and 70. We can definatly see that the product is not popular with clients under the age of 30 but very relevant for older clients and only starts tailing off after around retirement age. Perhaps we could infer the company sells mortgages bonds or life insurance.

alt text

Q2 - Sql

alt text

Q3 - Financial Modeling

alt text

Q4 - Problem Solving

Not yet completed

Advanced - Coin Flipping

I Created a StoreProc that uses The Recursive CTE design pattern to find the Highest Number of consecutive flips for a chosen coin side (heads) then used a cursor (not ideal) to iterate through each of the players for simplicity.The Code for all the sql artefacts have been uploaded above

alt text

Advanced - Prime Proportions

choose the number of squares to create (Max 10 for simplicity) Click the "Generate table" button and watch the squares being generated and the prime numbers highlighted in red, the VBA code has been saved in a separate file in the repository the only part not completed was the summary table. The actual working excel file is in the zip folder, to use please make sure macros are enabled.

alt text

About

BI_Insights_Challenge

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors

Languages

0