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.