Power BI ( SSRS + SQL + Paginated)- WFO- Bangalore- 5+ yrs only DM - RNA

Company Description

WNS (Holdings) Limited (NYSE: WNS), is a leading Business Process Management (BPM) company. We combine our deep industry knowledge with technology and analytics expertise to co-create innovative, digital-led transformational solutions with clients across 10 industries. We enable businesses in Travel, Insurance, Banking and Financial Services, Manufacturing, Retail and Consumer Packaged Goods, Shipping and Logistics, Healthcare, and Utilities to re-imagine their digital future and transform their outcomes with operational excellence.We deliver an entire spectrum of BPM services in finance and accounting, procurement, customer interaction services and human resources leveraging collaborative models that are tailored to address the unique business challenges of each client. We co-create and execute the future vision of 400+ clients with the help of our 44,000+ employees.

Job Description

Design and create compelling data visualizations, dashboards, and reports that provide actionable insights to support decision-making.Hands on experience in writing complex SQL queries and creating the stored procedure to create SSRS paginated reporting.Good understanding of Reporting.Working closely with data engineers and data analysts.Continuously optimize existing reports, ensuring performance, accuracy, and responsiveness, and addressing any data quality issues.SkillMinimum Experience – 3 to 8 YearsT-SQL/PL-SQL, SSRS Paginated Report, Sap BI , Power BIGood CommunicationStrong Aptitude

Qualifications

Power BI

1. Key Features of Power BI
2. Data Integration Techniques
3. Data Refresh in Power BI
4. Data governance and security in Power BI
5. Active and Inactive Relationship
6. Filters in Power BI
7. Function in Power BI
   1. DAX
      1. CALCULATE
      2. SUMX
      3. AVERAGEX
   2. Time Intelligence Functions (ex : YTD)
   3. Filter Functions
   4. Text Functions
   5. Logical Functions (ex: AND)
   6. Date and Time Functions(ex: Month)

SSRS

1. Key Components of SSRS Paginated Reports
2. Creating Parameters in SSRS
3. Best Practices for SSRS Paginated Reports
4. Best Practices for Parameters
5. Change the sequence of report parameters in SSRS

SQL

1. DML & DDL
2. Primary key, Unique key, foreign key
3. Types of Joins
4. Date & Aggregate function
5. String functions
6. Set Operators
7. Windows function
8. CTE
9. Temp table in SQL
   1. Local
   2. Global
10. Performance tunning
11. Sample query based on above topics
    1. Query to identify and remove data redundancy in table
    2. Number of records based on joins

Additional Information

• 100% Work from Office
• No Mobile Phones/storage devices allowed within the floor