Hi we would like an excel sheet to
1. Import data into a Raw Data tab
2. Press a button to run a macro that creates a "Clean data tab" cleans the Raw data. Each cleaning action will be noted on a Meta Data log. Cleaning actions will include removing columns that have no results across all rows. Removing rows that have no results across all columns, Verifying all data is in the correct data type and deleting those that are not, adding default data to any unfilled cells, filling in location names
Once data is clean, create a "log data" tab with clean data logged
3. after cleaning the data, a "Deep Learning" tab will be generated. This will include getting the top 10 and bottom 10 results from the clean data for each element.
4. We will create a Data Mining Dashboard with the analysis requested.
things like
element ratios
comparing elements
anomaly detection
Cases, Variables, Types of variables
Matrix and Frequency Table
Graphs and shapes of Distributions
Mode, Median and Mean
Range, Interquartile Range and Box Plot
Variance and Standard Deviation
Z-scores
Contingency Table, Scatterplot, Pearson’s r
Basics of Regression
Elementary Probability
Random Variables and Probability Distributions
Normal Distribution, Binomial Distribution & Poisson Distribution
Analysis of variance
I have attached a rough draft
Hello,
I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile.
Please visit : https://www.freelancer.com/u/schoudhary1553
I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you.
Kinds Regards,
Sandeep
Hello,
Being an expert in excel and stat I can provide you complete solution for this job in very less time, as we are a team we can complete it very quickly.
Hello?
How are you?
I have good experiences in "Data Analysis Excel" as you can see my profile for these (Excel, Excel Macros).
I have been working for 7 yrs in this scope.
While we contract and work in our jobs, I will get paid once you have confirmed satisfied result.
If I do not deliver satisfied result, I will never get paid from you.
We can discuss more details to understand more easily if you have other infos.
Hope to work with you.
Thank you.
Msc computer science.
MBA accounts and finance.
Mphill in statistics.
having seven years of experience in Excel vba and
Excel macros.
I already done many Excel complex projects like:
Excel models designing.
Excel dashboards designing.
Excel Reporting systems.
Excel complex calculators.
Cost accounting financial models.
sir I can deliver you quality work with guarantee.
I already designed these Excel projects.
1. DCF excel financial model.
2. Waterfall Excel model.
3. Pms Excel dashboard.
4. Excel Tracker.
5. Mock up Excel dashboard.
6. Inventory Excel dashboard.
7. Excel Reporting system.
8. Excel lifestyle calculator.
I also done many other such projects by using Excel vba, Excel macros and Visual basics.
Hi,
I would to offer my services for your project Data Analysis Excel.
I am an India based accountant having more than five years experience and also expert in Microsoft Excel including complex formulas and VBA or Macros programming & development.
I am having experience in Global Accounting and Taxation as well.
Most of jobs which I have performed so far are for the clients/employers based in India, US, UK, UAE, Australia,New Zealand.
I perform variety of job including following:-
*Bookkeeping
*Accounting
*Taxation
*Payroll
*Financial statements
*Financial modelling/Projections/Forecasting
*Business Plan/Business writing
*Process Development
*Dashboard Development
*VBA or Macros development
*Data Processing/Data Extraction/Data Entry
I am having working exposure and experience in numerous accounting software such as:-
*Xero
*MYOB
*QuickBooks
*ZohoBooks
*Tally
*Banana
*SAP
*Odoo
I am also having good experience in Accounting Software implementation and integrations job.
Looking forward to a successful cooperation with you.
Kind Regards
Gopal
Dear sir.
Your project attracted my attention at first glance, because I've extensive experience in Data Analysis Excel Programming.
I'm really confident about your project, and very eager to join your project.
If we have a chance to cooperate, I'll do my best to provide wonderful result.
Looking forward to your response.
Best Regards.
Domain experience in F&A Operations processes for General Ledger Accounting (R2R), Accounts Payable, Fixed Asset Accounting and fair knowledge in IFRS and US GAAP Accounting, SOX Audit and Compliance, US Payroll Accounting, Sourcing and Procurement support functions process like Contract and Supplier Management
