Business Intelligence (BI)

Recent redundancy has given me a chance to hone my skills in areas of interest – One of these areas is Business Intelligence Development which enables businesses to perform analysis from vast and complex data.  I have obtained the 70-448 BIS development and maintenance training kit and jumped into the deep end of BI SQL!

For my Masters dissertation I will need to perform an analysis of data and present my findings.  The theory was that I would develop a relational database, an application to analyse my data and use the graphs to present my results.

But before that, there’s Developing SSIS Packages, Developing SSAS Cubes and SSRS Reporting to get around plus some Data wharehousing principles and theory.

Handy that I have the time!

Shares….The Miners!

MinersIt has been a while since I posted anything concerning the shares – This year has proven to be an absolute nightmare for any private investor with the markets showing a loss right across the board.

The AIM market has been hit particularly hard, most of the shares I was holding lost at least 60 – 70% of their value in the course of 6 months and to date have not recovered.

An article published 15/12/11 on the iii by Sarah Modlock and Fiona Bond covering the mining sector covers a few choice penny stocks in this area which are tipped for bigger things.

Granted, good value amongst these stocks, but where is Central Rand Gold (CRND.L) in this article?  4p a share earlier this year in January, tumbled to its lowest around 0.22p when their mining rights were revoked in September.  Good news has since flowed and mining rights have been granted allowing operations to continue.

Obviously this is a risky investment, but rights granted and a 2 year forecast back to 4p you can be sure to put a small punt in an ISA for tax free profits.

CRND is currently trading at 0.7p @ market close on the 16th December.

Soapy soapy

I have delved into the world of homemade soap making.  Hot oils, fats and some caustic soda litter my shed, alongside a vast selection of essential oils and recipes.

When I have a few hours to spare, a trip to the shed to escape the noise and conjure up some man soaps for friends and family.  This weekend I made some charcoal soap which turned out as black as the Sunday news of Speed’s tragic passing and some poppy seed mix that looks interestingly speckled.

With 4 weeks till fully cured, a bit of patience is needed to prevent mischievous hands from using the bars early.

Candidate Database

frontend dbImproving current business process for candidate information management.

Project Requirements: Enable searching of candidate records through a common user interface using legacy Access DB.  Filter of out standing candidates for records.  Report of performance statistics.

Resources: no current server resource, existing Access DB without normalisation, relationships and queries.

Ideal Solution:  Front End GUI, Back End DB, Queries, Reports and all on Server for multi user access.  Ideal starting point for Oracle or SQL server project.

Result: MS Access DB with three User types, Relationships, SQL Queries and some Reporting & Statistics integration.  Process for sequential DB useage and future exportation of data.

  • Dashboard GUI has live search strings & integers across a range of candidate data available in normalised tables
  • Clicking of search result pulls up record in association
  • Query of pending / out standing candidate qualifications
  • Reporting – Graphical representation of current monthly, period and yearly performance targets

Twitter Branding @Football_Wales

Asked to produce a Twitter branding for @Football_Wales.  An idea from a local footy fan who tweets about Welsh football and local clubs.  Initially not happy with his copied logo from google he approach me to come up with something new.

Design Requirements :

His design / branding requirements were, “something cool like the Arseblog and 3d!”

Further questioning produced a more specific brief

  • 3D Logo…
  • Football related…
  • Welsh themed….

Technical Requirements :

A twitter football theme, compromising of a an avatar, background and profile design.

Ideas / Exploration:


 

 

 

Solution :

Searching for some templates online, I was able to produce several ideas and mockups in wireframe and illustration detail.

  • PSD background of some grass/turf for the pitch in 1980×1600 to cover a wide range of resolutions.
  • Avatar – GooFinal Logo gle Sketch Up mock up and then illustrated in Photoshop with some nifty touches.  One profile 500×500 reduced to 125×125 to capture the detail and a smaller avatar for the side bar.  Shield in Yellow, plus the element of shadow is making use of the white space to enhance the 3D effect.
  • Profile – Light green sidebar, blue links and white text.

Result : Follow @football_wales

Shares….TRP

5 weeks to go….bang or bust

