Free · takes a minute · your resume fills your profile
CoreHRx never asks candidates for money. If anyone does, .
Role at a glance
You will
Build, optimize, and maintain interactive Power BI dashboards and reports.
Apply AI/ML features within BI dashboards for predictive insights and automation.
Use advanced Excel functions for data analysis, validation, and reporting.
Experience
4–6 years
Education
Bachelor's degree (preferred)
Must-have skills
Data ModelingData Structures & AlgorithmsMicrosoft SQL ServerPower BIPower QueryQuery Optimization
How well do your skills match this job?
Sign in to see your fit: the skills, experience and location this job asks for, checked against your profile.
Job description
Location: Noida, Uttar Pradesh Department: Data Science
WSP India is seeking a motivated Business Intelligence Analyst with 4–6 years of experience to design, develop, and maintain BI dashboards and reports.
The ideal candidate will have strong analytical skills and hands-on expertise in Power BI, Excel, and AI-driven BI solutions.
Responsibilities
Build, optimize, and maintain interactive Power BI dashboards and reports.
Apply AI/ML features within BI dashboards for predictive insights and automation.
Use advanced Excel functions for data analysis, validation, and reporting.
Connect BI tools to SQL Server and other databases for seamless data integration.
Ensure accuracy and consistency of data across multiple sources.
Interpret complex datasets to provide actionable business insights.
Manage BI workspace permissions, documentation, and governance.
Basic understanding of billing, invoicing, timesheets, and expenses and how they feed into project cost reporting (good to have).
Basic awareness of project budgets, monthly accruals, and planned vs. actual cost tracking to support performance dashboards (good to have).
Ability to check project and billing data for accuracy and coordinate with finance and project teams; familiarity with ERP systems is a plus (good to have).
Required Skills
4–6 years of experience in Business Intelligence or related roles.
This guide is for freshers in India preparing for data analyst and Power BI developer interviews, and for experienced analysts and BI developers moving into senior roles. It has 60 questions with answers in three levels: the basics of Power BI Desktop, the Service, Power Query and modelling; then the DAX, relationships, security and refresh questions asked of people with a few years of experience; and finally performance, internals and design questions for senior roles. Many answers include a DAX measure or a Power Query step with worked numbers. Read the question, answer it aloud, then compare, and take the mock test to check yourself against the clock.
Questions you may be asked
What is the difference between Power BI Desktop and the Power BI Service?
What is the difference between a semantic model, a report and a dashboard?
What is Power Query, and what are applied steps?
Why do data types matter in Power Query, and how do you load dates written as DD/MM/YYYY correctly?