Excel Powerpivot with Dax functions &VBA
- or -
Post a project like this£250(approx. $313)
- Posted:
- Proposals: 9
- Remote
- #1902731
- OPPORTUNITY
- Expired
Data Modeling in Excel & Power BI With Power Pivot, Power Query, DAX and Google Data Studio Expert.
Dhaka
19324720827054870064986519467141963679197536320758942081384
Description
Experience Level: Intermediate
Need to develop a 5 year model, using Power Pivot, with extensive functionality.
Functionality to include:
1) Budget/forecast data is shown annually but actuals are shown monthly and quarterly. Must be able to show comparatives for both Actuals and Budget/forecast data for all 3 variants selected, (annually, quarterly and monthly). Budget/forecast data be split into monthly amounts based on a few options, eg. equal split, based on the number of days in the month, based on last years monthly actuals.
2) Must be able to add annual price increase for each product lines and customer, for each subsequent year based on excel table.
3) Based on options selected by the user, from the drop-down in several cells, VBA code must be able to display the data in PivotTable, Pivotgraph or Table format. E.g. Variant selected is "Actual and Forecast", Year selected is "2019", Customer is"XXX", Product is "Bike 1", display the data in a Table.
4) Ability to add new products based on a fixed annual amounts.
Eg. For New Product 1, expected quantity to be sold in Year 2019 is 200, in Year 2020 is 300 and Year 2021 is 350,
For New Product 2, expected quantity to be sold in Year 2019 is 100, in Year 2020 is 150 and Year 2021 is 200,etc. Based on Sales and cost Prices for Products1 and 2, compute the Sales and Cost of Sales for both products.
5) Must be able to upload actuals each month, via VBA code and add the additional data to the Power Pivot Table.
Can send template
Functionality to include:
1) Budget/forecast data is shown annually but actuals are shown monthly and quarterly. Must be able to show comparatives for both Actuals and Budget/forecast data for all 3 variants selected, (annually, quarterly and monthly). Budget/forecast data be split into monthly amounts based on a few options, eg. equal split, based on the number of days in the month, based on last years monthly actuals.
2) Must be able to add annual price increase for each product lines and customer, for each subsequent year based on excel table.
3) Based on options selected by the user, from the drop-down in several cells, VBA code must be able to display the data in PivotTable, Pivotgraph or Table format. E.g. Variant selected is "Actual and Forecast", Year selected is "2019", Customer is"XXX", Product is "Bike 1", display the data in a Table.
4) Ability to add new products based on a fixed annual amounts.
Eg. For New Product 1, expected quantity to be sold in Year 2019 is 200, in Year 2020 is 300 and Year 2021 is 350,
For New Product 2, expected quantity to be sold in Year 2019 is 100, in Year 2020 is 150 and Year 2021 is 200,etc. Based on Sales and cost Prices for Products1 and 2, compute the Sales and Cost of Sales for both products.
5) Must be able to upload actuals each month, via VBA code and add the additional data to the Power Pivot Table.
Can send template
P D.
98% (11)Projects Completed
10
Freelancers worked with
9
Projects awarded
19%
Last project
19 Mar 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi. I have seen the description and will be able to provide a solution. However , i need to see the template for a quotation.
Please send me the template. -
Hello!
I have read carefully your job description and I will be happy to help. Can you please send me the file please to review it?
Thanks.
597912594533
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies