14. Visuals and Their Formatting
Now let us see how to make a report good-looking and useful – Visuals and formatting. Bar, line, combo, scatter, card, matrix, AI visuals... in this module we learn when to use each visual and when not to. Remember, the right chart matters more than a pretty chart.
आता report सुंदर आणि उपयोगी कसा बनवायचा ते बघू – Visuals आणि formatting. Bar, line, combo, scatter, card, matrix, AI visuals... प्रत्येक visual कधी वापरायचा आणि कधी नाही, हे या module मध्ये शिकूया. लक्षात ठेवा, सुंदर chart पेक्षा बरोबर chart जास्त महत्त्वाचा.
अब देखते हैं कि report सुंदर और काम की कैसे बनाएँ – Visuals और formatting. Bar, line, combo, scatter, card, matrix, AI visuals... हर visual कब इस्तेमाल करना है और कब नहीं, यह इस module में सीखेंगे. याद रखिए, सुंदर chart से ज़्यादा सही chart ज़रूरी है.
What you will learn in this module
- Creating visuals, the field wells and the Format pane (Visual vs General tabs)
- A "choose the right chart" table based on the business question
- Every built-in visual: what it is for, when not to use it, field wells, an example on our data and its key formatting options
- The Analytics pane: constant, average, median, percentile, trend and forecast lines
- AI visuals, text/image/shape/button elements, R/Python visuals and AppSource custom visuals
Live story: Which chart for which question?
Suppose the Netflix India content team wants a one-page view of watch hours by language (fictional numbers). Hindi, Marathi, Tamil and English shows sit in one table. A pie chart with 12 slices hides the answer. A sorted bar chart shows it in one second. This chapter picks the right visual and formats it so a manager reads it fast.
All numbers in this story are fictional practice data.
Live story: कोणत्या प्रश्नासाठी कोणता chart?
समजा Netflix India ची content team ला भाषेनुसार watch hours चा एक-page view हवाय (काल्पनिक आकडे). Hindi, Marathi, Tamil आणि English shows एकाच table मध्ये आहेत. 12 तुकड्यांचा pie chart उत्तर लपवतो. Sort केलेला bar chart ते एका सेकंदात दाखवतो. हा chapter योग्य visual निवडतो आणि manager ला पटकन वाचता येईल असं format करतो.
या story मधले सगळे आकडे काल्पनिक practice data आहेत.
Live story: किस सवाल के लिए कौन-सा chart?
मान लीजिए Netflix India की content team को भाषा के हिसाब से watch hours का एक-page view चाहिए (काल्पनिक आँकड़े). Hindi, Marathi, Tamil और English shows एक ही table में हैं. 12 टुकड़ों वाला pie chart जवाब छिपा देता है. Sort किया हुआ bar chart उसे एक सेकंड में दिखाता है. यह chapter सही visual चुनता है और उसे ऐसे format करता है कि manager जल्दी पढ़ ले.
इस story के सारे आँकड़े काल्पनिक practice data हैं.
Concepts in this chapter
- 14.1Creating a Visual Step by Step
- 14.2The Format Pane: Visual Tab, General Tab and Analytics
- 14.3Choose the Right Chart
- 14.4Bar and Column Charts (Stacked, Clustered, 100% Stacked)
- 14.5Line, Area and Stacked Area Charts
- 14.6Line and Column Combo Charts
- 14.7Ribbon Chart
- 14.8Waterfall Chart
- 14.9Funnel Chart
- 14.10Scatter and Bubble Charts (with Play Axis)
- 14.11Pie, Donut and Treemap
- 14.12Map, Filled Map, Shape Map and Azure Map (Summary)
- 14.13Gauge
- 14.14Card, Card (new) and Multi-row Card
- 14.15KPI Visual
- 14.16Slicer
- 14.17Table
- 14.18Matrix
- 14.19AI Visuals: Decomposition Tree, Key Influencers, Q&A, Narrative
- 14.20Text Box, Image, Shapes and Buttons
- 14.21R and Python Visuals, and Custom Visuals from AppSource
- 14.22Small Multiples and Visual Calculations (Quick Look)
- 14.23The Analytics Pane
- 14.24Sparklines in a Table or Matrix
- 14.25Visual Calculations (Version-Dependent)
- 14.26Anomaly Detection on a Line Chart
- 14.27Copilot in Power BI
The chapter recap is at the end of the last concept page.
Ravi Sir's Cards: 32 revision, interview and comparison cards for this chapter · मराठी cards