DATA VISUALIZATION POWER BI with Ratan Kumar Jha

📊 Power BI Visuals – Quick Summary

𝐁𝐚𝐫 𝐂𝐡𝐚𝐫𝐭 – Compares values across categories with horizontal bars. Great for ranking and comparison.

𝐂𝐨𝐥𝐮𝐦𝐧 𝐂𝐡𝐚𝐫𝐭 – Similar to bar charts but vertical. Ideal for time-based data and trends.

𝐒𝐭𝐚𝐜𝐤𝐞𝐝 𝐁𝐚𝐫/𝐂𝐨𝐥𝐮𝐦𝐧 – Shows total values with a breakdown by sub-category. Useful for part-to-whole analysis.

𝟏𝟎𝟎% 𝐒𝐭𝐚𝐜𝐤𝐞𝐝 𝐁𝐚𝐫/𝐂𝐨𝐥𝐮𝐦𝐧 – Focuses on percentage contributions across categories, normalizing all to 100%.

𝐋𝐢𝐧𝐞 𝐂𝐡𝐚𝐫𝐭 – Displays trends over time. Best for continuous data like sales over months.

𝐀𝐫𝐞𝐚 𝐂𝐡𝐚𝐫𝐭 – Like a line chart, but fills the area under the line to show volume or magnitude.

𝐒𝐜𝐚𝐭𝐭𝐞𝐫 𝐂𝐡𝐚𝐫𝐭 – Plots two numeric values to show relationships or outliers (e.g., sales vs. profit).

𝐏𝐢𝐞/𝐃𝐨𝐧𝐮𝐭 𝐂𝐡𝐚𝐫𝐭 – Great for showing part-to-whole data with few categories. Donut allows a total in the center.

𝐓𝐫𝐞𝐞𝐌𝐚𝐩 – Uses nested rectangles to show proportional data by category and sub-category.

𝐆𝐚𝐮𝐠𝐞 – Tracks a single KPI against a target using a circular dial.

𝐊𝐏𝐈 – Highlights one key metric with its trend and status against a goal.

𝐌𝐮𝐥𝐭𝐢-𝐑𝐨𝐰 𝐂𝐚𝐫𝐝 – Displays multiple metrics in a list format for dashboard summaries.

𝐂𝐚𝐫𝐝 – Shows a single value (e.g., total sales) prominently.

𝐓𝐚𝐛𝐥𝐞 – Displays detailed row-by-row data, like an Excel sheet.

𝐌𝐚𝐭𝐫𝐢𝐱 – Like a pivot table, allows row/column groupings with totals and drill-down.

𝐒𝐥𝐢𝐜𝐞𝐫 – An interactive filter that lets users control what data appears in visuals.

💡 AI & Advanced Visuals

𝐊𝐞𝐲 𝐈𝐧𝐟𝐥𝐮𝐞𝐧𝐜𝐞𝐫 – Uses AI to show which factors most impact a selected metric.

𝐃𝐞𝐜𝐨𝐦𝐩𝐨𝐬𝐢𝐭𝐢𝐨𝐧 𝐓𝐫𝐞𝐞 – Breaks down a metric by categories to uncover root causes.

𝐐 & 𝐀 – Lets users ask natural language questions and generates visual answers.

𝐒𝐦𝐚𝐫𝐭 𝐍𝐚𝐫𝐫𝐚𝐭𝐢𝐯𝐞 – Automatically writes insights and summaries based on your data.