비즈니스 인텔리전스 Jobs

My existing Power BI report pulls several large tables from Microsoft Dynamics 365 Business Central through the standard API. The model works, but the scheduled refresh now fails with frequent time-outs; reliability is my biggest concern. So far I have: • enabled incremental refresh on the largest tables • tuned a handful of queries • experimented with splitting data into smaller API calls None of these measures has eliminated the failure. I need an expert who can: 1. pinpoint the exact bottleneck within the current data model, gateway settings, or API calls 2. redesign the retrieval strategy so the report finishes every refresh window without timing out 3. leave me with a clean, documented PBIX (or dataflow) that follows best practice for query folding, partitioning, and ...

I need a small-to-mid-size piece of software that will fully automate an internal process. The exact workflow and data sources will be shared once we sign an NDA, but in broad strokes the task involves reading structured input, applying a set of business rules, and producing an export that can be fed straight into our existing system. The schedule is tight: I’d like a first usable build, complete with source code and basic documentation, delivered within seven days of project start. Because of that, I’m looking for someone who can point to relevant, real-world experience with similar automation projects—please highlight the most comparable work you’ve done and the technologies you used. If you’re confident you can turn around a clean, reliable solution o...

The project centers on a manually-entered sales spreadsheet that requires a full Excel-based analysis focused on monthly sales performance. I will supply the raw rows exactly as they come from our internal forms; they first need cleaning (duplicate checks, consistent date formatting, error spotting) before any insights can be trusted. Once the data is reliable, the workflow should move into sorting, filtering, and creating pivot tables that break revenue down by month, product line, and any other field that emerges as useful. Clear, professional charts—line, clustered column, or a pivot chart—must then visualise month-over-month results so trends and anomalies are unmistakable at a glance. Deliverables • Cleaned Excel file with all transformation steps traceable ...

I have a batch of Word documents that contain structured data—tables, lists, and figures—that all need to live in a single Google Sheet (fully Excel-compatible). First, every value has to be transcribed with 100 % accuracy, keeping the original wording for headers and notes. Once the sheet is complete, I also need a layer of data analysis: • Create clear pivot tables (or equivalent functions) that summarise totals, averages, and any obvious trends. • Insert simple charts where they help illustrate those findings. • Add a short written summary on a separate tab explaining key insights in plain language. No data comes from scans or handwritten sources—only the supplied Word files—so formatting should be straightforward. I will share the temp...

Project Objective We are building a complete reporting environment that connects our operational SQL database to a clean, intuitive Power BI reporting suite designed for two primary audiences: 1. Executive Leadership – high-level commercial insights and company performance 2. Operational Managers – actionable operational metrics and drill-downs The goal is to transform raw operational data into clear, reliable decision-making dashboards that update automatically and can be trusted across the organization. The final solution should deliver real-time business intelligence including revenue performance, operational activity, and commercial trends. ⸻ Data Environment Source System SQL Server operational database containing: • Sales transactions • Customers &bu...

I need an interactive Power BI dashboard built from Excel/CSV exports that I’ll provide. The sole focus is customer engagement, so the model and visuals should surface churn, retention, active-user trends, session frequency, and any other insight you recommend for quickly reading engagement health. You’ll connect the flat files, shape them in Power Query, build a clear data model, write the DAX needed for metrics and time intelligence, and design a clean, uncluttered layout that works on both desktop and the Power BI Service. The report must refresh seamlessly whenever I replace the source files and come with a short note explaining tables, relationships, and calculated measures so I can extend it later. Deliverables: • Finished .pbix file with the customer-engagement da...

I need a single, accountant-friendly dashboard inside Odoo that instantly tells me how we are performing. The scope is limited to the Accounting & Finance domain, and the dashboard must surface three real-time reports—Balance Sheet, Profit & Loss, and Cash-Flow—without requiring my team to click through multiple menus. Beyond the reports, the screen should let us act on the numbers. Integrated invoice management, expense tracking, and tax calculations all have to sit behind the same interface so users can drill down, raise an invoice, approve an expense, or preview a tax liability from one place. I’m already running Odoo; you can rely on standard Accounting and Studio features, custom modules, or a mix, as long as upgrades remain straightforward. Deliverables ...

