ADVENTUREWORKS-ANALYSIS WITH MICROSOFT FABRIC AND SQL SERVER
This project exemplifies the seamless integration of Microsoft Fabric and SQL Server On-Premises to construct an interactive dashboard, facilitating comprehensive data analysis for informed decision-making. By leveraging advanced dataflow Gen2 techniques and establishing an On-Premises gateway connection, raw data from SQL views was transformed into actionable insights within Power BI Desktop. Emphasizing performance optimization, Import Mode was favoured over DirectQuery, ensuring efficient data processing. The resulting dashboard not only provided a holistic view of AdventureWorks' performance but also laid the groundwork for future data-driven endeavours, showcasing the project's pivotal role in driving informed business strategies.
Click the below link to view the project
Skills: Microsoft Fabric · DAX · Dataflow Gen2 · Microsoft SQL Server · Microsoft Power BI · Data Analytics · Data Visualization · SQL View · Data Gateway · Data Integration
Portfolio & ServicesMore posts from Ganiu Aina
View posts
AFRICA UNEMPLOYMENT ANALYSIS
Ganiu Aina · This analysis focuses on unemployment in Africa, identifying Djibouti, Lesotho, South Africa, Eswatini, and Libya as the top five countries with high rates. Surprisingly, despite its large population, Nigeria ranks 12th in electricity access and 34th in unemployment rates. Nigeri ...
You may be interested in these jobs
-
· ITC Worldwide is seeking a Power BI Developer with expertise in Microsoft's Power BI Desktop and Power BI Services (Fabric), to support reporting and KPI development for business applications and intelligence. The ideal candidate will play a critical role in designing, develop ...
Abuja Federal Capital Territory, Nigeria2 days ago
Comments