Save this Search
     

All Jobspivot tables

 (7 results)  
Sort by:
  • Posted Date
Results for 'pivot tables'
Hourly Rate: Not Sure   |  Duration: 1-3 months  |  Posted: 2h, 4m ago  |  Ends: 14d, 21h  |   0 Proposals
Existing team of highly-skilled & experienced MS SQL Server team is seeking to temporarily augment their team for 1 month short-term, with a freelance cloud SQL Server expert on a 100% telecommuting basis. 10 hours / week of work expected. The project requirement is to build out a small-sized, low-transactional-volume but highly available database implementation on cost-effective cloud platform, using SSIS, Excel and SSMS to connect using Workgroup Networking topology (in other words, without depending on Active Directory). The cloud implementation will not be using Active Directory. The cloud SQL Server expert must exhibit advanced-level knowledge of the following: SQL Server architecture, administration, T-SQL development & debugging; SSIS development, administration, deployment, debugging; Excel data connections, pivot tables, formulas & expressions; Ability to analyze cloud offerings from different solution providers to product cost-benefit analysis reports and ad...
Category: Database Administration       
Preferred Location: North America, Western Europe, Eastern Europe, Central & South America, Australia/Oceania

w****e01
 [?]
Sign in to view client's details.
| w****e01
|    United States
Fixed Price: Not Sure   |  Posted: Sep 03, 2015  |  Ends: 13d, 18h  |   16 Proposals
I need help with an Excel PivotTable. I have a set of data like so: 1,a,date1,TRUE 2,a,date1,TRUE 3,b,date1,FALSE 4,a,date2,TRUE 5,b,date2,FALSE 6,b,date2,TRUE 7,b,date2,TRUE I need the PivotTable to show: date1,date2,Grant Total a 100%,100%,100% b 0%,66%,66% Note that the data is showing the % of TRUE in the 4th column and the Grand Total is showing the % of TRUE for that row in the PivotTable. I need exact instructions that I can reproduce in a PivotTable over here. I am happy to send you the Excel file if that helps. Sample file:   [obscured]  /s/3saosdp92lvfjqk/Book1.xlsx?dl=0
Category: Database Administration       

d****r01
 [?]
Sign in to view client's details.
| d****r01
|    United States
Hourly Rate: $10 - $15 / hr   |  Duration: Not Sure  |  Posted: Aug 25, 2015  |  Ends: 5d, 4h  |   43 Proposals
Hello: We are looking for a Microsoft Excel expert to help organize sales data for a small company. Candidate should be able to use pivot tables to: compile sales sheets/data from multiple months and regions, track monthly variance in customers, and plot and track ordering quantities and frequency for a small range of products. This company does not generate an overwhelming amount of data, but the excel organization task requires data to be organized in a way so that management can use the data to make strategic decisions. More details to be discussed upon engagement.
Category: Financial Reporting       

W****der
 [?]
Sign in to view client's details.
| W****der
|    United States
Hourly Rate: Not Sure   |  Duration: 1-3 months  |  Posted: Aug 23, 2015  |  Ends: 2d, 21h  |   10 Proposals
I posted this once before, but decided I wasn't ready. I am now. I have the money, the time, and the design. I have developed algorithms for using pivot tables in Excel, to decide which are the "best" pivots to do to get the most predictive models. I want to build these into Excel, presumably via a DLL, and sell it. I must locate licensing software/service I can purchase to lock down the DLL so that people will not be able to use if they do not pay. Suggestions are welcome. I have read that publishing over SharePoint people can steal your intellectual property, so I don't think I want to do that. I do not care if you write in VB (compiled), C#, Visual C++, etc. I am a somewhat experienced programmer, and can probably follow along as long as you include reasonable comments. I will purchase a copy of the version of Visual Studio you use, and review/compile the code as you go. This is a requirement of the project. I want to limit to about 10 hours a week, sometimes m...
Category: Software Application       
Preferred Location: United States

t****gid
 [?]
Sign in to view client's details.
| t****gid
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Aug 11, 2015  |  Ends: 35d, 15h  |   7 Proposals
Responsible for: - Assisting in the maintenance and monitoring of keyword bids, account daily and monthly budget caps, in tune with industry know how, optimization, quality score and other important account metrics. - Managing and maintaining updates for large keyword lists. - Providing creative copy suggestions. - Assisting in the management of display network placement lists on AdWords and through other contextual advertising platforms. - Providing recommendations and execute strategies for keyword opportunities, campaign structuring, targeting, display network, and other facets of paid search in accordance with client goals. - Providing support with the generation new paid search campaigns, ad groups, and accounts and aid in the creation of new paid search marketing initiatives. - Helping with media planning and buying. - Liaise with publishers, plan and strategize media schedules. - Generating tags for publishers via 3rd party tracking tools. - Troubleshooting creatives and tags i...
Category: Search Engine Marketing       

o****ent
 [?]
Sign in to view client's details.
| o****ent *
|    Australia
Fixed Price: Not Sure   |  Posted: Jun 26, 2015  |  Ends: 19d, 9h  |   23 Proposals
Responsibilities ? The individual should have a desire for data mining, scripting, problem solving and statistical analysis. ? The individual will be responsible for scripting data models, automating data feeds using BI tools to help visualize data and various ad hoc projects. ? The individual will also need to drive statistical analysis projects from beginning to end, and have working experience with regression, factor analysis, building models and predictive analytics. ? Strong communication skills to obtain stakeholder buy-in and convince audience on the quality of the delivered models are critical to this position. ? To work collaboratively with data scientists and analysts. ? Drive improvement in methodologies, systems and processes ? Have a deep understanding of large data, our data structures, and how to manipulate our data in an efficient manner ? Have working experience with statistical tools such as SPSS and SAS, have the ability to create statistical models, analyze factors...
Category: Software Application       
Skills: .NET Framework, Java, PHP       
Preferred Location: Philippines

H****ent
 [?]
Sign in to view client's details.
| H****ent *
|    Malaysia
Symbol Key
Payment method not yet verified
Payment verified
Purchased $1-$500
Purchased $500-$5,000
Purchased more than $5,000
You have already submitted a
proposal to this job