i
Celebal Technologies
Filter interviews by
Clear (1)
Append in Power Query is used to combine multiple tables or queries into a single table or query.
Append is used to stack tables on top of each other, adding rows from one table to the end of another.
It is useful when you have multiple tables with the same structure and want to combine them into one.
You can append tables from different data sources or within the same data source.
For example, you can append sales data fr...
Merge in Power Query combines multiple tables into one by matching rows based on specified columns.
Merge is used to combine tables in Power Query
You can merge based on one or more columns
Different types of merges include inner, left outer, right outer, and full outer joins
Filter context determines which rows of data are visible to calculations in DAX formulas.
Filter context is dynamic and changes based on user interactions.
It can be set by slicers, filters, or relationships between tables.
Filter context is used to calculate results based on the current filter selections.
It helps in determining which rows of data are included in calculations.
Summarize function is used in Power BI to aggregate data based on specified columns.
Used to group data and perform aggregate functions like sum, count, average, etc.
Can be used in DAX formulas to create calculated columns or measures.
Example: SUMMARIZE('Table', 'Column1', 'Column2', SUM('Value'))
Aptitude consists of apti,reasoning, sql and power bi questions, some verbal questions too.
Top trending discussions
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...
Normalization is a database design technique that organizes data in a structured manner to eliminate redundancy and improve data integrity.
Normalization helps in reducing data redundancy by breaking down a large table into smaller, more manageable tables.
There are different normal forms, such as 1NF, 2NF, 3NF, BCNF, and 4NF, each with specific rules and dependencies.
Normalization ensures data integrity by minimizing da...
I applied via Naukri.com
I applied via Company Website and was interviewed in Jun 2022. There were 2 interview rounds.
I was interviewed in Jul 2024.
Brief information about Business Intelligence (BI) tools.
Power BI plays a crucial role in today's market by enabling organizations to visualize and analyze their data for better decision-making.
Power BI allows businesses to create interactive reports and dashboards for data visualization.
It helps in analyzing data trends, identifying patterns, and making informed decisions.
Power BI integrates with various data sources, making it easier to consolidate and analyze data from mu...
Power BI is a Microsoft business analytics tool while Tableau is a data visualization tool.
Power BI is a Microsoft product while Tableau is developed by Tableau Software.
Power BI is more user-friendly for users familiar with Microsoft products.
Tableau has more advanced visualization capabilities compared to Power BI.
Power BI integrates well with other Microsoft products like Excel and Azure, while Tableau has more flex...
Power BI has been used in various industries for data visualization and analysis.
Retail industry: analyzing sales data to identify trends and optimize inventory
Finance sector: creating interactive dashboards for financial reporting and analysis
Healthcare sector: tracking patient outcomes and hospital performance metrics
Manufacturing industry: monitoring production efficiency and supply chain management
My salary expectations are in line with industry standards for a Power BI Developer with my level of experience.
I have researched the average salary range for Power BI Developers in this location
I am looking for a competitive salary that reflects my skills and experience
I am open to negotiation based on the overall compensation package offered
I applied via LinkedIn and was interviewed in Aug 2023. There was 1 interview round.
based on 2 interviews
Interview experience
based on 4 reviews
Rating in categories
Data Engineer
381
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate
250
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Consultant
158
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Data Engineer
158
salaries
| ₹0 L/yr - ₹0 L/yr |
Data Scientist
123
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Infosys
Wipro
HCLTech