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

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

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Bangalore - India

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

Design and create compelling data visualizations dashboards and reports that provide actionable insights to support on experience in writing complex SQL queries and creating the stored procedure to create SSRS paginated understanding of closely with data engineers and data optimize existing reports ensuring performance accuracy and responsiveness and addressing any data quality 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


Remote Work :

No


Employment Type :

Full-time

Employment Type

Full-time

Company Industry

About Company

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.