Data Analytics

𝗧𝗢𝗣 𝟱 𝗙𝗥𝗘𝗘 𝗧𝗘𝗖𝗛 𝗖𝗢𝗨𝗥𝗦𝗘𝗦 𝗜 𝗪𝗜𝗦𝗛 𝗜 𝗛𝗔𝗗 𝗧𝗔𝗞𝗘𝗡 𝗦𝗢𝗢𝗡𝗘𝗥! 💻🎓 Discover 5 FREE tech courses to kick-start your learning journey and strengthen your resume. 🚀 ✅ Learn Valuable Technical Skills ✅ Beginner-Friendly Learning Resources ✅ Build Practical Knowledge ✅ Strengthen Your Resume & Portfolio ✅ Prepare for Tech Career Opportunities 💡 The best investment you can make in 2026 is upgrading your skills! 🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇 :- https://pdlink.in/4Bw1PL9 ⚡ Start learning today. Your future self will thank you!

🔟 A stakeholder says the YoY growth shown in Power BI is incorrect. How would you investigate? Sample Answer: I would not immediately assume that the DAX formula is wrong. I would investigate systematically: First, verify the current-year and previous-year sales values. Then check the Date table and relationships. Next, verify whether the report filters are affecting the calculation. I would also check whether the business definition of sales has changed, such as excluding cancelled transactions or returns. Finally, I would reconcile the Power BI result with the source data or another trusted report. The goal is to determine whether the issue is caused by DAX, data, filters, relationships, or business logic. 📌 Double Tap ❤️ For More

📊 Data Analyst Interview Series — Part 15 Guys, let's continue our Data Analyst Interview Series. In this part, let's focus on Power BI Time Intelligence and practical DAX questions that are commonly asked in Data Analyst interviews. 1️⃣ What is time intelligence in Power BI? Sample Answer: Time intelligence refers to DAX calculations that allow us to analyze data across different time periods. For example, we can calculate: • Year-to-date sales • Month-to-date sales • Previous year sales • Year-over-year growth • Previous month sales • Running totals Time intelligence is useful for comparing business performance over time. 2️⃣ How do you calculate Year-to-Date (YTD) sales? Sample Answer: I would first create a Total Sales measure: Total Sales = SUM(Sales[SalesAmount]) Then I can calculate YTD Sales using: YTD Sales = TOTALYTD( [Total Sales], 'Date'[Date] ) This calculates sales accumulated from the beginning of the year up to the current date in the report context. 3️⃣ How do you calculate previous year's sales? Sample Answer: I can use the SAMEPERIODLASTYEAR function. Previous Year Sales = CALCULATE( [Total Sales], SAMEPERIODLASTYEAR('Date'[Date]) ) This allows me to compare the current period's sales with the corresponding period from the previous year. 4️⃣ How do you calculate Year-over-Year growth? Sample Answer: First, I calculate the previous year's sales: Previous Year Sales = CALCULATE( [Total Sales], SAMEPERIODLASTYEAR('Date'[Date]) ) Then I calculate the percentage growth: YoY Growth % = DIVIDE( [Total Sales] - [Previous Year Sales], [Previous Year Sales], 0 ) This tells me how much sales increased or decreased compared with the previous year. 5️⃣ Why do we need a Date table in Power BI? Sample Answer: A proper Date table provides a consistent calendar structure for time-based analysis. It can contain: • Date • Year • Quarter • Month • Month Number • Week • Day A Date table is especially important when creating time-intelligence calculations such as YTD, previous year, and year-over-year comparisons. 6️⃣ What is the difference between DATEADD and SAMEPERIODLASTYEAR? Sample Answer: Both can be used for comparing different time periods, but they work differently. SAMEPERIODLASTYEAR shifts the current date context exactly one year backward. DATEADD allows us to shift the date context by a specified number of intervals such as: • Day • Month • Quarter • Year For example: Previous Month Sales = CALCULATE( [Total Sales], DATEADD('Date'[Date], -1, MONTH) ) I would choose the function based on the type of time comparison required. 7️⃣ How would you calculate Month-over-Month growth? Sample Answer: First, I calculate previous month's sales: Previous Month Sales = CALCULATE( [Total Sales], DATEADD('Date'[Date], -1, MONTH) ) Then: MoM Growth % = DIVIDE( [Total Sales] - [Previous Month Sales], [Previous Month Sales], 0 ) This helps identify whether sales increased or decreased compared with the previous month. 8️⃣ How would you create a running total in Power BI? Sample Answer: A running total calculates the cumulative value up to the current date. For example: Running Total = CALCULATE( [Total Sales], FILTER( ALL('Date'[Date]), 'Date'[Date] <= MAX('Date'[Date]) ) ) This can be used to display cumulative sales throughout the year. 9️⃣ What would you do if a time-intelligence calculation gives incorrect results? Sample Answer: I would first check the Date table and model rather than immediately changing the DAX formula. I would verify: • A proper Date table exists. • Dates are unique in the Date table. • The Date table covers the required period. • The relationship between Date and fact table is correct. • The Date column has the correct data type. • The Date table is marked as a Date table when appropriate. • Filters are behaving as expected.

