Q1: What is Power BI?
Answer: Power BI is a business analytics tool developed by Microsoft that allows users to connect to various data sources, transform raw data, create interactive visualizations, and share reports and dashboards. It consists of multiple components including Power BI Desktop (for report creation), Power BI Service (cloud-based sharing), and Power BI Mobile (for on-the-go access).
🎯 Explain: Power BI ek Microsoft ka tool hai jo raw data ko visual reports aur dashboards mein convert karta hai. Tum Excel, SQL, CSV — kahin se bhi data lo, Power BI mein clean karo, charts banao, aur management ko share kar do. Teen parts hain — Desktop (offline kaam), Service (online share), Mobile (phone pe dekho). Basically data ko meaningful insights mein badalta hai.

Q2: What are the main components of Power BI?
Answer: Power BI has five main components: (1) Power BI Desktop — a free Windows application for creating reports. (2) Power BI Service — a cloud-based platform (app.powerbi.com) for publishing and sharing. (3) Power BI Mobile — apps for iOS and Android. (4) Power BI Report Server — an on-premise server for organizations that want to keep data in-house. (5) Power BI Embedded — for developers to embed reports into custom applications.
🎯 Explain: Power BI sirf ek software nahi hai — ek ecosystem hai. Desktop pe reports banao (free hai). Service pe publish karo (cloud pe). Mobile pe phone se dekho. Report Server company ke apne server pe host karo. Embedded apni app mein Power BI reports daal do. Interview mein pehle 3 — Desktop, Service, Mobile — hamesha yaad rakho. Baaki 2 advanced scenarios ke liye hain.

Q3: What is the difference between Power BI Desktop and Power BI Service?
Answer: Power BI Desktop is a free Windows application used for data import, transformation, data modeling, and report creation — all done locally on your computer. Power BI Service is a cloud-based online platform where published reports are shared, viewed, and collaborated upon. Reports are created in Desktop and published to Service for distribution. Desktop is for building, Service is for sharing and consuming.
🎯 Explain: Desktop = kitchen hai jahan khana banate ho. Service = restaurant hai jahan logo ko serve karte ho. Tum Desktop mein data connect karo, clean karo, charts banao — yeh sab local hota hai. Phir publish karo Service pe — managers browser mein open karke dekh lete hain. Desktop offline bhi kaam karta hai, Service internet chahiye. Simple rule: Desktop = create, Service = share.

Q4: Is Power BI free or paid?
Answer: Power BI offers multiple licensing options: (1) Power BI Desktop — completely free, used for creating reports. (2) Power BI Pro — paid license (per user/month), required for sharing reports with others on Power BI Service. (3) Power BI Premium — higher tier with dedicated capacity, larger data models, and advanced features like paginated reports and deployment pipelines. (4) Power BI Premium Per User (PPU) — premium features at a lower per-user cost.
🎯 Explain: Desktop bilkul free hai — download karo aur reports banao. Problem tab aati hai jab share karna hota hai. Service pe share karne ke liye Pro license chahiye — monthly cost hoti hai. Premium badi companies ke liye hai — zyada data, zyada features, zyada cost. Interview mein "Desktop free hai, sharing ke liye Pro chahiye" — yeh key line hai.

Q5: What file format does Power BI Desktop use?
Answer: Power BI Desktop saves reports in .pbix file format. This file contains the entire report including data model, queries, relationships, measures, visualizations, and report pages. When published to Power BI Service, the .pbix file is uploaded to the cloud. Additionally, Power BI also supports .pbit (template files) which contain the report structure without data — useful for sharing templates.
🎯 Explain: Jaise Excel ka .xlsx hota hai, waise Power BI ka .pbix hota hai. Ek .pbix file mein sab kuch hota hai — data, charts, relationships, formulas. Share karna ho toh .pbix bhej do ya Service pe publish karo. Template (.pbit) mein data nahi hota — sirf structure hota hai — jab kisi ko format dena ho toh useful hai.

