Mariana's Portfolios

Project Portfolio in Power BI - Dashboards from different areas developed for decision making.

All data is fictitious.

This page contains my completed Dashboards:

Projects Dashboard
Quality Dashboard
Marketing Dashboard

Projects Dashboard

Dashboard created for a fictitious company.

Project Case

Develop a weekly report.

The main objectives of this dashboard:

S curve with work progress.
Management of the status of activities (completed, in progress and not started).
Opening of activities open in the week.
Identification if there is something overdue.
Workload of critical resources and activities.
Schedule control.
Next steps.

Database:

General Schedule - Excel

Below you can check the Dashboard in a 100% interactive way.

Quality Dashboard

Dashboard created for a fictitious company with a database imported from Excel.

The company sells inputs for chemical industries. In the last year the company presented an increase in the rate of complaints from its customers.

The main objectives of this dashboard:

Identify which customers are impacted by this service failure.
What are the causes of the problem.
Decide where to invest the resource (time and team).
Follow the action plan.

Data base:

History of Orders and identification of which were not fulfilled.
Service level control.
Customer base.

Below you can check the Dashboard in a 100% interactive way.

Marketing Dashboard

Dashboard created for a fictitious company.

The fictional company Beauty Shop sells cosmetics and has a large e-commerce and they want to have better control and visibility of performance of advertisements to direct the company's strategies.

The main objectives of this dashboard:

Track spend (BRL) and CPC (Cost Per Click) over time - both for Facebook ADS and Google ADS.
Control total investments in online ads and understand the representativeness (%) by channel (Facebook/Google).
What is the CAC (Customer Acquisition Cost).
How much is the ROAS (Return On Advertising Spend) - return obtained through campaigns.
How is the lead conversion funnel by stage of the conversion process.
(Impressions, Reaches, Clicks and Sales).

Data base:

Facebook Campaign History - Excel
Google Ads - csv
E-commerce sales base - Excel

Below you can check the Dashboard in a 100% interactive way.

Page updated

Google Sites

Report abuse