# Internal Dashboard

### PowerBI for UNESCO Data Analysis and Visualization

### 🚀 Getting Started

Power BI is UNESCO’s recommended platform for interactive data visualization and reporting. This guide will help you explore, build, and share dashboards that turn data into actionable insights.

#### ✅ Access the Platform

* Go to: <https://app.powerbi.com>
* Managed by the Division of Business Solutions (DBS)
* Use your UNESCO Microsoft 365 credentials to log in

***

### ✅ Before You Start

✔️ Check Data Availability – Make sure your data is clean, complete, and accessible (Excel, SharePoint, Dataverse, etc.)

✔️ Define Your Audience – Who will use the dashboard? What decisions will it support?

✔️ Clarify Your Questions – What do you want to learn or show with the data?

***

### 🏆 Dashboard Design Best Practices

1. Start with a Wireframe

Sketch your dashboard layout before building it. Focus on key indicators and user flow.

1. Use Consistent Visuals

✔️ DO:

* Use bar charts for comparisons
* Use line charts for trends
* Use cards for KPIs

❌ AVOID:

* Overloading with too many visuals
* Using pie charts for more than 3 categories
* Keep It Simple&#x20;
  * Limit each page to 4–6 visuals
  * Use filters and slicers to let users explore
  * Avoid technical jargon in labels and tooltips

***

### ⚙️ Technical Setup

#### ✅ Connect to Your Data

* Use Dataiku Postgres Connection to get data sources using [PGSQL\_AZURE\_ANALYTICS](https://dss-61c005b5-f304e2f4-dku.eu-west-3.app.dataiku.io/admin/connections/PGSQL_AZURE_ANALYTICS/) config on dev instance and on automation same connection name configure on prod instance.
* Use only Power Query to clean and transform data as an ultimate option

#### ✅ Enable Key Features

* Row-level security (RLS) - implemented on the CO2 air Travel Carbon Emissions. Add member to appropriate role (Full Access or Account view)

***

### 💼 Publishing & Sharing

1. Publish to Power BI Service&#x20;
   * Use the correct workspace
   * The target is to have one workspace per sector EDU, CLT, SCI, SHS, CI
   * Currently, the workspaces are:
     1. Workspace\_CLT
     2. Workspace\_ED
     3. Workspace\_DBS\_Carbon Emissions
     4. Workspace\_DBS\_Data-AI

2. Share with Stakeholders

✔️ Set permissions carefully (view/edit)

***

### 🧑‍💻 Role Definitions

\
✔️ Dashboard Designer – Builds the report in Power BI Desktop

✔️ Data Owner – Provides and validates the data

✔️ Data Analyst – Supports with modeling and DAX

✔️ Viewer – Consumes the dashboard for decision-making

\
Note these roles are currently managed by DBS Infrastructure unit. To provide limited access through RLS security, users must be after the Viewer role and be added to the right permissions role.

***

### ✅ Dashboard Checklist

Before Publishing:

☑️ Data is clean and up to date

☑️ Visuals are clear and labeled

☑️ Filters and slicers work correctly

After Publishing:

☑️ Refresh schedule is active

☑️ Users have access<br>

***

### ⭐ Final Tips

✔️ Design for the User – Think about what they need to see first

✔️ Tell a Story – Use visuals to guide interpretation

✔️ Keep It Dynamic – Use filters, slicers, and drill-throughs


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://unesco.gitbook.io/unesco-data-ai/tools/internal-dashboard.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.