𝗠𝗔𝗦𝗧𝗘𝗥 𝗦𝗤𝗟 𝗙𝗢𝗥 𝗙𝗥𝗘𝗘 𝗜𝗡 𝟮𝟬𝟮𝟲 📊 🔥 Essential Skill for Data Analytics 🔥 Useful for Data Science & Backend Development 🔥 Practice Real-World Database Queries 🔥 Strengthen Your Technical Interview Skills 🎯 Perfect For:- Students | Freshers | Job Seekers | Working Professionals 🔗 𝗘𝘅𝗽𝗹𝗼𝗿𝗲 𝗔𝗟𝗟 𝟱 𝗙𝗥𝗘𝗘 𝗦𝗤𝗟 𝗪𝗲𝗯𝘀𝗶𝘁𝗲𝘀 👇:- https://pdlink.in/4yOlWlh 📌 SAVE this post & SHARE it with friends preparing for tech careers!

🚀𝗠𝗔𝗦𝗧𝗘𝗥 𝗘𝗫𝗖𝗘𝗟 𝗙𝗢𝗥 𝗙𝗥𝗘𝗘 𝗜𝗡 𝟮𝟬𝟮𝟲! 📊 Discover 4 FREE Websites to learn Microsoft Excel from beginner to advanced level! 🎓 🔥 FREE Learning Resources 🔥 Beginner to Advanced Tutorials 🔥 Practical Examples & Exercises 🔥 Learn Anytime, Anywhere 🔗 𝗟𝗶𝗻𝗸👇:- https://pdlink.in/4jDfcCP ⚡ One powerful skill can open doors to multiple career opportunities!

9️⃣ What is DIVIDE and why would you use it instead of "/"? Sample Answer: DIVIDE is a DAX function used for division and allows us to safely handle situations where the denominator is zero or blank. For example: Profit Margin = DIVIDE( [Total Profit], [Total Sales], 0 ) If Total Sales is zero, the expression returns 0 instead of producing a division-by-zero error. This makes DIVIDE a safer choice for business calculations. 🔟 How would you explain context transition in an interview? Sample Answer: Context transition happens when CALCULATE converts the current row context into filter context. It is particularly important when CALCULATE is used inside an iterator or when working with calculated columns. For example, if I use CALCULATE inside an iterator such as SUMX, the current row can influence the filter context used by the calculation. 📌 Double Tap ❤️ For More

