How to Build a Data Analyst Portfolio Website

How to Build a Data Analyst Portfolio Website That Gets You Noticed

If you are applying for Data Analyst jobs, having a strong CV is important—but your CV does not always show what you can actually do.

A Data Analyst portfolio website gives employers an opportunity to see your projects, dashboards, technical skills, problem-solving ability, and the way you communicate data insights.

The good news is that you do not need to be a web developer to build one. With Google Sites, you can create and publish a professional Data Analyst portfolio without writing code.

What You Will Build

By the end of this tutorial, you will have a simple professional portfolio website containing:

  • A professional homepage
  • An About Me section
  • Your Data Analyst skills
  • Featured data analysis projects
  • Power BI or Tableau dashboards
  • Python and SQL projects
  • Links to your GitHub repositories
  • Your education and certifications
  • Your professional experience
  • A contact section
  • Your LinkedIn profile
  • A downloadable CV

Why Do Data Analysts Need a Portfolio Website?

A Data Analyst portfolio allows you to demonstrate your ability rather than simply listing technologies on your CV.

For example, instead of writing:

Skills: Python, SQL, Power BI, Excel, Tableau and Machine Learning.

Your portfolio can show an actual project where you used those skills to solve a business problem.

Example:
Customer Churn Analysis using SQL, Python and Power BI — analysed customer behaviour, identified factors associated with churn, created an interactive dashboard and presented recommendations for improving customer retention.

This gives a recruiter or hiring manager something concrete to evaluate.

Step 1: Create Your Google Sites Website

The first step is to create your website using Google Sites. You can start with a blank site or use one of the available templates.

For a Data Analyst portfolio, I recommend starting with a blank site because it gives you more control over the structure and content.

Recommended Website Structure

Keep your portfolio simple. A good structure could look like this:

Page Purpose
Home Introduce yourself and your Data Analyst profile
About Tell your professional story
Projects Showcase your best Data Analyst projects
Skills Show your technical and analytical skills
Experience Highlight professional experience
Contact Make it easy for employers to contact you

Step 2: Design Your Homepage

Your homepage is the first thing visitors should see when they open your portfolio.

Do not make the homepage complicated. The visitor should immediately understand who you are, what you do and what you can offer.

Recommended Homepage Layout

[Your Name]
Data Analyst | Data Scientist | Business Intelligence Analyst

I transform complex data into actionable insights using SQL, Python, Power BI and advanced analytics.

View My Projects    Download CV

Your homepage should also include a professional photograph if appropriate, your location, key technical skills and links to your LinkedIn and GitHub profiles.

Step 3: Write a Strong “About Me” Section

Your About section should not simply repeat your CV. Instead, use it to explain your professional identity and the type of problems you solve.

A simple structure is:

  1. Who you are
  2. Your professional background
  3. Your areas of expertise
  4. The types of problems you solve
  5. The industries or areas you are interested in
  6. What you are currently looking for
Example:

I am a Data Analyst passionate about transforming complex datasets into clear, actionable insights. My experience includes data cleaning, exploratory data analysis, statistical analysis, SQL, Python and business intelligence. I enjoy using data to identify trends, solve business problems and support evidence-based decision-making.

Step 4: Create Your Data Analyst Projects Page

This is arguably the most important part of your portfolio.

Do not simply list project titles. Each project should tell a story about a problem you solved using data.

Use This Structure for Every Project

Section What to Include
Project Title Give the project a clear name
Business Problem Explain what problem you were trying to solve
Dataset Describe the data and its source
Tools SQL, Python, Power BI, Excel, Tableau, etc.
Analysis Explain what you analysed
Insights Highlight your most important findings
Recommendations Explain what decision-makers should do
Project Link GitHub, dashboard or live application

Step 5: Add Your Power BI Dashboards

If you use Power BI, your portfolio is an excellent place to showcase your dashboards.

Instead of simply writing “I know Power BI”, embed a dashboard that allows visitors to see the quality of your work.

Examples of Dashboards to Include

  • Sales Performance Dashboard
  • Customer Churn Dashboard
  • Financial Performance Dashboard
  • Healthcare Analytics Dashboard
  • Human Resources Dashboard
  • Marketing Analytics Dashboard
  • Energy Consumption Dashboard

In Google Sites, you can add dashboards and other web content using the available embed options. Make sure the dashboard is configured to allow the intended audience to view it.

Step 6: Add Your GitHub Projects

If you use Python, SQL or R, your GitHub repositories can provide evidence of your technical skills.

Create a GitHub repository for each major project where appropriate, and make sure the repository contains a useful README file.

A Good Project README Should Explain

  • What the project is about
  • The business or analytical problem
  • The dataset used
  • Tools and technologies
  • Steps taken during the analysis
  • Important findings
  • Visualisations
  • How someone can reproduce the analysis

Step 7: Showcase Your Data Analyst Skills

Avoid creating a huge list of every technology you have ever used.

Instead, organise your skills into categories.

Category Examples
Data Analysis Excel, Python, Pandas, R
Databases SQL, MySQL, PostgreSQL
Visualisation Power BI, Tableau, Matplotlib
Statistics Descriptive Statistics, Hypothesis Testing, Regression
Programming Python, R, SQL
Other Git, GitHub, APIs, Cloud Platforms

Step 8: Add Your Experience and Certifications

Create a section showing your professional experience, education and relevant certifications.

However, keep the information concise. Your portfolio is not meant to completely replace your CV.

Add a prominent Download CV button that allows recruiters to access your full CV.

Step 9: Add a Contact Section

Make it extremely easy for someone to contact you.

Your contact section can include:

  • Email address
  • LinkedIn profile
  • GitHub profile
  • Location
  • Professional contact form
