Partnership for providing Investment/Risk Analytics Service for your Investment Fund in New York

Looking for Small size Investment Funds in New York

Need of our Services: For any small size investment fund competing with global players where span of funds are generally very short, tactical victories becomes the most important for its survival. Your competition is global (and not local) with innovative companies in USA/EU/India and companies that are taking advantage of cost arbitrage. Automation of VBA-Excel-SQL-R-Python gives the Analyst more time to look at the market and focus on their core expertise. The new areas to contemplate are computations and compilations moving on cloud, storing unstructured large data, and parallel editing.

Moreover, at the time when attrition is a problem (all time low unemployment with toughest skill immigration environment) , a well documented automated setup not only saves time for the current person but also makes it easy to transfer knowledge to new persons joining the team or expansion.

Power of Open Source: Use of SQL/R/VBA/Python/Latex helps to have better data handling and analytic capability. These open source technologies and come with no extra software cost and we provide training to develop the source code to enhance it into the future. Batch files process / shell programming can help you automate lot of manual processes.

Access to Talent in India: Our team at Qcfinance.in will not only help you in automation but also help you to get access to the 2nd biggest place to find programming talent on the globe after the US. Most of the big analytics research team outside US is located in Bangalore / Bombay and there is always a possibility to get the very right talent / small team / partnership in India at substantially low cost. Wrongly implemented offshoring model often destroys value rather than saving cost.

Criticality of Time: For a small investment startup (2-10 people), the most valuable thing is TIME and hence we help you to tactically get the mundane task out of system, revisit the bottleneck, and hence you can then focus on the main product / strategy that makes your startup special.

Cost Benefit and Agility: We are comprehensively more affordable than any other Analytics consultancy due to our size and expenses. We can start with a very small project (duration & cost) and then move ahead if things get going. We are looking to focus only on one fund for a duration of 6-12m.

Technologies: MATLAB, R, VBA, SAS, Latex, SQL, Python, MongoDB others.

Almost all of the small funds have problems or opportunities for improvement in your workflow. Senior Analyst can fix them if they had the time or could train their employees with such expertise?

Here are the list of problems that we handle:

• Unforeseen, undocumented, forgiven, hidden cost of issues like below are bringing your profits
• Poorly-understood, legacy framework mostly into excel—dilapidated on unknown, unstated assumptions
• Slow process of calculations
• Un-scalable excel models that are difficult to maintain, improve, replicate or extend
• Increased pressure, requiring added reporting and enhanced auditing
• Lack of in-house research resources for SQL and R – both of which are open source (free – with no extra burden)
• Over-reliance on external novel untested software from vendors
• Not using the power of Google Cloud (other cloud) for sharing files and parallel editing models and documentations
• Cloud based Google Spreadsheet programming

QCFin provide quant automation and programming solutions for removing tech hurdles, enabling financial and consulting companies to create more value in their systems and employers which increases the valuation for the firm.

Domain of Analysis: From simple office tasks like automation of excel to more complex tasks like Monte Carlo simulations

About us:  QcFinance.in India is a vibrant startup and we are a small team (of three) working on Financial Analytics and have been in operation for over four years with a vast library of training videos, code and experience in Investment Projects and Automation. We have presence in NY and India making us aware of deficiencies, strengths and arbitrages that exist. We are looking for a right partner to form a tactical joint venture 6m-12m.

Team of Six: Two Senior Analyst (TBD), Shivgan Joshi (NYC), Ankit Virakta (NYC), Piyush L (Indore, India), Arpit Soni (Indore, India), other contractors based out of Indore, India and NY..

Bandwidth (per week): 40-80 hours onsite at NYC, 40-250 hours Indore, India. We commit to only one fund at one time for a time ranging from 6-18 months.

Pricing: 6-12 month Service Agreement.

Yours Sincerely,

Piyush L

International Business Development in New York

Qcfinance.in, India

piyush@qcfinance.in

