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

Reading from Excel & Heatmaps

I am going to talk about some topics of MATLAB.

Heatmaps in MATLAB
http://in.mathworks.com/help/bioinfo/ref/heatmap.html

Colors:
http://buli.waw.pl/matlab-heatmap-colormap/

Reading from Excel:
http://in.mathworks.com/help/matlab/ref/xlsread.html

Not able to save due to security reasons
xlswrite('d:\myExample.xlsx',[headers; values]);


http://in.mathworks.com/help/bioinfo/ref/datamatrix.html

Youtube Video Editing

Youtube Video Editing

Developing SQL Framework for ESG

Developing SQL Framework for ESG

Finding out the keys and the normalization

Wordpress

http://sourceforge.net/projects/xampp/

Software Companies in Indore

Software Companies in Indore

Impetus
Infobeans
CSC
CDN
Viscus
Yash Tech
Infocus
Seed Infotecch


Gate 6 , beyondkey, diaspark, webduniya, walkover


1. CSC (actually it came from acquisition of PMSI)
2. Impetus
3. Infobeans
4. Diaspark (formerly Suvi)
5. Twist Mobiles
6. Apticraft
7. Kalptaru
8. Ideavate
9. Ruchi Infotech (of Ruchi Soya Group)
10. Rave Infosys
11. Mphasis (They only have BPO)
12. Yash Technologies

CSC

Twist mobile

EngineerBabu

Vatsana

Manthan Mania

Impetus

CDN

Indori Zyka

FYI

Echai

Dispark

http://www.dailypioneer.com/state-editions/bhopal/mp-bid-to-draw-investments--in-it-sector.html

https://www.cisin.com/aboutus.htm

Global best place to work as SE:
http://itflow.biz/10-best-countries-fordevelopers/

Post Under Development -


One of the books I often hear about is "Stochastic Calculus for Finance I by Steven E. Shreve"

Online Course on Basic Latex

For any reseacher or publisher Latex is the most important tool, for all MS / PhD Students who want to deal with big thesis Latex is the only solution. I use Latex interchangeably with Miktex which is shown below.

To start with please download the below files and install in the same order:
texstudio2.8.6_win_qt5.3.1
https://www.texstudio.org/
basic-miktex-2.9.5105-x64
https://miktex.org/download

First step is to run Texstudios as shown in: http://docs.miktex.org/2.9/manual/localguide.html#gettingstarted



Second step: Opening an old file to get the syntax:
The extension for these files is .tex


\documentclass{article}

\title{Proposed Change g}
\author{Shivgan}

\begin{document}
\maketitle

\section{Introduction}
The new section below

\section{New Formulas}

Given below are the formulas for standard deviations.

 \[Stdeev (P_{n}-P_{n+1}) \] 

\[ \frac{P_{n+1}- P_{n}}{P_{n}}\] 

\section{Conclusion}
Not much of a paper, but it's a start.

\end{document}


The above code in italic is the first code you should execute.

This begins your journey in Latex.

ACET Exam Prep

ACET Exam Strategy

Calculator used Casio: FX 82 MS
Price of calculator: 425

Calculations shows:
Nth root
factorial
NcR
hyperblic
one memory function

eigen value vector
5 marks

memory storage  -


Deriving all series formulas

Taylor series and Maclaurin series

Eigenvectors and eigenvalues

Lagrangian multipliers


negative expansion
eigen vales
english

ap gp hp
o(x)

a^x

Maclaurin series

Taylor series 

Poissiin
2nd moment
Newton rhadpin


The 2nd moment for continuous and discrete distributions.

There is great deal of depth in getting parameters of Poisson distributions

Newton Rhapson steps are tricky - answer at nth step

So from the fundamentals - they did touch last areas given at the end of each chapter

Also Diff of integration needs to be revisited

Instructor Based Introductory Course To R - R for finance/ Analytics Online Course & Projects at qcfinance.in

COURSE LINK - Introduction to R

Course Highlights:

1. No pre-knowledge of R required.
2. Get started with Programming in R.
3. Get Practical examples to understand better.
4. Gives an Idea of it’s financial applications as well.
5. Highly flexible and tailored according to individual needs.
6. Contains perfect blend of theory and practice
7. Gain confidence with R.
8. 4 interactive classes with experienced teacher.
9. Personalized approach.
10. Flexible timings.

Now ask for as low as just one customized  session (1 hour) from qcfinance.in at $20.

