End-to-End Sales Report Development by Boris KeckarovskiEnd-to-End Sales Report Development by Boris Keckarovski

End-to-End Sales Report Development

Portfolio project
Boris Keckarovski
• Extracted raw transactional and master data from Dynamics 365 using Export to Data Lake, ensuring seamless integration with downstream analytical processes. • Designed and implemented ETL pipelines to clean, transform, and standardize the data, addressing data quality issues such as duplicates, missing values, and inconsistent formats. • Developed optimized SQL queries leveraging joins, subqueries, and CTEs to create structured analytical views for reporting and performance optimization. • Built a Power BI data model, establishing one-to-many and many-to-many relationships between tables to enable efficient data navigation. • Created advanced DAX measures and calculated columns for key performance metrics, enabling dynamic and interactive visualizations in Power BI dashboards.

0 likes · 6 views · Feb 3, 2025

Extracted Dynamics 365 data to Azure Data Lake, built ETL pipelines for cleaning, optimized SQL queries, and created a Power BI model with advanced DAX

Tags