IP Launch Services

IP Launch Services IPLS is a team who aim to help regtech startups launch their businesses with marketing and sales support.

Very excited about our COVID inspired cubicles being installed today so staff can start working in the office and stay s...
05/18/2020

Very excited about our COVID inspired cubicles being installed today so staff can start working in the office and stay socially distant. Thank you GS Woodworks for your excellent craftmanship. These things are solid and a work of art!

Launching new data management systems often means working on large data clean up in preparation for a data migration pro...
01/06/2020

Launching new data management systems often means working on large data clean up in preparation for a data migration project.

We would all prefer data clean up to be an easy and automated task. Excel has some useful tools to help spot exact duplicates, but if there’s an extra comma or period, most of us have to rely on some old fashioned, roll up your sleeves, manual data clean-up.

Here are some tips from some very experienced data clean up staff at IPLS:-

1. Break it down into sections or stages. For example, stage one is name clean up. Stage two, focus on the dates. Block off hours in the day to get it done if you have the time over several days.

2. Demand no other distractions – no other job responsibilities. You don’t answer your phone or your emails or participate in office chit chat. If you have your own office put up a “Do Not Disturb” sign. Open plan office? Put on headphones and a baseball cap to signal to others you are working on a project. If you can’t avoid other work – work on the project in the early mornings before anyone else arrives.

3. Take frequent breaks – rest your eyes frequently, every 10-15 minutes. Staring at a screen is very hard on the eyes.

4. Adjust lighting on your screen and around you – low/no overhead lights and darken your screen. If you can’t adjust overhead lighting, that baseball cap can help block out the overhead light glare.

5. Don’t let your mind wander – as soon as you are not focusing on the data, stand up, take a break, then start again. Certain music types help some of us focus. Some of us swear by EDM (Electronic Dance Music) while others prefer classical or even head banging rock music for focus. Find what works for you (and don’t judge the others in their choice of music).

6. Save your work often – every 10 to 15 minutes – or more frequently.

7. In a crunch? There’s going to come a time when you can do no more. Have a 2nd person ready to take over so the work continues and you hit your deadline.

Remember, clean data means no duplications, no extra commas, no missing commas, no extra spaces and, often, no foreign characters. Common pitfalls are date formations – make sure every entry has the same date formation – e..g, dd/mm/yyyy.

Look for typos. Sort and re-sort the data often looking for duplicate names, client numbers and account numbers.
Understand any input values and what they mean. Data migration may require input of certain values in certain columns. For example, “True” or “False”. Often it’s not clear what the values mean. Make sure to ask if you’re not certain.

Your data is valuable – keep it clean and make sure all staff that enter data into your systems are aware of how critical accuracy in data entry is. Good luck!

Happy holidays! We had a great Christmas party today at the office in Conway and will re-open 2 January. Everyone be saf...
12/20/2019

Happy holidays! We had a great Christmas party today at the office in Conway and will re-open 2 January. Everyone be safe and enjoy this special time with your family and friends!

11/18/2019

In London this week for a client marketing at a conference!

We were in New York City this week pitching our client's   at a competition. We were one of 7 finalists out of 100 appli...
10/31/2019

We were in New York City this week pitching our client's at a competition. We were one of 7 finalists out of 100 applicants! The event was held in Times Square and we were THIS close to the NYE Ball!!

Great looking team in their new staff t-shirts!
10/16/2019

Great looking team in their new staff t-shirts!

09/04/2019

Social media marketing for and can be difficult. One of our staff members, Jacob helped create the "Compliance Dance" series of videos for a client to help continue to build brand awareness.

Founders of tech starters should be reading a LOT and  this is one of the best books out there for anyone with an idea.
08/13/2019

Founders of tech starters should be reading a LOT and this is one of the best books out there for anyone with an idea.

We decided for a bit of fun to use this photo on a client's page. It had more engagement than all other posts f...
08/07/2019

We decided for a bit of fun to use this photo on a client's page. It had more engagement than all other posts for the past 30 days. Social media is a finicky beast for and companies. If you're too serious all the time, people tune you out. We find that "keeping it real" and letting people see who's behind the emails are most effective. If you need help with your social media, email [email protected] to learn more.

Yes, we get to bring our dogs into the office! Even the big ones. Especially when a long day at the office is needed to ...
08/05/2019

Yes, we get to bring our dogs into the office! Even the big ones. Especially when a long day at the office is needed to finish client projects. This is Drogo. We now need a Beware of Bear sign on office door.

Lots of great artwork in historic downtown Conway. One of our favorites is Aurora Rising near our office.
07/30/2019

Lots of great artwork in historic downtown Conway. One of our favorites is Aurora Rising near our office.

Address

Conway, AR
72032

Website

Alerts

Be the first to know and let us send you an email when IP Launch Services posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Share