https://in.linkedin.com/in/piyushl

Shivgan: (929) 356-5046

http://www.virtualassistantjobs.com/resume/dvvnlgpy-shivgan-joshi/

Tactical Partnership for providing Investment/Risk Analytics Service for your Company in New York

Tactical Partnership for providing Investment/Risk Analytics Service for your Company in New York

We are looking for New York clients / companies and looking to build up our presence.

Need: For any global investment fund / startup competing with global players, tactical victories becomes the most important area of value creation for the startup. Your competition is global (and not local) with innovative companies in USA/EU/India and companies that are taking advantage of cost arbitrage. Automation of VBA-Excel-SQL-R-Python gives the Analyst more time to look at the market and focus on their core expertise.

At the time when attrition is a problem, a well documented setup not only saves time for the current person but also makes it easy to transfer knowledge to new persons joining the team.

Power of Open Source: Use of SQL/R/VBA/Python/Latex helps to have better data handling and analytic capability. These open source technologies and come with no extra software cost and we provide training to develop the source code to enhance it into the future.

About us:  QcFinance.in India is a startup and we are a small team (of three) working on Financial Analytics and have been in operation for over four years with a vast library of training videos, code and experience in Investment Projects and Automation. We have presence in NY and India making us aware of deficiencies, strengths and arbitrages that exist.

 

Access to India: Our team at Qcfinance.in will not only help you in automation but also our team at IIR also helps you to get access to the 2nd biggest place to find programming talent on the globe. Most of the big research team outside US is located in Bangalore / Bombay and there is always a possibility to get the very right talent / small team / partnership in India at substantially low cost.

Criticality of Time: For a small investment startup (5-20 people), the most valuable thing is timing and hence we help you to tactically get the mundane task out of system, revisit the bottleneck, and hence you can then focus on the main product / strategy that makes your startup special.

 

Cost Benefit and Agility: We are comprehensively more affordable than any other Analytics consultancy due to our size and expenses. We can start with a very small project (duration & cost) and then move ahead if things get going.

Technologies: MATLAB, R, VBA, SAS, Latex, SQL, Python, MongoDB others.

How Qcfinance.in work with new startups:

How many times have you seen problems or opportunities for improvement in your workflow and promised to fix them if you only had the time or if you only could train your employees with such expertise?

• Unforeseen, undocumented, forgiven, hidden cost of issues like below are bringing your profits
• Poorly-understood, legacy framework mostly into excel—dilapidated on unknown, unstated assumptions
• Slow process of calculations
• Un-scalable excel models that are difficult to maintain, improve, replicate or extend
• Increased pressure, requiring added reporting and enhanced auditing
• Lack of in-house research resources for SQL and R – both of which are open source (free – with no extra burden)
• Over-reliance on external novel untested software from vendors
• Not using the power of Google Cloud (other cloud) for sharing files and parallel editing models and documentations

QCFin provide quant automation and programming solutions for removing tech hurdles, enabling financial and consulting companies to create more value in their systems and employers which increases the valuation for the firm.

Domain of Analysis: From simple office tasks like automation of excel to more complex tasks like Monte Carlo simulations

 

Yours Sincerely,

Piyush L

International Business Development

Qcfinance.in and IndoIsraelResearch.com

India

https://in.linkedin.com/in/piyushl

VBA Excel Classes in New York

Instructor led onsite VBA Class offers Excel classes in NYC for beginners, advanced Excel training, and Excel VBA training courses. Email or Call VBA Class to learn more about Excel.

VBA Consultant New York

Email us at new_york@Qcfinance.in / (929) 356-5046

We offer onsite lessons in NY and have tutors who are working with our team to be available in New York City, including Manhattan and also uptown.

