Feb 23

Data mining services are used extensively by businesses who have strong focus on their consumers. They are used in retail, financial, communication and even marketing organizations. Data mining services allow companies to determine relationships between various internal factors like price and product positioning and external aspects like market competition, economic indicators and customer demographics. As a result, businesses can enhance their sales and corporate profits.

Retailers use data mining services to determine point-of-sale records of customer purchases so that they can send more targeted offers and promotional newsletters. They can also customize their marketing strategies as pet the purchase history of individual customers. Data mining services provide retailers with crucial client information based of which they can develop products and services that appeal to the particular audience segments.

Data mining services can be used effectively by both SMEs as well as major organizations.

Video rental companies have used data mining services to mine its rental history database and recommend rentals to people. Similarly, credit card companies companies suggest products to its subscribers based on their monthly expenditure habits. These are just a couple of examples how businesses are using data mining services to know more about their target audiences and make their marketing strategies more effective.

Working of Data Mining Services
Data mining is a perfect amalgamation of IT and analytical systems. Data mining professionals use specialized softwares to identify relationships and patterns in stored transaction data based on open-ended user queries. Some of the popular relationships on the basis of which data is classified are:

Classes – Data mining services are used to locate data in predetermined groups. For example, a restaurant can mine the purchase data about their customers so that they can determine when do people visit and what do they order. Using this information, they can have daily special items and special treats in order to attract more traffic.

Clusters – Data elements are also grouped according to logical relationships and preferences of consumers. Data mining services can be used to identify niche market segments and consumer affinities.

Associations – Data mining services are used to identify associations as well.

Sequential Patterns – Data mining services are used to anticipate behavior patterns and trends.

Process of Data Mining

Data mining services comprises of a series of procedures -

The data is first extracted and transformed. Then the transaction data is loaded onto the data warehouse system.
The stored data is managed within the multidimensional database system.
Access to the data is given to business analysts and information technology professionals.
These data mining professionals analyze the data by application software.
The data is presented in a useful format, such as a graph or table.

Data mining services have ingenuous benefits for any business . The web is an exhaustive source of data but to pick out relevant data and transform it into understandable information is what data mining services do for a business. With relevant data in place, businesses can seek to make their operations and processes more effective.

Article Source: http://www.articlesnatch.com

About the Author:
Maneet Puri is the director of LeXolution IT Services, a professional IT services company that specializes in providing a range of KPO services. He helps his clients with a range of data entry,Data mining and data processing services as well.

Oct 07

