Yash Nagrecha

Data Analyst @My First Australian Offer

Tech stack: SQL (SQLite), Power BI (DAX), Python, Excel• Built an AI-augmented Retail Energy Analytics solution by integrating OpenAI\'s API with Power BI dashboards via Python, enabling automated generation of contextual insights and actionable recommendations beyond traditional reporting.• Delivered 4 end-to-end analytics projects using Excel, SQL (DB Browser for SQLite), Power BI, and Python, analysing rows of sales, financial, and customer data to produce executive-ready insights and recommendations.• Built interactive Excel and Power BI dashboards featuring 5+ analytical visuals, KPI cards, DAX measures, PivotTables, and slicers, enabling analysis of revenue, customer value, and service performance across regions and categories.• Performed financial variance analysis using SQL in DB Browser for SQLite across 12 months, 6+ expense categories, and multiple cities, applying GROUP BY, ORDER BY, and CASE logic to identify recurring overspend patterns and cost-control opportunities.• Implemented customer segmentation and value analysis across 700+ customers, identifying high-value segments responsible for the majority of revenue and supporting targeted retention and upselling strategies.• Developed a Python-based regression model using pandas and scikit-learn, engineering time-based features (Month, Quarter) and evaluating performance with R², MAE, and RMSE, clearly documenting deterministic relationships and modelling limitations.