VBA Class with no Prerequisites
We also offer a VBA Class online …
Excel Visual Basic Applications Class objectives:
Macros: Strengths and Weaknesses
How to Debug and Fix Macros, How to Handle Errors when they come
How to Utilize Variables and Arrays
How to Write Programs With the Visual Basic Editor
How to Use If/Then and For/Next Conditional Control Structures to Loop from Row to Row and Sheet to Sheet and Make Decisions
How to Call Excel Functions and Write New Functions
How to Create User Forms and Call Excel Dialogs
Helpful Resources And Much More

VBA Private Training

VBA Private Training We recognize that many clients have one-time projects for which they need specific assistance. Excel Training NYC offers private VBA training upon request. Hourly rates start at $30 (mixed of online and on location). More hours would qualify for a discount! These are mixed rates for onsite and online mix in New York / Manhattan areas.

Class Tags:
New York excel
New York visual basic
Union Square classes
Manhattan classes

We Serving New York and surrounding area.

A part of classes is taken onsite at a location in New York, a part online with the help of offshore team, and most of assignments are executed on your own system.

Locations that you are request are:
Mid Town, New York
Lower Mahatten, New York City
East Village New York City
Garment District in New York City

Offerings: I might help you to outsource some of the automation, programming and analytical tasks to Qcfinance India (I am one of the co-founders of the company since 2012). QCFinance helps startups with limited resource to be more efficient by providing solution aimed to enhancing valuations of small companies (5-20). Since I am in NYC, I will make sure that you are completely satisfied, and since I was a part of the team I know the team in India very well. In India, I have worked in Captives and 3rd Party service providers for various banks like: Deutsche bank (Index quant team), Wells Fargo (CIB), XL Catlin Investments (New York team).

Demo Pricing: You may even outsource a very small pilot project / training assistance @ $30-50/hour to start with! With mix of training and project outsourcing, you can make your employees more productive, also the automation of mundane task will enhance the value of your startup! All top investment banks and companies today have their offices in India hence India has become an important place to do business more than ever.

I have a strong belief that once you understand more about the Indian outsourcing industry you will have a better chance of using it to add value to your company.

How Qcfinance.in work with small companies:

How many times have you seen problems or opportunities for improvement in your workflow and promised to fix them if you only had the time or if you only could train your employees with such expertise?

Unforeseen, undocumented, forgiven, hidden cost of issues like below are bringing your valuations down:
Poorly-understood, legacy framework mostly into excel--dilapidated on unknown, unstated assumptions
Slow process of calculations
Un-scalable excel models that are difficult to maintain, improve, replicate or extend
Increased pressure, requiring added reporting and enhanced auditing
Lack of in-house research resources for SQL and R -- both of which are open source (free -- with no extra burden)
Over-reliance on external novel untested software from vendors

QCFin provide quant automation and programming solutions for removing tech hurdles, enabling financial and consulting companies to create more value in their systems and employers which increases the valuation for the firm.

Technologies: MATLAB, R, VBA, SAS, Latex, SQL others.

Analysis: From simple office tasks like automation of excel and latex reports to more complex tasks like Monte carlo simulations

Sample course:
LEVEL 1: EXCEL FUNCTIONS
1.1: INTRODUCTION
1.2: WORKSHEET FUNCTIONS
1.3: MATH/LOOKUP FUNCTIONS
1.4: COMPOUNDING
1.5: INTEREST RATES
1.6: DISCOUNT FACTORS
1.7: BOND PRICING
1.8: OFFSET
1.9: PIVOT TABLES
1.10: HOMEWORK PREP

LEVEL 2: VBA BASICS
2.1: SUBS/FUNCTIONS
2.2: VARIABLES
2.3: VECTORS
2.4: LOOPS
2.5: BOND PRICING
2.6: STATEMENTS
2.7: LINEAR INTERPOLATION
2.8: LINEAR INTERPOLATION - CODE
2.9: FORWARD RATE CURVE
2.10: FORWARD RATE CURVE – CODE
2.11: HOMEWORK PREP

