1.
Write the Role of Data Visualization in Analytics
Data visualization plays a crucial role in analytics by:
- Simplifying complex data: Converts raw data into visual formats (charts, graphs).
- Identifying trends and patterns: Makes it easy to spot outliers, correlations, and trends.
- Improving decision-making: Helps stakeholders understand insights quickly.
- Enhancing communication: Visuals are easier to understand and present than raw numbers.
- Driving interactive exploration: Tools like Tableau allow dynamic filtering and drilling into data.
2. Write the Different Types of Charts Available in Tableau
Tableau offers a wide variety of chart types, including:
- Bar Chart: Compare categories (e.g., sales by region)
- Line Chart: Show trends over time (e.g., monthly profit)
- Pie Chart: Display part-to-whole relationships
- Tree Map: Show hierarchical data using rectangles
- Scatter Plot: Analyze relationships between two measures
- Heat Map: Visualize data density or concentration
- Histogram: View distribution of continuous data
- Box-and-Whisker Plot: Display distribution and outliers
- Bullet Chart: Show performance against a target
- Map (Geographic): Display location-based insights (e.g., sales by state)
3. Write the Steps for Performing Filter and Sorting Using Tableau
A. Steps for Applying a Filter in Tableau:
1. Drag the desired field (e.g., Region) to the Filters shelf.
2. Choose the values or condition to include.
3. Click Show Filter to allow user interaction.
4. Adjust the filter type (dropdown, slider, etc.) as needed.
B. Steps for Sorting Data in Tableau:
1. Click on the axis label or column header in the chart.
2. Use the sort icon (A-Z or Z-A).
3. Alternatively, right-click the field in Rows/Columns, then choose Sort:
- Sort by: Alphabetic, Field, or Manual
- Order: Ascending or Descending
4. Write the Steps in Performing Dashboard Using Tableau
1. Open Tableau and create the necessary worksheets (charts, tables, etc.).
2. Click on the Dashboard tab, then click New Dashboard.
3. Drag and drop worksheets into the dashboard layout area.
4. Add interactive controls like filters, legends, parameters.
5. Use containers to manage layout (vertical/horizontal).
6. Add titles, text boxes, and images for clarity.
7. Test interactivity (e.g., filter actions, highlight actions).
8. Save and publish to Tableau Server, Public, or Tableau Cloud.
5. Steps in Analyzing Customer Feedback and Market Research Data
1. Import survey or feedback data into Tableau (Excel, CSV, or database).
2. Clean and preprocess the data (handle missing values, standardize responses).
3. Create calculated fields (e.g., sentiment labels, NPS categories).
4. Use bar charts, pie charts, or word clouds to show response distributions.
5. Perform sentiment analysis or categorize open-ended responses.
6. Use filters to break down data by demographic, channel, or product.
7. Create a dashboard with KPIs like satisfaction score, frequency of issues, etc.
8. Share findings through interactive dashboards for decision-makers.