Vishal Rai

Played a significant part in ensuring the successful delivery of the weekly requirements on Power BI, as requested by clients and stakeholders. This involved creating Power BI Report or new visuals on existing reports that enabled them to gain a deeper understanding of the data. Ensured that the project report was kept up to date on a daily basis by monitoring the Azure Data Factory pipeline. This involved overseeing the execution of Azure Databricks notebooks, which enabled users to access the latest data with minimal delay. Utilized Azure Databricks to gather, clean, and transform data. The transformed data was then stored in Microsoft SQL Server, which served as a repository. Finally, Power BI was employed to perform additional visualizations using the stored data. Collaborated with stakeholders to ensure effective communication and alignment on client feedback, driving the creation of new features to better meet client needs.

Contributed to creating Power BI reports to assist clients marketing teams in making informed business decisions. Imported data to Azure DataBricks (ADB) from upstream sources and transformed it in the backend using ADB to clean, filter, and transform raw data into useful insights. Created a tabular model with live connection to ensure that reports were always up-to-date and accurate. Created a DAX query based on the Excel pivot provided by clients. Used Power BI to present a customized view that facilitated users in conducting their respective analyses. Developed skills in data transformation, modeling, and visualization, relevant for organizations seeking to use data effectively.