ข่าวกรองธุรกิจ Jobs

I run a retail operation and want to turn the raw data we collect into clear, practical intelligence. The goal is to understand why customers buy, how their habits shift over time, and which factors drive repeat purchases so I can refine merchandising, promotions, and loyalty efforts. I can provide any combination of purchase history, demographic information, or website interaction data once we agree on the best approach. Your task is to explore the data, surface patterns, and translate them into an easy-to-read report with actionable recommendations—think trend visualisations, segment profiles, and concrete next steps I can implement right away. Please outline the methods and tools you prefer for data cleaning, exploration, and visualisation (e.g., Python/Pandas, R, Tableau, Power...

Sales & Profitability Dashboard — Project Description Overview An interactive Excel-based dashboard that consolidates raw sales transaction data into real-time KPIs, breakdowns, and visualizations for tracking revenue, cost, and profitability performance across regions, product categories, time periods, and sales reps. Objective To give sales and finance stakeholders a single, self-updating view of business performance — eliminating manual pivot-table building and enabling faster, data-driven decisions on where revenue and margin are strongest or weakest. Key Features Live transaction table — a structured Excel Table capturing Date, Region, Category, Product, Sales Rep, Units Sold, Unit Price, and Unit Cost, with Revenue, COGS, Gross Profit, and Margin % calculate...

I need an end-to-end Tableau dashboard that puts sales performance front and center. The data set is ready; what I’m missing is the polished, interactive layer that lets managers explore results on their own. Here is what matters most to me: • Key metrics: Total sales and Sales by product must be clearly surfaced, with room to add growth rate later if we decide it’s useful. • Visuals: Combine Bar, Line, and Pie charts so users can switch perspectives without leaving the workbook. • Interactivity: Filters by region, product category, and time period, plus hover tooltips and drill-downs that reveal underlying tables. • Storytelling: A concise KPI banner that highlights highs and lows at a glance before users dive deeper. Deliverables • A package...

I have a single Excel/CSV master file that captures every employee movement in the organisation, and I need a dynamic Power BI dashboard built around it. The goal is simple: the moment I replace or append the source file, every visual should refresh without any extra work from me. What the report must show: • Total headcount • Employee attrition rate • New-hire and exit counts I want users to slice these numbers region-wise, department-wise, and role-wise through interactive filters. Clear trend lines, month-over-month comparisons, and a clean summary card layout are preferred so executives can grasp churn patterns at a glance. Deliverables 1. A PBIX file containing a tidy data model, DAX measures for the metrics above, and well-labelled visuals. 2. Automated refresh se...

Analyzed sales data using Excel, SQL and Power BI to identify sales trends, top-performing products, revenue insights and business performance. Created an interactive Power BI dashboard with KPIs and visualizations to help users understand the data and make better business decisions.

I manage our university’s Student Information System and need a technically savvy partner to keep it running at peak performance while we expand its capabilities. Day to day, the work ranges from fine-tuning system configuration, maintaining a clean permission hierarchy, and automating routine admin tasks, through to digging into database queries when the system slows down or an integration drops data. You’ll be hands-on with: • System configuration & ongoing management • User account lifecycle, roles, and permissions • Reporting, analytics, and custom queries Current pain points I want resolved quickly: • Intermittent performance slow-downs during high-traffic periods • Data integration failures between the SIS and our LMS/HR platforms ...

I have a dataset that needs to be explored in Excel to uncover clear, actionable marketing insights. Your task is to clean the data, build the right pivot tables or Power Query steps, and present trends, segments, and key performance indicators in easy-to-read charts and summaries. What I expect • A tidy, well-documented workbook with formulas or macros that I can reuse. • Dashboards or pivot charts highlighting customer segments, campaign performance, and any anomalies worth noting. • A short written summary (one page is fine) explaining the findings and suggested next steps. To help me choose quickly, please attach examples of previous work where you performed similar Excel-based marketing analysis. Screenshots or a brief description of the outcome are enough; no sen...