Q6: What types of data sources can Power BI connect to?
Answer: Power BI can connect to a wide range of data sources including: (1) Files — Excel, CSV, XML, JSON, PDF. (2) Databases — SQL Server, MySQL, PostgreSQL, Oracle, Azure SQL. (3) Online Services — SharePoint, Google Analytics, Salesforce, Dynamics 365. (4) Others — Web pages, OData feeds, Python/R scripts, REST APIs, Hadoop, Spark. Power BI supports over 100+ native connectors and also allows custom connectors.
🎯 Explain: Power BI ki sabse badi strength yeh hai ki yeh almost kisi bhi source se data le sakta hai. Excel file hai? Connect karo. SQL database hai? Connect karo. Google Analytics? Website? API? Sab support karta hai. 100+ connectors hain built-in. Interview mein 4-5 common sources batao — Excel, SQL Server, CSV, SharePoint, Web — impressive lagta hai.

Q7: What is Power Query in Power BI?
Answer: Power Query is the data transformation and preparation engine built into Power BI Desktop. It allows users to connect to data sources, clean data, reshape columns, merge tables, remove duplicates, change data types, filter rows, and perform various ETL (Extract, Transform, Load) operations — all through a visual interface without writing code. Power Query uses M language behind the scenes.
🎯 Explain: Power Query ek data cleaning ka tool hai Power BI ke andar. Jab raw data aata hai — usme extra columns hoti hain, wrong data types hote hain, duplicates hote hain. Power Query mein bina code likhe sab fix kar sakte ho — click-based interface hai. Background mein M language use hoti hai. Basically data ko "report-ready" banata hai Power Query.

Q8: What is the difference between Import and DirectQuery mode?
Answer: In Import mode, data is loaded into Power BI's in-memory engine and stored within the .pbix file. Queries run on this cached data, making reports very fast. In DirectQuery mode, no data is imported — Power BI sends queries directly to the source database every time a visual loads or a user interacts with the report. Import is faster but uses memory, DirectQuery is real-time but slower and depends on source performance.
🎯 Explain: Import mode mein data Power BI ke andar copy ho jaata hai — fast hota hai lekin file size badh jaati hai. DirectQuery mein data copy nahi hota — har baar source se direct leke aata hai — slow ho sakta hai lekin data hamesha latest hota hai. Chhoti data sets ke liye Import best hai, badi databases jahan real-time chahiye wahan DirectQuery. Interview mein dono ka pros/cons batao.

Q9: What is ETL and how does Power BI handle it?
Answer: ETL stands for Extract, Transform, and Load. Extract means pulling data from various sources. Transform means cleaning and reshaping the data. Load means loading the processed data into the data model. In Power BI, Power Query handles the ETL process — it extracts data from sources, allows transformations through its visual editor, and loads the cleaned data into the Power BI data model for report creation.
🎯 Explain: ETL ek process hai — pehle data nikalo (Extract), phir clean karo (Transform), phir load karo model mein (Load). Power BI mein Power Query yeh teen step handle karta hai. Jab tum "Get Data" click karte ho — Extract ho raha hai. Power Query Editor mein cleaning — Transform. Apply karne pe — Load. Simple 3-step process jo har BI tool mein hota hai.

Q10: What is the difference between Merge and Append in Power Query?
Answer: Merge combines two tables horizontally based on a matching column — similar to SQL JOIN. It adds columns from the second table to the first. Append combines two tables vertically by stacking rows — similar to SQL UNION. It adds rows from the second table below the first. Merge increases column count, Append increases row count.
🎯 Explain: Merge = side by side jodte ho — jaise Employee table mein Department table ka naam add karna based on DeptID. Yeh SQL JOIN jaisa hai. Append = upar neeche jodte ho — jaise Jan ki sales aur Feb ki sales ek table mein stack karna. Yeh SQL UNION jaisa hai. Simple rule: columns badhane hain → Merge, rows badhane hain → Append.

Q11: What is the M language in Power BI?
Answer: M language (also called Power Query Formula Language) is the scripting language used behind Power Query. Every transformation you apply in Power Query's visual editor generates M code automatically. Users can also write custom M code in the Advanced Editor for complex transformations that are not available through the visual interface. M is a functional, case-sensitive language.
🎯 Explain: Jab tum Power Query mein koi step apply karte ho — background mein M code automatically likh raha hota hai. Jaise "Remove Columns" click kiya toh M mein Table.RemoveColumns() likh gaya. Normally beginners ko M likhne ki zaroorat nahi padti — GUI se kaam ho jaata hai. Advanced users custom transformations ke liye M code likhte hain Advanced Editor mein. Case-sensitive hai — "Name" aur "name" alag hain.

