Inteligencia comercial Jobs

Operations Data in my last company Collaborate with business stakeholders to gather functional requirements and translate them into scalable BI reporting solutions. • Designed and implemented robust data integration workflows by consolidating data from Excel, SharePoint, Salesforce, and SQL Server into a centralized reporting model. • Performed comprehensive data profiling, cleansing, transformation, and modeling using Power Query (M) to deliver high-quality, analysis-ready datasets. • Designed and developed dynamic dashboards using custom visuals, hierarchical drill-down structures, geo-maps, and drill-through features to enhance analytical depth and improve strategic business decisions. • Proficient in advanced DAX (YTD, QTD, MTD, YoY, MoM), performance optimization ...

I need a single, highly-interactive MIS dashboard built in Excel that can read from several existing Excel workbooks and turn that raw data into clear, management-ready insights. The solution should consolidate the files automatically, refresh on demand, and surface the most important KPIs through slicers, dynamic charts, and drill-down summaries. Power Query, PivotTables / Power Pivot, advanced formulas, and—where it genuinely adds value—VBA are all welcome so long as the final workbook remains portable and easy for non-technical colleagues to maintain. At the click of a button every metric must update, ready for export to PDF or direct screen presentation at our weekly management meeting. Deliverables: • A fully-functional .xlsx/.xlsm dashboard that connects onl...

Built an interactive Power BI dashboard analyzing HR data for over 1000 employees across 3 countries and 7 departments. The dashboard tracks key workforce metrics including total salary, average age, hiring trends, gender diversity, and bonus distribution. Raw data was cleaned and transformed using Power Query, with custom DAX measures built for accurate KPI calculations. The dashboard includes interactive filters (Department, Gender, Job Title, Country, Business Unit) allowing users to explore the data dynamically, along with visualizations like salary distribution charts, employee count by department, global employee distribution maps, and age group segmentation. Designed with a clean, professional layout suitable for business decision-making

I need a customized excel template, that I can input data each week to track 4 variables in a line graph. Build it in Excel.

I want to pick up the phone, reach out to a handful of small businesses here in the United States (no more than ten), and come back with two very clear pieces of intelligence: • Exactly what services they currently offer • Any candid customer feedback they can share—how clients perceive them, what’s working, what isn’t You’ll handle the entire calling cycle: sourcing the right decision-maker, making a concise but friendly inquiry, and recording answers in a short Google Sheet or Excel file. Please add a brief call log so I can see when each conversation happened and note any voicemails or follow-ups required. A U.S. phone number and native-level English are essential because these owners expect a local caller. Courtesy, persistence, and clean data...

I need a clean, interactive dashboard in Power BI that turns my raw sales data into clear, actionable insights. The core dataset is our historical sales (product, region, channel, time-series), and I want the visuals to spotlight trends, seasonality, and any anomalies so my team can make decisions quickly. Besides the sales figures, I also have customer feedback captured from Instagram. If you can weave that social-media sentiment into the same report—perhaps as a supplementary page or a slicer-driven overlay—that would be ideal, but the primary focus remains the sales story. You will receive: • CSV exports of the sales tables (fact and dimension files) • A JSON feed of the Instagram comments already tagged for sentiment Deliverables I expect: • A Power BI...

1. Project Overview / Heading Title: Zomato Restaurant Data Analysis Dashboard Domain: Food Delivery / Restaurant Analytics Tool Used: Power BI (dashboard UI se clear hai) Purpose: Zomato platform par available restaurants ka comprehensive analysis — price, ratings, delivery time, city & area distribution, high/low rated restaurants, etc. 2. Problem Statement Zomato jaise platforms par hazaron restaurants hote hain. Management / business stakeholders ko yeh samajhna mushkil hota hai ki: Kaunse cities / areas mein zyada restaurants hain? Average price range kya hai aur kaunse cuisine expensive hain? High-rated vs Low-rated restaurants ka distribution kaisa hai? Delivery time aur ratings ka relation kya hai? Overall business health (total restaurants, average rating, average price...

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...