Inventory and Sales Business Solutions

Project Title : Inventory &Sales Business Solutions Client : Andhra Jyothi Media Pvt Ltd Duration : Nov-2023 – Apr-2025 Environment : Microsoft Power BI Description: - Andhra Jyothi is the third largest circulated Telugu language daily newspaper of India. It is sold mostly in the states of Andhra Pradesh and Telangana.

Responsibilities

 Developed Sales Performance, Revenue, and Profitability Dashboards using Bar Charts, Column Charts, Line Charts, KPI Cards, and Tables by importing data from CSV, Excel, and Flat Files.  Built Inventory Management Reports with Stacked Column Charts, Gauges,and Slicers to monitor stock availability, reorder levels, inventory aging, and warehouse performance.  Created Product Performance and Category Analysis Reports using Pie Charts and Clustered Bar Charts to identify top-selling, slow-moving, and low-performing products.  Designed Customer Sales and Regional Analysis Dashboards with Filled Maps, Line Charts, Ribbon Charts, and Scatter Charts to analyze sales trends, customer segments, and regional performance.  Developed Order Fulfillment, Inventory Movement, and Shipment Reports using,Funnel Charts and Tables to monitor purchase orders, dispatches, returns, and stock movements.  Automated Daily, Weekly, and Monthly Executive Reports by publishing datasets to Power BI Service, configuring scheduled refreshes, and implementing interactive Bookmarks, Drill-through, Drill-down, Filters, and Slicers.  Created Executive KPI Dashboards, Sales Summary Reports, Inventory Summary Reports to support strategic business decision-making.