Data Analytics

These are generally better candidates for measures, because they need to respond dynamically to report filters. 🎯 Power BI Interview Questions • What is DAX? DAX is the formula language used in Power BI for analytical calculations. • What is the difference between a calculated column and a measure? A calculated column calculates values row by row and stores them in the model. A measure calculates dynamically based on the current filter context. • What is filter context? The set of filters affecting a DAX calculation. • What is row context? The current row being evaluated, particularly relevant to calculated columns and certain DAX iterators. • What does CALCULATE() do? It evaluates an expression after modifying the filter context. • Why use DIVIDE()? It provides safer division handling, especially when the denominator can be zero or blank. 🎯 Practice Task Create these measures in a sample Sales model: • Total Sales = SUM(Sales[Sales_Amount]) • Total Cost = SUM(Sales[Cost]) • Total Profit = [Total Sales] - [Total Cost] • Profit Margin = DIVIDE([Total Profit], [Total Sales]) Then create Cards for each measure. Add a Region slicer. Change the region and observe what happens. This is one of the easiest ways to understand filter context practically. 💡 The biggest DAX concept to understand at this stage is: A measure doesn't simply calculate a number. It calculates a number based on the current context of your report. Power BI Resources: https://whatsapp.com/channel/0029Vai1xKf1dAvuk6s1v22c Double Tap ❤️ For Part-5 ----- 1.51 ₽ · /balance_help

If you understand filter context, you'll understand much more advanced DAX later. 🔹 10. CALCULATE() One of the most important DAX functions is CALCULATE(). It evaluates an expression after modifying the filter context. For example: West Sales = CALCULATE([Total Sales], Customers[Region] = "West") This calculates sales specifically for the West region. 🔹 11. Why CALCULATE() Is So Important Many advanced DAX calculations are built around CALCULATE(). It is commonly used for: • Conditional calculations, Time intelligence, Comparisons, Removing filters, Adding filters, Changing filter context Learning CALCULATE() properly is one of the biggest milestones in Power BI. 🔹 12. Measures Can Use Other Measures You don't need to repeat the same logic everywhere. • Total Sales = SUM(Sales[Sales_Amount]) • Total Cost = SUM(Sales[Cost]) • Total Profit = [Total Sales] - [Total Cost] This makes your model easier to maintain. 🔹 13. Profit Margin You can create: Profit Margin = DIVIDE([Total Profit], [Total Sales]) DIVIDE() is generally safer than manually using "/" because it handles division-by-zero cases more gracefully. 🔹 14. DIVIDE() vs "/" Instead of [Total Profit] / [Total Sales] prefer: Profit Margin = DIVIDE([Total Profit], [Total Sales], 0) You can also specify an alternate result (0) when denominator is zero. 🔹 15. Calculated Column vs Measure — When to Use Which? Simple rule: • Use a calculated column when you need a value stored for each row. Examples: Profit per transaction, Customer category, Product classification • Use a measure when you need an aggregated or dynamically calculated result. Examples: Total Sales, Total Profit, Profit Margin, Average Order Value, Sales Growth % For most report-level KPIs, measures are usually preferred. 🔹 16. Row Context Calculated columns work with row context. For example: Profit = Sales[Sales_Amount] - Sales[Cost] Power BI evaluates this expression for each row. Think: Row Context = "Which row am I currently calculating?" 🔹 17. Filter Context vs Row Context • Row Context → Focuses on the current row • Filter Context → Defines which data is included in a calculation Simple example: Calculated Column → Row by row. Measure → Based on current filter context. Understanding this distinction is essential before moving into advanced DAX. 🔹 18. COUNTROWS() COUNTROWS() counts rows in a table. Example: Total Orders = COUNTROWS(Sales) If one row represents one order, this can represent order count. But if your table contains multiple rows per order, it may not. In that situation: Total Orders = DISTINCTCOUNT(Sales[Order_ID]) may be more appropriate. Always understand the grain of your table. 🔹 19. RELATED() RELATED() can retrieve a value from a related table when working in row context. For example: Region = RELATED(Customers[Region]) This can bring the customer's region into a row-level calculation when the relationship and model support it. 🔹 20. Don't Create Everything as a Calculated Column A common beginner mistake is creating columns for every calculation. For example: Total Sales, Total Profit, Average Sales, Profit Margin, Sales Growth

