Membuat Portfolio Data Analyst dengan Excel dan Tableau

Introduction

This tutorial guides you through creating a data analyst portfolio using Excel and Tableau. By following these steps, you'll learn how to analyze and visualize data effectively, enhancing your skills and showcasing your work to potential employers.

Step 1: Download the Dataset

• Access the dataset from Kaggle at the following link: US Flight Delay Dataset.
• Sign in or create a Kaggle account to download the dataset.
• Save the dataset in a convenient location on your computer for easy access.

Step 2: Prepare the Data in Excel

• Open Excel and import the downloaded dataset.
• Clean the data by:
  • Removing any unnecessary columns.
  • Checking for and handling missing values.
  • Ensuring data types are correctly formatted (e.g., dates as date types).
• Create a summary table to analyze key metrics such as:
  • Total delays.
  • Average delay by airline.
  • Delays by airport.

Practical Tips

• Use Excel formulas like AVERAGE(), SUM(), and COUNTIF() to compute your metrics.

Step 3: Create Visualizations in Excel

• Use Excel’s charting tools to create visual representations of your data:
  • Create a bar chart for average delays by airline.
  • Create a pie chart to show the proportion of delays by airport.
• Format your charts for clarity:
  • Add titles and labels.
  • Choose colors that enhance readability.

Step 4: Export Charts for Tableau

• Once your charts are ready, take screenshots or export them as images.
• Save these images for use in your Tableau dashboard.

Step 5: Import Data into Tableau

• Open Tableau Public Desktop.
• Connect to your Excel file by selecting "Connect" and then "Excel."
• Import the cleaned dataset for analysis.

Step 6: Create a Dashboard in Tableau

• Drag and drop your data fields to create visualizations:
  • Use bar graphs, line charts, and maps to display your findings.
• Arrange your visualizations on the dashboard for a cohesive view.
• Include interactive elements like filters to allow users to explore the data.

Common Pitfalls to Avoid

• Ensure your data is correctly linked; mismatched fields can lead to inaccurate visualizations.
• Avoid overcrowding the dashboard with too many charts; focus on key insights.

Step 7: Publish Your Dashboard

• Once satisfied with your dashboard, publish it to Tableau Public.
• Share the link to your dashboard to showcase your work.

Conclusion

By following these steps, you have created a comprehensive data analyst portfolio using Excel and Tableau. This portfolio not only showcases your technical skills but also your ability to analyze and visualize data effectively. Consider exploring additional datasets or projects to further enhance your portfolio and skills.