My Notes

Go To Home Page
Power BI Problem Statements

Table of Content

Section 1: Basics & Interface


Section 2: Data Import & Power Query


Section 3: Data Modeling


Section 4: DAX


Section 5: Reports & Dashboards


Section 6: Optimization


🔹 Section 1: Basics & Interface

  • Explain the three main views in Power BI Desktop.
  • Difference between Power BI Desktop and Power BI Service.
  • What is the typical workflow in Power BI?
  • What is the difference between Import mode and DirectQuery?
  • Explain the purpose of Options & Settings in Power BI.

🔹 Section 2: Data Import & Power Query

  • How do you connect Power BI to an Excel file?
  • Explain the role of Power Query Editor.
  • How do you remove duplicates from a column?
  • How do you change data types in Power Query?
  • What is the purpose of Applied Steps?
  • Explain how to split and merge columns.
  • How do you handle missing values?
  • What is Group By operation?

🔹 Section 3: Data Modeling

  • Explain fact table and dimension table.
  • What is star schema and why is it preferred?
  • Difference between star schema and snowflake schema.
  • Explain cardinality types in relationships.
  • What is cross filter direction?
  • How do you create a hierarchy?
  • Why is a proper date table important?
  • What happens if you use many-to-many relationship?

🔹 Section 4: DAX

  • Difference between calculated column and measure.
  • Explain CALCULATE function with example.
  • What is filter context in DAX?
  • Difference between SUM and SUMX.
  • Explain time intelligence functions.
  • What is the purpose of VAR in DAX?
  • Write a DAX formula to calculate Year-to-Date sales.
  • Explain row context vs filter context.

🔹 Section 5: Reports & Dashboards

  • How do you create a bar chart in Power BI?
  • Explain the purpose of slicers.
  • What is drill-down and how is it used?
  • How do you apply conditional formatting?
  • Difference between report and dashboard.
  • Best practices for designing dashboards.
  • How do you publish a report?

🔹 Section 6: Optimization & Performance

  • How do you use Performance Analyzer?
  • Why is star schema important for performance?
  • How can you optimize DAX measures?
  • Why should calculated columns be minimized?
  • What are common reasons for slow reports?
  • Difference between bagging and boosting (conceptual BI comparison).
  • Best practices for improving Power BI performance.

Mini Project of using Next.js and Tailwind CSS