Google Trends Dashboard — Power BI

Project Overview

This project is an interactive Power BI dashboard designed to analyse Google Trends search-interest data across countries, keywords and time periods. The dashboard helps users compare keyword demand, monitor recent search performance, identify rising and top related keywords, and explore country-level interest patterns.

The project uses Power BI, Power Query, SerpAPI Google Trends endpoints, country/flag reference data, and custom dashboard assets to create a polished multi-page business intelligence report.

Business Problem

Search trend data can support market analysis, content planning, campaign monitoring and keyword strategy. However, Google Trends outputs are often fragmented across different views such as country interest, time-series demand, related keywords and recent activity.

This dashboard brings those views into one structured report so users can answer:

• Which keywords are currently performing strongly?
• How does keyword popularity change over time?
• Which countries show higher search interest?
• What were the strongest trends in the last 7 days?
• Which related topics or keywords are rising?

Tools Used

• Power BI — dashboard creation and visual analytics
• Power Query — API connection, transformation and refresh logic
• SerpAPI / Google Trends API — search-interest data extraction
• CSV / JSON — country flags and world map reference data
• Dashboard design assets — icons, wireframes and visual layouts

Dashboard Pages

1. Overview Page

The overview page summarises country selection, keyword search volume comparison and recent 7-day keyword performance. It provides a high-level view for users who want quick trend insights.

2. Keywords by Date

This page tracks keyword popularity over time and allows users to compare multiple keywords across historical periods.

3. Real-Time Performance

This page focuses on recent keyword activity and short-term search behaviour using the past 7 days of data.

4. Rising and Top Keywords

This page highlights related keywords, rising topics and top-performing associated search terms.

Data and API Sources

This project uses Google Trends data accessed through SerpAPI-style Power Query scripts.

The main Power Query files are:

powerquery/by_date_api.pq
powerquery/country_api.pq
powerquery/past_7_days_keywords_performance_data.pq
powerquery/related_keywords_rising_top.pq

The project also includes supporting reference data:

data/countries_with_flags_url.csv
data/countries_110m.json

The JSON file supports country-level map/geography visuals, while the CSV supports country flag display and country selection design.

Important API Key Note

The Power Query scripts contain placeholder API-key logic. To refresh the dashboard with live data, replace the placeholder value with your own API key.

For safety, do not commit a real API key to GitHub.

Use a placeholder such as:

Paste your API key here

Project Structure

google-trends-dashboard-powerbi/
├── README.md
├── PROJECT_SUMMARY.md
├── powerbi/
│   └── google_trends_dashboard.pbix
├── powerquery/
│   ├── by_date_api.pq
│   ├── country_api.pq
│   ├── past_7_days_keywords_performance_data.pq
│   └── related_keywords_rising_top.pq
├── data/
│   ├── countries_with_flags_url.csv
│   ├── countries_110m.json
│   └── README.md
├── assets/
│   ├── icons/
│   ├── design-backgrounds/
│   └── wireframes/
├── outputs/
│   └── screenshots/
└── docs/
    ├── api_refresh_notes.md
    ├── dashboard_design_notes.md
    └── project_notes.md

Key Features

• Multi-page Power BI dashboard
• Google Trends API connection through Power Query
• Country-level trend exploration
• Keyword comparison by time period
• Recent 7-day performance view
• Rising and top related keywords section
• Custom dashboard navigation and icon design
• GitHub-ready documentation and screenshots

Business Value

This dashboard can support:

• Market demand analysis
• Keyword research
• Content planning
• Campaign monitoring
• International trend comparison
• Strategy and business intelligence reporting

How to Use

1. Download this repository.
2. Open powerbi/google_trends_dashboard.pbix in Power BI Desktop.
3. Review the dashboard pages and visuals.
4. To refresh with live data, add your own API key in the Power Query files or Power BI parameters.
5. Do not publish real API keys to GitHub.

Portfolio Positioning

This project demonstrates Power BI dashboard design, API-based data extraction, Power Query transformation, market trend analysis, visual storytelling and business intelligence reporting.