Course Description:

One on One course Introductory course for R. 4 hours of basics of R to get you started in R. Flexible timings with personalized approach by Experienced Faculty. Online tests to prepare yourself better. This course will help you in:

• Add to the profile by learning R.

• Provides a base for learning advanced R.

• Gives you a perfect platform for launching a career in R.

• Gain the knowledge of  integration with excel  .

We use 2 pluggins -

1. XLconnect

2. Rexcel to connect excel & R

+we  also  give consultancy

Course Structure:

Class No.	Topics for CFA L1	Class duration
1	Installing R, Intro to R packages, R as calculator	1 hour
2	Matrix in R, Indexing in R, Intro to ARIMA, Regression in R	1 hour
3	Connecting R with Excel, Importing CSV, Input methods, connecting R with external sources feeds like QuantDL	1 hour
4	Revision/Doubt Clearing	1 hour

About the Author:

Shivgan Joshi

Indore, India

Shivgan Joshi holds a B.E. from Shri Vaishnav Institute of Technology, Indore & PGDF (Post Grad Diploma in Finance) from Business India Institute of Finance, New Delhi. Have worked extensively on VBA, MATLAB, R & others. He has cleared CFA Level 1 and FRM L1 and has scored 70% in BAT (in top 10 percentile globally approximately). He has taken more than 500 classes on GRE & GMAT preparations in last 1 year. He has published research papers in top journals like IEEE, LNCS Springer and more. He writes a popular blog: Stock Credit Finance CFA on Blogspot.com.

Guest Faculty: Nehal Jain

Nehal holds a B.E. degree in Electronics and Communication from IIST-II, Indore. Her key skills include R, MATLAB ,C , C++, Core Java and Advance Java.

Note: If you miss a scheduled one on one class, then don't worry, you can reschedule it at your convenient time & the missed class won't be counted. You may defer a class any number of time. Also, you get life time access to materials which gets constantly updated.

Contact Us: info@qcfinance.in

Skype Id: qcfinancein

Learning RDBMS and Advanced SQL in New York

Personalized 60 hours of Live interactive classes to help you learn RDBMS AND Advanced SQL in New York

Our Approach for RDBMS AND Advanced SQL course is individual specific. In this regard, we offer one on one RDBMS AND Advanced SQL sessions for better overall preparation. The classes are customized according to the requests made by our students. We can cut short the classes or extend them as per the requirements of our students. This way we can serve them much better.

Course Fee would be

Now ask for as low as just one customized  session (1 hour) from qcfinance.in at $20.

Overview

This Course is meant for who are beginner in Database technology.

This course is mainly focusing on the theoretical aspects of RDBMS AND Advanced SQL with few practical sessions. For all the sessions that will be covering in this particular course will be always relating to some of the real time scenarios so that it will be helpful for your career in database. Course will be mainly focusing on real time scenarios in the IT industry and along with the theoretical sessions we do have parallel Practical sessions too. And it covers most of the Advanced SQL Concepts which is widely used in IT industry.

Course Objectives:

On completion of this course, successful participants will be able to:

• Perform effectively as entry level software professionals.
• Writing different Queries to access the database.
• Develop and maintain programs in the platform they have studied.
• Contribute as members of a team.
• Get a hands-on experience on the concepts learnt during the course.

Who Should Attend-

This course is for Graduates and postgraduates also for working professionals who doesn't have any idea about the database concepts. This course will be useful for people who are looking to crack a database Related job interview or who are going to work on database without any prior knowledge on SQL. And anyone who needs to design, develop and maintain SQL databases.

Course Highlights

Upon successful completion of this course, students will be able to:

• Understand the basic concepts of relational databases ensure refined code by developers.
• Create reports of sorted and restricted data.
• Run data manipulation statements (DML).
• Control database access to specific objects.
• Manage schema objects.
• Manage objects with data dictionary views.
• Retrieve row and column data from tables.
• Control privileges at the object and system level.
• Create indexes and constraints; alter existing schema objects.
• Create and query external tables.
• The design of databases, including normalization.
• Improving performance with indices and partitions.
• Presenting different perspectives on the data with views.
• Programming databases with stored procedures and triggers.
• Data warehouses and data marts.
• Protecting against data degradation and SQL injection

Benefits To You

Gain expertise in relational database data management as you learn how to effectively use SQL commands against your business data. These features will help you query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects.

Language of Instruction: English