Q12: What is Data Refresh in Power BI?
Answer: Data Refresh is the process of updating the data in a Power BI report with the latest data from the original source. In Import mode, scheduled refresh can be set up on Power BI Service to automatically update data at specified intervals (up to 8 times per day with Pro, 48 with Premium). In DirectQuery mode, data is always live so no manual refresh is needed. Refresh ensures reports always show current data.
🎯 Explain: Import mode mein data copy hota hai — toh agar source mein naya data aaya toh Power BI ko refresh karna padta hai warna purana data dikhega. Service pe scheduled refresh set kar sakte ho — daily, multiple times a day. Pro mein 8 baar max, Premium mein 48 baar. DirectQuery mein refresh ki zaroorat nahi — har baar live data aata hai. Interview mein "scheduled refresh" aur "up to 8 times with Pro" mention karo.

Q13: What is Data Modeling in Power BI?
Answer: Data Modeling is the process of organizing and structuring data tables, defining relationships between them, creating calculated columns and measures, and establishing the logical framework that determines how data flows and aggregates in reports. A well-designed data model ensures accurate calculations, efficient performance, and meaningful visualizations. In Power BI, data modeling is done in the Model View.
🎯 Explain: Data Modeling matlab tables ko organize karna aur unke beech connections banana. Jaise Sales table aur Product table ko Product ID se relate karna. Agar modeling galat ho toh calculations galat aayenge — wrong numbers, duplicate counts. Model View mein tables ka diagram dikhta hai — lines se relationships dikhte hain. Sahi model = sahi report.

Q14: What is a Relationship in Power BI?
Answer: A Relationship in Power BI is a connection between two tables based on a common column. Relationships enable data to flow between tables so that filters applied on one table automatically affect related tables. Power BI supports three types of relationships: One-to-Many (1:M — most common), One-to-One (1:1), and Many-to-Many (M:M). Relationships have a direction — Single or Both (cross-filter direction).
🎯 Explain: Relationship do tables ko connect karta hai ek common column se. Jaise Sales table mein ProductID hai aur Products table mein bhi ProductID hai — dono ko relate karo. Ab jab slicer mein "Laptop" select karo toh Sales table automatically filter ho jayegi sirf Laptop ki rows pe. One-to-Many sabse common hai — ek product ki multiple sales. Relationship ke bina tables isolated rehte hain — filters kaam nahi karte.

Q15: What is a Star Schema?
Answer: Star Schema is a data modeling pattern where a central Fact Table (containing transactional data like sales, orders) is surrounded by multiple Dimension Tables (containing descriptive attributes like product names, customer details, dates). The fact table connects to each dimension table through foreign key relationships, forming a star-like structure. Star Schema is the recommended model design in Power BI for optimal performance and simplicity.
🎯 Explain: Star Schema ek design pattern hai — beech mein ek Fact Table hoti hai (Sales data — numbers, amounts) aur uske around Dimension Tables hoti hain (Products, Customers, Dates — descriptions). Star isliye kehte hain kyunki diagram star jaisa dikhta hai. Power BI ke liye yeh best model hai — fast performance, clean DAX, easy maintenance. Interview mein "Star Schema is the recommended approach in Power BI" — yeh line zaroor bolo.

Q16: What is the difference between a Fact Table and a Dimension Table?
Answer: A Fact Table contains quantitative, transactional data — sales amounts, quantities, order counts — the numbers you measure. It typically has many rows and foreign keys linking to dimension tables. A Dimension Table contains descriptive, categorical data — product names, categories, regions, customer names — the context by which you slice and filter fact data. Fact tables are large (millions of rows), dimension tables are small (hundreds or thousands).
🎯 Explain: Fact Table = "kya hua" — kitni sale hui, kitna amount aaya, kitne orders aaye. Numbers wali table. Dimension Table = "kis context mein" — kaunsa product, kaunsa customer, kaunsi date, kaunsa region. Description wali table. Example: Sales Fact Table mein 10 lakh rows hain. Products Dimension mein sirf 500 rows. Dono milke report banate hain — "Laptop ki North region mein kitni sale hui".

