Posts

Showing posts from April, 2025

Tableau Syllabus (APSCHE) and Model Paper

  GAYATRI VIDYA PARISHAD COLLEGE FOR DEGREE AND P.G. COURSES (A) DEPARTMENT OF BACHELOR OF SCIENCE HONOURS (DATA SCIENCE) SEMESTER-IV COURSE 9: DATA VISULIZATION USING TABLEAU Credits: 3                                                                                           3 hrs/week Aim and objectives of Course: ·  To know the importance of data Visualization in the world of Data Analytics and Prediction ·  To know the important libraries in Tableau   ·  To get equipped with Tableau Tool Learning outcomes of Course: · ...

UNIT-4

Image
  UNIT-4 Creating a Standard Map View: A standard map view is used to visualize geographic data (e.g., sales by region, population distribution) without requiring latitude/longitude values. Steps to Create a Standard Map View: Step-1:  Open the Tableau window import the Retail Sales data and connect. Step-2:  Open new work sheet, now double click on states . Step-3:  Now we add, sales and right click then select average under measure (sum) in the popup box. Step-4:  Now select Maps under Show Me. If you need to beautify the map then select colors under mark pane, select edit colors and then select Red Gold Green divergent in the drop button, click apply and then click ok. If you need to Profit also in the Sales view drag and drop the profits into sizes under Marks view. You will see red color with low values and green color with high values state wise. Plotting Custom Locations on a Map: This feature is useful when standard geographic fields (city, state) are no...

UNIT-5

Image
                                 UNIT-V Generating New Data with Forecasts: Generating data with forecasts in Tableau involves using its built-in forecasting tools to predict future trends based on historical data. Forecasting in Tableau uses historical data to predict future values using time series analysis. Tableau primarily uses Exponential Smoothing Models for forecasting. Requirements: §          At least one date field (e.g., daily, monthly) to define the time dimension. §          At least one measure (e.g., sales, profit) for forecasting. §      Ensure data is clean, with no missing values in the date or measure fields for accurate forecasts. §        Aggregate data if needed (e.g., sum sales by month).   Steps to generate Forecasts in Tableau: Step-1:  Connect to data source (Excel, SQL, cloud databa...