Business Analytics & AI Interview Questions — Flashcards | inGrade

Question 1

What is Tableau, and why is it used?

Accepted Answer

Tableau is a powerful data visualization tool that enables users to connect, analyze, and visualize data. Its user-friendly drag-and-drop interface allows even non-technical users to create interactive dashboards and gain insights from data. It is widely used for simplifying raw data analysis, creating real-time interactive dashboards, and supporting diverse data sources like Excel, SQL, and Cloud.

Question 2

What is Power BI?

Accepted Answer

Power BI is a business analytics tool by Microsoft that allows users to visualize data, share insights, and collaborate on interactive dashboards. It connects to multiple data sources, performs transformations, and provides advanced reporting capabilities. Key components include Power BI Desktop, Power BI Service, Power BI Mobile, Power Query, and Power Pivot.

Question 3

What is DAX, and why is it important in Power BI?

Accepted Answer

DAX (Data Analysis Expressions) is a formula language used in Power BI for creating calculated columns, measures, and custom aggregations. It provides advanced analytics capabilities, enabling users to extract meaningful insights. It is different from M language, which is used in Power Query for data transformation.

Question 4

What are LOD (Level of Detail) expressions in Tableau?

Accepted Answer

LOD expressions allow you to control the granularity of aggregations in calculations, independent of the view's level of detail. There are three types: FIXED (calculates at a specified level, independent of the visualization), INCLUDE (adds dimensions to the current view level), and EXCLUDE (removes dimensions from the current view level).

Question 5

What is the difference between Live and Extract connections in Tableau?

Accepted Answer

Live Connection provides real-time data fetch from the source — slower but reflects updates immediately. Extract Connection is a static data snapshot stored in .hyper files — faster but requires periodic updates. Extracts are useful for offline access and performance optimization.

Question 6

What is the difference between Import and Direct Query in Power BI?

Accepted Answer

Import mode loads data into Power BI, offering faster performance but larger file sizes. Direct Query connects live to the data source, ensuring real-time updates but slower performance. Direct Query is ideal when the dataset is too large to fit into memory or requires real-time updates.

Question 7

What is data storytelling in data visualization?

Accepted Answer

Data storytelling is the process of combining data, visuals, and narrative to convey insights effectively. It transforms raw data into actionable stories by identifying trends, patterns, or anomalies. The three key components are Data (accurate, relevant information), Visuals (clear charts and dashboards), and Narrative (context and interpretation).

Question 8

What are the key principles of effective data visualization?

Accepted Answer

The key principles are: Clarity (ensure the visualization communicates the intended message clearly), Simplicity (avoid unnecessary complexity), Relevance (focus on the most critical data points), and Accuracy (represent data truthfully without distortion). Choosing the right chart type based on data type, purpose, and audience is also essential.

Question 9

What is trend analysis, and why is it essential?

Accepted Answer

Trend analysis is the process of examining historical data to identify patterns or movements over time. It is essential for predicting future outcomes, identifying seasonality, and supporting strategic decisions. Tools like Tableau, Power BI, and Python libraries are widely used for visualizing trends through interactive dashboards and time-series analysis.

Question 10

What is the CALCULATE function in DAX?

Accepted Answer

CALCULATE modifies the context in which data is evaluated. For example: CALCULATE(SUM(Sales[Amount]), Region[Name] = 'North') calculates the total sales for the North region. It is one of the most powerful functions in DAX, allowing you to override filter context and perform complex calculations.

Start your learning journey today