Filter interviews by
I applied via Walk-in and was interviewed in Jul 2024. There was 1 interview round.
I applied via Company Website and was interviewed in Aug 2022. There was 1 interview round.
Measures are calculations based on aggregated data, while columns are static data columns.
Measures are dynamic and change based on filters and slicers
Columns are static and do not change based on filters and slicers
Measures are used for calculations such as sums, averages, and ratios
Columns are used for storing data such as names, dates, and numbers
Top trending discussions
posted on 31 May 2024
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
posted on 29 Jun 2024
posted on 14 Oct 2023
I was interviewed before Oct 2022.
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...
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;
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...
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...
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.
I applied via Approached by Company and was interviewed in Jul 2022. There were 2 interview rounds.
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Desktop Support Engineer
235
salaries
| ₹0 L/yr - ₹0 L/yr |
Network Support Engineer
172
salaries
| ₹0 L/yr - ₹0 L/yr |
Network Engineer
152
salaries
| ₹0 L/yr - ₹0 L/yr |
Technical Support Engineer
80
salaries
| ₹0 L/yr - ₹0 L/yr |
System Administrator
76
salaries
| ₹0 L/yr - ₹0 L/yr |
Wipro
TCS
HCLTech
Tech Mahindra