📊 Data Analyst Interview Series — Part 14 In the previous part, we covered Power BI fundamentals. Now let's focus on one of the most important areas in Power BI interviews: 📊 DAX & Context in Power BI 1️⃣ What is DAX and why is it important? Sample Answer: DAX stands for Data Analysis Expressions. It is the formula language used in Power BI to create measures, calculated columns, and calculated tables. DAX is important because it allows us to create business calculations that go beyond simple aggregations. For example: Total Sales = SUM(Sales[SalesAmount]) I can then use this measure in different visuals and Power BI will automatically recalculate it based on filters and selections. 2️⃣ What is filter context in DAX? Sample Answer: Filter context refers to the filters that affect how a DAX calculation is evaluated. For example, if I have a Total Sales measure and select: Region = South Year = 2026 Power BI calculates Total Sales only for records matching those filters. This is why the same measure can return different results depending on the filters applied to a report. 3️⃣ What is row context? Sample Answer: Row context means that DAX evaluates an expression for the current row. It is commonly encountered when working with calculated columns. For example: Profit = Sales[Revenue] - Sales[Cost] Power BI evaluates this calculation separately for each row in the Sales table. A simple way to remember: Row context → Current row Filter context → Current set of filtered data 4️⃣ What is the difference between a measure and a calculated column? Sample Answer: A calculated column is calculated for every row and stored in the model, while a measure is calculated dynamically when it is used in a visual. For example: Calculated column: Profit = Sales[Revenue] - Sales[Cost] Measure: Total Profit = SUM(Sales[Profit]) For aggregations and KPIs, I generally prefer measures because they respond dynamically to filters. 5️⃣ What is CALCULATE in DAX? Sample Answer: CALCULATE is one of the most important DAX functions because it evaluates an expression after modifying the filter context. For example: Sales for India = CALCULATE( [Total Sales], Customers[Country] = "India" ) This calculates Total Sales specifically for customers from India. CALCULATE is heavily used in advanced DAX calculations. 6️⃣ What is the difference between SUM and SUMX? Sample Answer: SUM simply adds values from a single column. Example: Total Sales = SUM(Sales[SalesAmount]) SUMX is an iterator. It evaluates an expression row by row and then adds the results. Example: Total Revenue = SUMX( Sales, Sales[Quantity] * Sales[UnitPrice] ) I would use SUM when the required values already exist in a column, and SUMX when I need to perform a calculation for each row before aggregating. 7️⃣ What is the difference between ALL and ALLSELECTED? Sample Answer: ALL removes filters from the specified table or column. For example, it can be used to calculate a value against the overall total. ALLSELECTED generally preserves the filters selected by the user while removing some visual-level filtering. This is particularly useful when calculating percentages or rankings within the user's selected report context. For example, if a user selects 2026, ALLSELECTED can help calculate values relative to the selected 2026 data rather than ignoring the user's selection completely. 8️⃣ How do you calculate percentage of total sales in Power BI? Sample Answer: First, I create a Total Sales measure: Total Sales = SUM(Sales[SalesAmount]) Then I can calculate percentage of total: Sales % = DIVIDE( [Total Sales], CALCULATE( [Total Sales], ALL(Sales) ), 0 ) This allows me to compare the current filtered sales against the overall sales total. 9️⃣ What is DIVIDE and why would you use it instead of "/"? Sample Answer:

9️⃣ What is the difference between a calculated column and a measure? Sample Answer: A few DAX formulas in your example need syntax corrections. Here’s a polished version: A calculated column is evaluated row by row and stored in the model. A measure is evaluated dynamically based on the report’s filter context. For example, a calculated column could be:

Profit = Sales[Revenue] - Sales[Cost]

A measure could be:

Total Sales = SUM(Sales[SalesAmount])

I generally prefer measures for aggregations and KPI calculations because they respond dynamically to report filters. 🔟 What is DAX in Power BI? Sample Answer: DAX stands for Data Analysis Expressions. It is the formula language used in Power BI to create measures, calculated columns, and calculated tables. For example:

Total Sales = SUM(Sales[SalesAmount])

Another example:

Profit Margin =
DIVIDE([Total Profit], [Total Sales], 0)

DAX is especially useful for business calculations such as KPIs, percentages, rankings, time intelligence, and comparisons. 📌 Double tap ❤️ for more.

📊 Data Analyst Interview Series — Part 13 📊 Power BI Interview Questions Part 13 — Power BI Fundamentals 1️⃣ What is Power BI and why is it used? Sample Answer: Power BI is a business intelligence and data visualization tool from Microsoft. It helps analysts connect to different data sources, clean and transform data, create data models, build interactive reports and dashboards, and share insights with stakeholders. For example, I can connect Power BI to SQL Server, Excel, or CSV files, transform the data using Power Query, create a data model, write DAX measures, and build an interactive sales dashboard. 2️⃣ What are the main components of Power BI? Sample Answer: The major components I commonly work with are: • Power BI Desktop — Build reports and data models. • Power BI Service — Publish, share, and manage reports online. • Power BI Mobile — View reports on mobile devices. • Power Query — Connect, clean, and transform data. • DAX — Create calculations and measures. • On-premises Data Gateway — Connect Power BI Service to on-premises data sources. Together, these components support the complete reporting and analytics process. 3️⃣ What is the difference between Power BI Desktop and Power BI Service? Sample Answer: Power BI Desktop is mainly used for developing reports and data models, while Power BI Service is a cloud-based platform used to publish, share, collaborate, and manage those reports. For example: Power BI Desktop → Build the report → Publish → Power BI Service → Share with users. 4️⃣ What is Power Query in Power BI? Sample Answer: Power Query is used for extracting, cleaning, and transforming data before loading it into the Power BI model. For example, I can use Power Query to: • Remove duplicates • Handle missing values • Change data types • Split columns • Merge datasets • Append datasets • Filter records • Create calculated transformation columns Power Query is essentially used for the ETL part of the process. 5️⃣ What is the difference between Power Query and DAX? Sample Answer: Power Query is primarily used to prepare and transform data before it enters the model, whereas DAX is used to create calculations within the Power BI model. For example: Power Query → Remove duplicates, merge tables, clean customer names. DAX → Calculate Total Sales, Profit Margin, Year-over-Year Growth. A simple way to remember it is: Power Query = Data preparation DAX = Data analysis and calculations 6️⃣ What is a data model in Power BI? Sample Answer: A data model defines how different tables are structured and connected within Power BI. For example, I might have: Sales Customers Products Date The Sales table can be connected to Customers, Products, and Date using relationships. A well-designed data model makes reporting more accurate, easier to maintain, and more efficient. 7️⃣ What is a relationship in Power BI? Sample Answer: A relationship connects two tables using a common column. For example: Customers ↓ Sales[CustomerID] This allows Power BI to understand which sales transactions belong to which customers. Common relationship types include: • One-to-many • Many-to-one • One-to-one • Many-to-many In most analytical models, one-to-many relationships are commonly used. 8️⃣ What is a star schema and why is it important? Sample Answer: A star schema is a data modeling approach where a central fact table is connected to multiple dimension tables. For example: FactSales → DimCustomer → DimProduct → DimDate → DimRegion The fact table contains measurable business transactions, while dimension tables provide descriptive information. I prefer a star schema because it makes the model easier to understand, improves filtering behavior, and generally supports better reporting performance. 9️⃣ What is the difference between a calculated column and a measure? Sample Answer:

𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 & 𝗠𝗮𝗰𝗵𝗶𝗻𝗲 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗙𝗥𝗘𝗘 𝗢𝗻𝗹𝗶𝗻𝗲 𝗠𝗮𝘀𝘁𝗲𝗿𝗰𝗹𝗮𝘀𝘀 📊 Build a strong foundation in Data Science .Explore Machine Learning and Deep Learning Eligibility :- Students • Freshers • Working Professionals 📅 Date:- 23 October 2026 ⏰ Time:- 7:00 PM–9:00 PM IST 💻 Mode:- Online 🔗 𝗥𝗲𝗴𝗶𝘀𝘁𝗲𝗿 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇 :- https://pdlink.in/4i8MKGn 📢 Share this opportunity with your friends and classmates.

𝗠𝗜𝗖𝗥𝗢𝗦𝗢𝗙𝗧 𝗙𝗥𝗘𝗘 𝗗𝗔𝗧𝗔 𝗦𝗖𝗜𝗘𝗡𝗖𝗘 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦 𝟮𝟬𝟮𝟲! 🎓 Microsoft offers valuable FREE learning resources to help you develop in-demand technical skills! 💻 ✅ 100% FREE Learning Resources ✅ Beginner-Friendly Tutorials ✅ Self-Paced Learning ✅ Practical Skills for Real-World Projects ✅ Useful for Data Analytics & Data Science Career Preparation 🔗 𝗔𝗰𝗰𝗲𝘀𝘀 𝗔𝗟𝗟 𝟰 𝗙𝗥𝗘𝗘 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀 👇:- https://pdlink.in/4k6ylNq ⚡ Your Data Science journey can start today — completely FREE!

Double Tap ❤️ For More Useful Shortcuts

