Business Intelligence Dashboards Offering Real-time Insights for a Japanese Multinational AC Manufacturing Company

Solution

• Q3 Team developed a Business Intelligence solution to gain business insights utilizing Power BI interactive dashboards using SQL server.
• Implemented User authorization i.e. restricted view and user access based on geography via dynamic row level security.
• Implemented features like dynamic top N filters and dynamic selection of measures to build an interactive visualization identifying most popular projects across time dimension and highest contributing products across various modules.

Country and User Level Detail Analysis is also available. Top projects and users by country can be toggled as per the Rank function provided.

Outcome