Filter interviews by
Wjat is ppwer bi and get the dax
Top trending discussions
posted on 17 Jan 2025
posted on 31 May 2024
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
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...
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
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 Naukri.com
based on 1 interview
Interview experience
Associate
602
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Associate
481
salaries
| ₹0 L/yr - ₹0 L/yr |
Programmer Analyst
297
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer
243
salaries
| ₹0 L/yr - ₹0 L/yr |
Manager
212
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Infosys
Wipro
HCLTech