Course Package:

• 60 Interactive Live classes

• Schedule: 9AM-11 PM IST Weekdays & Weekends

• 10-15 PPTs

Other Details:

• It is a personalized one-to-one course
• Course starts within a week of enrollment
• Free download access for course content and class recordings

Why should you enroll in this course?

• Provides details about RDBMS AND Advanced SQL
• Highly flexible and tailored as per needs of individual
• Gain confidence in RDBMS AND Advanced SQL which will add to your profile
• Examples with real data to enhance your IQ
• Contains right blend of learning and practice (Ratio 6:4)
• Real recent examples and real cases
• New interpretation, terminologies, and basic IQ for the subject covered

How this course will benefit you?

• Adding to the profile by learning RDBMS AND Advanced SQL.
• Base for learning advanced SQL
• Perfect platform for launching a career in RDBMS AND Advanced SQL.

Topics covered in the course:

RDBMS

Class No.	Topic	Class  duration (in hours)
1	Introduction to Database Management System.	2
2	Basic Concepts in DBMS	2
3	Client Server Computing.	2
4	Database Administrator.	2
5	E-R Model.	2
6	Normalization.	2
7	Relational Model.	2
8	Operations on DBMS(DDL,DML)	4
9	Security & Integrity.	2
10	Structure_&_Architecture of DBMS.	2
11	Transaction Management.	2
12	Evolution Of Database Management System.	2
13	Advantages_&_Disadvantages of DBMS.	2
14	Summary	2

Note: *Mix can be changed as requirements

ADVANCED SQL

Class No.	Topic	Duration(Hrs.)
1	Introduction to  SQL	2
2	Syntax for SQL scripts	2
	DML & DDL
	Select SQL
3	Distinct SQL	4
	Where SQL
	And & Or SQL
	Order By SQL
4	Insert Into SQL	4
	Update SQL
	Delete SQL
	Select Top SQL
	Like SQL
	Wildcards SQL
5	In SQL	4
	Between SQL
	Aliases SQL
	Joins SQL
	Inner Join SQL
6	Left Join SQL	4
	Right Join SQL
	Full Join SQL
	Union SQL
	Select Into SQL
7	Into Select SQL	4
	Create DBSQL
	Create Table SQL
	Constraints SQL
	Not Null SQL
	Unique SQL
8	Primary Key SQL	4
	Foreign Key SQL
	Check SQL
	Default SQL
	Create Index SQL
9	Drop SQL	4
	Alter SQL
	Auto Increment SQL
	Views SQL
	Dates SQL
10	Null Values SQL	4
	Null Functions SQL
	Data Types SQL
	DB Data Types
	SQL Functions
11	Avg() SQL	4
	Count() SQL
	First() SQL
	Last() SQL
12	Max() SQL	2
	Min() SQL
	Sum() SQL
	Group By SQL
13	Having SQL	4
	Ucase() SQL
	Lcase() SQL
	Mid() SQL
	Len() SQL
14	Round()SQL	2
	Now()SQL
15	Summary	2

Note: *Mix can be changed as requirements

Link for the course on wizIQ:    

Link  for Youtube videos:

Link for the course on Udemy:  

Tutorials:

Learning  RDBMS AND Advanced SQL

Custom Video Solutions:

In yet another innovation to simplify things for our learners, qcfinance.in has introduced the Custom Video Solutions Options. If a learner has some specific query but don't have the time to come to live online class, then he/she can ask for custom video solution for the query. qcfinance.in will make a video recording that will be uploaded to YouTube or given directly to the learner in mp4 format for their viewing. A learner can go through the recording as per there convenience. If still doubts exist, he/she can email us anytime for clarifying them.

Here are some examples of custom video solutions provided by qcfinance.in:

Note: If you miss a scheduled one on one class, then don't worry, you can reschedule it at your convenient time & the missed class won't be counted. You may defer a class any number of time. Also, you get life time access to material which gets constantly updated.

ABOUT THE INSTRUCTOR

Shivgan Joshi
Founder and Instructer at Qcfinance.in


Twinkle Sebastian

She is working in SAP as a database developer with 2 years of total experience. Have completed MCA from Christ University.

External Links:
https://borntolearn.mslearn.net/certification/database/f/516/t/321649

Frequently Asked Questions: http://qcfinance.in/FAQ.pdf

Contact Us: info@qcfinance.in

Skype Id: qcfinancein