Q17: What is Cardinality in Power BI?
Answer: Cardinality defines the nature of the relationship between two tables based on the uniqueness of values in the connecting columns. Three types exist: (1) One-to-Many (1:M) — one unique value in the primary table matches multiple values in the related table (most common). (2) One-to-One (1:1) — each value appears exactly once in both tables. (3) Many-to-Many (M:M) — duplicate values exist in both connecting columns (requires careful handling).
🎯 Explain: Cardinality matlab relationship ka type — ek side pe kitne unique values hain aur dusri side pe kitne. One-to-Many: ek Product ki multiple Sales — sabse common. One-to-One: ek Employee ka ek Address — rare. Many-to-Many: ek Student multiple Courses mein aur ek Course mein multiple Students — complex. Power BI mein mostly One-to-Many use hota hai. Many-to-Many se bachne ki koshish karo — performance issues aate hain.

Q18: What is Cross-Filter Direction in Power BI?
Answer: Cross-Filter Direction determines how filters propagate between related tables. Single direction means filters flow only from the dimension table to the fact table (one-way, recommended). Both direction means filters flow in both directions between tables (bi-directional). Single is the default and recommended setting. Both direction should be used carefully as it can cause performance issues and ambiguous results in complex models.
🎯 Explain: Cross-Filter Direction batata hai ki filter kis direction mein travel karega. Single direction: Products table mein slicer lagao → Sales table filter ho jaayegi. But ulta nahi hoga — Sales se Products filter nahi hogi. Both direction: dono taraf filter chalega. Single default hai aur recommended hai — simple aur fast. Both sirf tab use karo jab zaroorat ho — warna model complex aur slow ho jaata hai. Interview mein "Single direction is recommended" — yeh bolo.

Q19: What is DAX in Power BI?
Answer: DAX stands for Data Analysis Expressions. It is a formula language used in Power BI for creating calculated columns, measures, and calculated tables. DAX is similar to Excel formulas but is designed to work with relational data models and handle complex aggregations, filtering, and time intelligence calculations. DAX is the core language that makes Power BI reports dynamic and interactive.
🎯 Explain: DAX Power BI ki formula language hai — jaise Excel mein SUM, IF likhte ho, waise Power BI mein DAX likhte ho. Lekin DAX zyada powerful hai — relational tables ke saath kaam karta hai, context samajhta hai, time intelligence support karta hai. Bina DAX ke Power BI mein sirf basic drag-drop charts ban sakte hain. Proper analysis ke liye DAX zaroori hai — measures, KPIs, calculated values sab DAX se bante hain.

Q20: What is the difference between a Measure and a Calculated Column?
Answer: A Calculated Column is computed row by row during data refresh and stored in the data model — it adds a new column to the table permanently. A Measure is computed dynamically at query time based on the current filter context — it is not stored as data but calculated on the fly. Calculated Columns increase file size, Measures do not. Measures are preferred for aggregations and KPIs, Calculated Columns for row-level categorization.
🎯 Explain: Calculated Column = har row ke liye ek fixed value store hoti hai — jaise "Full Name" column banana First + Last Name se. Yeh data refresh pe ek baar calculate hota hai aur table mein permanently add hota hai. Measure = on-the-fly calculate hota hai — filter change karo toh value change ho jaati hai. Jaise Total Sales measure — slicer change karo toh dynamically update hoga. Golden rule: aggregation chahiye → Measure banao. Row-level value chahiye → Calculated Column.

Q21: What are some basic DAX functions?
Answer: Basic DAX functions include: (1) Aggregation — SUM, AVERAGE, MIN, MAX, COUNT, DISTINCTCOUNT. (2) Logical — IF, AND, OR, SWITCH. (3) Text — CONCATENATE, LEFT, RIGHT, LEN, UPPER, LOWER. (4) Date — YEAR, MONTH, DAY, TODAY, NOW. (5) Filter — CALCULATE, FILTER, ALL, ALLEXCEPT. (6) Table — ADDCOLUMNS, SUMMARIZE, VALUES. These functions form the foundation for building any Power BI measure or calculation.
🎯 Explain: DAX functions Excel se milte julte hain — SUM, IF, YEAR sab hain. Lekin kuch Power BI specific hain — CALCULATE (sabse important), FILTER, ALL, DISTINCTCOUNT. Interview mein commonly pooche jaate hain — SUM vs SUMX (simple vs row-by-row), COUNT vs DISTINCTCOUNT (total vs unique), CALCULATE (filter modify karta hai). Basic functions yaad rakho aur ek-ek ka example de sako toh best hai.

