Powerpivotlavori

Filtro

Le mie ultime ricerche
Filtra per:
Budget
a
a
a
Tipo
Competenze
Lingue
    Stato del lavoro
    155 powerpivot lavori trovati, prezzi in EUR

    I am looking for a freelancer who can build a data model in Power Pivot using 4 source files in Excel format and create a specific output layout in the form of a Power Pivot. - I have attached the 4 source files - I have attached a file that sketches how I want the output layout to be. - And to do that, I want to build a data-model in Excel using PowerPivot, and create a PowerPivot using data from each of these 4 sources, to match the desired layout. Skills and Experience: - Proficiency in Power Pivot and Excel - Strong understanding of Excel Manage Data Model from Power Pivot - Experience with creating Power Pivots - Experience with Power Query - Ability to work with multiple source files and integrate them into a single data model in Excel

    €126 (Avg Bid)
    €126 Offerta media
    29 offerte
    Powerpivot - Terminato left

    Online help for powerpivot. Creating in assisting mode a mapping link (like Vlookup) with chart of accounts data in the General ledger journal.

    €19 (Avg Bid)
    €19 Offerta media
    59 offerte
    HR Dashboards -- 2 Terminato left

    Tech stack: Power Bi Tools , Desktop ,Services Data Modelling, Data Editing. Objective : To Creating a report a Sales Analysis with the help of Power BI Tools, Desktop and Services. Solution : Gathering a data into files then I applied Power Query Editor to transforming or clean the data. after that i created a Data modeling using PowerPivot table to find relationship of the table. after that all cleaning and modeling Process I did Data Visualization to creating a interactive reports and publish a Power Bi services

    €95 (Avg Bid)
    €95 Offerta media
    36 offerte
    HR Dashboards Terminato left

    Tech stack: Power Bi Tools , Desktop ,Services Data Modelling, Data Editing. Objective : To Creating a report a Sales Analysis with the help of Power BI Tools, Desktop and Services. Solution : Gathering a data into files then I applied Power Query Editor to transforming or clean the data. after that i created a Data modeling using PowerPivot table to find relationship of the table. after that all cleaning and modeling Process I did Data Visualization to creating a interactive reports and publish a Power Bi services.

    €274 (Avg Bid)
    €274 Offerta media
    27 offerte

    Hi, I have got stuck on a Powerpivot task, and need someone to let me know the correct formula. I just want to sum the rows below a subtotal. At the moment it keepts recalculating dynamically. Each row is calculating the mix which is margin - price impact - volume. The issue is that volume is calculated dynamically so a new average unit cost is calculated for all profuct groups when I use the "All" function, where as I just want to add the numbers/rows underneath, using the average unit cost at those levels. So simply I want to add the rows below without it recalculating and working out a new average when I use the ALL function, I have tried Sumx but to do success. I believe for a dax expert this is an easy issue to resolve.

    €27 (Avg Bid)
    €27 Offerta media
    3 offerte
    Power BI Expert Terminato left

    Job Summary Create and manage BI and analytics solutions that turn data into knowledge. This includes developing, maint...concepts, i.e. OLAP processing, capacity planning, performance tuning and administration dimensions, hierarchies, aggregations, measures, KPI’s, calculations, storage and partitions, etc. Strong working knowledge of Microsoft Business Intelligence and database technologies; SSRS, SSIS, SQL Server 2014, T‐SQL Knowledge of other Microsoft technologies e.g. ASP.Net, , SharePoint, PowerBI, PowerPivot, Excel Services, Common Data Service, PowerAutomate (Flow), etc. Possess the ability to remain flexible in a quickly changing environment Excellent organizational skills including multitasking and prioritizing Strong analytical and problem‐solving capabilitie...

    €20 / hr (Avg Bid)
    €20 / hr Offerta media
    35 offerte

    I need to prepaper powerpivot excelsheet

    €20 (Avg Bid)
    €20 Offerta media
    36 offerte

    I am trying to create some excel PowerPivot measures that will keep a running total of a project sales and cost, but the calculations do not stay running when I use slicers.

    €34 (Avg Bid)
    €34 Offerta media
    25 offerte

    I have created an exel file (Timesheet3.6). Now I want to create another file (Timesheet3.7_test) but this time use power pivot instead of just excel tables. I have completed almost all the project but I can not find how to use a statement in DAX to do the same thing that I have done with excel formulas. In the excel formula (in the Timesheets3.6 file) I used =IF(AND(B2=B1;AF2<>AF1);(AR1+1);IF(AND(B2=B1;AF2=AF1);AR1;IF(B2<>B1;1))) In the original Timesheet3.6 file, this function exist in sheet 'ReportExt1' in column 'sequence'. I want to replce this formula in DAX in the Timesheets3.7_test file in the power pivot table that I created

    €20 (Avg Bid)
    €20 Offerta media
    9 offerte

    I have a simple Excel table with subtotals and multiplecolumns that I want to flatten to I can use the data into a pivot table. The table to change is in Sheet = 'MASTERDATA' it will look like sheet='Transformed' You will keep the link permanent so any change to MasterData will reflect in Transformed Minor challenge is that Masterdata has 3 headers per column

    €17 (Avg Bid)
    €17 Offerta media
    3 offerte

    Need to update a existing power query file

    €14 (Avg Bid)
    €14 Offerta media
    8 offerte

    Hi, I am looking for those with strong experience in visual formatting with MS Office packages - mainly Excel for formatting a number of files as per specified formats. Some help in organising and sequencing data within the documents may be required. High degree of attention to detail and quick to understand and implement is critical. In case i reach out, shar...required. High degree of attention to detail and quick to understand and implement is critical. In case i reach out, share the following at the earliest 1. Mention what kind of MS office documents have you worked on 2. What formatting improvements did you do in Excel 3. Sample work and how much time taken for it 4. Have you created visualisation and dashboards in excel 5. Are you familiar with Powerpivot and slicer ...

    €76 (Avg Bid)
    €76 Offerta media
    12 offerte

    Ich möchte eine grafische Auswertemöglichkeit von zukünftig geplanten Lagerbewegungen zu aktuellem Lagerbestand und geplanten Bestelleingängen. Die Lagerbewegungen pro Artikel bzw. Warengruppe und pro Monat aus der Vergangenheit sollen mit einem prozentualem Steigerungsfaktor (positiv oder negativ) in die Zukunft übernommen werden. Das sind also die geplanten Abgänge in der Zukunft. Parallel zu diesen Balken pro Monat soll der aktuelle Lagerbestand und den geplanten Wareneingängen aus Bestellungen als Balken dargestellt werden. Wenn dann die geplante Abgangsmenge minus dem Lagerbestand und geplanten Wareneingängen negativ wird, sieht man eindeutig wann in Zukunft spätestens wieder ein geplanter Wareneingang sein sollte. Die historischen Lagerbew...

    €127 (Avg Bid)
    €127 Offerta media
    6 offerte

    ...Automatically update of data in timely interval; - Automatically send e-mails to clients with attached dashboard/reports and preferably also auto questions based on retrieved data; Maybe in near future i want to visualize the dashboards/reports in PowerBI. Required: - Respond quick to tasks; - Have some knowledge of accounting/finance; - Excel VBA knowledge; - Powerautomate, PowerBI, Powerquery, PowerPivot knowledge;...

    €16 / hr (Avg Bid)
    €16 / hr Offerta media
    23 offerte

    Need to create a dashboard in Excel with forecast and shipped quantities - Do comparison across three versions of forecast with one actuals across multiple levels. Need someone with supply chain knowledge and powerpivot, marcos, VB to write some automated codes to refresh data every time data is loaded to the file. Also need to understand the data is too big - So need to make it work smoothly on excel.

    €84 (Avg Bid)
    €84 Offerta media
    30 offerte

    Hi, while I am am a fairly advanced Excel user, I am still starting off with PowerBI. While a lot of my skills with PowerPivot transfer, I just do not have the time to figure out this specific ask in the time frame I need it.

    €396 (Avg Bid)
    €396 Offerta media
    24 offerte
    API in Excel Terminato left

    Requirement: - I need to collect historical price data from the Binance Crypto exchange. - I require this information to be available in Excel Powerpivot and to be refreshable as and when new information is required. - This information is provided in an API (see ). - All the fields available from this API needs to be incorporated into the Powerpivot database. - I require this information for BTC/USD only. - I would need this information per minute over a 4 year period (1 September 2016 onwards). Should you wish to respond bear in mind: - I am not looking for the fastest response or the cheapest response - but will give this work to the person who has done adequate research and can

    €120 (Avg Bid)
    €120 Offerta media
    13 offerte

    I need Excel expert to help me set up data feed (Atmosvc) to Powerpivot and help me make pivot reports, I have the login details. Its showing error and I may be doing some stupid mistake.

    €18 (Avg Bid)
    €18 Offerta media
    59 offerte

    1. we need a dashboard in excel from SQL database 2. SQL database is approx 50 lac rows 3. Reason for excel : so that we can make small changes at our end 4. SQL database is imported in PowerPivot – added calculated column for working 5. Make sure – we can change the source of the database – on the file (header will be the same) 6. For few calculations we require data from another table – have linked using PowerPivot 7. Output : we need a utility to export the dashboard to pdf – for 1 particular filter(sales person) in bulk – (to avoid print as pdf manually for each sales person) – should be visually good looking and mobile friendly. ATTACHED – IS JUST A ROUGH CUT – will require much more detailed calculations – ...

    €260 (Avg Bid)
    €260 Offerta media
    12 offerte

    Excel guru needed to set up a consolidated data model, based on the followi...avrg. FX rate per month) Based on these inputs, I have a "Cockpit" Excel where the user can use Excel slicers (2 of them), which are connected to approx. 10 pivot tables, to analyse different views on the data (per business unit as well as per sales rep). The cockpit is already working, but I didn't use PowerPivot and the data model. Therefore, the Excel is currently quite slow in updating the pivots and graphs, after manipulating the slicers. You should know in detail how PowerPivot works from a technical point. I was told that depending on how wisely it is set up, the Excel will work faster. The work should be performed via a Teamviewer session (or similar), so you can direct...

    €23 / hr (Avg Bid)
    €23 / hr Offerta media
    27 offerte

    VBA macro for creating multiple tabs based on different combinations of filters and printing them from powerpivot.

    €56 (Avg Bid)
    €56 Offerta media
    6 offerte

    If you send a generic respons - I will not read... please answer the following below. I am looking for someone that is a data analyst with expert level technical skills in the following areas: 1 - Excel 2 - PowerPivot 3 - DAX 4 - Relational Databases (SQL) 5 - Power BI 6 - Forecasting (In Excel) Preferred 1 - Python 2 - Azure

    €19 / hr (Avg Bid)
    €19 / hr Offerta media
    24 offerte

    I have few projects. Specifically only in Excel - VBA Programming. I am looking for Excel Expert who can help me in my projects. Candidate should have Good knowledge of.. Advanced Excel, Excel VBA Programming, Creating Attractive/Dynamic Excel Dashboards, Power Query, Power Query M Coding. Knowledge of PowerPivot & Power BI will add advantage.

    €186 (Avg Bid)
    €186 Offerta media
    5 offerte

    ...business processes. We are now looking for offshore development partners to partner with. In our team we have an architect and O365 specialist, project managers and UX designer. But we would need O365 specialist with focus on Office 365, MS Teams, PowerApps, Flow and SharePoint Online. An PowerBI specialist with knowledge of Power BI Desktop, BIG DATA (HIVE), SQL server, DAX (SSASTabular), Excel PowerPivot, Powerquery, Power pivot. With experience of architecture of PowerBI, used various sources to pull data into Power BI such as Sql Server, HIVE, Oracle, SSAS. Knowledge of all types of transformations that are available in Power bi query editor. Procedures and SQL queries to pull data into power pivot model We also need UX and Usability competences. Would this be of inter...

    €19 / hr (Avg Bid)
    €19 / hr Offerta media
    1 offerte
    Project for Amit M. Terminato left

    ...business processes. We are now looking for offshore development partners to partner with. In our team we have an architect and O365 specialist, project managers and UX designer. But we would need O365 specialist with focus on Office 365, MS Teams, PowerApps, Flow and SharePoint Online. An PowerBI specialist with knowledge of Power BI Desktop, BIG DATA (HIVE), SQL server, DAX (SSASTabular), Excel PowerPivot, Powerquery, Power pivot. With experience of architecture of PowerBI, used various sources to pull data into Power BI such as Sql Server, HIVE, Oracle, SSAS. Knowledge of all types of transformations that are available in Power bi query editor. Procedures and SQL queries to pull data into power pivot model We also need UX and Usability competences. Would this be of inter...

    €19 / hr (Avg Bid)
    €19 / hr Offerta media
    1 offerte
    NEAK task 1. Terminato left

    ...presentation of your findings and conclusions with illustration, design, animation, transition, including the date of creation, page numbers, author name in the footer. Source: Business You can find information about the extension here: Microsoft (2018) Start the Power Pivot add-in for Excel. Available from: [Accessed: 5th January 2018] Microsoft (2018) PowerPivot for Excel Tutorial Introduction. Available from: (v=sql.110).aspx [Accessed: 5 January 2018] Microsoft (2018) Power Pivot: Powerful data analysis and data modeling in Excel. Available from: [Accessed: 5th January 2018] Microsoft (2018) Tutorial: Extend Data Model relationships using Excel, Power Pivot, and DAX. Available from:

    €15 (Avg Bid)
    €15 Offerta media
    5 offerte
    NEAK task excel Terminato left

    ...of your findings and conclusions with illustration, design, animation, transition, including the date of creation, page numbers. Source: Business intelligence.xlsx. You can find it in the attached files. You can find information about the extension here: Microsoft (2018) Start the Power Pivot add-in for Excel. Available from: [Accessed: 5 January 2018] Microsoft (2018) PowerPivot for Excel Tutorial Introduction. Available from: (v=sql.110).aspx [Accessed: 5 January 2018] Microsoft (2018) Turn on Power View in Excel 2016 for Windows. Available from: [Accessed: 5 January 2018] Microsoft (2018) Power Pivot: Powerful data analysis and data modeling in Excel. Available from:

    €9 (Avg Bid)
    €9 Offerta media
    3 offerte

    Assistance with pulling data from Viewpoint construction software into powerpivot / excel. Needs to be someone with knowledge of Viewpoint data structures. NDA required.

    €27 / hr (Avg Bid)
    €27 / hr Offerta media
    23 offerte
    Excel Task Terminato left

    The task is the following Create an Excel dashboard to analyse international sales of electronic ...points Making a Power Pivot table and chart 3. task 2 points Adding slicers 4. task 2 points Making a Power Pivot table and chart 5. task 2 points Adding slicers 6. task 1 point Creating a perspective You can find information about the extension here: Microsoft (2018) Start the Power Pivot add-in for Excel. Available from: [Accessed: 5th January 2018] Microsoft (2018) PowerPivot for Excel Tutorial Introduction. Available from: (v=sql.110).aspx [Accessed: 5th January 2018] Microsoft (2018) Power Pivot: Powerful data analysis and data modeling in Excel Available from: [Accessed: 5th january 2018]

    €17 (Avg Bid)
    €17 Offerta media
    10 offerte

    I have a complex data analysis task to present on power pivot dashboard. Show me the top 10 winners and losers comparing 2018vs2019 data rolled up two levels, all presented on an interactive power pivot dashboard with charts

    €25 (Avg Bid)
    €25 Offerta media
    15 offerte
    PowerPivot Report Terminato left

    I have data from three tables that I need to combine into one PivotTable Report. Data is connected via one field in each table. Several calculated columns need to be created so they can be included in the reports. Copy of final report is attached as "Example of Report" Company Names in Column 1 are in one table Columns B through H are in Table 2, Columns I & J are calculated from Table 2 Column K is calculated from Table 3 Column L is a new column that pulls from Table 2 I have all of the calculations that are necessary for the fields. I cannot figure out how to add the calculated columns into the datamodel and have the info pulled into the pivot table. Looking for help getting this set up so all I have to do is update the tables and refresh the report.

    €131 (Avg Bid)
    €131 Offerta media
    8 offerte
    Excel Project Terminato left

    (Datasets can be pulled from https://qwiexplorer.ces.census.gov/static/explore.html#x=0&g=0 ) Project requirements: Utilizing your quantitative reasoning questions and selected dataset, begin the final step of the project by converting your data to a table. Utilize the PowerPivot functionality and conduct the appropriate analysis required to answer your question. Below are sample steps: 1. Analyze your dataset and provide an analysis that provides the mean, mead, mode, and standard deviation for the selected data. 2. Analyze your dataset and provide an analysis that provides charts reflecting trends, and patterns. 3. Analyze your dataset and provide an analysis that provides logical tests - i.e. True/False, Good/Bad, and Applying Codes to data - such as Engin...

    €44 (Avg Bid)
    €44 Offerta media
    5 offerte

    I have an excel tool that shows daily, week to date and period to date data for our locations. In the Power Pivot Data Model the "RegionArea" Tab is outdated. I want to update this with the tab "Alignment" but would want this data in Power Pivot replacing "RegionArea". You would have to change relationships in PowerPivot as well. This should be a quick and easy project for anyone who is a Power Pivot expert

    €34 (Avg Bid)
    €34 Offerta media
    8 offerte

    Need a developer to build a "Write-back" application for excel pivot tables through VBA preferably. Power Pivot will be pulling from several other excel workbooks that act as "databases". We want to be able to change any line-item data(values & text) within the pivot table, and it update the original raw data. We want to stay away from any software that needs to be installed. We...to build a "Write-back" application for excel pivot tables through VBA preferably. Power Pivot will be pulling from several other excel workbooks that act as "databases". We want to be able to change any line-item data(values & text) within the pivot table, and it update the original raw data. We want to stay away from any software that needs to be installed. We wan...

    €465 (Avg Bid)
    €465 Offerta media
    21 offerte

    I’d like to automate, recreate/ redesign excel report, create template; Knowledge of vba macro, powerpivot and power bi will be helpful; available to communicate and respond to email ASAP. Thank you.

    €2 / hr (Avg Bid)
    €2 / hr Offerta media
    1 offerte

    Automate , redesign excel report; knowledge of vba macro, powerpivot and power bi will be helpful. Thank you

    €2 / hr (Avg Bid)
    €2 / hr Offerta media
    1 offerte

    Only people with knowledge of DAX syntax and Powerpivot apply please. i need a pivot table that has in one of the columns the total amount of th dataset. Please see attachment.

    €24 (Avg Bid)
    €24 Offerta media
    9 offerte

    ...Quotation spreadsheet. Essentially it will be a list of Requirements, Price table, Product specs table, and rule/criteria and a quote page listing the matching products and related price and quantities. We are an all Apple Mac environment so we are restricted to Excel for Mac 2016 functionality unfortunately. (ie All functions, SQL, VBA Marcos etc should work but no Power Pivot and no multi table PowerPivot available.) For Example: Requirements (Drop down Lists) 1 Savings OR 2 Backup OR 3 Both 4 Budget Amount 5 Roof Type Price table 1 Inverter A 2 Inverter B 3 Battery A 4 Battery B 5 Panel A 6 Panel B Product specs table 1 Inverter A (5kw, Max 10 panels, Min 5 panels etc) 2 Inverter B (10kw, Max 20 panels, Min 5 panels etc) ……. Rules/criteria 1 IF Savings ...

    €48 / hr (Avg Bid)
    €48 / hr Offerta media
    10 offerte

    ...room has between one and ten procedures per day. Scope I need help to analyse the data if different KPIs are met and in general have it visualized. 1. One KPI is if the target for the first procedure is met. There is a target for “patient wheel-in” and another target for “procedure start”. I would like to have this KPI visualized in a graph and would prefer if the graph can be interactive (like PowerPivot) where you are able to select different rooms, different days, time period (by week, month) etc. 2. I would like to have the room utilisation visualized. In the visualisation it should show the different time periods of the day: - empty room day start - pre-procedure - procedure - post-procedure - change-over - etc. This should be by week and by OR. Plea...

    €316 (Avg Bid)
    €316 Offerta media
    28 offerte

    Report/Process automation using MS Excel with VBA; Business Analysis, Data Modelling & Dashboard development using PowerPivot and PowerBI.

    €474 (Avg Bid)
    €474 Offerta media
    20 offerte

    Hi I need someone to complete excel dashboard using powerpivot, DAX and M. People with experience and sample work apply.

    €14 (Avg Bid)
    €14 Offerta media
    6 offerte

    I am currently building a predictive analytic tool with Excel and need an expert with strong experience working with Power Pivot to assist in creation of multiple files necessary to run statistical sport analysis on Mixed Martial Arts. Knowledge of sports or statistical analysis is not necessary.

    €1710 (Avg Bid)
    €1710 Offerta media
    12 offerte

    I need a measure formula for powerpivot and MS Power BI to calculate the average payment of a specific identifier (Healthcare CPT Code) from multiple rows that is linked to a date of service and account number. Any other payments or other rows associated with that account that are not specifically tied to the "identifier" CPT code should not be included in the calculation. There are two queries linked: Payments Query to Charges Query. I will be using pivot tables and slicers to highlight specific "Healthcare CPT codes" to review average payments

    €39 (Avg Bid)
    €39 Offerta media
    13 offerte

    Hello, we are transportation company looking for Power Pivot expert to fulfill needs of our customer. We will need to develop dashboard presentation in MS Office Excel using Power Pivot. Source data/calculations we will made on our side, we need just the "frontend" with nice UI. I will send you the specification once NDA is signed. I would appreciate some examples of your prior work in Power Pivot. Thank you. Best regards, Jan.

    €128 (Avg Bid)
    €128 Offerta media
    17 offerte

    Hi Jesus Alejandro G., My work colleague David Betts has sent you a message to advise I would like some help with some PowerPivot/DAX problems. I hope you will be able to help? Thanks, Greg

    €17 / hr (Avg Bid)
    €17 / hr Offerta media
    1 offerte

    Need to Create DAX formulas to build Pivot Table from PowerPivot data model. Using Excel 2016 - Power Pivot Pro and MS Access as data source.

    €35 (Avg Bid)
    Urgente
    €35 Offerta media
    2 offerte