COVID-19 ANALYSIS USING POWER BI DESKTOP

This project uses Microsoft Power BI Desktop to Transform, load and visualize the data.

DAX FORMULAS USED

Total Purchase = SUM(ifood_df[No.CatalogPurchases]) + SUM(ifood_df[No.DealsPurchases]) + SUM(ifood_df[No.StorePurchases]) + SUM(ifood_df[No.WebPurchases])

Target Response = 0.15* SUM(ifood_df[Response])

Campaign Profit = SUM(ifood_df[Z_Revenue]) - SUM(ifood_df[Z_CostContact])

% Success = (SUM(ifood_df[Response])) / (SUM(ifood_df[Campaign_Overall]))

DATASET The dataset used is uploaded and the source is Kaggle.

DASHBOARD