Projects:

➢ Transaction Dashboard using Power BI Project Summary:

• The Project shows a visual Dashboard consisting of ACV, ATV and ATF KPIs by different channels, brands, app, as well as by tiers.

• The data is sourced from different channels including SQL servers and dataflows.

• I used DAX and Power query to generate various measures and calculated columns. Besides these we used different plots, charts, and slicers to get required info from the data.

➢ Quarterly Business Report of Business Loyalty program Project Summary:

• In this project I used SQL and Python to analyze the data and prepare a final presentation on data.

• I have done thorough analysis on the loyalty program like customer value analysis, cross brand analysis, redemption analysis, member vs non-member analysis, app users’ study, RFM analysis, customer Lifetime value analysis etc.

➢ House price prediction: Implication of linear regression model Project Summary:

• In this project, I have done data analysis, used Train/Test Split method, missing value imputation, encoding, normal transformation, outlier engineering, scaling of data and checked the accuracy of model etc.

• In this project I used Python to analyze the data and prepared a final presentation on data.