🚀 Data Analyst Roadmap — Part 25 📊 Power BI Level 4 — DAX Fundamentals: Measures, Calculated Columns & Filter Context Now that you understand Power Query and Data Modeling, it's time to learn one of the most important parts of Power BI: DAX — Data Analysis Expressions DAX is the formula language used in Power BI to create calculations. 🔹 1. What Is DAX? DAX is used to create: • Measures • Calculated columns • Calculated tables For example: Total Sales = SUM(Sales[Sales_Amount]) This simple measure can become the foundation for many Power BI reports. 🔹 2. Measures vs Calculated Columns This is one of the most common Power BI interview questions. • Calculated Column: Calculates a value for each row. • Example: Profit = Sales[Sales_Amount] - Sales[Cost] • If there are 1 million rows, the column contains a result for each row. • Measure: Calculates a result when it is used in a visual. • Example: Total Sales = SUM(Sales[Sales_Amount]) • A measure can change depending on the filters and selections in the report. 🔹 3. Simple Example Suppose your Sales table contains: • Product: Laptop | Sales: 80,000 | Cost: 60,000 • Product: Mouse | Sales: 2,000 | Cost: 1,000 • Product: Keyboard | Sales: 4,000 | Cost: 2,500 • Calculated column: Profit = Sales[Sales] - Sales[Cost] calculates profit for every row. • Measure: Total Profit = SUM(Sales[Sales]) - SUM(Sales[Cost]) calculates the total based on the current filter context. 🔹 4. Basic Aggregation Functions Some DAX functions you'll use constantly are: • SUM(), AVERAGE(), MIN(), MAX(), COUNT(), COUNTROWS(), DISTINCTCOUNT() Examples: • Total Sales = SUM(Sales[Sales]) • Average Sales = AVERAGE(Sales[Sales]) • Total Orders = COUNTROWS(Sales) • Total Customers = DISTINCTCOUNT(Sales[Customer_ID]) 🔹 5. Why DISTINCTCOUNT() Matters Suppose the same customer placed 10 orders. COUNT() could count all transaction rows. But DISTINCTCOUNT(Sales[Customer_ID]) counts the customer only once. So if you want "How many unique customers do we have?" DISTINCTCOUNT() is often the right choice. 🔹 6. Creating Your First Measure In Power BI: Modeling → New Measure Then write: Total Sales = SUM(Sales[Sales_Amount]) You can then drag Total Sales into a Card visual. Result might show: TOTAL SALES ₹12.5 Cr 🔹 7. Measures Respond to Filters This is where DAX becomes powerful. Suppose your report contains Total Sales = ₹10 Crore. Now select Region = West. The same measure Total Sales = SUM(Sales[Sales_Amount]) may now show ₹3 Crore. You didn't create another measure. The filter changed the calculation. This is called Filter Context. 🔹 8. What Is Filter Context? Filter context means: The filters currently affecting a DAX calculation. Filters can come from: • Slicers, Visuals, Rows and columns, Page filters, Report filters, Relationships, DAX expressions For example: Region = West, Year = 2026, Category = Electronics. The Total Sales measure calculates only within that context. 🔹 9. A Simple Way to Understand Filter Context Think of it like this: • Total Sales → Which rows are currently visible? → Apply filters → Calculate SUM This concept is extremely important.

Preparing for a SQL interview? Focus on mastering these essential topics: 1. Joins: Get comfortable with inner, left, right, and outer joins. Knowing when to use what kind of join is important! 2. Window Functions: Understand when to use ROW_NUMBER, RANK(), DENSE_RANK(), LAG, and LEAD for complex analytical queries. 3. Query Execution Order: Know the sequence from FROM to ORDER BY. This is crucial for writing efficient, error-free queries. 4. Common Table Expressions (CTEs): Use CTEs to simplify and structure complex queries for better readability. 5. Aggregations & Window Functions: Combine aggregate functions with window functions for in-depth data analysis. 6. Subqueries: Learn how to use subqueries effectively within main SQL statements for complex data manipulations. 7. Handling NULLs: Be adept at managing NULL values to ensure accurate data processing and avoid potential pitfalls. 8. Indexing: Understand how proper indexing can significantly boost query performance. 9. GROUP BY & HAVING: Master grouping data and filtering groups with HAVING to refine your query results. 10. String Manipulation Functions: Get familiar with string functions like CONCAT, SUBSTRING, and REPLACE to handle text data efficiently. 11. Set Operations: Know how to use UNION, INTERSECT, and EXCEPT to combine or compare result sets. 12. Optimizing Queries: Learn techniques to optimize your queries for performance, especially with large datasets. Here you can find essential SQL Interview Resources👇 https://whatsapp.com/channel/0029VanC5rODzgT6TiTGoa1v Like this post if you need more 👍❤️ Hope it helps :)

🎓 𝗧𝗼𝗽 𝗜𝗻-𝗗𝗲𝗺𝗮𝗻𝗱 𝗙𝗥𝗘𝗘 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻𝘀 𝘁𝗼 𝗠𝗮𝘀𝘁𝗲𝗿 𝗶𝗻 𝟮𝟬𝟮𝟲 🔥 Explore these FREE certification courses in today’s most in-demand technology fields: 📊 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 :- https://pdlink.in/4eRA6eF 💻 𝗪𝗲𝗯 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗺𝗲𝗻𝘁 :- https://pdlink.in/4gP18Eo 💫 𝗔𝗿𝘁𝗶𝗳𝗶𝗰𝗶𝗮𝗹 𝗜𝗻𝘁𝗲𝗹𝗹𝗶𝗴𝗲𝗻𝗰𝗲 :- https://pdlink.in/45HWa5Q ☁️ 𝗖𝗹𝗼𝘂𝗱 𝗖𝗼𝗺𝗽𝘂𝘁𝗶𝗻𝗴 :- https://pdlink.in/4zrksPn 🟧 𝗔𝗪𝗦 :- https://pdlink.in/4j4Jxtv 🛡️ 𝗖𝘆𝗯𝗲𝗿𝘀𝗲𝗰𝘂𝗿𝗶𝘁𝘆 & 𝗔𝘇𝘂𝗿𝗲 :- https://pdlink.in/4f0GNuH ⚡ Start learning today and prepare yourself for better career opportunities in 2026!

