Chat with us, powered by LiveChat Perform an exploratory analysis using healthcare patient’s datasets and develop an interactive dashboard that provides insights on the key influencing factors on heart disease and hype - Writeden

1a) perform an exploratory analysis using healthcare patient's datasets and develop an interactive dashboard that provides insights on the key influencing factors on heart disease and hypertension.

1b) create visuals showing the impact of demographic factors on both diseases.

  c) create visuals showing the impact of behavioral factors on both diseases.

  d)  slice and dice data using all factors. 

   e) create a detailed analysis report, highlighting key insights from your analysis and tell the story on the top influencing factors on both diseases.

2)perform an exploratory analysis using the financial statements provided on the company's expenses, cash flow, income statement and balance sheet. Show 4 different dashboard views highlighting all the critical financial metrics performance. Slice and dice theses metrics with the different dimensions in the datasets to help understand the company's overall financial health.

2b) identify trends and patterns of the company's expenses and drill down by various dimensions.

c) what insights can you uncover about the company's cash flow?

d) slice and dice data using all factors for the balance sheet

e) create and executive report highlighting key insights, key drivers and provide detailed recommendations of how the company can improve its overall financial health.

3a) using machine learning model-python. predict student enrollment volume.

b) build a machine learning predictive model to forecast student enrollment volume using historical data to help ABC academy make smart investment decisions in executing marketing campaigns.

c) the management would like to know if the number of marketing campaigns launched impacts the volume of student's enrollment.

campaigns Enrollments
3 21
5 47
3 27
9 75
4 30
2 20
9 88
6 60
8 81
3 25
8 85
6 62
5 41
3 42
1 17
9 95
3 30
2 24
6 67
7 69
3 30
5 54
4 35
7 76
8 86
10 105
8 89
5 59
6 66

,

Balance Sheet

Balance Sheet Type Category Sub Category Year Cash 2016 2017 2018 2019
Assets Current Assets Cash 2015 11874 11875.15 11876.3 11877.45 11878.6
Assets Current Assets Accounts receivable 2015 4215 4216.15 4217.3 4218.45 4219.6
Assets Current Assets Inventory 2015 2145 2146.15 2147.3 2148.45 2149.6
Assets Current Assets Prepaid expenses 2015 354 355.15 356.3 357.45 358.6
Assets Current Assets Short-term investments 2015 254 255.15 256.3 257.45 258.6
Assets Fixed (Long-Term) Assets Long-term investments 2015 1208 1209.15 1210.3 1211.45 1212.6
Assets Fixed (Long-Term) Assets Property, plant, and equipment 2015 15340 15341.15 15342.3 15343.45 15344.6
Assets Fixed (Long-Term) Assets (Less accumulated depreciation) 2015 -2200 -2198.85 -2197.7 -2196.55 -2195.4
Assets Fixed (Long-Term) Assets Intangible assets 2015 2215 2216.15 2217.3 2218.45 2219.6
Assets Other Assets Deferred income tax 2015 134 135.15 136.3 137.45 138.6
Assets Other Assets Other 2015 324 325.15 326.3 327.45 328.6
Liabilities Current Liabilities Accounts payable 2015 8060 8061.15 8062.3 8063.45 8064.6
Liabilities Current Liabilities Short-term loans 2015 200 201.15 202.3 203.45 204.6
Liabilities Current Liabilities Income taxes payable 2015 3145 3146.15 3147.3 3148.45 3149.6
Liabilities Current Liabilities Accrued salaries and wages 2015 50 51.15 52.3 53.45 54.6
Liabilities Current Liabilities Unearned revenue 2015 333 334.15 335.3 336.45 337.6
Liabilities Current Liabilities Current portion of long-term debt 2015 0 1.15 2.3 3.45 4.6
Liabilities Long-Term Liabilities Long-term debt 2015 3450 3451.15 3452.3 3453.45 3454.6
Liabilities Long-Term Liabilities Deferred income tax 2015 252 253.15 254.3 255.45 256.6
Liabilities Long-Term Liabilities Other 2015 111 112.15 113.3 114.45 115.6
Owner's Equity Owner's Equity Owner's investment 2015 7178 7179.15 7180.3 7181.45 7182.6
Owner's Equity Owner's Equity Retained earnings 2015 4389 4390.15 4391.3 4392.45 4393.6
Owner's Equity Owner's Equity Other 2015 0 1.15 2.3 3.45 4.6
Assets Current Assets Cash 2016 11875.15
Assets Current Assets Accounts receivable 2016 4216.15
Assets Current Assets Inventory 2016 2146.15
Assets Current Assets Prepaid expenses 2016 355.15
Assets Current Assets Short-term investments 2016 255.15
Assets Fixed (Long-Term) Assets Long-term investments 2016 1209.15
Assets Fixed (Long-Term) Assets Property, plant, and equipment 2016 15341.15
Assets Fixed (Long-Term) Assets (Less accumulated depreciation) 2016 -2198.85
Assets Fixed (Long-Term) Assets Intangible assets 2016 2216.15
Assets Other Assets Deferred income tax 2016 135.15
Assets Other Assets Other 2016 325.15
Liabilities Current Liabilities Accounts payable 2016 8061.15
Liabilities Current Liabilities Short-term loans 2016 201.15
Liabilities Current Liabilities Income taxes payable 2016 3146.15
Liabilities Current Liabilities Accrued salaries and wages 2016 51.15
Liabilities Current Liabilities Unearned revenue 2016 334.15
Liabilities Current Liabilities Current portion of long-term debt 2016 1.15
Liabilities Long-Term Liabilities Long-term debt 2016 3451.15
Liabilities Long-Term Liabilities Deferred income tax 2016 253.15
Liabilities Long-Term Liabilities Other 2016 112.15
Owner's Equity Owner's Equity Owner's investment 2016 7179.15
Owner's Equity Owner's Equity Retained earnings 2016 4390.15
Owner's Equity Owner's Equity Other 2016 1.15