POWER BI

JD-

Report and Dashboard Development:

Create insightful and interactive reports and dashboards using BI tools (e.g. Power BI) to visualize and communicate key performance indicators.

Collaborate with business users to gather reporting requirements and ensure deliverables meet their needs.

Optimize SQL queries for better performance and responsiveness.

Troubleshoot and resolve data-related issues in a timely manner.

Stay informed about emerging trends and technologies in the BI domain.

Make recommendations for adopting new tools or methodologies to improve BI capabilities.

Develop interactive Dashboards reports and hands on experience working with complex DAX queries.

Knowledge of working on various data sources and handling multiple mode of reports (e.g. Import, Direct query).

Ability to work on various databases PostgreSQL, MSQL etc.

Develop robust, high-quality code with SQL programming, writing stored procedures, View and Data Modelling knowledge.

Knowledge of advanced SQL programming concepts like CTE (Common Table Expressions), SUB-queries and handling complex joins etc.

Proficient into creating desired index, tuning SQL queries, debug and analyze performance issues.

Responsible for ensuring quality delivery of code through testing techniques.

Experience developing engaging visual reports/dashboards

Experience in creating and applying themes, templates

Good understanding of l latest PBI features, best practices, limitations

Good experience on designing the pages

Basic understanding of the data modeling