This makes time-based analysis much easier. 🔹 12. Why Month Number Is Important If you display: January February March April Power BI may sort month names alphabetically depending on the setup. You need a: Month Number January → 1 February → 2 March → 3 Then sort Month by Month Number. 🔹 13. Understand the Grain Before creating relationships, ask: "What does one row represent?" For example: Sales table → One row = One order or: Sales table → One row = One order item These are different grains. If you don't understand the grain, you can accidentally double-count sales. 🔹 14. Example of a Grain Problem Suppose one order contains: Order 1001 Laptop → ₹60,000 Mouse → ₹2,000 The order-item table has two rows. If you join this with another table incorrectly, the ₹62,000 order value could potentially be repeated. So before creating relationships or calculations: Always understand the grain of your tables. 🔹 15. Active and Inactive Relationships Sometimes two tables can have more than one possible relationship. For example, Sales may contain: Order_Date Ship_Date Both could connect to the Date table. But Power BI generally allows only one active relationship between the same pair of tables at a time. The other relationship can be inactive and activated when needed using DAX. This becomes important when building advanced date analysis. 🔹 16. Filter Direction Relationships control how filters move between tables. In a simple star schema: Customer ↓ Sales filters usually flow from the dimension toward the fact table. Avoid using bi-directional filtering everywhere. It can create: • Ambiguous relationships • Unexpected results • Difficult-to-debug models • Performance issues 🔹 17. Don't Create Relationships Just Because Column Names Match For example: Customer_ID appearing in two tables doesn't automatically mean they should be connected. Check: ✔ Same business meaning ✔ Compatible data type ✔ Correct grain ✔ Unique values on the "one" side ✔ Correct cardinality 🎯 Interview Question What is the difference between a Fact Table and a Dimension Table? Fact Table Contains business transactions and measurable values. Example: "Sales, Quantity, Cost" Dimension Table Contains descriptive information used to analyze those transactions. Example: "Customer, Product, Date, Region" Easy way to remember: Fact = What happened Dimension = Describe what happened 💡 Key Lesson Don't build your Power BI visuals before understanding your data model. A good model makes your calculations easier, your reports more reliable, and your analysis much easier to maintain. 🚀 Double Tap ❤️ For More ----- 13.17 ₽ · /balance_help

🚀 Data Analyst Roadmap — Part 24 📊 Power BI Level 3 — Data Modeling & Relationships Once your data is clean, the next step is to build a proper data model. This is where you decide how your tables connect and how Power BI should understand your data. 🔹 1. What Is a Data Model? A data model is the structure that connects your tables. For example, you might have: Sales Order_ID Customer_ID Product_ID Date Sales Quantity Customers Customer_ID Customer_Name Region Products Product_ID Product_Name Category Date Date Month Quarter Year These tables are connected through relationships. 🔹 2. Fact Table A fact table contains business transactions and numerical values. Example: Sales It may contain: • Sales Amount • Quantity • Cost • Profit • Order ID Think: Fact = What happened? 🔹 3. Dimension Table Dimension tables describe the facts. Examples: Customer → Who? Product → What? Date → When? Region → Where? For example: Customer Customer_ID Customer_Name Region 🔹 4. Star Schema A common Power BI model looks like this:

Customers


Products ──── Sales ──── Date


Region

The fact table is in the middle and dimension tables surround it. This is called a Star Schema. 🔹 5. Primary Key A primary key uniquely identifies a record. For example: Customer_ID 101 102 103 Each ID identifies one customer. 🔹 6. Foreign Key The Sales table can contain the same customer multiple times: Customer_ID 101 101 102 101 103 Here, "Customer_ID" is used to connect Sales with Customers. So: Customers → Primary Key Sales → Foreign Key 🔹 7. One-to-Many Relationship The most common relationship in Power BI is: One Customer → Many Sales

Customers              Sales
    1                    *
    |                    |
Customer_ID ───────── Customer_ID

This is called a: 1 : * relationship 🔹 8. Why Relationships Matter Suppose you select: Region = West Power BI needs to know which sales belong to customers from the West region. The relationship allows the filter to travel from: Customers ↓ Sales Without a proper relationship, your visuals may show incorrect results. 🔹 9. Cardinality Cardinality describes how records relate between two tables. Common types: 1 : * → One-to-Many 1 : 1 → One-to-One • : * → Many-to-Many For most Power BI analytical models, 1-to-many relationships are the most common. 🔹 10. Many-to-Many Relationships Many-to-many relationships can make models more complicated. For example: Customers ↔ Products A customer can buy many products. A product can be purchased by many customers. Instead of directly connecting them in some cases, a bridge table can be used. Customers ↓ Bridge Table ↓ Products 🔹 11. Date Table A proper Date table is extremely important for Power BI. It can contain: Date Day Month Month Number Quarter Year Year-Month For example:

