Data Analyst with a business-oriented approach

نبذة عني

Data analyst specialist, specializing in end-to-end data processing, advanced modeling, and dynamic business intelligence solutions using Advanced Excel and Power BI. Building complex relational data models using Power Pivot and Power Query. Developing automated reporting workflows using advanced functions, Index-Match/XLOOKUP, conditional formatting, and dynamic Pivot Tables to handle large-scale operational datasets. Data cleaning, transformation, handling null values, and structuring raw data for downstream consumption. Power BI Development & DAX End-to-end dashboard design from schema modeling (Star/Snowflake schemas) to final executive reporting. Writing advanced DAX measures and calculated columns (Time Intelligence functions like TOTALYTD/SAMEPERIODLASTYEAR, calculated tables, iterator functions like SUMX, and context transition). Optimizing performance, managing row-level security (RLS), and configuring scheduled data refreshes and gateway connections. Data Extraction & SQL Integration: Querying and extracting data from relational databases using optimized SQL queries and joins to feed analytical models. Professional Value: Focused on replacing manual tracking with automated, scalable dashboards that track Key Performance Indicators (KPIs), monitor variances, and translate complex data points into actionable operational insights. Ready to audit existing workflows or build scalable analytical architecture from scratch