LEVEL 3: OPTION PRICING
3.1: OPTION PAYOFF MODEL
3.2: BINOMIAL ASSET PRICING MODEL
3.3: BINOMIAL ASSET PRICING MODEL - CODE
3.4: BLACK SCHOLES

3.5: HOMEWORK PREP
LEVEL 4: CLASSES
4.1: CELL VS RANGE
4.2: USER DATA TYPES
4.3: COLLECTIONS
4.4 CLASSES
4.5: PORTFOLIO ANALYSIS
4.6: VALUE AT RISK
4.7: HOMEWORK PREP

LEVEL 5: DATA STRUCTURING
5.1: SELECTION
5.2: CHARTS
5.3: FILE MANIPULATION
5.4: USERFORMS
5.5: PIVOT TABLES - CODE
5.6: SQL IN VBA
5.8: INTERVIEW TIPS

5.9: CASE STUDY 



https://youtu.be/1Rk6FmpqVk0

https://youtu.be/z-EuWqEWVH8

http://www.tutoringhelp.org/tutors/NY/New-York/357241


Importing csv:
http://www.homeandlearn.org/open_a_text_file_in_vba.html

Charts:
http://www.homeandlearn.org/vba_charts_sheets.html

List of Files:
https://trumpexcel.com/list-of-file-names-from-a-folder-in-excel/

Workbook play:
https://analysistabs.com/excel-vba/open-close-existing-workbook/

Option Explicit:
https://wellsr.com/vba/excel/vba-option-explicit/

Screen Updating:
https://stackoverflow.com/questions/38122480/application-screenupdating-in-subroutine-called-within-subroutine

Run when worksheet is activated:
https://ccm.net/faq/5675-excel-run-a-macro-when-opening-a-sheet

Workbook open then activate:
https://www.mrexcel.com/forum/excel-questions/39172-auto-run-macro-when-open-worksheet.html

Complexity and Recursion

Complexity and Recursion



Complexity of Algorithms - how to find out how it is log



Table to calculate - which complexity



If there is a power: n^2




Logic of what? Chapters of logic.

Advanced Topics in SQL - SQL tutor / class in NYC New York Manhattan

SQL tutor / class in NYC New York Manhattan
Basic Topics:
Executing a Simple Query
Working with Functions
Organizing Data
Retrieving Data from Multiple Tables using Joins
Presenting Query Results
Querying Using Subqueries
Manipulating Table Data
Views
Indexing
Transactions
Decision
Format
Stored Procedures
Automation


Converting numbers to dates using timestamps. - this is topic of Orcale SQL, but I guess I will get something related to SQL Server.

Exceptions, error handling in the code
http://logicalread.solarwinds.com/sql-server-exception-handling-try-catch-throw-mc03/#.Vxj1I_l97IU
http://blog.sqlauthority.com/2007/04/11/sql-server-2005-explanation-of-trycatch-and-error-handling/

Handling duplicates

Date functions
http://www.w3schools.com/sql/sql_dates.asp
https://technet.microsoft.com/en-us/library/aa258265(v=sql.80).aspx
https://msdn.microsoft.com/en-us/library/ms186724.aspx

Intercept, except, union, union all - the differences between them

Inline Table-Valued Functions
https://technet.microsoft.com/en-us/library/ms189294(v=sql.105).aspx
https://www.youtube.com/watch?v=hs4mReAzESc

Recursive Queries,
This is done using CTE - where we will keep doing some recursion until we are done

APPLY Operator,



Offset Window

TOP and OFFSET-FETCH;


http://dbadiaries.com/new-t-sql-features-in-sql-server-2012-offset-and-fetch

Data Modification; Working with Date and Time;
http://sqlmag.com/t-sql/t-sql-classic-date-functions

Questions on Date:
http://www.sql-server-helper.com/faq/dates-p01.aspx
Many interesting questions are listed on:
http://stackoverflow.com/questions/tagged/sql-date-functions

Programmable Objects, Transactions and Concurrency, Exception Handling); In-Memory OLTP.