Date       | Month   | Quarter | Year
01-Jan-26  | January | Q1      | 2026
02-Jan-26  | January | Q1      | 2026

🎓 𝗧𝗼𝗽 𝗜𝗻-𝗗𝗲𝗺𝗮𝗻𝗱 𝗙𝗥𝗘𝗘 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻𝘀 𝘁𝗼 𝗠𝗮𝘀𝘁𝗲𝗿 𝗶𝗻 𝟮𝟬𝟮𝟲 🔥 Explore these FREE certification courses in today’s most in-demand technology fields: 📊 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 :- https://pdlink.in/4eRA6eF 💻 𝗪𝗲𝗯 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗺𝗲𝗻𝘁 :- https://pdlink.in/4gP18Eo 💫 𝗔𝗿𝘁𝗶𝗳𝗶𝗰𝗶𝗮𝗹 𝗜𝗻𝘁𝗲𝗹𝗹𝗶𝗴𝗲𝗻𝗰𝗲 :- https://pdlink.in/45HWa5Q ☁️ 𝗖𝗹𝗼𝘂𝗱 𝗖𝗼𝗺𝗽𝘂𝘁𝗶𝗻𝗴 :- https://pdlink.in/4zrksPn 🟧 𝗔𝗪𝗦 :- https://pdlink.in/4j4Jxtv 🛡️ 𝗖𝘆𝗯𝗲𝗿𝘀𝗲𝗰𝘂𝗿𝗶𝘁𝘆 & 𝗔𝘇𝘂𝗿𝗲 :- https://pdlink.in/4f0GNuH ⚡ Start learning today and prepare yourself for better career opportunities in 2026!

🎓 𝗧𝗼𝗽 𝗜𝗻-𝗗𝗲𝗺𝗮𝗻𝗱 𝗙𝗥𝗘𝗘 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻𝘀 𝘁𝗼 𝗠𝗮𝘀𝘁𝗲𝗿 𝗶𝗻 𝟮𝟬𝟮𝟲 🔥 Explore these FREE certification courses in today’s most in-demand technology fields: 📊 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 :- https://pdlink.in/4eRA6eF 💻 𝗪𝗲𝗯 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗺𝗲𝗻𝘁 :- https://pdlink.in/4gP18Eo 💫 𝗔𝗿𝘁𝗶𝗳𝗶𝗰𝗶𝗮𝗹 𝗜𝗻𝘁𝗲𝗹𝗹𝗶𝗴𝗲𝗻𝗰𝗲 :- https://pdlink.in/45HWa5Q ☁️ 𝗖𝗹𝗼𝘂𝗱 𝗖𝗼𝗺𝗽𝘂𝘁𝗶𝗻𝗴 :- https://pdlink.in/4zrksPn 🟧 𝗔𝗪𝗦 :- https://pdlink.in/4j4Jxtv 🛡️ 𝗖𝘆𝗯𝗲𝗿𝘀𝗲𝗰𝘂𝗿𝗶𝘁𝘆 & 𝗔𝘇𝘂𝗿𝗲 :- https://pdlink.in/4f0GNuH ⚡ Start learning today and prepare yourself for better career opportunities in 2026!

You don't need to master M immediately. Start by understanding the transformations available through the interface. 🔹 13. Merge Queries Merge Queries combines related tables using a common column. For example: Customers Customer_ID | Customer_Name 101 | John 102 | Sarah Orders Order_ID | Customer_ID | Sales 1 | 101 | 5000 2 | 102 | 7000 You can merge them using: Customer_ID This is similar to a SQL "JOIN". 🔹 14. Append Queries Append combines tables by adding rows. For example: January Sales ↓ February Sales ↓ March Sales becomes one table containing all three months. Remember: Merge → Combine columns Append → Combine rows 🔹 15. Applied Steps Power Query records every transformation you perform. For example: Source ↓ Changed Type ↓ Removed Columns ↓ Filtered Rows ↓ Trimmed Text ↓ Removed Duplicates This makes the cleaning process repeatable. When the source data is refreshed, Power Query can apply the same steps again. 🔹 16. Query Folding Query Folding is an important performance concept. When possible, Power Query pushes transformations back to the source system. For example: Power BI ↓ Filter 2026 Data ↓ Database performs filtering ↓ Power BI receives required data This can reduce the amount of data transferred and improve refresh performance. Query folding depends on the data source and the transformations being used. 🔹 17. Power Query vs SQL vs DAX Remember this simple difference: SQL → Retrieve and analyze data from databases Power Query → Clean and transform data DAX → Create calculations and analyze data inside the Power BI model A typical workflow is: SQL ↓ Get Data Power Query ↓ Clean & Transform Data Model ↓ Create Relationships DAX ↓ Create Measures Visuals ↓ Build Report 🎯 Interview Question What is the difference between Merge and Append in Power Query? Merge combines related tables using matching columns. Append stacks tables with similar structures by adding rows. Merge → More columns Append → More rows 💡 Key Lesson Power Query prepares your data so that your Power BI model and reports are built on clean, reliable data. 🚀 Double Tap ❤️ For Part-3 ----- 1.35 ₽ · /balance_help

