Find Jobs
Hire Freelancers

Help with my PowerPivot Data Model

£20-250 GBP

Geschlossen
Veröffentlicht vor etwa 1 Monat

£20-250 GBP

Bezahlt bei Lieferung
I need some help with a data model I created in Power Pivot. I have 2 data sets: one is Sales and the other is Stock. I have added both data sets to my data model and am now trying to create a pivot which pulls data from both tables. My Sales table pulls the data perfectly but the Stock table does not. Some context... When I pulled the data into the data model I added a column which I called DataModelLink. This created a 1 (Sales) to many (Stock) relationship between the two tables. As an example, I tried to pull the data of one particular style which had one line in the Sales table but 2 lines in the Stock table. For this reason, my Pivot is only reading one of two of the lines on the Stock data table. I am happy to share the data model as it is only sample data.
Projekt-ID: 38011776

Über das Projekt

39 Vorschläge
Remote Projekt
Aktiv vor 29 Tagen

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
39 Freelancer bieten im Durchschnitt £111 GBP für diesen Auftrag
Avatar des Nutzers
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep
£180 GBP in 4 Tagen
4,9 (607 Bewertungen)
8,6
8,6
Avatar des Nutzers
Hi, i am not Power Pivot expert but i believe you made a mistake when you created DataModelLink, in Stock table you are creating it based on LOC_LOC_ID field which is not the same for those 2 rows you mentioned (one is 520 the other is 523, maybe). Try filtering the data in Data Model to get to the same 2 rows (like you did on the sheet) and you will see the DataModelLink difference (only in one number). If you are interested, feel free to message me and i will show you a screenshot. Thanks, Milan
£20 GBP in 1 Tag
5,0 (797 Bewertungen)
7,5
7,5
Avatar des Nutzers
Hi there! As I have read, I see you need help I would like to offer my help with your data model in Power Pivot and creating the pivot you need to pull data from both Sales and Stock tables. As a professional with experience in handling Power Pivot and creating complex data models, I am confident that I can help you efficiently integrate Sales and Stock data sets into your existing model. I'm a professional Database Administrator and Analytics Engineer with more than 10 years of experience and more than 300 projects done here on this platform. I offer unlimited revisions and I don't require any payment in front. I always meet delivery deadlines working until I get the desired results. I know all the most used softwares to do this project specifically, I could even give you some other options in case you think is better to use other tools. Send me a message so I can show you my previous work and we can discuss more. Appreciatively, Giovanni.
£20 GBP in 1 Tag
4,9 (60 Bewertungen)
7,0
7,0
Avatar des Nutzers
Hello, Greetings of the day! I have a vast experience of working in Advanced Excel and I have completed many projects based on Advanced Excel. I have read your requirements and I can complete your project within time frame with proper and efficient work. I am a full time Freelancer and available to start your project immediately. I have an experience of below skills • Changing Raw Data into Presentable Data which can be easily under stood. • Use of Advanced Excel Formula • Data, Power Query, Tables & Formatting • Conditional Formatting • Advanced Charting • Pivot Tables & Pivot Reporting • VBA & Macros • Data Analysis • Anova analysis in Excel • Statistic & Modeling using Excel • Forecasting & Trend Analysis & many more …. I am ready to work on a Sample file also if required. Please initiate the chat so that we can discuss more about project and start the project. Thanks & Regards Sneh
£135 GBP in 2 Tagen
4,7 (51 Bewertungen)
5,9
5,9
Avatar des Nutzers
With my extensive background in Data Processing, Excel, and Statistics, I am well-equipped to help you with your PowerPivot Data Model. Not only do I understand the technical aspects of Power Pivot and data relationships, but I am proficient at ensuring consistent and accurate data flow through the model. In your case, where sales and stock datasets need to be combined, it is crucial to set up the relationship correctly - an aspect that demands a high degree of precision which falls well within the domain of my expertise. The practical experience I have gained in projects involving intricate data modeling gives me an edge when it comes to understanding data dynamics within tables. The challenge you are facing - only reading one line from the Stock data table instead of both - generally stems from inconsistencies or disparities in field values used for relationship establishment. By closely analyzing your data structure and your specific requirement to pull data for any given style, I can thoroughly evaluate how best to structure your DataModelLink column so that your Stock table is properly integrated with Sales. My meticulous approach towards problem-solving ensures that even minor discrepancies are identified and resolved efficiently. Trust me with your project and let's unlock the full potential of your data model!
£200 GBP in 2 Tagen
4,9 (27 Bewertungen)
5,5
5,5
Avatar des Nutzers
Hi There, **** Your issue is resolved **** I have gone your excel data file and resolved the reason ' why pivat table was reading only one line'. Now sum of free qty is 9 in pivot. I am available to share the solution. Warm Regards Saims
£20 GBP in 1 Tag
5,0 (30 Bewertungen)
5,0
5,0
Avatar des Nutzers
With over two decades of experience in software development and data analysis, I bring a wealth of knowledge to the table that is well-suited for resolving complex issues like yours. As a specialist in database design and administration, I have a proven track record in working with MS Excel and specifically Power Pivot, much like the challenge you're currently facing. Having previously developed multi-table databases including ones with 1-to-many relationships similar to your Sales and Stock tables, I'm confident that I can debug and resolve the current issue you have. Especially drawing from my extensive statistical skills, I can carefully validate the results of your data model, enabling you to confidently use it for analysis and informed decision-making. Furthermore, my experience with UNO and WHO has allowed me to develop an acute attention to detail and a strong commitment to quality. I will not only provide a solution to your immediate problem but also ensure that it is integrated seamlessly into your broader data modeling structure. In addition, being comfortable sharing best practices and knowledge, I'll make sure you understand the correction implemented so that you can leverage these skills in your future work as well. Let's connect soon so we can dive into your project together!
£135 GBP in 7 Tagen
5,0 (13 Bewertungen)
4,5
4,5
Avatar des Nutzers
Hi There Matt M., Good morning! My name is Jane a skilled Statistician with skills including Excel, Data Processing, Database Administration, Statistics and Database Programming. I have over 5 years in tutoring data analysis and statistics. Having completed similar project, I am confident in my ability to deliver high-quality results for this project. I am eager to discuss further details and see how I can contribute to your team. I am happy to offer a free consultation and a 10% discount for first-time clients. Please send a message to discuss more about this project. Best Jane
£150 GBP in 2 Tagen
5,0 (11 Bewertungen)
3,8
3,8
Avatar des Nutzers
you need: 1. power pivot model 2. for sales and stocks right?
£250 GBP in 1 Tag
4,9 (5 Bewertungen)
2,8
2,8
Avatar des Nutzers
Hi Matt M., How are you doing? As a professional developer with expertise in Database Programming, Database Administration, Excel, Statistics and Data Processing, I eagerly anticipate the opportunity to complete this project for you. Please drop me a message to discuss the project detail. Thank you for considering my services.
£40 GBP in 5 Tagen
5,0 (1 Bewertung)
2,4
2,4
Avatar des Nutzers
As an experienced data expert, I'm your go-to person when it comes to tackling complex Excel tasks like this. Over the past half a decade, I have honed my skills in Data Processing and Excel to a fine art. I have worked with numerous clients in similar situations, whether it was for analyzing sales data or managing stock. I understand that your concern lies in efficiently merging the Sales and Stock data for better analysis - and I assure you that finding solutions for such issues is my forte. Your PowerPivot model is something I've had hands-on experience with, and I’ve successfully developed effective data models for clients using multiple tables - just like your situation. If you decide to work with me, we can establish clear communication channels to ensure a smooth knowledge transfer process. Once I comprehend the specific nuances of your model, I will deploy all of my expertise to fix the issue at hand efficiently, thus providing you with a working Pivot that incorporates all the necessary insights from your Sales and Stock data. Your satisfaction means everything to me, so rest assured that by hiring me, you're making an investment in a successful completion to your project. Let's turn those two lonely lines on the Stock table into valuable components of your Pivot report!
£30 GBP in 2 Tagen
4,4 (8 Bewertungen)
2,8
2,8
Avatar des Nutzers
Dear Matt M., I’ve read all of your requirements fully and I'm really interested in Help with my PowerPivot Data Model. I have rich experience in Database Administration, Data Processing, Excel, Database Programming and Statistics with over 9 years. I am always ready to discuss more detail this project with you and I can start working immediately. Looking forward to working with you soon. For the best result and a long term in the future. Regards, Mikael.
£20 GBP in 5 Tagen
5,0 (1 Bewertung)
1,6
1,6
Avatar des Nutzers
Dear sir, I hope you will be fine and healthy. I am Muhammad Imran Ahmad. I have been working as a professional Data Analytics for the last 2 years. I have a good experience with MS EXCEL, GOOGLE SHEETS, R STUDIO, BlueSky Statistics, POWER BI DESKTOP AND TABLEAU . I am an expert in Data Analytics and Business intelligence. I can analyze your data in google spreadsheets and in ms excel. I can make a pivoting table of the Clients' valuable data. I can analyze the required data and text documents on word cloud generators. I am good at communication and soft skills. I always believe in the client's demand and quality work. I believe in accuracy and always give my best in every work. I am looking for your positive reply.
£135 GBP in 7 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
I've been working on MS Excel and PowerBI for over 8 years with fortune 100 companies and accumulated over time considerable expertise ranging from basic formulas to complex VBA macros. I have had the chance to use my skills in different industries, departments and in different environments I can manipulate and analyze raw data and turn it into visual, clear, and useful information (graphs, dashboard, etc.). I can also fix/improve existing spreadsheets by automating reports, updating formulas, etc. I perform a range of tasks from simple to difficult, for small and large jobs, working on Microsoft Excel and PowerBI using a wide variety of tools: Pivot tables, Macros, all sorts of lookups, formulas/Functions and DAX. You can contact me with the following tasks: Data Analysis/Visualization Business Analysis based on data Merge multiple Excel spreadsheet into one master spreadsheet Collect data from a website or directory to Excel spreadsheet (data entry) Search and fill missing data fields Split the data of a column into multiple fields. Data manipulation Data formatting PDF to Excel conversion Fix/improve existing spreadsheets Data Cleaning Data Segregating Automation by Macros
£135 GBP in 7 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
He trabajado en proyectos que involucran la manipulación, limpieza y análisis de datos en hojas de cálculo de Excel. Tengo habilidades sólidas en fórmulas, tablas dinámicas y funciones avanzadas.
£55 GBP in 7 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
Hi there, I have gone through the attached data model trial file and have understood your issue. I am an expert Power Pivot user and can easily assist you with your data tables. Let's connect to discuss further.
£20 GBP in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
"I specialize in Power Pivot and data modeling. I'll troubleshoot the issue with your Sales and Stock tables' relationship, ensuring accurate data retrieval in your pivot. With expertise in creating efficient data models, I'll optimize your setup for seamless analysis. Let's ensure your insights are comprehensive." Here is my assurance for each service that I provide: 1. High-quality work 2. Proficient user of Excel 3. Good in English Language Thank you for reviewing my proposal and looking forward to your positive feedback. Regards, Wafi Jaidi Data Analyst (Notes: Only 3 minors correction that I will provide)
£90 GBP in 7 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
I work in a Power BI Developer and Power Platform Developer role every day. I interact with internal clients within the company to create either reports, applications, or flows, as well as SharePoint pages. I believe I would be a suitable fit for your need.
£135 GBP in 15 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
Hello, I'm Luth from Malaysia I am here to assist you with your Power Pivot data model challenge. It appears that you're encountering an issue with the relationship between your Sales and Stock tables. The problem might stem from how the DataModelLink column is linking these tables, causing discrepancies in your analysis. To address this, we'll embark on a comprehensive review of your data model. We'll carefully examine the setup of the relationship between the tables and investigate if the DataModelLink column is accurately linking the data. If necessary, we'll explore alternative methods of connecting the Sales and Stock tables, such as using unique identifiers or refining the existing linking column. I would like to ask a few questions regarding the project : 1. How long is the expected duration of project completion? 2. Is the project urgent and requires any additional software to be used? Let's collaborate to troubleshoot and optimize your data model effectively. Best regards, Luth Zulfikar
£50 GBP in 7 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
Hi, I can help with the data modelling part. I have 6+ years of experience in connecting data from various sources to power bi dashboard & Achieved the daily refresh of data. I can do this with 174 Euro in 3 days.
£175 GBP in 3 Tagen
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von UNITED KINGDOM
Hove, United Kingdom
0,0
0
Mitglied seit Apr. 19, 2024

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.