Along the course you will learn how to use T-SQL to solve practical problems such as:

Relational Division, Missing and Existing Ranges (Gaps and Islands),

Separating Elements, Pivoting and Unpivoting, Ranking and Offset, Running Totals, Moving

Averages, YTD, Custom Aggregations, Dynamic Analysis of Grouping Sets, TOP and

OFFSET-FETCH Problems,

Paging,

Data De-Duplication,

Handling Sequences,

Merging Data,

Treatment of Temporal Intervals (Intersection, Max Concurrent, Packing),

Dynamic Filtering,

Migrating On-Disk to Memory Optimized Data,

Internals and index tuning,

including coverage of Column store data, index access methods, temporary

tables,

set vs. cursors,
http://stackoverflow.com/questions/24168/why-are-relational-set-based-queries-better-than-cursors

Cursors enable manipulation of whole result sets at once. In this scenario, a cursor enables the rows in a result set to be processed sequentially. In SQL procedures, a cursor makes it possible to define a result set (a set of data rows) and perform complex logic on a row by row basis.

query tuning using query.

Triggers

HIERARCHYID datatype
https://www.simple-talk.com/blogs/2012/04/24/hierarchical-queries-with-common-table-expressions/

New York
New York city
Manhattan
SQL Tutor Trainer



Advanced SQL Topics

Functions, Stored Procedures, Packages
Pivoting data: CASE & PIVOT syntax
Hierarchical Queries
Cursors: Implicit and Explicit
Triggers
Dynamic SQL
Materialized Views
Query Optimization: Indexes
Query Optimization: Explain Plans
Query Optimization: Profiling
Data Modelling: Normal Forms, 1 through 3
Data Modelling: Primary & Foreign Keys
Data Modelling: Table Constraints
Data Modelling: Link/Corrollary Tables
Full Text Searching
XML
Isolation Levels
Entity Relationship Diagrams (ERDs), Logical and Physical
Transactions: COMMIT, ROLLBACK, Error Handling

Dynamic SQL

Dynamic SQL




Example from AdventureWorks:
http://www.sqlusa.com/bestpractices/dynamicsql/
http://sqlusa.com/bestpractices/training/scripts/dynamicsql/
https://www.mssqltips.com/sqlservertip/1160/execute-dynamic-sql-commands-in-sql-server/
http://stackoverflow.com/questions/2588013/dynamic-sql-to-query-an-adventureworks-table
http://www.sqlteam.com/article/using-dynamic-sql-in-stored-procedures
http://oakdome.com/programming/SQL_DynamicSQL_sp_executesql.php
http://www.kodyaz.com/articles/t-sql-pivot-tables-in-sql-server-tutorial-with-examples.aspx
https://www.brentozar.com/archive/2013/11/filtered-indexes-and-dynamic-sql/

Dynamic SQL and Procedures:
https://www.youtube.com/watch?v=MiAwOoelu9k

SQl Server Dynamic SQL:
https://www.youtube.com/watch?v=jS3kpNavKM8

Dynamic SQL / Adhoc SQL (6 min short video):
https://www.youtube.com/watch?v=aRr6q4V0sXY

Table names would vary at run time and schema would vary at runtime:
https://www.youtube.com/watch?v=n3odG4bl4LE

Advanced SQL

Advanced SQL consist of new queries in SQL

There is over 100 videos and interview questions on: https://www.youtube.com/user/kudvenkat

i want to master of joins, paritition, views, trigger, dynamicswql

what database do you practice?

functions, proc, in oracle pl sql

http://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_10002.htm#i2077142

SELECT

The WITH query_name clause lets you assign a name to a subquery block. You can then reference the subquery block multiple places in the query by specifying query_name. Oracle Database optimizes the query by treating the query name as either an inline view or as a temporary table.

docs.oracle.com

i have both oracle sql and ms server 2008

try 2 question for today

1.

find the 2nd highest salary of employees table

2. list employees alongwith their manager in employees table