🚀 Data Analyst Roadmap — Part 23 📊 Power BI Level 2 — Power Query: Data Cleaning & Transformation Power Query is used in Power BI to clean, transform, and prepare data before building reports. 🔹 1. Open Power Query In Power BI Desktop: Home → Transform Data This opens the Power Query Editor. You will mainly work with: • Queries • Data Preview • Applied Steps 🔹 2. Change Data Types Always check whether columns have the correct data type. For example: Customer_ID → Text Quantity → Whole Number Sales → Decimal Number Order_Date → Date Incorrect data types can cause problems in calculations and visuals. 🔹 3. Remove Unnecessary Columns If your dataset contains columns you don't need, remove them. For example: Customer_ID Customer_Name Email Phone Sales Internal_Code If your analysis only needs Customer ID, Customer Name, and Sales, remove the rest. 🔹 4. Filter Unnecessary Rows Power Query can remove or filter: • Blank rows • Invalid records • Test data • Unwanted categories • Records outside the required period Always understand the business rule before removing data. 🔹 5. Remove Duplicates Power Query allows you to remove duplicate values based on selected columns. For example, if "Customer_ID" should be unique in a Customer table, duplicate IDs should be investigated. But don't remove duplicates blindly. A Sales table can naturally contain many rows for the same customer. 🔹 6. Handle Missing Values You may find: Blank NULL N/A Unknown Depending on the situation, you can: • Keep the value blank • Replace it • Remove the record Don't automatically replace blanks with zero. For example, a blank discount doesn't always mean a discount of 0. 🔹 7. Clean Text Data often contains unwanted spaces or inconsistent formatting. Example: " Mumbai" "Mumbai " "MUMBAI" Useful Power Query transformations include: Trim → Removes unnecessary spaces Clean → Removes unwanted non-printable characters You can also change text to: • UPPERCASE • lowercase • Proper Case 🔹 8. Replace Values Suppose your data contains: Mum Mumbai MUMBAI You can replace and standardize values so they are represented consistently. This is especially useful for: • City • Region • Category • Department • Status 🔹 9. Split Columns Suppose you have: Full Name John Smith Sarah Johnson You can split it into: First Name | Last Name John | Smith Sarah | Johnson You can split a column using delimiters such as: • Space • Comma • Dash • Custom delimiter 🔹 10. Extract Text You can extract specific parts of a text column. For example: john@gmail.com You could extract: john or: gmail.com Power Query provides options such as: • Text Before Delimiter • Text After Delimiter • Text Between Delimiters • First Characters • Last Characters 🔹 11. Conditional Column You can create categories based on conditions. For example: Sales >= 50,000 → High Sales >= 20,000 → Medium Otherwise → Low This is similar to "CASE WHEN" in SQL. 🔹 12. Custom Column Power Query also allows you to create calculated columns. For example: Total Amount = Quantity × Unit Price Custom columns use Power Query's formula language, called M.

🚀 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲 𝘁𝗼 𝗚𝗲𝘁 𝗮 𝗛𝗶𝗴𝗵-𝗣𝗮𝘆𝗶𝗻𝗴 𝗝𝗼𝗯 𝗶𝗻 𝟮𝟬𝟮𝟲 📊 Build job-ready skills through live online classes, practical assignments and real-world projects. 💼 End-to-End Placement Support 🤝 500+ Partner Companies 🎓 2000+ Students Placed 🏆 Highest Salary: ₹41 LPA 📞 Get FREE career counselling and check your eligibility! 🔗 𝗥𝗲𝗴𝗶𝘀𝘁𝗲𝗿 𝗡𝗼𝘄 👇 https://pdlink.in/45vk5ph ⚡Prepare for roles such as Data Analyst, Business Analyst, BI Analyst and Reporting Analyst.

For example: ┌─────────────────┐ │ TOTAL SALES │ │ ₹12.5 Cr │ └─────────────────┘ Other examples: Total Profit Total Customers Total Orders Average Order Value A dashboard should make its most important KPIs easy to find. 🔹 17. Slicers Slicers allow users to interactively filter a report. For example: Region: [All ▼] Year: [2026 ▼] Category: [Electronics ▼] Selecting a region can update multiple visuals on the report page. This is one of the features that makes Power BI dashboards interactive. 🔹 18. Filters Power BI provides filtering at different levels. Common concepts include: Visual-level filter Affects one visual. Page-level filter Affects visuals on a particular page. Report-level filter Can affect the entire report. Understanding filter behavior becomes extremely important when building complex reports. 🔹 19. Dashboard vs Report These terms are often confused. A report can contain multiple pages with interactive visuals. A dashboard in the Power BI Service is a single-page canvas made from pinned tiles. In everyday conversation, people sometimes use "dashboard" to mean any Power BI report page. But technically, they're different concepts. 🔹 20. The Real Purpose of a Power BI Dashboard A good dashboard should answer business questions. For example: Sales Dashboard «How much are we selling?» «Which regions are performing best?» «Which products drive revenue?» «Is revenue increasing or decreasing?» «Where are we underperforming?» The dashboard should make these answers easy to discover. 🔹 21. Common Beginner Mistakes Avoid: ❌ Adding too many visuals ❌ Using every available chart type ❌ Creating unnecessary colors and decorations ❌ Building dashboards before understanding the data ❌ Ignoring relationships ❌ Creating everything as calculated columns ❌ Using measures incorrectly ❌ Showing numbers without business context A professional dashboard should be: Clear + Accurate + Interactive + Business-focused 🚀 Double Tap ❤️ For More ----- 1.41 ₽ · /balance_help

