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
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 | ||||