INTL
Freelancer
어려움
외주
원격 가능
Automated Tableau Sales & Expense Dashboards
예산
$12~$18 EUR
예상 기간
1~2개월
난이도
어려움
기술 스택
Tableau
Tableau Prep
Excel
ETL
Data Modeling
Data Visualization
Business Analysis
Automation
AI 분석 요약
기존 스프레드시트와 회계 시스템의 판매 및 비용 데이터를 활용하여 Tableau에서 자동화된 대시보드를 구축하는 프로젝트입니다. 지역별 판매 및 급여 지출을 명확하게 보여주고, 데이터 준비(ETL) 및 자동 새로 고침 기능을 구현하며, Tableau, 데이터 모델링 및 자동화 역량이 필수적입니다.
프로젝트 원문 설명
I need automated dashboards built in Tableau that pull our sales and expense data directly from our existing spreadsheets and accounting system. The key focus is a clear, interactive view of sales by region alongside salaries & wages so management can spot trends quickly without manual reporting.
Source files arrive weekly, so the solution must refresh on a schedule with zero manual intervention. If you can streamline the data prep inside Tableau Prep or a similar ETL step, even better. While the initial scope covers sales-by-region and salary costs, I’m open to expanding to other metrics (total revenue, marketing spend, etc.) once the core framework is stable.
Acceptance criteria
• One Tableau workbook containing:
- Sales dashboard showing regional breakdowns, drill-through to individual territories, and YoY comparison
- Expense dashboard focused on salaries & wages with month-to-date and forecast views
• Automated data refresh (live connection or nightly extract) and documented setup steps
• Clean, intuitive layout that works on desktop and mobile Tableau views
• Handover of the .twb/.twbx file plus any Prep flows, with brief video or written walkthrough of key calculations and filters
If this matches your expertise in Tableau, data modeling, and automation, I’d love to see your approach and timeline.
Source files arrive weekly, so the solution must refresh on a schedule with zero manual intervention. If you can streamline the data prep inside Tableau Prep or a similar ETL step, even better. While the initial scope covers sales-by-region and salary costs, I’m open to expanding to other metrics (total revenue, marketing spend, etc.) once the core framework is stable.
Acceptance criteria
• One Tableau workbook containing:
- Sales dashboard showing regional breakdowns, drill-through to individual territories, and YoY comparison
- Expense dashboard focused on salaries & wages with month-to-date and forecast views
• Automated data refresh (live connection or nightly extract) and documented setup steps
• Clean, intuitive layout that works on desktop and mobile Tableau views
• Handover of the .twb/.twbx file plus any Prep flows, with brief video or written walkthrough of key calculations and filters
If this matches your expertise in Tableau, data modeling, and automation, I’d love to see your approach and timeline.
Freelancer에서 원본 확인
원본 보기