AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
techmax technologies Interview Questions and Answers
techmax technologies Interview Experiences
2 interviews found
Selected
I applied via LinkedIn and was interviewed in May 2024. There were 2 interview rounds.
Sequence No Questions
Power Bi Fundementals
Power BI Developer Interview Questions asked at other Companies
I applied via Indeed and was interviewed in Nov 2022. There were 3 interview rounds.
We had a bunch of questions with the manager and I was selected to round two which was more technical.
(5 Questions)
- Q1. I had a technical round on SQL. and Power BI Measure.
- Q2. Find the 3rd highest salary for a group of people.
- Q3. What is coalesce function
- Ans.
Coalesce function returns the first non-null value from a list of values.
Coalesce function is used in SQL and other programming languages.
It takes two or more arguments and returns the first non-null value.
If all arguments are null, it returns null.
Example: COALESCE(NULL, 'hello', NULL, 'world') returns 'hello'.
- Q4. Difference between slicer and filter pane in powerbi desktop
- Ans.
Slicer and filter pane are both used to filter data in Power BI, but slicers are visual while filter pane is a list.
Slicers are visual elements that allow users to filter data by selecting options from a dropdown list or a range slider.
Filter pane is a list of filters that can be applied to a report or a visual, and it allows users to filter data by selecting options from a list or typing in a search box.
Slicers are mo...
- Q5. Difference between iterators and aggregator function in dax
- Ans.
Iterators are used to iterate over a table or column, while aggregator functions perform calculations on a set of values.
Iterators include functions like FILTER, SUMX, and AVERAGEX.
Aggregator functions include functions like SUM, AVERAGE, and COUNT.
Iterators are used to perform calculations on a row-by-row basis, while aggregator functions perform calculations on a set of values.
Iterators can be used to filter data bef...
Interview Preparation Tips
Skills evaluated in this interview
Power BI Developer Interview Questions asked at other Companies
Interview questions from similar companies
Power BI Developer Interview Questions & Answers
Persistent Systems
sagar nimje
posted on 17 Jan 2025
(2 Questions)
- Q1. Connectivity mode
- Q2. RLS
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
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. 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 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
Vedant Sugandh
(2 Questions)
- Q1. ROW LEVEL SECURITY
- Q2. SUM, SUMIF SUMIFS AND DELETE TRUNCATE
Selected
I applied via Naukri.com and was interviewed in Feb 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Difference Between direct query mode and import mode
- Ans.
Direct query mode connects to data source in real-time, while import mode loads data into Power BI for faster analysis.
Direct query mode connects to data source in real-time, providing up-to-date data
Import mode loads data into Power BI for faster analysis, but may not always reflect real-time changes
Direct query mode is suitable for large datasets that require real-time updates
Import mode is suitable for smaller datas
- Q2. Define powerBI in layman poin of view
- Ans.
PowerBI is a data visualization tool that helps users analyze and visualize data to make informed business decisions.
PowerBI helps in creating interactive reports and dashboards
It allows users to connect to various data sources like Excel, SQL databases, and cloud services
Users can create custom visualizations and share insights with others
PowerBI can be used for data exploration, data modeling, and data storytelling
(1 Question)
- Q1. How the end user access the report
- Ans.
End users can access the report through Power BI Service, Power BI Mobile App, or embedded in other applications.
End users can access the report through Power BI Service by logging in with their credentials
End users can also access the report through Power BI Mobile App on their smartphones or tablets
Reports can be embedded in other applications using Power BI Embedded feature
Interview Preparation Tips
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
techmax technologies Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
techmax technologies Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
techmax technologies Reviews and Ratings
based on 6 reviews
Rating in categories
|
Power BI Developer
4
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
BI Developer
3
salaries
| ₹0 L/yr - ₹0 L/yr |
Infosys
TCS
Wipro
HCLTech
- Home >
- Interviews >
- techmax technologies Interview Questions