I have been working on some project that involves using very huge tables. Actually most of tables are heaps and to reduce IO we decided to compress those tables on PAGE level because the database is READ-ONLY. Fortunately in SQL Server 2008 we can issue ALTER TABLE… REBUILD.. to rebild the heaps to remove forwarding pointers ,please read Tibor’s article (http://sqlblog.com/blogs/tibor_karaszi/archive/2009/08/28/heaps-forwarding-pointers-alter-table-rebuild-and-non-clustered-indexes.aspx)

Well ,after running the scripts we ended up with almost 500GB empty space. Usually it is not good to shrink the database as you gain nothing (it will grow again) and that caused fragmentation which does not help in terms of performance. Shrinking VLDB is another topic but what I did NOT know if your queries are doing INDEX SEEK SQL Server can get to any row easily no matter how fragmented the table is.
In that case fragmenation has no impact on performance.

If you think about it does perfect sense. Fragmentation is a measure of how closely the logical order matches the physical order. So if you do a scan (following the logical order) on a fragmented table, you can be jumping all over the to get the rows you need,instead of accessing them nice and neat and contiguously.

Many thanks to Kalen Delaney.

Sep 28

Traditionally it was employers who had to make themselves visible when looking to fill vacancies – posting adverts in the press, then choosing a pool of candidates from a veritable tsunami of applicants. But not any more. There’s mounting evidence that personnel specialists are now scouring social media sites and job boards for potential employees.

“Recruitment departments are starting to dabble with professional networking and other forms of social media to head- hunt potential candidates,” says Teresa Sperti of The IT Job Board. Microsoft recruiter Declan Fitzgerald claims that he saved £60,000 in recruitment fees by sourcing nine programming posts through professional networking site LinkedIn instead of using traditional channels.

That’s all good news if you’re currently looking for a job in IT. What better way to ply your wares than on the web, where you can track down the right people and demonstrate your expertise direct? Consider this your ten step guide.

Step 1: Set up multiple accounts

The first rule of successful professional networking is to keep business and pleasure strictly separate. Multiple social networking accounts will help you to present your best face to recruiters. A good first step is to use business-oriented networks like MySpace and LiveJournalfor mates. However, with Facebook and Twitter accounting for the lion’s share of media attention and internet traffic, that approach will exclude access to a lot of influential contacts. Setting up two separate accounts for friends and business on these networks will enable you to compartmentalise your image.

To stop all these accounts getting out of control, use tools that are capable of managing more than one account. Both TweetDeck and Twhirl let you post to more than one Twitter account without the need to continuously log in and out. Seesmic Desktop does the same job, and it handily also allows you to update your Facebook status at the same time.

Step 2: Use Facebook’s privacy settings

While it’s good practice to create business profiles on business-oriented social networks, Facebook is the undisputed hub of the net’s social activity. So, here’s an alternative to multiple profiles: tweak Facebook’s privacy settings so that work contacts aren’t able to see any of your friends’ pictures of your latest debauched night on the town.

Click ‘Friends’ on the main menu bar in Facebook and then click ‘+Create’ in the Lists section of the sidebar. Call this list ‘Work’. You’ll be given the option to add existing friends to this list. Create a second list called ‘Mates’. Once created, you can add anyone who requests friendship to either list.

To make people on your Work list see a professional-looking profile, go to ‘Settings | Privacy | Profile’. The options here allow you to choose exactly who sees what. As an example, let’s say you only want people on your Mates list to see your photos. Click on ‘Edit photo album settings’, choose an album and make sure only your friends can see it. Then, in the ‘Except these people’ box, type in ‘Work’. Now you’ll be able to share all the amusing photos you want to with your mates, safe in the knowledge that the people on your ‘Work’ list can’t see what you get up to after hours.

Step 3: Be careful what you say

Separating your work and personal lives is only one part of the process of creating a professional image for yourself online – a technique named ‘personal branding’. You need to present a ‘best version’ of yourself using the whole range of social-media tools available.

“My key Twitter advice to BBC colleagues (is) don’t say anything you wouldn’t say on air,” BBC Technology Correspondent Rory Cellan Jones recently tweeted. That advice holds true whether you’re blogging, tweeting or changing a public Facebook status update.

“It is very easy to build your reputation and credibility using social media. Unfortunately, it’s just as easy to damage it irrevocably by being careless and whimsical in its use,” says Judith Germain, Managing Director of leadership consultancy Dynamic Transitions. “One thing to remember is that everything that you do on the web is permanent, even in ‘closed’ networks.”

The website Tweleted and the Google cache mean that even deleted posts can be easily found. So think for a second before pressing that ‘Update’ button. And if you do find yourself participating in an argument, make sure you’re polite – or just anonymous.

Step 4: Promote your expertise

Establish yourself as an expert in a particular field or subject. Social-media sites offer plenty of opportunities to promote yourself as a leading light in your area. LinkedIn’s Answers application is a great place to put this into practice. Browse through questions that other LinkedIn members have posted in your area of expertise or search by keyword. The more good-quality answers you provide, the more visible you become.

If you’re willing to invest more time, consider joining Experts Exchange, a site where people post IT related queries. Join as a volunteer and accrue points towards ‘expert’ status through providing solutions.

Blogging is another possibility, but be careful. Post expert advice and considered opinion rather than your opinion on Alton Towers or the prices at Starbucks if you want to draw a returning crowd. A post called ’10 Things To Do If Your PC Crashes’ is worth much more than a whining rant about Windows being buggy.

Step 5: Don’t be a spammer

Blog articles with titles like ‘10 Reasons I’ll Un-follow You on Twitter’ cite aggressive self-promotion as the fastest route to lose friends and alienate people, so avoid things like pushing your website with every status update or spamming hashtags with inappropriate information just to get yourself noticed.

The key to keeping followers and impressing recruiters is to balance your activity. “Engage with your network,” says www.mashable.com contributor Atherton Bartleby. “Genuine engagement with your followers will ultimately ensure that your mobile number is retained and not ‘lost’ at the end of that fabulous party, and it will ensure that you don’t (too often) commit any serious faux pas.”

Step 6: Follow the right folks

Here’s a great tactic to ensure you make the right contacts: put together a list of companies you’ve got in your sights, find out who works there and, if possible, who’s in charge of hiring. Then make friends with or follow them on social-networking sites. Some corporate sites list personnel in their ‘About Us’ section – so try that avenue first. Search LinkedIn for company names if you hit a brick wall with the first method, and back that up with a search of PeekYou, Plaxo and Spoke. These are all social media directories aimed at business users. A multipronged approach like this should yield a lot of names – and you can make friends with people on all these networks.

Once you have concrete names, search for them on Twitter and Facebook. Click ‘Find People’ in Twitter, then enter first name and last name as keywords to find everyone registered under that name. Facebook is trickier – a name search may pop up a bigger list of false positives – so search by email address instead.

If you haven’t found anyone in your initial search, try a people directory like Pipl – a search engine that specialises in digging up data from ‘the deep web’, including social network profiles and blogs. This will also reveal other social-media sites your target is signed up with. Finally, use Google Blog Search to track down your target’s blogs – and when you can comment on a post, do it.

Step 7: Join specialist groups

Don’t just rely on your virtual friends for leads – join specialist groups and communities online to get an inside track and promote your expertise. Even mainstream social-networking sites have a lot to offer.

“Look to existing networks, such as Facebook and LinkedIn, where there will be groups that discuss the industry and specific technologies and practices within it as well as dedicated forums and communities for the sector,” says Rachel Hawkes, one of the brains behind Social Media Portal. “The IT specialist should look to become engaged with the communities and establish a presence that adds value to the other community members by offering opinion, advice and leadership.”

Doing this properly requires some commitment, though. To get the best from specialist groups, you should check in and post regularly. It’s sensible to follow the old school rules of ‘netiquette’ when joining any new group. Lurk for a while and get a feel for the tone of conversation before you join in with a comment. Some groups may require you to post an introductory note, for example. Others may frown on long, self-promotional signatures.

It’s worth searching out specialist communities that match your expertise outside of the obvious choices, too. As an IT specialist, you’ll find social networks running on message boards, mailing lists, Yahoo Groups and Google Groups.

Step 8: Do a job search

Once you’re hanging out in the right online neighbourhood, you’ll hear about some of the best jobs going. That doesn’t mean you have to stop being proactive, though.

“In a recent survey we conducted, when asked which tools they considered most important when applying for jobs, 40 per cent of IT candidates referred to using skills-specific job boards and 32 per cent said they would make direct contact with a company,” says Teresa Sperti of The IT Job Board. ”Seasoned or specialist IT professionals candidates often favour skills-specific job boards, with only four per cent of candidates seeing generic job boards as very important to their job search.”

In other words, using sites that cater specifically to your area of expertise pays dividends. At The IT Job Board – and most other sites – you can sign up for an email summary matching a keyword search. A great way to keep tabs on job sites is an RSS feed, which is easy to add to your iGoogle front page or check in your favourite feed reader. For example, search by keyword at job site Computing Careers and you’ll find an RSS feed link at the bottom of your returned results.

Step 9: Make a video resume

Hopefully your efforts at making yourself visible in a good way to the right people will not have gone unnoticed, and your name will start to surface when positions need to be filled. If that’s the case, you need something more than your various social-network profiles to surface when somebody Googles your name. Owning a website is an obvious first step, but another idea that is gaining momentum at the moment is the video resume.

Thousands of people have posted CVs on YouTube, although the quality is highly variable. If you can’t afford professional production costs, keep things simple. Use the best quality camcorder you can, and make sure the lighting’s natural. Record sound separately, using a decent condenser microphone if possible. You can do the latter directly into Audacity, an open-source sound-editing tool. Many of the best video resumes feature a fixed shot of the subject talking about themselves to camera, but it’s still fine to use software like Windows Movie Maker to add photos and clips too.

Though making a video resume is still a fairly new idea, it’s catching on as a trend – so you’ll have to work a little bit harder to come up with something that stands out. Mike Anderson’s produced his CV in graph form – and got to the front page of Digg and almost 200,000 hits on Flickr. Then there’s Australian games designer Jarrard Woods, who launched his freelance career by building his Super Mario Bros resignation.

Just remember: this clip from the comedy series How I Met Your Mother is intended as a parody (specifically of this infamous disaster), not an inspiration. But you can try this style too if you like.

Step 10: Measure your impact

Keeping up a presence on lots of sites can be a drain on your time – so measure your success with people by measuring traffic from each site, then ditch the ones that don’t work. You can use web analytics tools like Webalizer and AWStats to see where hits to your blog or online CV are coming from. Both programs summarise referrer sites in tables for you – but there’s a lot of static to work through.

A more effective method is to encode URLs you tweet or place in social profiles with a shortening service like Bit.ly. Every time you post a shortened URL, Bit.ly will track how many clicks it generates. Create a different version of the URL for each of your social networks and you can instantly see which work best.