Power BI and Excel Reports (portfolio)
Embedded Files
Few of the Power BI reports
Few of the Power BI reports
RFM Analysis: Marketing model for Customer Segmentation - Power Bi
Maven Airlines data challenge: Passenger Satisfaction Report ( Service Level KPIs') - Power BI
Onyx Data Challenge: Pie Bakery Sales Analysis (Sales, Cost, and Forecasting analysis) - Power BI
Kaggle: US Superstore (Profit and Logistics KPI) - Power BI
Product Segmentation (Revenue,Profit and PLC) - MS Excel
Top or Bottom N Values ( Sales Volume/Value) - MS Excel
Price Volume Mix Analysis (Sales,Price,Volume) - MS Excel
Product Segmentation Model ( MS Excel )
Functional area : Sales and Marketing
Model : To derive the Scores/Ratings based on Revenue,Profit and PLC
Parameters used : Revenue,Profit and PLC (Product Life Cycle).
Objective : Segment the Products based on Ratings or Scores to facilitate Sales and Marketing decisions.
Excel Formulas and Functions used : Table,Sum,Rank,Data Validation,If ,Index Match,Rept,Pivot Table,Quartile.Inc.
Top and Bottom N Values (MS Excel)
Functional area : Sales and Marketing
Model : Top N values (without filters/pivot tables)
Parameters used : Sales Volume and Value
Objective : View Top or Bottom N products from the Sales (Actuals )Data.It can be utilised for Inventory Data,Customer data based on Quantitative inputs like Volume,Value,Revenue,Profit,Cost,etc.
Excel Formulas and Functions used : Index,Sortby,Sequence,Vlookup,IFError.
Price Volume Mix Variance Analysis (Price Volume Revenue bridges)
(in MS Excel)
Functional area : Sales and Marketing
Model : Price Volume Mix Variance
Parameters used : Sales Volume and Value
Objective : Price-volume-mix analysis is vital in understanding the changes in sales and profits between two periods, between budget and actual or between 2 periods.It enables to see the impact of 3 components (price,volume and mix).
The analysis of the price and volume changes is a critical component in business. It allows businessmen to analyze the current year’s sales based on the previous one and also predict future sales.
Excel Formulas and Functions used : Basic maths and formulatext function.Conditional formating (if required).
Google Sites
Report abuse