Tip: Do not hide your contact information at the bottom of a complicated website. A recruiter should be able to find your LinkedIn, email or CV quickly.

Step 10: Make Your Google Sites Portfolio Look Professional

Google Sites makes it easy to build a website, but the quality of the final portfolio still depends on your design choices.

Use a Simple Colour Scheme

Choose two or three professional colours and use them consistently throughout the website.

For example:

Primary: Navy Blue
Accent: Orange
Background: White or Light Grey

Avoid using too many colours, fonts, animations or decorative elements.

Use High-Quality Project Images

Screenshots of your dashboards and visualisations can make your projects much easier to understand.

Crop screenshots properly and make sure text inside the dashboard remains readable.

10 Data Analyst Projects You Can Add to Your Portfolio

If you are building your first portfolio and do not have much professional experience, you can create practical projects using publicly available datasets.

  1. Sales Performance Analysis
  2. Customer Churn Analysis
  3. Supermarket Sales Dashboard
  4. Healthcare Data Analysis
  5. House Price Analysis
  6. Employee Attrition Analysis
  7. Marketing Campaign Analysis
  8. Energy Consumption Analysis
  9. Ride-Hailing Data Analysis
  10. COVID-19 or Public Health Data Analysis

The important thing is not the number of projects. Three excellent projects are usually more valuable than ten poorly documented projects.

How to Choose Your Best Three Projects

Try to select projects that demonstrate different aspects of your Data Analyst skill set.

Project Skills Demonstrated
SQL Project SQL, joins, aggregation, data cleaning and analysis
Power BI Project Data modelling, DAX, visualisation and business intelligence
Python Project Python, Pandas, EDA, statistics and visualisation

How to Write a Data Analyst Project Description

One of the biggest mistakes beginners make is writing project descriptions that only explain what they did.

Instead, explain the problem, process, result and business implication.

Weak:
Created a Power BI dashboard using sales data.

Better:
Analysed monthly sales performance across products, regions and customer segments using Power BI. The dashboard was designed to help management identify underperforming regions, monitor revenue trends and compare product performance.

How to Make Your Portfolio Recruiter-Friendly

Imagine that a recruiter has only a few minutes to review your portfolio.

They should quickly find answers to these questions:

  • Who is this person?
  • What type of Data Analyst are they?
  • What tools do they know?
  • What projects have they completed?
  • Can they work with real-world data?
  • Can they communicate insights?
  • Where can I see their work?
  • How can I contact them?

If your website answers these questions quickly, you have created a much more useful portfolio.

Common Data Analyst Portfolio Mistakes to Avoid

1. Listing Skills Without Evidence

Do not simply list Python, SQL and Power BI. Show projects where you actually used them.

2. Adding Too Many Projects

Focus on quality rather than quantity. Select projects that demonstrate different skills.

3. No Business Context

Data Analysts solve problems. Explain why the analysis matters instead of focusing only on technical procedures.

4. Poor Dashboard Design

A technically correct dashboard can still be difficult to use. Focus on clear titles, appropriate charts, readable numbers and logical layout.

5. No Contact Information

Always provide a clear way for recruiters, clients or employers to contact you.

How to Publish Your Google Sites Portfolio

Once your website is complete, preview it carefully before publishing.

Check the website on both desktop and mobile views and make sure all buttons, project links, dashboards, GitHub repositories and CV links work correctly.

You can then publish the site and share the portfolio link on your CV, LinkedIn profile, job applications and professional email signature.

Important: Before sharing your portfolio with employers, open the published website in a private/incognito browser window and confirm that visitors can actually access the pages, dashboards and documents you intended to make public.

Data Analyst Portfolio Checklist

Before you start applying for jobs, use this checklist:

Portfolio Element Complete?
Professional homepage ☐
Professional About section ☐
3–5 strong projects ☐
Power BI/Tableau dashboard ☐
SQL project ☐
Python data analysis project ☐
GitHub profile ☐
LinkedIn profile ☐
Downloadable CV ☐
Contact information ☐
Mobile/desktop testing ☐

Frequently Asked Questions

Can I build a Data Analyst portfolio without knowing how to code?

Yes. Google Sites allows you to create a website without writing HTML, CSS or JavaScript. Your focus should be on presenting your projects, skills and professional experience effectively.

Is Google Sites good for a Data Analyst portfolio?

Yes. It is particularly useful for beginners and professionals who want to create a simple portfolio quickly without spending time developing a website from scratch.

How many projects should a Data Analyst portfolio have?

There is no fixed number. Start with three strong projects that demonstrate different skills, then add more as you gain experience.

Should I include academic projects?

Yes. Academic, personal and professional projects can all be included, particularly when you are an entry-level Data Analyst and do not yet have extensive professional experience.

Should I put my portfolio link on my CV?

Yes. Place your portfolio link somewhere visible on your CV, alongside your LinkedIn and GitHub profiles where relevant.

Final Thoughts

Building a Data Analyst portfolio does not have to be complicated. With Google Sites, you can create a professional portfolio without learning web development.

The most important part is not the website itself. It is the evidence of your ability to work with data and communicate insights.

Focus on a small number of high-quality projects. Explain the problem you solved, show your analysis, present your visualisations, highlight your findings and explain the recommendations that came from your work.

Your portfolio should ultimately answer one important question for a potential employer:

“Can this person use data to solve problems and communicate insights?”

If your Google Sites portfolio can answer that question clearly, you are already much closer to having a portfolio that supports your job search.

Explore Our Students’ Real Projects

Our students don’t just learn—they build real-world data analytics, machine learning, AI, Power BI, SQL, Python, and web development projects throughout their training. Explore our growing portfolio and see what you can achieve with DataLab.

🚀 Click to View Our Students’ Projects