Cognizant Power BI Developer Interview Questions and Answers for Freshers

ABC Corporation is a multinational technology company specializing in software development and data analytics.

• ABC Corporation is known for its expertise in Power BI development.

• The company has a global presence with offices in multiple countries.

• ABC Corporation offers a wide range of software solutions for various industries.

• They have a strong focus on data analytics and provide advanced reporting and visualization too...read more

The current CTC and expected CTC are personal financial details and should not be disclosed in an interview.

• It is not appropriate to discuss personal financial details in an interview.

• Salary negotiations should be done after receiving a job offer.

• Focus on discussing your skills, experience, and qualifications for the Power BI Developer role.

Row Level Security is a feature in Power BI that allows you to restrict data access at the row level based on user roles and filters.

• Row Level Security (RLS) is used to control data access in Power BI based on user roles and filters.

• It allows you to define rules that determine which rows of data a user can see.

• RLS can be applied to tables or views in the data model.

• It is commonly used to restrict access to sensitive or...read more

SUM calculates the sum of a column or expression, while SUMX calculates the sum of an expression over a table.

• SUM is used to calculate the sum of a column or expression in Power BI.

• SUMX is used to calculate the sum of an expression over a table in Power BI.

• SUM is typically used with a column reference, while SUMX is used with an expression.

• SUMX can be used to perform calculations on filtered or modified data.

• Example: S...read more

Calculated columns are computed during data loading, while measures are computed on the fly during data visualization.

• Calculated columns are created in the data model and stored in the underlying table.

• Measures are created using DAX expressions and are calculated dynamically based on the context of the visualization.

• Calculated columns consume memory and can impact performance, while measures are more efficient.

• Calculat...read more

The last working day of the company is the day on which an employee's employment ends.

• The last working day is typically determined by the company's policies and the employee's contract.

• It may be different for each employee depending on their notice period or reason for leaving.

• The last working day is usually communicated to the employee through an official letter or email.

• On the last working day, the employee may be re...read more

There are multiple types of filters in Power BI including visual, page, report, and drill-through filters.

• Visual filters apply to a specific visual or group of visuals.

• Page filters apply to all visuals on a specific page.

• Report filters apply to all visuals on all pages of a report.

• Drill-through filters allow users to navigate to a different report page based on a selected data point.

The three filters can be applied to the data in Power BI to narrow down the results.

• Filters can be applied to specific columns or measures in the data

• Filters can be used to show only certain values or ranges of values

• Filters can be combined to create more complex filtering logic

There are three connectivity modes in Power BI: Import, DirectQuery, and Live Connection.

• Import mode: Data is imported into Power BI and stored in a dataset.

• DirectQuery mode: Data stays in the data source and queries are sent directly to the source.

• Live Connection mode: Power BI connects directly to the data source for real-time data access.

The current company is XYZ Corporation.

• The current company is XYZ Corporation.

• XYZ Corporation is a multinational technology company.

• XYZ Corporation specializes in software development and data analytics.

• XYZ Corporation has a strong presence in the Power BI industry.

I work remotely from my home office.

• I work from a dedicated home office space.

• I have all the necessary equipment and tools to work remotely.

• I communicate with my team and clients through online collaboration tools.

• I am available for meetings and discussions via video conferencing.

• I maintain a productive work environment at home.

I have 5 years of experience as a Power BI Developer.

• Developed interactive dashboards and reports using Power BI

• Created data models and performed data analysis

• Worked with various data sources such as SQL Server, Excel, and SharePoint

• Implemented data transformations and data cleansing

• Collaborated with business stakeholders to gather requirements and provide insights

• Optimized performance and improved data visualization

• Tr...read more

I have recently worked as a Power BI Developer, creating interactive dashboards and reports.

• Developed interactive dashboards and reports using Power BI

• Gathered requirements from stakeholders and translated them into data visualizations

• Created data models and implemented data transformations

• Collaborated with cross-functional teams to ensure data accuracy and consistency

• Provided training and support to end-users for effe