fx Analysis & Visualization

Charts That Don't Lie

75 मिनट6 पाठ18 प्रश्न

पाठ

1. Chart choice matrix: trend / comparison / composition / distribution / relationship13 min 2. Line, column, bar — and when not to use a pie chart13 min 3. Combo charts and the right use of a secondary axis13 min 4. Scatter, histogram, waterfall, funnel12 min 5. Sparklines and in-cell data bars12 min 6. Remove chartjunk: gridlines, direct labels, axis truncation ethics12 min

अभ्यास फ़ाइल

⬇ डाउनलोड करें analysis-visualization-practice.zip

Analysis & Visualization practice bundle

Extract the ZIP before opening files. Start with pivot-practice.xlsx: its Sales sheet contains the original 16-row tblSales table for pivot and dynamic-array exercises. Grand total: ₹10,70,000. Keep an unchanged copy as your baseline.

capstone/data/ contains 24 monthly sales CSVs, totaling 50,000 synthetic orders from April 2024 through March 2026. Stores, Products and Targets CSVs sit outside that folder so a sales-only folder import does not combine incompatible schemas.

analysis-reference.xlsx contains a Wide Targets exercise and independently calculated reference summaries for checking your work. These are plain tables, not completed PivotTables or a Power Pivot model; build those in Excel as directed in the lessons. solutions-en.md and solutions-hi.md provide exercise answers.

calendar.csv contains daily dates for 2024–2026, FY labels and fiscal month numbers. Load it into the model and mark its Date column as the date table. answer-key.json and the optional standard-library audit_capstone.py let you reconcile the CSVs without Excel. README.md explains setup and filter scope.

Use a supported Windows desktop Excel edition with Power Pivot for the complete model exercises. The modern dynamic-array lessons specify their own Excel version requirements. The download contains no macros, credentials, or external connections.

मॉड्यूल प्रश्नोत्तरी (18)

1. Best chart for a trend over 12 months?

Line

2. Comparing 8 stores with long names?

Horizontal bar, sorted

3. Spread of order values?

Histogram

4. Store names are long — column or bar?

Bar

5. Max slices for a readable pie?

About 3–4, with clear differences

6. How do you put the largest bar on top?

Sort descending + Categories in reverse order

7. When is a secondary axis appropriate?

When the series have different units

8. Actual vs Target — secondary axis?

No — same units, same axis

9. Alternative when a dual-axis chart is confusing?

Two small charts with the same x-axis

10. Which chart shows how totals moved from last year to this year by region?

Waterfall

11. What must be numeric in a scatter?

Both x and y

12. Waterfall start/end bars float — fix?

Format Data Point → Set as total

13. Why set sparklines to "Same for All"?

So rows are compared on the same scale

14. Data bars should start at what minimum?

Zero

15. Which sparkline type suits above/below target?

Win/Loss

16. Must bar charts start at zero?

Yes

17. With axis at ₹7 cr, how much bigger does North (9.43) look than West (7.48)?

About 5×, though it's really 1.26×

18. How many highlight colours per chart?

One