Later, you'll learn how to connect Power BI directly to SQL databases and other enterprise sources. 🔹 7. Importing Data A typical process is: Home ↓ Get Data ↓ Choose Source ↓ Select Table/File ↓ Transform Data ↓ Load Don't immediately start creating charts. First understand: What data did I load? 🔹 8. Power Query Power Query is Power BI's data preparation and transformation engine. You'll use it to: • Remove unwanted columns • Rename columns • Change data types • Remove duplicates • Handle missing values • Split columns • Merge tables • Append tables • Filter rows • Create transformation steps This is similar to the Power Query work you learned in Excel. The important idea is: Power Query prepares the data before analysis. 🔹 9. Power Query vs DAX This distinction is extremely important. Power Query → Used mainly for data preparation and transformation DAX → Used mainly for calculations and analysis inside the data model Think: Power Query "Prepare the data." DAX "Analyze the data." You'll learn both in detail in later parts. 🔹 10. Data Modeling Suppose you have: Sales • Order_ID • Customer_ID • Product_ID • Date • Sales Customers • Customer_ID • Customer_Name • Region Products • Product_ID • Product_Name • Category Date • Date • Month • Quarter • Year Instead of putting everything into one giant table, Power BI can connect these tables through relationships. This is called data modeling. 🔹 11. Relationships For example: Customers Customer_ID ↓ Sales ↑ Product_ID Products The relationship allows Power BI to understand how tables are connected. For example: Customer → Sales allows you to analyze sales by customer region. Product → Sales allows you to analyze sales by product category. 🔹 12. Fact Tables and Dimension Tables A common data-modeling structure is the star schema. At the center: ⭐ Fact Table Around it: 🔹 Dimension Tables Example: Customers Products — Sales — Date Region The "Sales" table contains business events or measurements. The dimension tables provide descriptive context. This structure is extremely important for Power BI. 🔹 13. Measures vs Columns Another fundamental concept. Suppose you have: "Sales" A calculated column could calculate something for each row. A measure calculates a value based on the current report context. Example measure: Total Sales = SUM(Sales[Sales_Amount]) When you put this measure into a visual, Power BI calculates it according to the selected: • Region • Product • Date • Customer • Filters This makes measures extremely powerful. 🔹 14. Your First Visualization Suppose you have: Month| Sales Jan| 100,000 Feb| 120,000 Mar| 150,000 You could create a line chart. The chart immediately communicates: 📈 Sales are increasing over time. But visualization choice matters. You shouldn't select a chart because it looks attractive. Choose it because it communicates the business message clearly. 🔹 15. Common Power BI Visuals You should become familiar with: 📊 Bar Chart 📈 Line Chart 🥧 Pie / Donut Chart 🔢 Card 📋 Table 📑 Matrix 🎯 KPI 🗺️ Map 📊 Column Chart 🎛️ Slicer Each visual serves a different analytical purpose. 🔹 16. Cards Cards are useful for displaying important KPIs.