this was asked in interview with me in the currentjo

3. find information of those employees whose salary is greater than average salary of their respective departments

after that query that I sent you

it returns 1st row of each join no matter how many matches are there

if in two tables you only want to join first row and no other row

you need to use row_number, partition by and subquery

this question is trending now in interviews

select * from employees x, (select DEPARTMENT_ID,avg(salary) avg_salary from employees group by department_id) y where x.department_id=y.department_id and x.salary>y.avg_salary;

this is query to compare salary of each employee against avg salary of department and display only those with highest salary

can you write query to select max salary for each department?

using cte

WITH cteRowNum AS ( SELECT DeptID, EmpName, Salary, DENSE_RANK() OVER(PARTITION BY DeptID ORDER BY Salary DESC) AS RowNum FROM EmpDetails ) SELECT DeptID, EmpName, Salary FROM cteRowNum WHERE RowNum = 1;

These analytical functions are known as window function in sql server

CTE:
http://sql-beginner.blogspot.co.il/2012/09/difference-between-cte-and-sub-query.html
https://technet.microsoft.com/en-us/library/ms190766(v=sql.105).aspx

https://en.wikipedia.org/wiki/Hierarchical_and_recursive_queries_in_SQL
https://technet.microsoft.com/en-us/library/ms186243%28v=sql.105%29.aspx?f=255&MSPPError=-2147217396
https://www.youtube.com/playlist?list=PL08903FB7ACA1C2FB
http://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_10002.htm#i2077142
dynamic sql

R code for Breaking X/Y axis

# http://stackoverflow.com/questions/19612348/break-x-axis-in-r
# http://www.statmethods.net/advgraphs/axes.html
# http://www.inside-r.org/packages/cran/plotrix/docs/axis.break


# Example 1
x <- c(9.45, 8.78, 0.93, 0.47, 0.24, 0.12)
y <- c(10.72, 10.56, 10.35, 10.10, 9.13, 6.72)
z <- c(7.578, 7.456, 6.956, 6.712, 4.832, 3.345)
plot(x, y, col='blue', pch=16, xlab= 'x', ylab='y, z')
points(x, z, col='red', pch=17)
library(plotrix)
axis.break(1,2,style="slash")



#Break X axis

xgap <- ifelse(x > 8, x-6, x)
#Possibly you'd want to check if there are values between 2 and 8.
plot(xgap, y, col='blue', pch=16, xlab= 'x', ylab='y, z', xaxt="n")
points(xgap, z, col='red', pch=17)
xat <- pretty(xgap)
xat <- xat[xat!=2]
xlab <- ifelse(xat>2, xat+6, xat)
axis(1,at=xat, labels=xlab)
library(plotrix)
axis.break(1,2,style="slash")


library(plotrix)
par(bty="n") # deleting the box
gap.plot(x,y, gap=c(2,7.5), gap.axis="x", pch=16,
         col="blue", ylim=range(c(y,z)),
         xtics=c(0:3,8:10), xticlab=c(0:3,8:10))

gap.plot(x,z, gap=c(2,7.5), gap.axis="x", pch=17,
         col="red", ylim=range(c(y,z)), add=TRUE); axis(2)

abline(v=seq(1.99,2.09,.001), col="white")  # hiding vertical lines
axis.break(1,2,style="slash")  



# Break Y Axis

ygap <- ifelse(y > 8, y-6, y)
#Possibly you'd want to check if there are values between 2 and 8.
plot(ygap, x, col='blue', pch=16, xlab= 'x', ylab='y, z', yaxt="n")
points(ygap, z, col='red', pch=17)
yat <- pretty(ygap)
yat <- yat[yat!=2]
ylab <- ifelse(yat>2, yat+6, yat)
axis(2,at=yat, labels=ylab)
library(plotrix)
axis.break(2,2,style="slash")

OLAP Cubes in SQL Server for Adventure Works

OLAP Cubes in SQL Server for Adventure Works