Q22: What is the CALCULATE function in DAX?
Answer: CALCULATE is the most powerful and important DAX function. It evaluates an expression in a modified filter context. It takes two parts: (1) the expression to evaluate (like SUM of sales), and (2) one or more filter arguments that modify the filter context before the expression is evaluated. CALCULATE is essential for creating KPIs, comparisons, and any measure where you need to override or add filters dynamically.
🎯 Explain: CALCULATE DAX ka king hai — sabse important function. Simple SUM sirf current filter context mein kaam karta hai. CALCULATE filter context ko modify karta hai — matlab "mujhe total sales do but sirf North region ki" ya "mujhe last year ki sales do". Syntax: CALCULATE(expression, filter1, filter2). Time Intelligence functions bhi CALCULATE ke andar use hote hain. Interview mein "CALCULATE is the most important DAX function" — yeh confidently bolo.

Q23: What is the difference between SUM and SUMX?
Answer: SUM is a simple aggregation function that adds up all values in a single column — SUM(Sales[Amount]). SUMX is an iterator function that goes row by row through a table, evaluates an expression for each row, and then sums up the results — SUMX(Sales, Sales[Quantity] * Sales[Price]). SUM works on one column, SUMX can work with calculations involving multiple columns. SUMX is used when you need row-level computation before aggregation.
🎯 Explain: SUM sirf ek column ka total karta hai — SUM(Sales[Amount]) = saari amounts ka total. SUMX row-by-row jaata hai — har row mein pehle Quantity × Price calculate karta hai, phir sab ka total karta hai. SUM = direct column add. SUMX = pehle har row mein formula lagao, phir add karo. SUMX tab use hota hai jab table mein directly woh column nahi hai jo chahiye — calculate karna padta hai pehle.

Q24: What is Filter Context in Power BI?
Answer: Filter Context is the set of filters that are active when a DAX expression is evaluated. These filters come from multiple sources: slicers, visual-level filters, page-level filters, report-level filters, row/column placement in a matrix, and filters applied by CALCULATE. Filter Context determines which subset of data a measure operates on. Understanding Filter Context is fundamental to writing correct DAX formulas.
🎯 Explain: Filter Context matlab "abhi kaunse filters active hain". Agar slicer mein "2023" select hai aur visual mein "North" region dikh rahi hai — toh measure sirf 2023 ke North ki data pe calculate hoga. Yeh automatic hota hai. CALCULATE yeh context modify kar sakta hai — add, remove, ya change filters. Har measure ka result Filter Context pe depend karta hai — same measure alag visuals mein alag values dikhata hai kyunki context alag hota hai. DAX samajhna = Filter Context samajhna.

Q25: What is the difference between a Report and a Dashboard in Power BI?
Answer: A Report is a multi-page canvas created in Power BI Desktop containing detailed visualizations, tables, charts, and interactive elements built from a single dataset. A Dashboard is a single-page view created in Power BI Service by pinning visuals from one or multiple reports. Reports are for detailed analysis, Dashboards are for high-level monitoring. Reports support filtering and drilling, Dashboards show pinned tiles that link back to source reports.
🎯 Explain: Report = detailed book — multiple pages, interactive charts, slicers, drill-down — sab kuch explore kar sakte ho. Desktop mein banate hain. Dashboard = summary poster — ek page pe key metrics pinned hote hain multiple reports se — Service mein banate hain. Dashboard mein sirf tiles hote hain — click karo toh original report khulta hai. CEO ko Dashboard dikhao, Analyst ko Report do. Interview mein yeh difference clearly batao — common question hai.

