Manoj K

Business Intelligence Consultant @Costcutter

London, GB

Design and development of Microsoft Power BI visualization solutions like Dashboards, Standard Reports, Scorecards, Drill down reports, Drill through reports, charts, and Ad - hoc Reports.• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards. • Designed expressions to calculate, group, filter, parameterize, and format report contents to analyse the retailers\' performance.• Generated score cards with executive summary dashboards to display performance monitoring measures.• Delivered on-demand reports in multiple rendering formats with standard and data-driven subscriptions. • Utilized Power BI (Power View) to create various analytical dashboards that depict critical KPIs such as sales, profitability, inventory, and business hours with slicers and dicers enabling end-user to make filters.• Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI with the decision makers for strategic planning. • Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging. • Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI. • Provisioned VMs with SQL Server on the cloud utilizing Microsoft Azure and setting up communication with the help of endpoints • Deploying Dashboards and reports to the Cloud.• Good understanding of Data Modelling in data warehouse environments such as star schema and snowflake schema. • Experienced in developing Data Mapping, Performance Tuning, and Identifying Bottlenecks of sources, mappings, targets, and sessions.• Involved in developing test cases for Unit Testing.• Perform thorough unit testing on all relevant platforms to ensure proper implementation.• Collaborated with senior management, subject matter experts, and IT teams to define business requirements