🚀 Data Analyst Roadmap — Part 22 📊 Power BI Level 1 — Introduction to Power BI & Business Intelligence After learning Excel and SQL, it's time to move into one of the most important tools in the modern Data Analyst toolkit: Microsoft Power BI Power BI helps you transform raw data into: 📊 Interactive dashboards 📈 Reports 🔍 Business insights 🎯 KPIs 📉 Trends and comparisons 💼 Decision-making tools The goal isn't simply to create attractive charts. The goal is to turn data into information that people can use to make better decisions. 🔹 1. What Is Power BI? Power BI is Microsoft's business intelligence and data visualization platform. It allows you to: • Connect to different data sources • Clean and transform data • Build data models • Create calculations • Create interactive visualizations • Build dashboards and reports • Share insights with others A typical workflow looks like: Data Sources ↓ Power Query ↓ Data Model ↓ DAX Calculations ↓ Visualizations ↓ Report / Dashboard ↓ Business Insights 🔹 2. Why Should a Data Analyst Learn Power BI? Companies generate huge amounts of data. But raw tables aren't easy for business users to understand. Imagine giving management this: Date | Region | Product | Sales | Profit They may have thousands or millions of rows. Instead, Power BI can turn that data into: Total Sales: ₹12.5 Cr Profit: ₹3.1 Cr Top Region: West Top Product: Product A Monthly Trend: 📈 Sales by Region: Interactive chart Now decision-makers can understand the situation quickly. 🔹 3. Power BI vs Excel You already learned Excel in the earlier parts of this roadmap. Both tools are valuable, but they are commonly used differently. Excel| Power BI Spreadsheet-based| BI platform Great for ad-hoc analysis| Great for interactive reporting Cell-based calculations| Model + DAX-based calculations Manual dashboard updates can be common| Reports can refresh from data sources Excellent for detailed individual analysis| Excellent for scalable business reporting This doesn't mean: Power BI replaces Excel. Strong Data Analysts often use both. 🔹 4. Main Components of Power BI You should become familiar with the Power BI ecosystem. The major concepts you'll encounter are: Power BI Desktop Used to build reports, transform data, create models, and write DAX. Power BI Service Used for publishing, sharing, collaboration, refresh, and managing reports in the cloud. Power BI Mobile Allows users to view and interact with reports on mobile devices. For a beginner, Power BI Desktop is where most hands-on learning starts. 🔹 5. Power BI Desktop Interface When you open Power BI Desktop, you'll work with several important areas. Report View Used to create visualizations and report pages. Data View Allows you to inspect the data loaded into your model. Model View Shows relationships between tables. These three views are important because Power BI isn't just a visualization tool. It's also a data modeling and analytical environment. 🔹 6. Connecting Power BI to Data Power BI can connect to many sources. For example: 📁 Excel 📄 CSV 🗄️ SQL databases ☁️ Cloud data sources 🌐 Web sources 📊 Other business systems A common beginner workflow is: Excel/CSV → Power BI → Dashboard

🚀 𝗧𝗼𝗽 𝟯 𝗙𝗥𝗘𝗘 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀 𝘁𝗼 𝗟𝗲𝗮𝗿𝗻 𝗜𝗻-𝗗𝗲𝗺𝗮𝗻𝗱 𝗧𝗲𝗰𝗵 𝗦𝗸𝗶𝗹𝗹𝘀 🔥 💫 Artificial Intelligence (AI) 📊 Data Analytics 🔐 Cybersecurity 🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗳𝗼𝗿 𝗙𝗥𝗘𝗘 👇:- https://pdlink.in/4y2XyN1 🎯 Perfect for Students • Freshers • Beginners • Tech Enthusiasts 💡 Learn for FREE → Build Skills → Upgrade Your Career

🔹 11. Calculate Growth Percentage (Total_Sales - Previous_Sales) / NULLIF(Previous_Sales, 0) * 100 NULLIF() prevents division-by-zero errors. 🔹 12. Find the Latest Order for Every Customer

WITH Ranked_Orders AS (
    SELECT Customer_ID, Order_ID, Order_Date,
           ROW_NUMBER() OVER (PARTITION BY Customer_ID ORDER BY Order_Date DESC) AS rn
    FROM Orders
)

SELECT Customer_ID, Order_ID, Order_Date FROM Ranked_Orders WHERE rn = 1;

🔹 13-14. Inactive Customers & Duplicates Inactive = MAX(Order_Date) vs 90-day threshold. Business defines the rule, SQL calculates it. Detect duplicates:

WITH Duplicate_Check AS (
    SELECT *, ROW_NUMBER() OVER (PARTITION BY Customer_ID, Order_Date, Sales ORDER BY Order_ID) AS rn
    FROM Orders
)

SELECT * FROM Duplicate_Check WHERE rn > 1;

🔹 15. Combining Multiple Tables

SELECT c.Customer_ID, c.Customer_Name, p.Product_Name, oi.Quantity, oi.Sales
FROM Customers c
JOIN Orders o ON c.Customer_ID = o.Customer_ID
JOIN Order_Items oi ON o.Order_ID = oi.Order_ID
JOIN Products p ON oi.Product_ID = p.Product_ID;

⚠️ Every additional join can change the number of rows. Always check the grain. 🔹 16. The Most Important Analytical Pattern 1. Filter raw data → 2. Join tables → 3. Aggregate to correct grain → 4. Apply window functions → 5. Filter analytical result → 6. Present final output 💼 Real-World Business Problems to Practice Sales: Top 5 products by revenue, Top products within each category, Month with highest sales, Revenue growth by month Customers: Customers with no orders, declining purchases, most recent purchase, repeat customers, AOV per customer Operations: Orders taking longer than expected, Products never sold, Duplicate transactions, Most active regions 🎯 SQL Interview Challenge: Find the highest-selling product in each category.

WITH Product_Sales AS (
    SELECT Product_ID, Category, SUM(Sales) AS Total_Sales
    FROM Product_Sales_Data GROUP BY Product_ID, Category
),
Ranked_Products AS (
    SELECT *, RANK() OVER (PARTITION BY Category ORDER BY Total_Sales DESC) AS Sales_Rank
    FROM Product_Sales
)
SELECT Product_ID, Category, Total_Sales FROM Ranked_Products WHERE Sales_Rank = 1;

