Data Analysis

Sales & Logistics Analytics Dashboard | Power BI, SQL & DAXDesigned and implemented an end-to-end Power BI sales analytics solution modeled on a Star Schema data architecture, linking fact sales data with multiple dimensional entities. Engineered key business metrics using custom DAX measures to analyze 121K+ orders, $3.18M in freight costs, and $120M+ total revenue across global markets. Modeled order volume and demand trends across 4 key product categories and regional territories (led by Southwest and Canada), identifying peak growth cycles from 2011 to 2014. Visualized logistics and fulfillment operations, evaluating shipping method distributions and order status completion rates to support executive decision-making.