The denominator ignores the Product filter while retaining other relevant filters.” 4️⃣ What is the difference between calculated columns, measures, and calculated tables? Sample Answer: “A calculated column creates a value for every row and is stored in the model. A measure is calculated dynamically based on the current filter context and is generally preferred for aggregations and KPIs. A calculated table creates a new table using DAX. For example: Calculated column → Profit for each transaction Measure → Total Profit Calculated table → A DAX-generated table used for a specific modeling requirement.” 5️⃣ What is cardinality in Power BI relationships? Sample Answer: “Cardinality describes how records in one table relate to records in another table. Common relationship types include: • One-to-many • Many-to-one • One-to-one • Many-to-many In a typical star schema, a dimension table has unique keys and the fact table contains repeated keys, resulting in a one-to-many relationship from the dimension to the fact table.” 6️⃣ What is the difference between a single-direction and bidirectional relationship? Sample Answer: “In a single-direction relationship, filters generally flow from one table to another in the defined direction. In a bidirectional relationship, filters can propagate in both directions. I generally prefer single-direction relationships where possible because they make the model easier to understand and can reduce ambiguity and unexpected filtering behavior. Bidirectional relationships should be used when there is a clear modeling requirement.” 7️⃣ What is a Date table and why is it important? Sample Answer: “A Date table is a dedicated table containing dates and related attributes such as year, quarter, month, week, and day. It is important because consistent time-based analysis and time-intelligence calculations depend on a proper date structure. For example, instead of repeatedly extracting the month and year from a transaction date, I can use fields from a dedicated Date dimension.” 8️⃣ What is the difference between Import mode and DirectQuery? Sample Answer: “In Import mode, data is loaded into Power BI's in-memory model. This generally provides fast report performance, but the data needs to be refreshed. In DirectQuery, Power BI sends queries to the underlying data source when users interact with the report. This can allow access to more current data without importing the entire dataset, but performance depends heavily on the source system and query design. The choice depends on factors such as data volume, freshness requirements, source performance, and modeling limitations.” 9️⃣ What is a many-to-many relationship, and why can it be problematic? Sample Answer: “A many-to-many relationship occurs when multiple records in one table can relate to multiple records in another table. It can be useful in certain business scenarios, but it can also introduce ambiguous filter paths and unexpected results if the model isn't designed carefully. Where possible, I would look for a cleaner model, such as using a bridge table, to represent the many-to-many relationship explicitly.” 🔟 How would you calculate the percentage of total sales in Power BI? Sample Answer: “I would create a total sales measure and then calculate the denominator after removing the appropriate product or category filter.”

Total Sales =
SUM(Sales[Sales Amount])

Sales % of Total =
DIVIDE(
    [Total Sales],
    CALCULATE(
        [Total Sales],
        REMOVEFILTERS(Product)
    )
)

“This allows the numerator to respond to the current product context while the denominator represents the overall total across products.” 📌 Double Tap ❤️ For More ----- 1.34 ₽ · /balance_help

📊 Data Analyst Interview Series — Part 12 Let's go deeper into Power BI with 10 important interview questions focused on DAX, relationships, and data modeling. 👇 1️⃣ What is CALCULATE() in DAX? Sample Answer: “CALCULATE() is one of the most important DAX functions. It evaluates an expression after modifying the filter context. For example, if I want to calculate sales only for the India region:

India Sales =
CALCULATE(
    [Total Sales],
    Customer[Country] = "India"
)

CALCULATE() is fundamental for creating conditional and context-aware measures.” 2️⃣ What is the difference between SUM() and SUMX()? Sample Answer: “SUM() adds the values of a single column. SUMX() is an iterator. It evaluates an expression row by row and then sums the results. For example, if revenue needs to be calculated as Quantity multiplied by Price:

Total Revenue =
SUMX(
    Sales,
    Sales[Quantity] * Sales[Price]
)

I would use SUMX when the calculation needs to be performed for each row before aggregation.” 3️⃣ What is the difference between ALL() and REMOVEFILTERS()? Sample Answer: “Both can be used to remove filters in DAX. REMOVEFILTERS() is specifically designed to remove filters and is generally clearer when that is the intended purpose. For example, to calculate a percentage of total sales:

Sales % =
DIVIDE(
    [Total Sales],
    CALCULATE(
        [Total Sales],
        REMOVEFILTERS(Product)
    )
)

𝗧𝗔𝗧𝗔 𝗙𝗥𝗘𝗘 𝗠𝗜𝗖𝗥𝗢-𝗜𝗡𝗧𝗘𝗥𝗡𝗦𝗛𝗜𝗣𝗦 𝟮𝟬𝟮𝟲! 🎓 ✅ 100% FREE Learning Experience ✅ Short Programs — Approximately 4–6 Hours ✅ Practical, Real-World Tasks ✅ Self-Paced & Online ✅ Certificate Opportunities for Your Resume & LinkedIn ✅ No Traditional Interview Process 🔗 𝗘𝘅𝗽𝗹𝗼𝗿𝗲 𝗧𝗔𝗧𝗔 𝗙𝗥𝗘𝗘 𝗠𝗶𝗰𝗿𝗼-𝗜𝗻𝘁𝗲𝗿𝗻𝘀𝗵𝗶𝗽𝘀👇:- https://pdlink.in/4yWgaPn ⚡ Don't wait for your first job to start gaining practical experience!

