Perfeito. Vou estruturar o primeiro artigo para o seu blog técnico com base no que já conversamos: introdução ao projeto, foco no Campeonato Paulista como fonte inicial de dados e primeiros passos no Power BI.

Building a Power BI Dashboard for Brazilian Football: Starting with the Campeonato Paulista

When creating a data-driven dashboard, the best approach is to begin with a limited dataset and progressively expand. For Brazilian football, a good entry point is the Campeonato Paulista (São Paulo State Championship), one of the most traditional state leagues in Brazil. This article marks the first step of our journey to design a Power BI dashboard about Brazilian football clubs.

1. Choosing the Right Data Source

Before building any visualization, we need reliable and structured data. For the Campeonato Paulista, we can start with the following sources:

• Official website of the Federação Paulista de Futebol (FPF): futebolpaulista.com.br
• Sports portals:
  • Globo Esporte
  • UOL Esporte
• APIs and Open Data: for example API-Football or GitHub projects that scrape football statistics.

For a learning path, starting with web scraping or simple Excel/CSV exports from these sites is easier than handling APIs.

2. Structuring the Dataset

To create a meaningful dashboard, we need a minimum data structure. Three essential tables can be defined:

• Teams
  Fields: Team_ID, Name, City, Stadium, Logo_URL
• Matches
  Fields: Date, Round, Home_Team, Away_Team, Goals_Home, Goals_Away, Stadium
• Standings
  Fields: Team, Points, Matches, Wins, Draws, Losses, Goals_For, Goals_Against, Goal_Difference

Later we can enrich the model with Top Scorers, Disciplinary Records, and even Attendance Data.

3. Importing Data into Power BI

Power BI allows several approaches:

• Get Data → Web: directly connect to an online table (e.g., league standings).
• Get Data → Excel/CSV: manually exported files from sports websites.
• Get Data → Web (API): connect to a football statistics API using custom queries.

For the first experiment, we will import the Campeonato Paulista standings table from Globo Esporte or FPF’s website.

4. First Visualizations

With only the Standings table, we can already create:

• A ranking table by team, points, and matches played.
• A bar chart comparing goals scored and conceded.
• A column chart with the goal difference per team.
• A simple line chart showing point progression per round.

These initial visuals provide the foundation to later integrate richer data, such as player statistics and match events.

5. Learning Path

This project will evolve gradually, documenting both successful and failed attempts. The learning process includes:

1. Step 1: Import standings from the Campeonato Paulista.
2. Step 2: Build a simple bar chart of points per team.
3. Step 3: Add more tables (matches, top scorers).
4. Step 4: Expand the dashboard with other competitions (e.g., Brasileirão).

Summary Table

References

• Campeonato Paulista on Wikipedia
• Power BI on Wikipedia