Category Archives: Blog

All data is not created equal.

Last week Toyota announced that they would end production on the Scion brand of cars. Thirteen years ago Toyota launched Scion because their data showed that small cars were a good bet. Times were different in 2003. The US was still adapting to a post 9/11 world. Gas prices were on the rise and the economy was recovering. Jobs were good for college graduates and Toyota wanted to offer a product that 20 somethings could afford, and would be a good fit for their lifestyle. Their data suggested that Scion was a good investment. ScionFor years Scion made money and did decently. In 2007 the economy took another tumble. The middle class got hit really hard. This caused Scion to lose more sales because their target demographic took the biggest hit financially because of the economic down turn. Eventually Toyota, by teaming with Subaru to build the FR-S/BRZ, strived to change public opinion of Scion as a small inexpensive car brand for the 20 something crowd. Even after these efforts Scion failed to see much improvement in sales. While no company can see the future, if Toyota had collected more data, and adapted Scion’s business plan to include a small SUV when gas prices started to drop, or planned on adapting their small cars to accommodate two adults and a child seat comfortably, then they may have been able to increase their market share in the US. In the end Toyota chose to cut their losses and move on.

What can be learned from these business decisions? While lots of data can be collected through several sources, the strength of that data needs to be weighted. In addition the quality and source of the data are important aspects to be considered too. In the example of Scion, maybe Toyota could have given the lowering gas prices more importance and built larger vehicles to accommodate more people comfortably and traded off for a lower MPG. Or they could have focused on the losses the middle class were experiencing and built a luxury sedan that focused on a higher income demographic. In the end, they may have feared competing too closely with their other two automobile brands and just kept doing the same thing hoping for the best.

Self Service Analytics

Recently articles about data analytics have  pointed to the need for products that are designed for the Self-Service user. Historically data analytics have been done by data professionals or IT personnel with temperamental, complicated tools. In a recent article by Daniel Gutierrez, discussing the future of data analytics one point that he brings up is the changing trends and benefits of self-service platforms that enable the everyday user to function as data analysts.empower-with-data

Many companies have built visually appealing and informative features into their software trying to empower less-experienced users to easily analyze and identify trends in their data with the goal of helping them derive new strategies for business. This can be helpful at times, but sometimes just makes things even more difficult to understand. While it is good to enable business users to analyze data, if the data is corrupted or out of date users are still left in the dark. By building queries on a foundation of accurate data and addressing data quality initially users are able to reach more accurate conclusions. This is why at Aim-Smart, we believe that giving business/self-service users the power to match, deduplicate and verify the quality of data is a necessary first step for their data analysis.

By creating a tool with the goal of achieving data quality in Excel, Business/Self-Service users are able to clean, match and deduplicate data in a familiar environment. This decreases the learning curve of a new product for less experienced users. In addition it allows users to manipulate the data by using the existing Excel features they are familiar with. By allowing users to build their queries on a clean data foundation they can reach conclusions with greater accuracy. Another benefit is that this removes the need to move data back and forth with IT personnel for cleansing and verification, this reduces possible data corruption points.

Is your company ready for the future of data management? Have you taken the steps necessary to empower your employees to make business more successful?

Excel 2016 Implementation

excel-2016-logo-595Our team at Aim-Smart is excited to announce that after diligently working over the past months, Aim-Smart is fully compatible with Microsoft Excel 2016. With the updated version users are able to take the well-known abilities of Excel to the next level. By adding Data Quality features from Aim-Smart. Excel 2016 is enhanced with the tools any business user needs to deal with large data sets. Thanks to features that include the ability to fuzzy match entries, and process high level deduplication, Aim-Smart really boosts the abilities of Excel 2016. Optional features also enable users to do address verification with in Excel 2016. For more information about address verification using Aim-Smart in Excel read our blog post here.

Does your company have “Big Data”?

During the past few years business professionals have heard the term “Big Data” emerge. At times is has been used both positively and negatively. Some companies tout their “solutions, using Big Data” others use the term as a scare tactic “How will your company deal with Big Data”. Before worrying about what to do with Big Data, let’s first discuss if your company has Big Data.