I will turn your raw business data into a clean, reliable model and then build a modern Power BI—or, if you prefer, Excel—dashboard around it. Using SQL and Power Query I’ll handle the full preparation pipeline so every refresh runs automatically. The finished dashboard will surface your key sales, order, and performance indicators through intuitive charts, drill-through views, and slicers that non-technical users can explore with confidence. Colour palette, fonts, and layout will match your brand, and advanced filters will let you zero in on any segment or period in seconds. Deliverables • PBIX (or XLSX) file with documented queries and DAX formulas • Fully interactive report pages, mobile-friendly layout included • One-click refresh connection t...

I want to convert my current Excel file into a simple fleet management system for our bus operations. Right now we are creating a separate sheet for every day’s collection. Instead of that, I want a better structure where we only enter the daily data once and all reports are generated automatically. The system should have one main sheet called DATA ENTRY where we enter the following columns: Date Route No Bus No Driver Conductor Total Collection RFID Collection HSD Litres (diesel filled) Expense From this data Excel should automatically calculate: HSD Cost = HSD Litres × Diesel Rate (currently ₹91) Net Collection = Total Collection − Expense If Net Collection becomes negative, it should automatically appear in red. From the DATA ENTRY sheet I want Excel to automati...

Experience with Building Dashboards: I need someone who is experienced with building dashboards in Tableau using categorical data. This data will be extracted from Jira. There are 7 primary tasks. Each of these 7 tasks will be in one (1) of nine (9) states (i.e. State -1, State-2, State-3, State-4, State-5, State-6, State-7, State-8, State-9). Each task may have sub-tasks with 0 to 6 sub-states (i..e, Sub-state-0, Sub-state-1, Sub-state-2, Sub-state-3, Sub-state-4, Sub-state-5). The 7 primary tasks may have exceptions. These exceptions have 2 states (i.e., Except-1, Except-2). I need the following: 1. Sample Jira data presented in a dynamic Tableau dashboard using the above criterion. 2. Instructions on how to build the Tableau dashboard using live data extracted from Jira wit...

Project Brief – Customer Churn Prediction for Telecom Project Goal: The project aims to predict customer churn in the telecommunications industry. By identifying customers likely to leave, telecom companies can take proactive retention actions, reduce revenue loss, and improve customer satisfaction. Data Used: The dataset includes customer demographics, service subscriptions, contract details, billing information, and payment methods. Project Steps: Data Cleaning: Handling missing values and correcting inconsistencies. Exploratory Data Analysis (EDA): Understanding patterns and key factors affecting churn. Feature Engineering: Creating new variables to improve model performance. Model Building: Developing a machine learning classification model to predict churn. Technologies & To...

Project Brief – Customer Churn Prediction for Telecom Project Goal: The project aims to predict customer churn in the telecommunications industry. By identifying customers likely to leave, telecom companies can take proactive retention actions, reduce revenue loss, and improve customer satisfaction. Data Used: The dataset includes customer demographics, service subscriptions, contract details, billing information, and payment methods. Project Steps: Data Cleaning: Handling missing values and correcting inconsistencies. Exploratory Data Analysis (EDA): Understanding patterns and key factors affecting churn. Feature Engineering: Creating new variables to improve model performance. Model Building: Developing a machine learning classification model to predict churn. Technologies & To...

I developed an interactive BMW Global Sales Analysis Dashboard using Microsoft Excel to analyze sales performance across different regions, models, and time periods. The goal of the project was to transform raw sales data into a clear and insightful dashboard that helps users quickly understand business performance and trends. In this project, I performed data cleaning and transformation, then used Pivot Tables, Pivot Charts, and slicers to create an interactive dashboard. The dashboard includes key metrics such as: *Total Units Sold *Total Revenue *Average Car Price *Total Models Sold It also provides deeper insights through visualizations like: *Monthly sales trend analysis *Sales comparison by region *Revenue distribution by car model *EV growth trend over multiple years *Fuel pri...