References:
https://techpunch.wordpress.com/2008/09/08/sql-server-2008-how-to-build-and-deploy-adventureworks-olap-cubes/

https://www.youtube.com/watch?v=ctUiHZHr-5M

To install Other Databases check out
https://www.youtube.com/watch?v=iKVbx5IeUvQ

Importing HTML file in Excel using VBA

This proc opens HTML files in excel, copy it into the sheet and then close the html without saving.
This ways you can import data from various html files into excel.
This can be modified to import values from other format like XML also.
This is a although very mundane way but VBA 6 is very old, VBA.NET might have something better.

For learning more VBA skills please check out our courses at Qcfinance.in

Sub Import()
Dim oExcel As Excel.Application
Dim ws, ws2, ws3 As Worksheet
Dim wb As Variant
Dim wkb As Variant

Set activewkb = ThisWorkbook
Path = ActiveWorkbook.Path

   Dim StrFile As String
    Path = ActiveWorkbook.Path
   ' MsgBox Path
    StrFile = Dir(Path & "\HTML\")
    Do While Len(StrFile) > 0
        MsgBox StrFile
        StrFile = Dir
   ' MsgBox StrFile
       
    Set wb = Workbooks.Open(Path & "\HTML\" & StrFile)
On Error Resume Next
'MsgBox ActiveWorkbook.Path

For Each sh In wb.Sheets
      sh.Copy after:=activewkb.Sheets(activewkb.Sheets.Count)
   Next sh

'MsgBox "The name of the active workbook is " & ActiveWorkbook.Name
wb.Close savechanges:=False

Loop
End Sub

Debug Command to print Files

Sub LoopThroughFiles2()
    Dim StrFile As String
    Path = ActiveWorkbook.Path
    StrFile = Dir(Path & "\")
    Do While Len(StrFile) > 0
        Debug.Print StrFile
        StrFile = Dir
    Loop
End Sub

Demand of Java and Javascript will create the most Jobs in 2015

Since we are in IT Boom the highest demand would still be in the same areas as it has been in last five years.

I am attaching below the images and charts of the most popular coding language which will pay you the best salary in 2015.

Python is used extensively in Big Data Analytics with the Panda library.

JavaScript and full stack developer, Angular JS,  are some terms that I see most often.

Big data boom is still be realized but most of the work still remains in labs.

Python and mongoldb

Python and Mongol database




New Boston

Pycharm

Why R when you can do. with python

Create connection in python ...



Python- Lists, Strings, Indexing, Slicing, Tuples & Dictionaries.
Knowledge in Python Object Oriented - Creating Classes, Constructors, Overloading & Modules.
Knowledge in NumPy or Pandas.
Knowledge in STATISTICS Or DATA SCIENCE

Best Journals - List and ideas

Best Journals - List and ideas.

Innovation

Private Equity

Human Organization

Entrepreneurship

Israeli companies

Replying to Research done earlier this year in 2015 on the areas of our concern.

There are studies that suggest that the best journals in the area is

http://www.varietyofinnovation.org/?p=318

Another page that will help to get to best journals is

http://elpub.bib.uni-wuppertal.de/edocs/dokumente/fbb/wirtschaftswissenschaft/sdp/sdp12/sdp12002.pdf

Ranking Comparison of Innovation Management and Entrepreneurship Journals

http://onlinelibrary.wiley.com/journal/10.1111/(ISSN)1540-5885

http://onlinelibrary.wiley.com/doi/10.1111/jpim.12229/full

Journal of business Venturing: it is one the top ranked journal for entrepreneurship and Innovation. 

http://www.journals.elsevier.com/journal-of-business-venturing/

http://www.journals.elsevier.com/research-policy/

Best papers to be used to prepare literature review

Om Paper innovation in Israel

http://link.springer.com/article/10.1007/s10708-015-9676-9#/page-1

http://eds.b.ebscohost.com/eds/detail/detail?sid=9c2ef907-31bc-4e00-84f6-f7a96718792b%40sessionmgr198&vid=0&hid=121&bdata=Jmxhbmc9aGUmc2l0ZT1lZHMtbGl2ZQ%3d%3d#db=bsx&AN=101668192

http://link.springer.com/chapter/10.1007/978-3-319-18986-4_3

Does plays a role? Links from Research Policy.

http://www.sciencedirect.com/science/article/pii/S0048733315001687

http://www.sciencedirect.com/science/article/pii/S0048733315001481

http://www.sciencedirect.com/science/article/pii/S004873331500147X

Journal of Information System:

http://pubsonline.informs.org/loi/isre

Research Policy Journal:

http://www.journals.elsevier.com/research-policy/

http://www.sciencedirect.com/science/journal/00487333/45/1

 Acquiring long technology vs doing all the research has been a major question.

http://onlinelibrary.wiley.com/doi/10.1111/jpim.12224/abstract

More References from Journal Product Innovation:

http://onlinelibrary.wiley.com/doi/10.1111/jpim.12224/abstract

http://onlinelibrary.wiley.com/doi/10.1111/jpim.12239/abstract

Organizational Research

http://onlinelibrary.wiley.com/doi/10.1002/smj.2334/abstract

http://orm.sagepub.com/content/18/3/542.abstract

http://oss.sagepub.com/content/36/7/925.abstract

http://onlinelibrary.wiley.com/doi/10.1002/bdm.1868/abstract

http://onlinelibrary.wiley.com/doi/10.1002/bdm.1849/abstract

http://onlinelibrary.wiley.com/doi/10.1002/bdm.1837/abstract

http://oss.sagepub.com/content/36/10/1337.abstract

http://oss.sagepub.com/content/36/10/1315.abstract


Journal of Strategy Management

http://onlinelibrary.wiley.com/journal/10.1002/(ISSN)1097-0266

http://onlinelibrary.wiley.com/journal/10.1002/(ISSN)1097-0266/issues

Journal of Business Venturing

http://www.sciencedirect.com/science/article/pii/S0883902615000415

http://www.sciencedirect.com/science/article/pii/S0883902615000142

http://www.sciencedirect.com/science/article/pii/S0883902614000913

Management

http://pubsonline.informs.org/doi/abs/10.1287/mnsc.2015.2249

http://pubsonline.informs.org/doi/abs/10.1287/mnsc.2015.2220

matlab for mech engg

Study subjects:
1. Introduction to Programming. Operating and basic applications in BALTAM) sequence, formulas (.
2. The program flow control commands terms.
3. Loops.
4. vectors, matrices, functions. Graphics in BaltaM.
5. Finding equivalent system of forces and moments.
6. Calculation of cable tensions planar structure.
7. Calculation of cable tensions spatial structure.
8. Calculation of forces complicating flat rods.
9. bars complicating calculation of spatial forces.
10. Calculation of forces on the busy main buildings.
11. Moment of inertia. Calculation of the busiest buildings on forces deploying forces.

SPSS

Excel subjects:

Using copy, cut and paste in the excel environment

Formatting cells and spreadsheets

Functions: statistical, logic

Sorting, Filtering and managing data

Data presentation

Goal seeking, Evaluating alternatives.

SPSS subjects:

Combination of  files.

Variable and data sheets

Command creation and Output analysis of:

Transformations: recode; compute, count. Conditioned transformations

Descriptive statistics: Frequencies

Data analysis: Bivariate correlations; t-tests; х²

https://wagner.nyu.edu/files/syllabi/201209/CORE-GP.1011.001.pdf

https://www.publichealth.uga.edu/cgh/sites/default/files/HealthRisk_SPSS_Course_Proposal_02_20_2013_0.pdf

http://qipsr.as.uky.edu/sites/default/files/SPSS%20syllabus.pdf

http://staff.washington.edu/glynn/spssclas/syllabus.pdf