EJElias JimenezData + automation + decisionsAutomate your reports

Reporting automation · Power BI · Business intelligence

Stop spending hours building reports manually.

I help businesses turn recurring spreadsheets and raw data into automated, interactive dashboards—so leaders can see what matters and make better decisions faster.

Automate your reports View dashboard projects

6+ years with dataPower BI & advanced ExcelDominican Republic · Remote-ready

EXECUTIVE OVERVIEWBusiness performance

● Auto-refresh

Revenue$486K+12.4%

Gross margin34.8%+2.1%

Open A/R$72K−8.6%

Manual files Automated insight

Solutions built forSalesInventoryFinanceOperationsCustomersRecruiting

The problem

Still building the same reports every week?

When reporting depends on copying, reconciling, and rebuilding charts, your team spends its energy preparing information instead of using it.

Waiting days for reports

Combining files from departments

Correcting formulas and manual errors

Searching spreadsheets for answers

Updating the same charts every period

The transformation

I turn manual workflows into automated dashboards.

Your data is connected, cleaned, organized, and translated into consistent KPIs—giving management one interactive view that updates with minimal effort.

Connect scattered data

Automate recurring preparation

Monitor clear business KPIs

Find opportunities faster

Discuss your reporting process

Services

Better reporting systems, built around your decisions.

Not charts for chart’s sake. Each solution improves how information moves from source to decision.

Reporting Automation

Transform repetitive weekly and monthly reporting into a structured system that takes less effort to maintain.

Save reporting timeReduce manual workStandardize KPIs

Power BI Dashboards

Interactive management dashboards for sales, finance, inventory, customers, operations, HR, and recruiting.

Interactive analysisExecutive visibilityPeriod comparisons

Excel Automation

Improve existing workflows with Power Query, pivot tables, advanced formulas, and dashboard design.

Power QueryAdvanced ExcelRepeatable workflows

Data Cleaning & Transformation

Turn raw, inconsistent data into a reliable foundation for analysis and reporting.

Data qualityTransformationReliable analysis

BI Consulting

Identify the KPIs that matter and design a clearer, more efficient reporting approach.

KPI definitionProcess reviewReporting roadmap

Dashboard portfolio

Built to answer business questions.

Real portfolio projects focused on the problem, solution, and decisions—not only the visuals.

Finance

Power BI · Power Query · DAX · Excel

Expense Management Dashboard

Business problem

Expense data from multiple companies was stored in large Excel files, making analysis and comparisons difficult.

Solution & impact

A centralized dashboard makes spending patterns visible and supports faster financial decisions.

Cash vs. cardMonthly trendsTop expense typesYoY comparison

View project on LinkedIn

Sales

Power BI · DAX · Power Query · Data Modeling

Automotive Repair Sales Dashboard

Business problem

Management needed a faster way to monitor sales growth, customer value, discounts, and peak sales periods.

Solution & impact

An interactive dashboard converts transactional data into clear KPIs, comparisons, and trends.

MoM growthParts vs. laborTop customersSales periods

View project on LinkedIn

Sales

Microsoft Power BI

Automotive Dealer Sales Dashboard

Business problem

Dealership performance required manually reviewing spreadsheets across vehicles, salespeople, channels, and branches.

Solution & impact

A centralized dashboard reveals revenue drivers and makes dealership performance easier to monitor.

Gross marginTop modelsLead channelsBranch performance

View project on LinkedIn

Payments & Collections Dashboard screenshot

Finance

Power BI · Power Query · DAX

Payments & Collections Dashboard

Business problem

Multiple and partial payments tied to the same invoices made it difficult to track collections without duplicating invoice totals.

Solution & impact

A centralized dashboard accurately connects invoices and payment transactions, giving the business clearer visibility into cash collections, receivables, and outstanding debt.

Collection rateOutstanding balancesPayment methodsInvoice status

View project on LinkedIn

Client information is anonymized or modified where required.

About Elias

I make business data easier to trust—and easier to use.

I’m a Data Analyst and Business Intelligence professional with more than six years of experience across analytics, reporting, automation, dashboards, and business research.

My work connects technical execution with business context: defining the right KPIs, structuring messy data, and delivering reports managers can use confidently.

Connect on LinkedIn Follow on Instagram

Capabilities

Tools applied to real reporting problems.

Business Intelligence

• Power BI

• Tableau

• DAX

• Data visualization

Data Processing

• SQL

• Python

• Power Query

• Data cleaning

Reporting & Automation

• Advanced Excel

• Power Automate

• Microsoft 365

• SharePoint

Business Systems

• Salesforce

• Odoo

• ChatGPT

• Claude

How I work

From the current process to a system your team can rely on.

Understand the process

Map sources, manual tasks, frequency, and the KPIs management needs.

Connect & prepare

Clean, transform, and organize files, databases, and other sources.

Build the dashboard

Create an interactive view focused on important business questions.

Automate reporting

Configure a repeatable workflow with minimal manual intervention.

Spend less time preparing reports. Spend more time using them.

Learn data with me

Practical Excel & analytics tips.

Educational content demonstrates both technical knowledge and the ability to explain it clearly.

Excel Tip · Data Cleaning

Clean Names in Excel Instantly

Learn how NOMPROPIO and ESPACIOS can clean inconsistent names in seconds.

Watch on Instagram

Excel Charts · Data Visualization

Turn Excel Data into Clear Visual Stories

Use Excel charts to reveal trends, compare results, and communicate insights clearly.

Watch on Instagram

Excel Tip · Productivity

Fill Thousands of Formulas in Seconds

Double-click the fill handle to complete thousands of rows without dragging formulas manually.

Watch on Instagram

Power BI · Reporting Automation

From Manual Reports to Power BI

Transform recurring Excel reports into interactive Power BI dashboards that reduce manual work, centralize KPIs, reveal trends, and support faster business decisions.

Watch on Instagram

Power Query · Data Cleaning

Clean Messy Excel Data With Power Query

Use Power Query to remove blanks and duplicates, standardize text, correct data types, and create a repeatable cleaning process that refreshes automatically when new data arrives.

Watch on Instagram

Excel · Sales Analysis

Calculate Sales Growth in Excel

Calculate percentage growth between periods in Excel to compare performance, identify sales trends, and quickly spot declines.

Watch on Instagram

Follow @elias.djv

For recruiters

A data professional who understands the business behind the dashboard.

Open to Data Analyst, Business Intelligence, Reporting, and Power BI opportunities.

View LinkedIn Request resume

How much time does your team spend preparing reports every week?

If your team is repeatedly exporting data, updating spreadsheets, and rebuilding charts, there may be an opportunity to automate it.

Let’s automate your reporting

Start a conversation

Show me your current reporting process.

Tell me how your team prepares reports today. I’ll help identify where automation can reduce effort and improve visibility.

eliasjimenez0024@gmail.com +1 849-359-2837Santo Domingo, Dominican Republic · Available remotely