Lohane Tikamori

Data Analyst · Business Intelligence

Data into smart information.

I turn your company's spreadsheets and reports into clear dashboards in Power BI and Excel. You see where you earn, where you lose and where you fall behind, and you decide with numbers.

  • Almost 9 years in administration and finance
  • Almost 3 years in digital marketing
  • Power BI · Excel · Power Query · DAX

What I do

Every job starts with a question from the owner. The dashboard exists to answer it.

  • Management dashboards

    Sales, finance, purchasing, HR and logistics on one screen, built from the spreadsheets you already use.

  • Clean, joined-up data

    I combine and clean loose spreadsheets and system exports with Power Query, so the numbers add up.

  • Customer profiles

    Who buys, who drifts away and who could buy more. A base for marketing campaigns that hit.

  • Reports that lead to decisions

    Every delivery comes with the findings in plain words: what happened, why it matters and what to do.

How it works

  1. Conversation

    You tell me which decision you need to make and what data you already have.

  2. Organisation

    I gather and organise the data from copies of your spreadsheets.

  3. Dashboard and walkthrough

    You get the dashboard, and I explain what it shows and what to do about it.

Projects

Dashboards built in Power BI and Excel training programmes, using sample datasets. No client data appears here.

Purchasing

Power BI Intensive · Hashtag

QuestionWhich suppliers deliver on time, and which ones save money?

Highest costs

JanFebMarAprMayJunJulAugSepOctNovDec

Biggest savings

JanFebMarAprMayJunJulAugSepOctNovDec

What the dashboard showed

  • Northshore has the shortest average delivery delay.
  • Minerva brought the largest savings.
  • June, August and November had the highest costs.
Power BI · Power Query · DAX

Finance

Power BI Intensive · Hashtag

QuestionHow does money move through each bank?

37.58%margin
44.04%by PIX

What the dashboard showed

  • 37.58% profit margin at the selected bank.
  • 2,725 transactions, 1,200 of them by PIX instant payment.
  • March and September were the most profitable months.
Power BI · Power Query · DAX

Human Resources

Excel course · Hashtag

QuestionWho are the employees, and why do they leave?

Turnover 7.26%

0%Target 3–4%10%

What the dashboard showed

  • 7.26% turnover, above the 3–4% target.
  • Administration has 58 employees, 23 of them interns.
  • 49% of employees are based in São Paulo.
Excel

Sales

Excel course · Hashtag

QuestionWho sells, where, and how do customers pay?

North region, the top seller
R$ 26,700
best seller of the year
R$ 20,400
paid by credit card
R$ 51,300

What the dashboard showed

  • August and October passed R$ 9,000 in sales.
  • Most payments were by credit card.
  • The dashboard compares sellers, regions and months.
Excel

Revenue and Logistics

Power BI workshop · Empowerdata

QuestionWhere do deliveries run late, and why do products come back?

63.27%late deliveries

What the dashboard showed

  • More than half of the deliveries were late.
  • Three drivers accounted for most late orders.
  • Most returns were wrong or damaged products.
Power BI · Power Query · DAX

Audience profile

Excel workshop · Simplifica Treinamentos

QuestionWho signed up for the free course, and who is likely to buy the paid one?

  • Women60%
  • Basic Excel only58.33%
  • Seeking promotion28.59%

What the dashboard showed

  • Most only know basic Excel: there is demand for the paid course.
  • São Paulo leads, with 2,515 sign-ups.
  • Recommendation: campaigns aimed at this audience at the next events.
Excel

Bank Marketing

Excel for Data Analysis · Escola Preditiva · 2025

QuestionWhat does a buyer of the bank's investment products look like?

  • Age
  • Job
  • Marital status
  • Education
  • Credit
  • Mortgage
  • Loan

What the dashboard showed

  • Exploratory analysis with formulas and statistical charts.
  • Findings turned into a report for the marketing team.
Excel
Lohane Tikamori

About me

I hold a degree in Business Administration from Universidade Paulista (2011). I worked almost 9 years in administration and finance and almost 3 years in digital marketing.

So I read a dashboard like someone who looks after the cash and the operation, not only like someone who makes charts. A number only matters when it helps someone decide.

Today I specialise in data analysis, with Google's Advanced Data Analytics programme (Coursera) and training in Power BI and Excel.

Tools

  • Power BI
  • Power Query
  • DAX
  • Excel

Shall we talk?

Tell me which decision is hard to make in your business. I will reply saying whether the data you already have can answer it.

lohane@tikamori.com

Adds my name, email and website to your phone's contacts. Online. I work in Portuguese; English by email.

Purchasing
Purchasing: See the original dashboard

Image of the original dashboard. Tap outside or Close to go back.

Finance
Finance: See the original dashboard

Image of the original dashboard. Tap outside or Close to go back.

Human Resources
Human Resources: See the original dashboard

Image of the original dashboard. Tap outside or Close to go back.

Sales
Sales: See the original dashboard

Image of the original dashboard. Tap outside or Close to go back.

Revenue and Logistics
Revenue and Logistics: See the original dashboard

Image of the original dashboard. Tap outside or Close to go back.

Audience profile
Audience profile: See the original dashboard

Image of the original dashboard. Tap outside or Close to go back.

Bank Marketing
Bank Marketing: See the original dashboard

Image of the original dashboard. Tap outside or Close to go back.