AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
gNAP Services Power BI Developer Interview Questions and Answers for Freshers
gNAP Services Power BI Developer Interview Experiences for Freshers
1 interview found
abhishek kumar mishra
Selected
I applied via Naukri.com and was interviewed before Feb 2023. There was 1 interview round.
(1 Question)
- Q1. Prepare SQL and Power BI for this role. For SQL questions are mainly asked from joins, constraints, stored procedures, triggers, views etc. For Power BI prepare DAX, data modeling, power query, use of diff...
Interview questions from similar companies
Power BI Developer Interview Questions & Answers
Hexaware Technologies
Anonymous
posted on 31 May 2024
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
(1 Question)
- Q1. Tell me about Yourself
Interview Preparation Tips
Power BI Developer Interview Questions & Answers
Hexaware Technologies
Umeed Pasha
posted on 29 Jun 2024
(2 Questions)
- Q1. Dax query method question
- Q2. Direct query method and formulas
Power BI Developer Interview Questions & Answers
Hexaware Technologies
Anonymous
posted on 14 Oct 2023
Selected
I was interviewed before Oct 2022.
(1 Question)
- Q1. What is the difference between star schema and snowflake schema?
- Ans.
Star schema has a single fact table connected to multiple dimension tables, while snowflake schema has normalized dimension tables.
Star schema denormalizes dimension tables, making it easier to query but potentially less efficient for storage.
Snowflake schema normalizes dimension tables, reducing redundancy but potentially making queries more complex.
Star schema is commonly used for data warehouses with denormalized da...
(1 Question)
- Q1. What is the use of GROUP BY clause?
- Ans.
The GROUP BY clause is used in SQL to group rows that have the same values into summary rows.
It is used with aggregate functions like COUNT, SUM, AVG, etc.
It helps in summarizing data and generating reports.
It is often used in conjunction with the HAVING clause to filter grouped data.
Example: SELECT department, COUNT(employee_id) FROM employees GROUP BY department;
Interview Preparation Tips
Skills evaluated in this interview
Interview Questionnaire
1 Question
- Q1. What is a power bi
- Ans.
Power BI is a business analytics tool that provides interactive visualizations and business intelligence capabilities.
Power BI is a Microsoft product used for data analysis and visualization.
It allows users to connect to various data sources and create interactive reports and dashboards.
Power BI provides a wide range of visualizations, such as charts, maps, and tables, to represent data.
Users can create custom calculat...
Skills evaluated in this interview
Interview Questionnaire
4 Questions
- Q1. How many types of subscription in power BI report reserver
- Ans.
There are two types of subscriptions in Power BI Report Server.
The two types of subscriptions are Power BI Report Server Standard and Power BI Report Server Enterprise.
The Standard subscription allows for a single server deployment, while the Enterprise subscription allows for a distributed deployment.
The Enterprise subscription also includes additional features such as high availability and disaster recovery.
Both subs...
- Q2. Email subscription, data driven subscription
- Q3. Why are you using Sql server agent ?
- Ans.
Sql server agent is used for scheduling and automating tasks in SQL Server.
Automates routine tasks like backups, index maintenance, etc.
Allows scheduling of jobs to run at specific times or intervals.
Provides alerts and notifications for job failures.
Can be used to execute PowerShell scripts or SSIS packages.
Helps improve database performance and reliability.
- Q4. Before creating the need check the sql server agent running or not if sql server Agent is not running the report schedules will be getting failed.
Skills evaluated in this interview
Interview Questionnaire
1 Question
- Q1. All basic questions in first round and little technical in second round. The interview process is very friendly. No need to worry.
Interview Preparation Tips
Interview Preparation Tips
Selected
I applied via Approached by Company and was interviewed in Jul 2022. There were 2 interview rounds.
(2 Questions)
- Q1. Power bi troubleshooting Visualisation
- Q2. Gateway Dax, sql queries
Interview Preparation Tips
Sql simple queries
Dwh question
(1 Question)
- Q1. Difference between calculated column and measure
- Ans.
Calculated columns are static values calculated at the row level, while measures are dynamic values calculated at the aggregate level.
Calculated columns are stored in the data model and can be used in visuals directly.
Measures are calculated on the fly based on the context of the visualization or report.
Calculated columns are useful for creating new columns based on existing data, while measures are used for aggregatio
gNAP Services Interview FAQs
Tell us how to improve this page.
gNAP Services Interviews By Designations
Interview Questions for Popular Designations
- Senior Power BI Developer Interview Questions
- Power Programmer Interview Questions
- Power Plant Engineer Interview Questions
- MSBI and Power BI Developer Interview Questions
- Backup Administrator Interview Questions
- Power Electronics Engineer Interview Questions
- Power Apps Developer Interview Questions
- Power Plant Manager Interview Questions
- Show more
gNAP Services Power BI Developer Interview Process for Freshers
based on 1 interview
Interview experience
Power BI Developer Interview Questions from Similar Companies
gNAP Services Power BI Developer Reviews and Ratings
based on 8 reviews
Rating in categories
|
Power BI Developer
39
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Cost and Progress Manager
13
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Software Engineer
9
salaries
| ₹0 L/yr - ₹0 L/yr |
|
MIS Executive
7
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Costing Executive
7
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Infosys
Wipro
HCLTech
- Home >
- Interviews >
- gNAP Services Interview Questions >
- gNAP Services Power BI Developer Interview Questions for Fresher
