DASHBOARD

1. EXCEL

2. GOOGLE SHEET

3. GOOGLE DATA STUDIO

Create A Dashboard In Excel

Step 1: Import the necessary data into Excel

Step 2: Set up your workbook

Step 3: Add raw data to a table

Step 4: Data analysis

Step 5: Determine the visuals

Step 6: Create your Excel dashboard

Step 7: Customize your dashboard

Dashboard template

Create a Dashboard in Google Sheets

1. Create a database

2. Generate a chart

3. Format the chart for readability and usability

Create a Dashboard in Google Data Studio

* Data sources and connectors

* Metrics and dimensions

* Prepare the dataset (we’ll use Google Sheets)

* Prepare the dashboard layout