Find Jobs
Hire Freelancers

Country Level WSSI

$30-250 USD

Cancelled
Posted 6 months ago

$30-250 USD

Paid on delivery
I am looking for someone to help formulate a country-level WSSI (Weekly Sales, Stock, and Inventory) report in Power Query. This report should be able to update automatically every week as the data actualizes once the raw data is dropped in the folder. Every week i will paste the raw data in a folder (to keep things simple now i have linked it to the template) and once the data is pasted i will update the Wk tab to show the current week. I have attached the template that i started working on, the data set provided has Week (wk 1 - 52), Current Week (Elapsed, Prev, Yes & Unelapsed) Country (markets 1 -& 2), Sales (at Cost Quantity and Retail) the remaining columns are all at Cost, Intake, Markdown, Opening and Closing stock. I am having difficulty in calculating a rolling closing stock number for future weeks. Advanced level in Dax and Power query M Thanks
Project ID: 37445373

About the project

59 proposals
Remote project
Active 6 mos ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello there! My name is Ayesha, and I'm a professional freelancer. I understand you are trying to find someone to formulate a country-level WSSI (Weekly Sales, Stock, and Inventory) report in Power Query I think I'm the ideal candidate for the job because of my vast expertise in many areas. I am well-equipped to handle the task efficiently.I have experience in this field and have been doing it for 5 years. I guarantee to complete the project by the deadline because I understand how important it is to meet deadlines. You can look at my portfolio to get you a better idea about my work (https://www.freelancer.com/u/scriptwriterx) Thank you for considering my bid. I will look forward to discuss more about the project. Best regards, Ayesha
$40 USD in 1 day
5.0 (2 reviews)
0.1
0.1
59 freelancers are bidding on average $122 USD for this job
User Avatar
Hi there! My name is Akriti and I'm a Google Sheets expert, Excel VBA expert, web development wizard, data processing expert and automation enthusiast. I understand how important it is for you to have an update of your country-level WSSI report every week so that you can keep track of the current week's data as soon as it's pasted into the folder. With my expertise in data processing and Excel, I can ensure that your weekly reporting task becomes efficient and seamless. Plus, my client satisfaction focus and focus on customer satisfaction make me a great fit for this project. If you're interested in hiring me for this project please feel free to contact me directly so we can discuss further.
$140 USD in 2 days
4.9 (412 reviews)
7.5
7.5
User Avatar
Hello there! My name is Sandeep and I am an expert in Data Processing and Excel. I noticed that you are looking for someone to help you formulate a country-level WSSI (Weekly Sales, Stock, and Inventory) report in Power Query. With my extensive experience in Data Processing and Excel, I believe I am the perfect fit for this project. I understand how important it is to have an accurate WSSI report that can update automatically every week as the data actualizes once the raw data is dropped in the folder. My skillset includes data processing such as Google Api, Xero Services, Data Entry and Web Scrapping which would be perfect for this project. Additionally, my services include Word Processing, WordPress development and web research which will be beneficial for your needs.
$30 USD in 1 day
4.9 (212 reviews)
7.0
7.0
User Avatar
Hi There, Good evening! I have gone through your requirement. I have worked on the similar type of requirements in past. Please ping to discuss more on the project. Below is my intro - "First use then believe". I don't want to mention much here but I have 8+ years of extensive experience in Power BI along with Power Apps, Power Automate, Python & AWS with total 10+ years of IT experience. I am not intelligent, but I try to complete the work ASAP as I don't believe in deadline. I don't believe in saying rather my work speaks. It's our first collaboration that's why I have to describe my proposal or else I prefer not to as it won't be needed next time. ✅ You can go through my profile to see my past works in Freelancer site ==> https://www.freelancer.com/u/Akmanyu
$140 USD in 7 days
5.0 (98 reviews)
6.5
6.5
User Avatar
Hi Hope you are doing good, I can perfectly help you with that in quick turnaround. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, creating dynamic dashboards and Excel (including VBA and Macro) to perform Data Analysis, Data Visualization, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project. Kind Regards Arun
$140 USD in 1 day
5.0 (48 reviews)
5.8
5.8
User Avatar
Dear Client,                 I am writing to express my interest in collaborating with you on your project posted in Freelancer. Based on the project details provided, I assure you that I have the skills and expertise required to deliver high-quality work within the specified timeframe. I am confident in my ability to deliver exceptional results for your project. I am committed to maintaining open lines of communication, delivering on time, and ensuring your complete satisfaction. Waiting to hear from you. With thanks regards
$109 USD in 6 days
4.6 (52 reviews)
5.8
5.8
User Avatar
Hi there! My name is Lukman and I am a Microsoft Data Platform and PowerBI Super user nominated by Microsoft with more than 5 years of experience in various Enterprise ERP Applications, Dynamics 365 Business Central as a functional analyst and Microsoft Power BI specialist. I pride myself in my ability to gather, interpret and understand user requirements and provide appropriate solutions to achieve business goals. I'm confident that I can help you with your country-level WSSI report. I understand the complexities involved in calculating a rolling closing stock number for future weeks - especially when dealing with multiple markets - so I will ensure that your project is completed on time and within budget. Moreover, my services include the data architecture/data engineering required to facilitate automation. If you're interested in working with me please let me know and we can discuss further how we can make this project happen together!
$250 USD in 2 days
4.9 (18 reviews)
4.4
4.4
User Avatar
Hi there,I am a Data Scientist is a professional responsible for extracting actionable insights and knowledge from large volumes of Data Visualization. I have over 12-plus years of experience with Power BI, PowerApps,Powershell, Visual Studio, Power Automate, Microsoft Power BI, Microsoft 365,tebleau,My top priority is to provide a high quality of work, I am willing to fully devote my time and energy to improve the service offered, with timely, accurate and professional results, building trust and a long term relationship with customer is my main objective. https://www.freelancer.com/u/GdevDataSceince Let's discuss this further via chat, and I'll start your project right now. Thanks Gdev
$100 USD in 2 days
5.0 (12 reviews)
4.4
4.4
User Avatar
Hi, Your job post for 'Country Level WSSI' grabbed my attention instantly because it perfectly matches the skill set I work on. Having read the requirements carefully, I am sure I can complete your project very nicely. I have good expertise in Data Processing, Excel, MySQL, Power BI & that's why I believe I am a great fit for this job. Please review my portfolio here: https://www.freelancer.com/u/MSaadJaved If you find me suitable for this job, please initiate the chat so I can ask you few questions that will clear the things further. Sincerely, Saad Javed
$250 USD in 3 days
5.0 (1 review)
3.9
3.9
User Avatar
Hi there! I'm excited to hear that you're looking for someone to help you formulate a country-level WSSI report in Power Query. With over 15 years of experience in data processing, Excel, and data analysis, I am confident that I can provide the best solution for your needs. I have extensive knowledge of how to use Power Query to create reports that update automatically every week as the data actualizes once the raw data is dropped in the folder. Additionally, my skillset includes logical reasoning and the ability to envision long-term goals - two invaluable traits for this project that would prove vital in ensuring successful completion of your needs. If you give me the chance to work on this project, I guarantee that you will not be disappointed with the results - let me know how I can help!
$30 USD in 3 days
5.0 (4 reviews)
3.3
3.3
User Avatar
I propose to take on the task of formulating your country-level WSSI report in Power Query. My bid for the entire project,. Automated Weekly Updates: I'll design the Power Query to automatically update the WSSI report every week as soon as new data is added to the specified folder. Data Mapping and Template Integration: I'll refine the template you've provided, ensuring seamless integration with the raw data you'll be pasting in the folder. This will include linking the data to the template for quick and accurate updates. Dynamic Week Display: The Wk tab will dynamically display the current week based on the data you input. This will make it simple for you to visualize and track weekly changes. Closing Stock Calculation: I'll tackle the challenge of calculating a rolling closing stock number for future weeks. This involves implementing an algorithm that considers the existing data and forecasts closing stock for upcoming weeks. My expertise in Power Query and data analysis equips me to handle this task effectively. I am confident that my solution will not only meet your current requirements but also provide scalability for future enhancements. I look forward to the opportunity to contribute to the efficiency of your reporting process. If you have any questions or would like to discuss this further, please feel free to reach out.
$50 USD in 1 day
5.0 (7 reviews)
3.5
3.5
User Avatar
Hi, I am interested in this project and i am ready to do it for you. To proceed further, I am ready to discuss your project and start immediately. Thanks
$140 USD in 7 days
4.6 (24 reviews)
3.9
3.9
User Avatar
Hello I understand your request that you’re demanding Country Level WSSI As a Professional Geeks I can avail creative, proactive and high-tech solutions to your development needs. I have excellent experience in Metatrader (4 And 5),Ninjatrader (7 And 8),Indicators & Trading Robots Development,Tradingview (Pinescript & Strategy),Python Trading Api,Machine Learning,,Python,HTML, Javascript, PHP,CSS, Laravel,Java,Joomla,Angular.js,MySQL, Node.js, React.js,Wordpress,linux Ruby on Rails, Database, Objective-C and Swift,C, C#, C++, Qt, Linux and raspberry. My Engineering skill are unimaginable with lot of success in engineering task My page is clear about my professionalism with awarded task Don't hesitate to contact me to create awesome products! Thanks
$30 USD in 1 day
5.0 (2 reviews)
2.8
2.8
User Avatar
I am called Fonki Ndenibi Joel. I run a freelance company with professionals in all works of life. My team can give you the best result at the most affordable cost. Let's talk more so we can start working on this right away.
$140 USD in 1 day
5.0 (4 reviews)
2.6
2.6
User Avatar
Hello, my name is Rajput and I am a professional with extensive data entry, data analysis and organizational abilities. I specialize in data entry software and have a strong track record of maintaining high accuracy levels while managing large volumes of data swiftly and efficiently. I understand that you are looking for someone to help formulate a country-level WSSI (Weekly Sales, Stock, and Inventory) report in Power Query. This report should be able to update automatically every week as the data actualizes once the raw data is dropped in the folder. I believe that my skillset makes me the perfect fit for this project. With my expertise in data entry, data analysis and organizational abilities, I am confident that I can provide you with the highest level of accuracy while meeting tight deadlines.
$140 USD in 7 days
4.8 (3 reviews)
2.3
2.3
User Avatar
Dear Client, I understand your requirement for a dynamic WSSI report in Power Query. I have reviewed the attached template and the dataset structure. To address your challenge with calculating a rolling closing stock for future weeks, I propose implementing a DAX formula within Power Query to ensure accurate and automated updates. I have extensive experience with Power Query and data modeling, and I am confident in my ability to enhance the functionality of your WSSI report. Let's discuss further details and any specific nuances you'd like to incorporate. Looking forward to assisting you,
$30 USD in 1 day
5.0 (1 review)
0.8
0.8
User Avatar
Hi There Ashraf M., Good morning! I am skilled mobile engineer with skills including MySQL, Data Processing, Excel and Power BI. Please send a message to discuss more about this project. If you have any questions, please let us know
$30 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Thanks for your job posting. I have read your Country Level WSSI project detail. I am EXPERT in these roles. ☑️ Web Development - Web Basics: HTML5, CSS3, SCSS/LESS, JavaScript, jQuery/Prototype - JavaScript Full Stack: TypeScript, Angular, React.js/Next.js, Node.js/Nest.js, Vue.js/Nuxt.js -CMS: WordPress, Drupal, Joomla, Craft CMS - eCommerce: WooCommerce, Prestashop, Shopify, Magento, Drupal Commerce, OpenCart - PHP Full Stack: Laravel, CodeIgniter, CakePHP, Symfony - Python Framework: Django, Flask - Database: GraphQL, MongoDB, MySQL, PostgreSQL, MSSQL, Oracle ☑️ Mobile App Development Xamarin, Ionic, Flutter/Dart, React Native, Objective C, Swift, Kotlin/Java ☑️ System Administration Amazon Web Services, AWS Lambda, CloudFlare As you can see from my skills and projects, I have lots of experience in these roles and I can do this job very quickly and perfectly as you want. I can do full-time work in any time zone and I always know how to arrange the time to get the job done in the best way. Please contact me for your success. Thanks.?
$155 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I have over 5 years of experience in MySQL and I have carefully read your project requirements. I understand that you need assistance in formulating a country-level WSSI report in Power Query. To achieve this, I propose creating a Power Query solution that will automatically update the report every week as new data is added to the designated folder. The solution will include calculations for rolling closing stock numbers for future weeks. I have reviewed the template you provided and I am confident in my ability to deliver a comprehensive and accurate WSSI report. I would appreciate the opportunity to discuss the project further and address any specific requirements or concerns you may have. Please feel free to connect with me in the chat to initiate the discussion. Best regards, Zain Javed
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, Ashraf M.. Thanks for your job posting. I read your job details ........................Country Level WSSI..................... and understood what you need. As a professional Web developer, I can help you perfectly. Please message me to discuss more details. I'm always ready to help you. Best regards. Lena.
$100 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, Ashraf M.. Thanks for your job posting. I read your job details and understood what you need. As a professional Web developer, I have rich experience with Data Processing, MySQL, Power BI and Excel. I can help you perfectly. Please message me to discuss more details. I'm always ready to help you. Best regards. Sofiia.
$100 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of KUWAIT
Kuwait, Kuwait
5.0
3
Payment method verified
Member since Jan 14, 2021

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.