I developed an innovative solution comprising both an API and a corresponding APP to trace the data lineage from PowerBI. The primary aim of this project was to facilitate data analysts in conducting impact studies by providing clear insight into the data's origins and transformations.

Leveraging FastAPI, I designed the API to be highly efficient and robust, offering excellent performance and interactivity with the APP. The integration of these two components ensured a seamless and comprehensive data tracking process that enabled detailed examination of the data flow within PowerBI.

Recognizing the importance of collaboration, version control, and continuous deployment, I utilized a comprehensive toolset in the CI/CD pipeline. This included Bitbucket for code repository management, Artifactory for artifact repository, Docker for containerization, OpenShift for orchestration, and Jenkins for continuous integration and deployment.

The combination of these tools enabled an agile and responsive development environment. It ensured that the code was consistently tested, built, and deployed, leading to high reliability and streamlined updates.

In conclusion, the project showcases a successful alignment of cutting-edge technology and methodology to create a specialized solution for data analysts. The focus on tracing data lineage within PowerBI provides a valuable tool to support in-depth impact studies, making the process more efficient and insightful.