Cole Ondus

The overall objective of the study was to find out the relationship between monetary policies and financial performance of commercial banks in Kenya. The study found out that there is a strong positive relationship between monetary policies and financial performance of commercial banks in Kenya. Therefore, the study concludes that monetary policies instruments influence the financial performance of commercial banks in Kenya.

-- 1. Remove Duplicates
-- 2. Standardize the data
-- 3. Null values or blank values
-- 4. Remove any columns

The goal was to value a company's shares. I used DCF model to find NPVs of future free cash flows. I then calculated the intrinsic value of the company
and compared it with the market value. This enabled me to see if the company's shares are overvalued or undervalued.

I calculated Accrued Interest, Clean prices, and dirty prices of government treasury bonds. I used net present value to discount the values of the future cashflows(interest payments).

I imported real field survey data from an Excel workbook into Power Query editor. I cleaned and transformed the data into meaningful data for analysis. I analysed the transformed data in Power BI and created a dashboard containing visualizations with actionable insights.

I created charts, graphs and tables to communicate insights from data analysis.

I used DAX formulas and calculations to create new aggregation measures and columns. I used SUMX formula and IF statements to iterate sum over each row.