Mohammad Arshad

Data Analyst

• Job Details:Designed and developed Power BI dashboards to track key performance indicators (KPIs) and provide actionable insights to stakeholders for data-driven decision-making. Customized interactive Power BI dashboards and reports to monitor sales, customer behaviour, and inventory, driving strategic decisions with ensured data integrity. Built and optimized Power BI data models to enhance performance, improve reporting efficiency, and streamline data analysis. Formulated and fine-tuned DAX measures to perform advanced calculations like running totals, YoY growth, moving averages, and dynamic segmentation of customer data for improved business insights. Reduced reporting turnaround times by 40% through optimized DAX and Power Query workflows. Streamlined ETL workflows in Power Query and SQL to automate data extraction, transformation, and loading into Power BI, improving data flow and reporting efficiency. Leveraged Excel for data preprocessing, cleaning, deduplication, and structuring using VLOOKUP, INDEX-MATCH, XLOOKUP, PivotTables, conditional formatting, and data validation to deliver accurate, analysis-ready datasets. Engineered complex SQL queries for data extraction, transformation, and analysis, ensuring accuracy and actionable insights. Enhanced SQL workflows using CTEs and window functions to perform advanced analytics like ranking and trend analysis, delivering actionable insights for e-commerce and retail performance. Optimized SQL performance by creating views and automating reports with stored procedures, enabling faster data retrieval and timely delivery of critical business metrics. Managed large datasets (7M+ records) from SQL and Excel into Power BI, ensuring seamless data connectivity, consistency, and accurate reporting. Implemented row-level security (RLS) in Power BI to restrict data access based on user roles, ensuring secure and role-based reporting.