Inteligență de afaceri Jobs

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

I need a Power BI Fabric trainer for online live sessions. Each session should last 1 hour, 3 X a week for min 10 to 12 weeks, Total hrs min 60 hrs Ideal skills and experience: - Expertise in Power BI and Power BI Fabric. - Experience in delivering online training sessions. - Ability to engage and teach effectively. - Real Time Project should involve the following -Build a Fabric Data pipeline for real time sales data, Develop Power BI dashboards with interactive KPI, DAX and AI insights, Fabric Data with Power BI Reporting, Case studies Finance, Retail and Healthcare data sets, Tools : MS Fabric Analytics, SQL & Python for Data handling, Azure Cloud, Excel and Advanced Analytic Tools - Prepare students for MS Fabric and Power BI certification - Resume preparation and post job supp...

I need to take data from 2-3 spreadsheets and create different reports.

I have a set of weekly-refreshed sales figures that I want to explore in depth through a single, well-structured Excel workbook built around Power Pivot. The file must let me load new data each week, refresh the model with one click, and instantly see the impact across all reports. Here is what I need you to put in place: • Robust Power Pivot data model that ingests my raw sales tables and maintains clean relationships • Import and export routines (ideally via Power Query) so I can pull in CSV files and, when required, push summarized data back out • A suite of advanced DAX calculations: period-over-period growth, cumulative totals, top-N products, regional contribution, and any other metrics that help reveal trends • Interactive visualizations—charts, sli...

Headline: Driving Decisions with Data: The BMW Sales Analytics Dashboard Luxury brands don't just sell products; they sell experiences. But behind every premium experience is a massive engine of data. I’ve built a comprehensive BMW Sales Dashboard in Power BI to analyze how one of the world’s most iconic automotive brands performs across different markets. This project isn't just about the "Ultimate Driving Machine"—it’s about the Ultimate Data Insights. Key Insights Captured: Model Performance: Identifying which series (3 Series, X5, i7) is leading the revenue charts. Regional Deep-Dive: Mapping sales distribution across global territories to spot emerging markets. Engine Type Trends: Analyzing the shift from traditional Internal Combustio...

I’m looking for a freelancer who can guide me in learning integration and configuration for Elite 3E, as well as Intapp, iManage, and Bhoomi along with database configuration and scheduling jobs/ task over databases. The ideal mentor can walk me through APIs in a live environment and help me understand how these applications work in practice, directly related to my day-to-day job responsibilities.