Data Analyst
CurrentDevelop operational reportsBuild automated reports and dashboards with the help of Power BI and other reporting toolsUnderstand business requirements to set functional specifications for reporting applicationsBe experienced in tools and systems on MS SQL Server BI Stack, including SSRS and TSQL, Power Query, MDX, PowerBI, and DAXBe able to quickly shape data into reporting and analytics solutionsCreate functional reportingHave knowledge of database fundamentals such as multidimensional database design, relational database design, and moreWork with business leaders to identify opportunities for improvementCollaborate with team members to collect and analyze dataEstablish KPIs to measure the effectiveness of business decisionsStructure large data sets to find usable information Implemented ETL processes using Power Query to extract and transform data from 5 POSs covering 1825 Locations, ensuring data integrity and consistency. Designed and developed interactive dashboards and reports in Power BI, incorporating advanced calculations, drill-down functionality, and data visualizations to track Transaction counts, Sales, and customer complaints.Utilized Power Query to connect to various data sources, performed data cleansingImplemented row-level security in Power BI to provide secure data access and ensure data confidentiality.