i
HCLTech
Filter interviews by
I applied via Naukri.com and was interviewed in Feb 2024. There were 2 interview rounds.
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
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
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
I applied via Job Portal
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...
I applied via Naukri.com and was interviewed before Oct 2021. There were 2 interview rounds.
Import model is a Power BI feature that allows you to import data from various sources and create a data model.
Import model is used to create a data model in Power BI.
It allows you to import data from various sources such as Excel, CSV, SQL Server, etc.
You can create relationships between tables, add calculated columns, and measures.
Import model is useful when you have large amounts of data that need to be transformed ...
I applied via Campus Placement and was interviewed before Feb 2021. There were 4 interview rounds.
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 Company Website and was interviewed before Jan 2022. There were 4 interview rounds.
I applied via LinkedIn and was interviewed in Apr 2024. There was 1 interview round.
Star schema is a data warehouse schema where a central fact table is connected to multiple dimension tables. Snowflake schema is a normalized form of star schema.
Star schema consists of a central fact table connected to multiple dimension tables
Snowflake schema is a normalized form of star schema where dimension tables are further normalized into sub-dimension tables
Star schema is denormalized for faster query performa...
Performance of reports can be improved by optimizing queries, reducing data volume, using efficient visuals, and caching data.
Optimize queries by removing unnecessary columns and filters
Reduce data volume by aggregating data at the source or using incremental refresh
Use efficient visuals like matrix instead of tables for large datasets
Cache data to reduce query times for frequently accessed data
Data query is the process of retrieving specific data from a database, while data flow is the movement of data from one point to another.
Data query involves writing SQL queries to extract specific data from a database
Data flow refers to the movement of data from source to destination through various transformations
Data query is used to filter and retrieve relevant data, while data flow ensures data is processed and mov...
Power Query is used to import and transform data within Power BI, while Direct Query allows real-time data access from the data source.
Power Query is used to import and transform data within Power BI before loading it into the data model.
Direct Query allows Power BI to query the data source directly in real-time, without importing the data into the data model.
Power Query is suitable for smaller datasets that can be loa...
RANK assigns a unique rank to each row based on a specified column, while DENSE RANK assigns a unique rank to each distinct row.
RANK function is used to assign a unique rank to each row based on a specified column
DENSE RANK function is used to assign a unique rank to each distinct row, skipping ranks if there are ties
RANK and DENSE RANK are commonly used in SQL queries to rank data based on certain criteria
Calculated column is a static column in a table calculated based on a formula, while Measure is a dynamic calculation based on aggregated data.
Calculated column is created in Power BI using DAX formula and stored in the data model.
Measure is a calculation performed on the fly based on the context of the visualization.
Calculated columns are static and can be used for filtering and sorting, while Measures are dynamic and
I have used complex DAX functions like CALCULATE, FILTER, SUMX, etc. to perform advanced calculations in Power BI.
Used CALCULATE function to apply filters and context changes to calculations
Utilized FILTER function to filter data based on specific conditions
Implemented SUMX function to iterate over a table and perform calculations for each row
CALCULATED function is used in Power BI to create custom calculations based on existing data in a report.
CALCULATED function is used to create custom calculations in DAX (Data Analysis Expressions) language.
It allows users to define complex calculations based on existing data in the report.
CALCULATED function can be used with other DAX functions to perform calculations like aggregations, comparisons, and conditional lo...
Query folding in Power BI is a process where Power BI pushes the data transformation steps back to the data source.
Query folding improves performance by reducing the amount of data loaded into Power BI.
It allows Power BI to leverage the capabilities of the data source for data transformation.
Commonly used with relational databases like SQL Server, Oracle, etc.
Example: When filtering data in Power BI, query folding will...
Types of context refer to the different ways in which data can be analyzed and interpreted in Power BI.
Row context: evaluates calculations row by row
Filter context: applies filters to data before calculations
Query context: used in DAX queries to retrieve data
Relationship context: determines how tables are related
Power BI is a business analytics tool by Microsoft that provides interactive visualizations and business intelligence capabilities.
Power BI is a business analytics tool by Microsoft
It allows users to create interactive visualizations and reports
Users can connect to various data sources to import data
Power BI offers a wide range of data visualization options such as charts, graphs, and maps
Users can share and collaborat
INNER JOIN is used to combine rows from two or more tables based on a related column between them.
Use INNER JOIN to retrieve rows from both tables that have matching values in the specified column
Syntax: SELECT column_name(s) FROM table1 INNER JOIN table2 ON table1.column_name = table2.column_name
Example: SELECT Orders.OrderID, Customers.CustomerName FROM Orders INNER JOIN Customers ON Orders.CustomerID = Customers.Cus
Row level security is a feature in Power BI that restricts data access at the row level based on user roles or criteria.
Row level security limits data access based on user roles or criteria
It ensures that users only see the data they are authorized to access
Row level security can be implemented using DAX expressions in Power BI
Data gateway is a tool that connects on-premises data sources with cloud-based applications.
Data gateway allows for secure transfer of data between on-premises and cloud environments
It acts as a bridge between on-premises data sources and cloud services like Power BI
Data gateway helps in maintaining data security and compliance
Examples of data gateways include Power BI Gateway and Azure Data Gateway
Filters are used to restrict data at the report level, while slicers are interactive visual filters applied to specific visuals.
Filters are applied at the report level and affect all visuals, while slicers are applied to specific visuals only.
Slicers allow users to interactively filter data by selecting values from a list or range.
Filters can be applied to multiple visuals at once, while slicers are applied individuall...
I applied via Naukri.com and was interviewed in Jan 2021. There was 1 interview round.
Power BI provides various types of security to protect data and control access.
Row-level security allows restricting data access based on user roles or filters.
Data encryption ensures that data is securely stored and transmitted.
Azure Active Directory integration enables centralized user authentication and access control.
Power BI service provides access and sharing controls to manage permissions.
Data loss prevention po...
Gauge charts are used to visually represent a single value within a given range.
Gauge charts are commonly used in business dashboards to display key performance indicators (KPIs).
They provide a quick and intuitive way to assess the current status or progress towards a goal.
Gauge charts can be used to show metrics such as sales targets, customer satisfaction scores, or production efficiency.
They are effective in highlig...
Gateway is a tool that allows Power BI to connect to on-premises data sources. Dataflow is a self-service data preparation tool in Power BI.
Gateway enables Power BI to securely access on-premises data sources.
Dataflow allows users to extract, transform, and load data from various sources into Power BI.
Gateway and Dataflow work together to enable data refresh and data preparation in Power BI.
Gateway can be used to conne...
based on 4 interviews
Interview experience
based on 24 reviews
Rating in categories
Software Engineer
23.4k
salaries
| ₹1.9 L/yr - ₹8 L/yr |
Technical Lead
21.5k
salaries
| ₹7 L/yr - ₹27.9 L/yr |
Senior Software Engineer
16k
salaries
| ₹4.5 L/yr - ₹17 L/yr |
Lead Engineer
15.8k
salaries
| ₹4.1 L/yr - ₹14 L/yr |
Analyst
14.7k
salaries
| ₹0.8 L/yr - ₹6.6 L/yr |
TCS
Wipro
Accenture
Cognizant