GWC Logistics
IBN Herbals Interview Questions and Answers
Q1. Why we go for power bi instead of excel
Power BI offers more advanced data visualization and analysis capabilities compared to Excel.
Power BI allows for interactive and dynamic data visualization, making it easier to identify trends and patterns.
Power BI can handle larger datasets more efficiently than Excel.
Power BI offers more advanced data modeling and transformation capabilities.
Power BI allows for easy sharing and collaboration on reports and dashboards.
Power BI integrates with a wide range of data sources, ma...read more
Q2. What is parameter in power bi?
Parameters in Power BI are values that can be passed to queries, filters, or functions to customize data analysis.
Parameters can be used to filter data based on specific criteria.
They can also be used to dynamically change calculations or visualizations.
Parameters can be defined in Power Query Editor or in DAX formulas.
Examples include using parameters to filter data by date range or product category.
Q3. What is dax function?
DAX (Data Analysis Expressions) is a collection of functions, operators, and constants that can be used in Power BI, Excel, and other data analysis tools.
DAX functions are used to create custom calculations in Power BI and Excel.
DAX functions can be used for tasks like filtering, aggregating, and manipulating data.
Examples of DAX functions include SUM, AVERAGE, CALCULATE, and RELATED.
Q4. What is data modelling?
Data modelling is the process of creating a visual representation of data relationships and patterns.
Data modelling involves identifying and defining the relationships between different data elements.
It helps in organizing and structuring data in a way that is easy to understand and analyze.
Common techniques used in data modelling include entity-relationship diagrams, UML diagrams, and data flow diagrams.
Data modelling is essential for database design, data warehousing, and b...read more
Q5. Types of data connectivity mode?
Types of data connectivity modes include direct, gateway, and hybrid connections.
Direct connectivity mode involves connecting directly to the data source without any intermediary
Gateway connectivity mode uses a gateway to securely connect to on-premises data sources from cloud services
Hybrid connectivity mode combines elements of both direct and gateway connections for flexibility and security
Q6. Drop vs truncate
Drop deletes all rows from a table, while truncate removes all rows and resets auto-increment values.
Drop is a DDL command, while truncate is a DML command.
Drop is slower as it logs individual row deletions, while truncate is faster as it deallocates data pages.
Drop can be rolled back, while truncate cannot be rolled back.
Example: DROP TABLE table_name; TRUNCATE TABLE table_name;
Top Data Analyst Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month
Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.
