Categories
Technology Work

Real Time Stalking

LinkedIn

Fact

I rarely “surf” to random sites any more, any site that wants my attention must have an RSS feed that I can put into Google Reader.

Fact

I am intrigued by the social networking sites, a few are listed here. LinkedIn is one that I can see the point of.

LinkedIn have recently introduced an RSS feed for my network updates, so it ticks both boxes. What’s the downside? I’m not sure what it is. It could be that LinkedIn is a work/professional focussed network rather than personal. It could be the immediacy of the updates from my colleagues. It’s strange but I feel crossed between a stalker and a voyeur in a way that I just don’t get from feeds from other sites.

View Ross Goodman's profile on LinkedIn

Categories
Dimensional Modelling Maxima Information Group Work

Modelling Change In Your Dimensions

Money

You use dimension tables to hold the descriptive attributes that you want to use to analyse your measures.

This is fine but what do you do when this information changes? There are three common ways that you can handle changes in your dimensional model.

Categories
Ross Technology Work

Ideal Working Environment

My Home Office

I have just fine tuned my working environment and have come up with the ideal setup.

OK the monitor heights are a bit wonky but I very rarely span monitors, I like to have discrete items open in each and focus on one monitor at a time.

In this picture I have outlook split between monitors 1 & 2, thunderbird between 2 and 3 and firefox crossing all 3.

Categories
Dimensional Modelling Maxima Information Group Work

Dimensional Modelling – Facts


Creative Commons License photo credit: Felipe Morin

I am often asked by my colleagues to explain dimensional modelling concepts to them. I will try to capture come on the concepts here. I am going to focus on Facts.

Specifically, types of facts: Accumulating, Factless, Transactions, Snapshots, Additive, SemiAdditive and Non Additive

Categories
Technology Work

My First TwitterBot

Twitter

I have just “finished?” my first twitterbot!

If you send it a direct message with part of the name of someone who works at Eclectic it will send you their contact details as a return direct message.

The API is very straight forward, only my lack of bash skills slowed me down.

Categories
Maxima Information Group Work

Make A Profit From Your Expenses!

Money

As I mentioned previously my company has been bought over. One of the immediate changes is that we are now responsible for booking our own travel and accomodation, rather than it being done centrally. Whilst this is a pain if you are busy, you can turn this to your own advantage.

This week i have “earned” £52.46 for doing my job !

Categories
Maxima Information Group Work

Consultancy VISTA

http://www.hamaddarwish.com
I really hate just regurgitating content from other sites but the following article just hit home, summarising what, in my opinion, sets us apart!
Read the article here.

VISTA is an acronym for value, integrity, service, trust, and accountability. These qualities are essential to extend beyond a simple provider-consumer relationship and to establish shared-value consulting relationships.

Value is fundamental to a successful consulting relationship. You must know and be able to articulate what value you will provide as a consultant or will expect a consultant to provide for your BI program. To achieve shared-value relationships, the inverse is also important: You must know and be able to articulate what value the consultant expects to receive. When value is described in measurable terms, it becomes possible to discuss and develop a consensus on value expectations.

Integrity is a cornerstone of good consulting practice. The best consultants operate based upon a code of ethics. As a provider of services, be prepared to state your code of ethics. As a consumer, be sure to ask about it. Key ethics considerations include confidentiality and nondisclosure. Also avoid conflict of interest; be (or hire) a consultant who is not influenced or biased by the possibility of work beyond the scope of the current engagement.

Service is the heart of successful consulting; it is a service business. Thus, consultants are service workers. An effective consultant is one who actively works to deliver real benefits to clients in a professional and effective way. A positive and pleasant experience upon conclusion of each engagement is the mark of service-oriented consulting. As a consultant, be able to clearly articulate your service model. If you’re hiring a consultant, be sure to ask how your prospective consultants define and deliver service.

Trust aids in confidence, comfort, and ease of communication – all essential for successful consulting. A relationship based on trust prevents suspicion and misgivings for both providers and consumers of consulting services. Good consultants know how to establish trust and will offer solid and meaningful references who attest to their trustworthiness. Wise consulting clients openly inquire about references and take the time to check them carefully.

Accountability helps to set expectations, enhance communications, prevent misunderstandings, and assure a conflict-free consulting experience for both parties. Before a consulting engagement begins, agree on fees, reimbursable expenses, reporting responsibilities, the form and frequency of progress reports, the basis of billing, and payment terms and conditions.

Categories
Maxima Information Group Work

I Have A New Employer !

The one time I take a “true” holiday, switch my phone off, don’t check e-mails, I open the paper and what do I see: THIS.

Categories
Dimensional Modelling Maxima Information Group Work

Dimensionally Modelling A Recursive Hierarchy


Creative Commons License photo credit: gadl

I was recently asked how to include a recursive hierarchy into a dimensional model.

What do I mean by a recursive hierarchy? This is when an entity (a table) relates to it’s self. Take the following example from an Oracle database:

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
7369 ‘SMITH’ ‘CLERK’ 7902 ’17-DEC-1980′ 800 NULL 20
7499 ‘ALLEN’ ‘SALESMAN’ 7698 ’20-FEB-1981′ 1600 300 30
7521 ‘WARD’ ‘SALESMAN’ 7698 ’22-FEB-1981′ 1250 500 30
7566 ‘JONES’ ‘MANAGER’ 7839 ‘2-APR-1981’ 2975 NULL 20
7654 ‘MARTIN’ ‘SALESMAN’ 7698 ’28-SEP-1981′ 1250 1400 30
7698 ‘BLAKE’ ‘MANAGER’ 7839 ‘1-MAY-1981’ 2850 NULL 30
7782 ‘CLARK’ ‘MANAGER’ 7839 ‘9-JUN-1981’ 2450 NULL 10
7788 ‘SCOTT’ ‘ANALYST’ 7566 ’09-DEC-1982′ 3000 NULL 20
7839 ‘KING’ ‘PRESIDENT’ NULL ’17-NOV-1981′ 5000 NULL 10
7844 ‘TURNER’ ‘SALESMAN’ 7698 ‘8-SEP-1981’ 1500 0 30
7876 ‘ADAMS’ ‘CLERK’ 7788 ’12-JAN-1983′ 1100 NULL 20
7900 ‘JAMES’ ‘CLERK’ 7698 ‘3-DEC-1981’ 950 NULL 30
7902 ‘FORD’ ‘ANALYST’ 7566 ‘3-DEC-1981’ 3000 NULL 20
7934 ‘MILLER’ ‘CLERK’ 7782 ’23-JAN-1982′ 1300 NULL 10

From this we can see that there is a recursive hierarchy within this table between the empno column and the mgr column, the mgr column shows the employee that is the manager for each row.