Tools used : MS Excel, Power BI, MySQL, DAX
• Created a dynamic multi-view dashboard in Power BI, connecting directly to SQL Server to analyze sales trends. This enhanced data accessibility, enabling data-driven decisions and contributing to a notable 10% increase in business process efficiency.
• Successfully imported and harmonized data from various sources, encompassing over 60,000 records from MySQL and Excel. Conducted comprehensive data modeling, improving data accessibility and accuracy for strategic decision-making.
• Imported 2 different data sources (MySQL, and Excel) with more than 60 Thousand records and performed data modeling.
• Established SQL Server and Power BI integration, leveraging the power of DAX and Power Query for enhanced data analysis.