Big Data QuestionsBig Data is defined by three aspects, Volume, Varity and Velocity. Volume is the amount of data that is being analyzed, Varity is the number of fields of within the collected data. Velocity relates to the speed at which data is being collected, real time data collection is becoming more and more common. While all these things would be very useful to most businesses, the reality is, most businesses don’t have the financial ability to collect and process this much data. In addition many businesses don’t require Big Data to thrive and grow in their marketplace.

Of course there are large corporations who process and need Big Data, but your company may be just as effective with much smaller amount of information. In these situations products offered by large data analysis companies can be overwhelming and too broad for your needs. In addition they can be more expensive than your company’s budget can afford. It has become evident in the current business market place that more manageable products are necessary to fill these needs. Smaller software products that utilize data quality in Excel are a great place to start. Products that produce results with amounts of information much smaller than “Big Data”, yet have the ability to process increasingly amounts of data as a company grows are very useful.

Aim-Smart is an excellent option for any business regardless of size. Aim-Smart is easy for business professionals and management with little to no data analyses experience to use. In addition, when used properly, Aim-Smart eliminates incorrect data and prevent incorrect data from lowering the quality of analyzation results. By placing these abilities in practically any employee’s hands team members are more informed and will make better decisions about what to do when the company has an issue that data can solve.

Finding cost-effective solutions to data gathering and maintenance for small businesses

The U.S. loves small businesses. I would argue that every individual American has at least one small business that they love. These businesses vary in types and varieties. Some individuals will tell you about their favorite local restaurant, they will praise their small farmer’s market or a local coffee and doughnut shop. These small businesses are what modern America was built on. Today it is becoming harder and harder for these businesses grow and thrive.

Here are some questions that concern small business owners.Small Business

1. How can we build and manage our data when most of the products are priced way out of reach?
2. What first steps should we take to better our ability to deal with data?
3. Where will my dollars make the largest difference?

While large firms that specialize in data have huge price tags, there are some reasonably priced alternatives for small businesses. Database software is becoming more reasonable in price, in part because of downward pressure coming from MySQL and other open source systems. A business owner can maintain their own database with a small amount of training or find technical contractors who, for a reasonable price, will setup and query databases for any business. In the past there has been one thing missing – good data quality software for the small business. That’s why we helped create Aim-Smart for cleaning and removing duplicates from their existing and incoming data.

In addition to having reliable places to store and manage the data, businesses need effective ways to collect data. Many businesses offer incentives for customers that are willing to share their data. These include email coupons, club memberships that come with discounts, or just offering birthday incentives. Building up your database of customer information is very important. Keeping customers up-to-date with emails and mailers keeps you fresh in their minds and keeps them coming back.

It is a well-known fact in business that maintaining customers is considerably less expensive than finding new ones. Depending on the industry it costs 4-10 times more money to find new customers than to keep existing ones. This means every dollar you spend to maintain contact and better your relationship with your current clients is far more valuable. Having customer data up-to-date is vital to this. Small businesses can find address verification software that is reasonably priced and easy to use. Once they have found an inexpensive database process, they can easily maintain it themselves with minor effort and training. In addition, Aim-Smart offers a National Change of Address service whereby customers can update their customers’ addresses automatically, should they move. This leverages the USPS change of address system (those little cards you fill out when you move so that your mail gets forwarded).

Thanks to new software options and prices small businesses can afford, smaller businesses have greater ability to compete against their larger rivals.

Reduced Pricing for the month of December!

Aim-Smart is now offering a new purchasing option and reduced pricing.

Aim-Smart is introducing the “Total Company License”. This is a great option for companies who have multiple users in multiple departments that can benefit from the high level data matching Aim-Smart offers.

Aim-Smart’s current price is $10K USD for a single license which covers one computer installation but allows for multiple users on that computer. Aim-Smart also offers a 5 license bundle for $35K USD and, like the single license option, allows for multiple users on each computer. The 5 license package is popular with companies who have multiple departments who use Aim-Smart but aren’t physically close to one another. By installing Aim-Smart on a shared computer users can receive their results easily and save the files for access later.

During the month of December we are offering reduced prices on both the single and 5 license packages. Please call for details. 303-772-6100

The “Total Company License” Now companies have the option of installing Aim-Smart* on all of their machines for a deeply discounted price compared to the single and 5 license packages. Call and get a quote today! 303-772-6100

*some restrictions apply, contact Neil at ext.145 for further details