Designed semantic business intelligence models and Power BI data models for the intelligence reporting project. Created dimension tables for products, customers, and time, and implemented a Star schema structure for the sales data.Advanced data manipulation and transformation were performed using Mquery.

Involved in integrating consumer sentiment scores and sentiment data into the BI semantic model by leveraging Power BI functionalities.Created dynamic scorecards with Power View that displays the essential data needed by many departments.Several DAX functions were implemented for fact calculations and columns, which helped to improve the efficiency of the data presentation.

Designed and developed impactful dashboards using Power BI, translating complex data into visually compelling insights. Performed a significant part in combining several data formats (Parquet, CSV, JSON, ORC) and different types of data (structured, semi-structured, and unstructured) to enable thorough data analysis.