Interactive and Dynamic Excel Dashboard by Pietro MacorigInteractive and Dynamic Excel Dashboard by Pietro Macorig

Interactive and Dynamic Excel DashboardPietro Macorig

Cover image for Interactive and Dynamic Excel Dashboard

Hi, my name is Pietro, an aspiring management engineer in Italy, and I will build custom dashboards for you.

I will transform your raw data into a modern, dynamic dashboard enriched with interactive filters, making it easy to understand and utilize.

I will:

Data clean the dataset (such as removing duplicates);

Use Power Query, merging different queries;

Create summarizing pivot tables;

Create different graphs/charts suiting the data;

Insert data filters and timeline;

Create an appealing, interactive, and functional dashboard.

Through our collaboration, you will gain the ability to make data-driven decisions that will boost your business.

What's included

Data Cleaning

With the help of Power Query and/or formulas, I will clean your datasets.

Braistorming

If you don't have an idea of how to visualize your data, I will examine your dataset and decide which graphs suit best.

Data Visualization

Creating Pivot Tables, and filters, using conditional formatting, and creating the final dashboard

Revision

Answer any of your questions to make sure you are satisfied with my work.

Example work

Employee Dashboard

Supermarket Sales Dashboard

Car Sales Dashboard

Pietro's other services

Cover image for I’ll teach you how to manipulate and visualize data in Excel

I’ll teach you how to manipulate and visualize data in Excel$20 /hr

Starting at$40

Duration4 days

Tags

Microsoft Excel

Data Analyst

Data Visualizer