🧠 SQL Resources: https://whatsapp.com/channel/0029VanC5rODzgT6TiTGoa1v Double Tap ❤️ For More ----- 1.38 ₽ · /balance_help

🚀 Data Analyst Roadmap — Part 18 🧠 SQL Level 8 — Advanced Analytical Queries & Business Problems At this stage, you know the core SQL building blocks: SELECT → WHERE → GROUP BY → HAVING → JOIN → CTE → Window Functions → Date Analysis Now it's time to combine them. Real Data Analyst work rarely asks: "Write a query using RANK()" Instead, you'll get business questions like: • "Which customers are becoming inactive?" • "What are our top-selling products in each category?" • "Which month had the highest revenue growth?" The real skill is converting a business problem into SQL logic. 🔹 1. Start With the Business Question Before writing SQL, identify: • What are we measuring? • At what level? • Which tables contain the required data? • What filters are needed? • Do we need aggregation? • Do we need ranking or comparison? For example: "Find the top 3 products in every category." Break it down: Product → Category → Sales → Rank within Category → Keep Top 3 🔹 2. Find the Correct Grain Grain means: What does one row represent? • Orders → one row per order • Order_Items → one row per product within an order • Customers → one row per customer If you don't understand the grain, you can accidentally double-count revenue. 🔹 3. Revenue by Customer

SELECT
    c.Customer_ID,
    c.Customer_Name,
    SUM(o.Sales) AS Total_Sales
FROM Customers c
JOIN Orders o ON c.Customer_ID = o.Customer_ID
GROUP BY c.Customer_ID, c.Customer_Name;

🔹 4. Rank Customers by Revenue

WITH Customer_Sales AS (
    SELECT Customer_ID, SUM(Sales) AS Total_Sales
    FROM Orders GROUP BY Customer_ID
)
SELECT
    Customer_ID,
    Total_Sales,
    RANK() OVER (ORDER BY Total_Sales DESC) AS Sales_Rank
FROM Customer_Sales;

🔹 5. Top 3 Customers in Each Region

WITH Customer_Sales AS (
    SELECT Customer_ID, Region, SUM(Sales) AS Total_Sales
    FROM Orders GROUP BY Customer_ID, Region
),
Ranked_Customers AS (
    SELECT *, RANK() OVER (PARTITION BY Region ORDER BY Total_Sales DESC) AS Sales_Rank
    FROM Customer_Sales
)

SELECT * FROM Ranked_Customers WHERE Sales_Rank <= 3;

🔹 6. Finding the Second-Highest Salary

WITH Ranked_Employees AS (
    SELECT Employee, Salary,
           DENSE_RANK() OVER (ORDER BY Salary DESC) AS Salary_Rank
    FROM Employees
)

SELECT Employee, Salary FROM Ranked_Employees WHERE Salary_Rank = 2;

🔹 7. Find Products That Never Sold

SELECT p.Product_ID, p.Product_Name
FROM Products p
LEFT JOIN Order_Items oi ON p.Product_ID = oi.Product_ID
WHERE oi.Product_ID IS NULL;

🔹 8. Customers With No Orders

SELECT c.Customer_ID, c.Customer_Name
FROM Customers c
LEFT JOIN Orders o ON c.Customer_ID = o.Customer_ID
WHERE o.Customer_ID IS NULL;

🔹 9. Customers Above Average Spending

WITH Customer_Sales AS (
    SELECT Customer_ID, SUM(Sales) AS Total_Sales
    FROM Orders GROUP BY Customer_ID
)
SELECT Customer_ID, Total_Sales FROM Customer_Sales
WHERE Total_Sales > (SELECT AVG(Total_Sales) FROM Customer_Sales);

🔹 10. Month-over-Month Sales Growth

WITH Monthly_Sales AS (
    SELECT EXTRACT(YEAR FROM Order_Date) AS Year,
           EXTRACT(MONTH FROM Order_Date) AS Month,
           SUM(Sales) AS Total_Sales
    FROM Orders GROUP BY 1, 2
),
Comparison AS (
    SELECT Year, Month, Total_Sales,
           LAG(Total_Sales) OVER (ORDER BY Year, Month) AS Previous_Sales
    FROM Monthly_Sales
)

SELECT Year, Month, Total_Sales, Previous_Sales,
       Total_Sales - Previous_Sales AS Sales_Change
FROM Comparison;

𝗧𝗼𝗽 𝟱 𝗙𝗥𝗘𝗘 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝘁𝗼 𝗞𝗶𝗰𝗸𝘀𝘁𝗮𝗿𝘁 𝗬𝗼𝘂𝗿 𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 𝗖𝗮𝗿𝗲𝗲𝗿 📊 Want to start a career in Data Science without spending money? Here are 5 beginner-friendly learning resources covering essential skills such as Python, SQL, Machine Learning and hands-on projects. 🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗳𝗼𝗿 𝗙𝗥𝗘𝗘 👇:- https://pdlink.in/4ilAmok 🎯 Perfect for Students • Freshers • Beginners • Aspiring Data Scientists 💡 Learn → Practice → Build Projects → Create Your Portfolio