I need a Power BI dashboard for leadership review. The primary focus is to visualize the organization chart. Requirements: - Connect to Excel spreadsheets - Create a comprehensive organization chart Ideal Skills: - Proficiency in Power BI - Experience with Excel data integration - Strong data visualization skills

Create an Org chart or org structure in Power BI Dashboard which includes below I want each manager’s (Manager 1) entire footprint which should include his: 1. Span of control (Direct Reports and Indirect Reports) for each manager under Manager 1 2. Span by Location 3. Span by Layers 4. Open and Filled positions 5. Drill down org structure Example: Rahul Mehta’s Span of control, Span by Location, his layers, how much open and closed positions does he have. If you have experience designing hierarchy visuals—Org Chart custom visuals, decomposition trees, graphs, cards or similar—let me see a sample when you respond. I’m ready to provide the spreadsheets as soon as we agree on the approach, and I’m looking forward to a clean, user-friendly result.

I need a PowerBI developer to create reports using data from a MySQL database. The reports will cover financial, sales, and operational metrics. Key Requirements: - Connect PowerBI to MySQL database - Develop comprehensive financial, sales, and operational reports - Ensure reports are interactive and user-friendly - Experience with PowerBI and MySQL is essential Ideal Skills and Experience: - Strong background in PowerBI - Proficient in MySQL - Experience in creating financial, sales, and operational reports - Ability to deliver within budget and timeline

I already have a clean, curated dataset sitting in Salesforce CRM Analytics . What I now need is an engaging dashboard that turns those rows into insight. The data is loaded and modeled, so the task is purely visual: build the bar and line charts I specify, arrange them into a single interactive dashboard, and apply any filters or bindings required so users can drill down without delays. The subject matter is banking-related, so every chart should highlight the metrics that matter to that sector—think revenue flow, account growth, and other teller-to-boardroom indicators—yet all of the source fields are ready for you to pick up. I will share a short spec for each widget; you translate it into lenses, add the SAQL tweaks if needed, and publish the finished dashboard to our CRM ...

I need an interactive HR analytics dashboard that lets me explore employee attrition, workforce demographics, and job-satisfaction trends in one place. The finished product should surface essentials such as total headcount, overall attrition rate, age distribution, department-level turnover, education-field breakdowns, and satisfaction scores, all with drill-through and filter capability so the HR team can quickly pinpoint patterns behind employee exits and make data-driven decisions. I marked “data analytics” as the preferred environment because I care more about seamless insight discovery than about whether the final interface is strictly web-based or desktop; feel free to recommend the most practical hosting approach as long as the experience remains smooth and secure. Pow...

I am putting together a comprehensive inventory-management report that draws on several different raw data sources and I need your help building it in Advance Excel, enhancing it with Macros/VBA automation, and visualising the results in Power BI. Here is what I have in mind. Multiple CSV and spreadsheet feeds will be consolidated, cleaned and reshaped inside Excel. Macros or VBA routines should automate the refresh and mapping process so I can drop new files into a folder and have the workbook update itself without manual intervention. From there, the prepared tables need to flow into a Power BI model that produces an at-a-glance dashboard highlighting current stock levels, inbound and outbound movements, and any exceptions that require action. I will supply sample data so you can design...

BI Report Builder — React/FastAPI (Tableau-experienced only) We're building a visual, drag-and-drop report builder inside our enterprise HRMS SaaS — think simplified Tableau embedded in a web app. If you've only done basic dashboards, this isn't the role. What we're building: A canvas where users drag data entities (employees, invoices, timesheets, etc.), connect them visually, pick columns, configure chart types, and generate cross-entity reports — all in-browser without SQL knowledge. What's already done: Backend already supports multi-source SQL JOINs with full injection protection and tenant isolation 22 pre-aggregated data entities with 17 predefined valid join relationships Chart rendering components already built (bar, line, pie, area, ...