Hotting up now; 5 weeks to go to spudding and more pressure on 2p placement holders to sell out in the 4-5p range.  So far the last few days have seen a flurry of buying and several large individual 40K plus buys in two days.

Up 7% alone today has brought more attention to company as the general market became a sea of red as investors fear for short term outlook.

In the words of the great man himself, Del Boy – HE WHO DARES, WINS!  I’m holding out to double my money and hopefully riding the free shares long term.

Keeping an eye out for my next move into either MXP.L, IERE.L, AST.L or even further CHAR.L

Shares….TRP rising

trp1

Moving onwards! A few weeks ago TRP, tipped for Feb 2010 spudding has started to move from the dusty bowls of Uganda. Now at 4.03p 4.10p to buy – movement from 2.35p has been quick over the Christmas period the iii board rallying for news in anticipation.

Reduction of MM’s holdings through PI buying meant that hedging the SP at 5-6p would see most investors doubling their capital and awaiting news for an oil strike in the well to produce a possible 15p SP or a potential takeover of +20p.

Great news for the PI’s – It is likely that 5p will see a sell out for those doubling money and anticipating a fall to 2p with free shares to top up in the event of a duster.  If they do strike oil, which is high probability in this region, the share price is looking for speculated 7-8p prior spudding and those in the know will hold out past 12p.

Current strategy is to double my money and leave the free shares to ride – pure profit in my portfolio.

News….GKP splurt!

gkp_oil

Upgraded to Probable Takeover from Possible

Gulf Keystone Petroleum Ltd (GKP.L) said on Monday it found additional oil in an Iraqi well, sending the oil and gas explorer’s shares up 7.8 percent this morning to 125p and resting at around 107p throughout the day.

The new Triassic discovery flowed at 10,000 barrels of oil equivalent (boe) per day and the section currently shows potential aggregate rates of about 24,000 boe per day, the company said.  In layman’s terms – more oil!

Gulf Keystone, the field’s operator and majority owner, said the Jurassic and Triassic tests in the well have so far resulted in an aggregate actual test rate of 20,000 boe per day.

Further interest is bound to pick up over the next few days – this news has taken fund managers targets to 175p short term and buy out price of between £3 and £5.  Not bad for a share that was 20p in March.

Shares….Tower Resources PLC

trp1

From the dust…. Purely a speculation – Fancy a bit of easy money up to the New Year? Who doesn’t!

Tower Resources PLC are due to commence drilling February 2010 in Uganda and also in the run up to news on estimation spud in 30 days (or less) for Iti-1 well.  At 2.3p a share, AIM listed Tower Resources is high risk and a purely speculated exploration company. RNS from company website released this week confirms agreement and proposed project with Ugandan Government.

Why so cheap? Sentiment from back in June when TRP hit a duster caused massive selling and a drop from 7.5p to 2p and a repeat of the climb on drilling news will bring a possible 5p up to Feb and on discovery possible 15p.

A word of warning, failure to find oil will probably send the share price down to 0.5p – 1p so worth doing your own research beforehand.

click graph for larger view – opens in new window

trp_graph

Shares….Swing high, swing low sweet chariot?

chariot

Chariot Oil and Gas

Up 8% today with support at 24p for the third time this month, it looks like a debt free Chariot oil has found the new resistance levels for investors to jump on board.  A busy time leading up to Christmas and building on gains made on Tuesday, investors can find opportunities to jump aboard the chariot after the company’s market capitalisation falls close to its cash level.

Could this be an opportunity for some pre-new year festivities and a blinding start to 2010?

As quoted from their website, Chariot Oil and Gas Limited (AIM: CHAR.L) is an independent oil and gas exploration company with interests in Namibia – Enigma Oil and Gas Exploration Limited is a wholly owned subsidiary of Chariot and is the operator of the license areas.  All of these blocks are in the exploration phase and Chariot is focused on investigating these using state of the art technologies which have previously led to giant oil finds. Other oil giants in the area include BHP Biliton, Tullow Oil, Circle Oil and Arcadia Petroleum.

Chariot Closed today 26.75 with a day high of 27.0 and low of 24.00 offers a of 3% on the spread means there is certainly some singing to be done in the near future.  Swing high swing low sweet chariot………

Worth a look for medium to long term with prospect of 50p near Christmas.