Data Analytics Portfolio

Turning data into
business decisions.

Digital Media Technology student passionate about finding patterns in data and communicating insights in a clear, visual way.

SQL Power BI Excel Data Visualization Business Intelligence
View projects LinkedIn

Tools

Technical stack

SQL

Queries, aggregations, joins, subqueries and exploratory analysis on relational data.

📊

Power BI

Interactive dashboards, KPIs, basic DAX and visual storytelling with data.

📋

Excel

Pivot tables, advanced formulas, charts and data cleaning.

🔍

Data Analysis

Metric definition, trend interpretation and generation of business insights.

Portfolio

Analytics projects

01 / 03

Sales Analysis — Olist E-commerce

Completed

Full exploratory analysis of a Brazilian marketplace with ~100,000 real orders. Identified revenue trends, most profitable categories and mapped regional customer profiles.

DatasetOlist (Kaggle)
Volume~100k orders
Period2016 – 2018
SQLPower BIE-commerceEDA
Monthly revenue trend Top 10 categories by revenue Avg order value by state Customer satisfaction scores Regional delivery time Payment method preferences
96.4k
Total Orders
R$13.6M
Total Revenue
R$140.88
Avg Order Value
77%
Satisfied Customers

Key Results

Monthly Revenue Trend

Revenue growth from Jan 2017 to May 2018

Top 5 Categories by Revenue

Total revenue in R$ thousands

Customer Satisfaction

Distribution of review scores (1–5)

Payment Methods

Share of orders by payment type


View on GitHub →
02 / 03

HR Analytics — IBM Dataset

Completed

Analysis of employee profiles and factors associated with turnover at a tech company. Identified patterns to help HR make more strategic decisions about talent retention.

DatasetIBM HR Analytics (Kaggle)
Volume1,470 employees
FocusPeople Analytics
SQLPower BIHRTurnover
Overall attrition rate Turnover by department Salary vs satisfaction Age & tenure patterns Work-life balance score Retention risk profile
1,470
Total Employees
16.1%
Attrition Rate
$2,045
Income Gap (left vs stayed)
39.8%
Sales Rep Turnover

Key Results

Attrition by Department

Attrition rate % per department

Attrition by Age Group

Younger employees leave more often

Job Satisfaction vs Attrition

Lower satisfaction = higher turnover

Attrition by Tenure

First year is the most critical


View on GitHub →
03 / 03

Churn Analysis — Telecom Dataset

Completed

Study of the profile of customers who cancel a telecom service. Built a data-driven story identifying risk factors and concrete business recommendations for reducing churn.

DatasetTelecom Churn (Kaggle)
Volume~7,000 customers
FocusCustomer Retention
SQLPower BIChurnStorytelling
Overall churn rate Churn by contract type Churn by tenure Revenue at risk High-risk customer profile Business recommendations
7,043
Total Customers
26.5%
Churn Rate
$139k
Monthly Revenue Lost
812
High-Risk Customers

Key Results

Churn by Contract Type

Month-to-month drives most cancellations

Churn by Tenure

New customers are most at risk

Churn by Payment Method

Electronic check has highest churn

Impact of Tech Support

Services drastically reduce churn


View on GitHub →

About me

Who I am

I'm Caio Breder Bernardo-de-Lima, a Digital Media Technology student with a passion for turning data into decisions. I'm building my portfolio with projects based on real-world datasets.

I have hands-on experience with SQL for data extraction and analysis and Power BI for visualization. I'm always learning and applying what I study in practical projects.

I'm looking for a Junior Data Analyst opportunity where I can contribute with analyses that generate real business value.

3
Portfolio projects
2
BI tools
100k+
Records analyzed
Will to learn

Let's talk?

I'm open to internship and junior data analyst opportunities.