𝟰 𝗙𝗥𝗘𝗘 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗧𝗼 𝗠𝗮𝘀𝘁𝗲𝗿 𝗖𝗼𝗱𝗶𝗻𝗴 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘😍 ✅ 100% FREE YouTube Learning ✅ Beginner-Friendly Programming Tutorials ✅ Learn Popular & In-Demand Tech Skills ✅ Study at Your Own Pace ✅ Build a Strong Foundation for Coding Interviews 🔗 𝗔𝗰𝗰𝗲𝘀𝘀 𝗔𝗟𝗟 𝟰 𝗙𝗥𝗘𝗘 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 👇:- https://pdlink.in/3WcuMvi ⚡ Your coding journey can start today—completely FREE!

Sales Fact
    ↓
Customer Dimension
Product Dimension
Date Dimension
Region Dimension

The fact table contains measurable business events, while dimensions provide the context for analyzing those events. A well-designed star schema generally makes Power BI models easier to understand and can improve performance.” 9️⃣ What is filter context in Power BI? Sample Answer: “Filter context is the set of filters that determines which data is considered when a DAX measure is evaluated. For example, if I have a Total Sales measure and select ‘India’ in a Region slicer, the measure is evaluated only for the data remaining in that filter context. Understanding filter context is essential for writing effective DAX measures.” 🔟 What is the difference between a report and a dashboard in Power BI? Sample Answer: “A report is generally a multi-page interactive analysis containing visuals, filters, slicers, and detailed information. A dashboard is a single-page view in the Power BI Service that can contain tiles pinned from reports or other sources. Reports are typically used for detailed analysis, while dashboards are often used to provide a high-level overview of important KPIs.” 📌 Double Tap ❤️ For More ----- 1.41 ₽ · /balance_help

📊 Data Analyst Interview Series — Part 11 Guys, let's continue our Data Analyst Interview Series. We have covered SQL and Excel. Now let's start one of the most important tools for Data Analysts — Power BI. 📊 Here are 10 important Power BI interview questions to start with. 👇 1️⃣ What is Power BI? Sample Answer: “Power BI is a business intelligence and data visualization platform from Microsoft. It allows users to connect to different data sources, transform and model data, create interactive reports and dashboards, and share insights with business users. As a Data Analyst, I can use Power BI to turn raw data into interactive reports that help stakeholders understand performance and make decisions.” 2️⃣ What are the main components of Power BI? Sample Answer: “The major components I commonly work with are: • Power BI Desktop — used to connect, transform, model, and visualize data. • Power BI Service — used to publish, share, collaborate, and manage reports and dashboards. • Power Query — used for data extraction and transformation. • DAX — used to create measures, calculated columns, and calculated tables. • Data Model — defines relationships between tables and enables analysis. • Power BI Mobile — allows users to access reports on mobile devices.” 3️⃣ What is Power Query in Power BI? Sample Answer: “Power Query is the data transformation and preparation engine in Power BI. I use it to connect to different data sources and perform transformations such as removing duplicates, handling missing values, changing data types, filtering rows, splitting columns, merging tables, and appending datasets. One major advantage is that the transformation steps are saved and can be reapplied automatically whenever the data is refreshed.” 4️⃣ What is DAX? Sample Answer: “DAX stands for Data Analysis Expressions. It is the formula language used in Power BI for creating calculations in the data model. DAX is commonly used to create measures, calculated columns, and calculated tables. For example, a simple measure for total sales could be:

Total Sales = SUM(Sales[Sales Amount])

DAX becomes particularly powerful when calculations need to respond dynamically to filters and the report's filter context.” 5️⃣ What is the difference between a measure and a calculated column? Sample Answer: “A calculated column is calculated row by row and stored in the model. A measure is calculated when it is used in a visual and responds to the current filter context. For example, if I need a row-level calculation such as:

Profit = Sales[Revenue] - Sales[Cost]

a calculated column might be appropriate. But for a KPI such as total profit:

Total Profit = SUM(Sales[Profit])

I would generally use a measure.” 6️⃣ What is a relationship in Power BI? Sample Answer: “A relationship connects tables using related columns. For example, a Sales table may contain Product_ID and a Product table may also contain Product_ID. The relationship allows fields from the Product table to filter and analyze the Sales table. Creating relationships correctly is critical because incorrect relationships can produce incorrect report results.” 7️⃣ What is the difference between a fact table and a dimension table? Sample Answer: “A fact table generally contains transactional or measurable business events, such as sales, orders, or transactions. A dimension table contains descriptive information used to analyze those events, such as Customer, Product, Region, or Date. For example: Fact table → Sales Dimension tables → Customer, Product, Date, Region This structure makes the data model easier to analyze and maintain.” 8️⃣ What is a star schema? Sample Answer: “A star schema is a data modeling approach where a central fact table is connected to multiple dimension tables. For example: