Have Developed and implemented mission- critical, interactive and analytic Business Intelligence (BI) reports and dashboard solutions in Power BI for Hewlett Packard, Singapore. If interested please contact. We provide professional services.
- Extracted transformed and loaded data from multiple source systems like MS SQL Server, Excel into Power BI (import mode) in a format that is more suitable for analysis.
- Used Data Analysis Expressions (DAX) Function, Queries and Operations for transformation and manipulation such as Aggregate, Conditional split, Data conversion, Derived column, Lookup.
- Used Direct Query mode for dashboard that needed live data.
- Dashboards drill downs functions that displays a breakdown of production line, date, time. Drop-Down Parameters, Matrix Reports and Charts.
- Performed root cause analysis on failures. Resolve performance tuning related issues and queries.
- Created and maintained Views, User Defined Functions, Procedures and Constraints.
- Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
- Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
- Experience across Microsoft BI suite of products including MS SQL Server and Power BI SDLC from requirements collection, prototyping, development to deployment/implementation and support.