Q26: What are Slicers in Power BI?
Answer: Slicers are visual filter controls placed directly on the report canvas that allow users to interactively filter data by selecting specific values. Slicers can be based on text fields (dropdown, list), date fields (date range slider, calendar), or numeric fields (numeric range). They provide an intuitive, user-friendly way to filter report data without going into the filter pane. Slicers can affect all visuals on a page or be configured to target specific visuals only.
🎯 Explain: Slicers report pe dikhne wale filter buttons hain — user click karke data filter kar sakta hai. Year slicer lagao — "2023" select karo, sab charts sirf 2023 ka data dikhayenge. Region slicer lagao — "North" select karo, sab visuals North ke liye filter ho jayenge. Dropdown, list, slider — multiple formats hote hain. Users ke liye interactive experience deta hai bina technical knowledge ke. Dashboard ya report dono mein useful.

Q27: What are the different types of Filters in Power BI?
Answer: Power BI supports four levels of filters: (1) Visual-Level Filter — applies to a single visual only. (2) Page-Level Filter — applies to all visuals on the current page. (3) Report-Level Filter — applies to all visuals across all pages in the report. (4) Drillthrough Filter — filters data when a user navigates from one page to another for detailed analysis. Additionally, slicers act as interactive filters directly on the canvas. Filters are managed in the Filters pane.
🎯 Explain: Power BI mein 4 level ke filters hain — Visual level (sirf ek chart pe), Page level (poore page ke sab charts pe), Report level (sab pages pe), aur Drillthrough (detail page pe jaane ke liye). Jaise ek page pe sirf 2023 ka data dikhana hai — Page Level filter lagao. Poori report mein sirf "India" ka data chahiye — Report Level filter. Ek specific chart mein top 10 products — Visual Level filter. Levels samajhna important hai.

Q28: What is Drill-Down and Drill-Through in Power BI?
Answer: Drill-Down navigates from a higher level to a lower level within the same visual — for example, from Year to Quarter to Month in a bar chart — by clicking on the drill-down arrows. Drill-Through navigates from one report page to another detailed page — for example, right-clicking on a product to go to a detailed product analysis page. Drill-Down explores hierarchy within a visual, Drill-Through crosses pages for detail.
🎯 Explain: Drill-Down = ek chart ke andar deeper jaana — Year click kiya toh Quarters dikhenge, Quarter click kiya toh Months. Same visual mein hierarchy explore karte ho. Drill-Through = ek page se dusre page pe jaana — Sales summary page pe "Laptop" pe right-click karo aur "Drill Through to Product Detail" karo — naye page pe sirf Laptop ki detailed info dikhegi. Drill-Down = andar jaana, Drill-Through = dusre page pe jaana. Dono interactive analysis ke liye important hain.

Q29: What is a Workspace in Power BI Service?
Answer: A Workspace in Power BI Service is a collaborative environment where teams can create, manage, and share reports, dashboards, and datasets. There are two types: (1) My Workspace — personal space for individual use, only you can see it. (2) Shared Workspaces — team collaboration spaces where multiple users can access, edit, and view content based on their assigned roles (Admin, Member, Contributor, Viewer). Workspaces help organize content by project, department, or team.
🎯 Explain: Workspace ek folder jaisa hai Power BI Service mein. My Workspace tumhara personal space hai — sirf tum dekh sakte ho. Shared Workspace team ke liye hai — Sales team ka alag, HR ka alag. Usme reports, dashboards, datasets sab organized rehte hain. Roles hote hain — Admin (full control), Member (edit), Contributor (create), Viewer (sirf dekhna). Real companies mein har department ka alag workspace hota hai.

Q30: How do you publish a report from Power BI Desktop to Power BI Service?
Answer: To publish a report: (1) Open the report in Power BI Desktop. (2) Click the "Publish" button on the Home ribbon. (3) Sign in with your Power BI account (Pro or Premium license required for sharing). (4) Select the target Workspace where you want to publish. (5) Click "Select" — the report and dataset are uploaded to Power BI Service. After publishing, the report is accessible via browser, can be shared with colleagues, and data refresh schedules can be configured.
🎯 Explain: Publish karna bahut simple hai — Desktop mein report banao, Home tab mein Publish button click karo, apna Power BI account se sign in karo, workspace select karo — done! Service pe report live ho jayegi. Managers browser mein open karke dekh lenge. Lekin sharing ke liye Pro license chahiye — free version mein publish hota hai but share nahi kar sakte. Publish karne ke baad scheduled refresh bhi set karo taaki data latest rahe.