Microsoft BI is a business intelligence product used for data analysis and generating reports on server-based data. It features unlimited data analysis capacity with its reporting engine, SQL Server Reporting Services alongside ETL, master data management, and data cleansing.
$14
per month per user
ShopKeep
Score7 out of 10
Small Businesses (1-50 employees)
ShopKeep is an iPad point of sale system; The vendor says it is intuitive, secure, affordable software that helps merchants run smarter businesses. The product optimizes staffing and inventory, while offering sales reports and customer information on a cloud-based platform. The product includes low-cost, integrated payment processing, as well as point of sale hardware. According to the vendor, ShopKeep has 23,000 customers, and a customer…
Microsoft BI has a lot of features and is a very powerful tool, especially if you have folks on your team that know how to utilize all of its capabilities. To truly unlock all that it can do, it does require people to have a deep understanding of its capabilities. That's where the software really shines. If you are looking for a simpler, more basic reporting tool, there are other programs available that do not require such a steep learning curve.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
ShopKeep can maintain up to 10,000 individual stock items. This is perfect for a cafe, coffee shop, wine bar, small retail store, etc. If you're inventory exceeds the 10,000 items then it may not be a fit for you. Also, ShopKeep works with Apple tablets only (iPad 2 or later). If you prefer Android or PC based tablets then this won't work for you.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
ShopKeep provides solid pre-sales support. They did a pre-sales screen-share demo that helped us ensure that their system would handle the needs of the business, and they assisted us in making decisions around which hardware would be appropriate.
ShopKeep's hardware seems well thought out and well integrated. One exception is issues with the connection between their recommended iCMP credit card scanner and the register. Other than that, the hardware works well together.
The register has excellent configurability and customization capabilities, and handles a large variety of products easily. High-volume products can have their own buttons on the register. Products can be added to a purchase by using these buttons, by scanning a bar code with an integrated bar code scanner, or by doing a live text search.
The register is also easily configurable to handle product options - either multiple options like pizza toppings, or exclusive options like regular or decaf coffee.
The ShopKeep system can handle hybrid retail/quick serve/restaurant scenarios with grace. This was a factor that eliminated many other systems that are optimized for one or the other, or where the products for handling retail are completely separate from the products for handling quick serve/restaurant operations. Since this customer has a location where there is a quick serve counter, a restaurant, and a retail gift shop all in the same location, ShopKeep's ability to handle all of these kinds of transactions from the same platform is a powerful advantage. ShopKeep also recently added functionality to transfer open tickets between registers, so that if a customer starts out with a cup of coffee at the quick serve counter, their ticket can be picked up and added to at the gift shop if they wander in there to purchase items.
ShopKeep has a Back Office system that can be accessed through any Web browser, or through their mobile app. The Back Office system is used to import and export data, manage inventory, configure the iPad registers, set up product options, manage employees, and report transactions, sales, product costs & margins, and other data.
Discounts, returns and credits are relatively easy to handle from the register, and the system can be configured to require a manager to approve these kinds of transactions, or not.
Bulk imports and exports are handled well by ShopKeep's Back Office. When setting up initial inventory, products can be added through Excel, then imported as comma-separated values (CSV) files by uploading them through the Web browser. Once inventory is established, adding or modifying items can be done directly through the Web interface.
ShopKeep has a mobile app that can be used by owners or managers to remotely access real-time snapshots of sales and other important data whenever they wish.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Microsoft BI is fundamental to our suite of BI applications. That being said, Northcraft Analytics is focused on delighting our customers, so if the underlying factors of our decision change, we would choose to re-write our BI applications on a different stack. Luckily, mathematics are the fundamental IP of our technology... and is portable across all BI platforms for the foreseeable future.
Because we expect the current issue with the credit card reader disconnecting from the register to be solved with an upcoming software update, and we like many of the features of Shopkeep.
The Microsoft BI tools have great usability for both developers and end users alike. For developers familiar with Visual Studio, there is little learning curve. For those not, the single Visual Studio IDE means not having to learn separate tools for each component. For end-users, the web interface for SSRS is simple to navigate with intuitive controls. For ad-hoc analysis, Excel can connect directly to SSAS and provide a pivot table like experience which is familiar to many users. For database development, there is beginning to be some confusion, as there are now three tool choices (VS, SSMS, Azure Data Studio) for developers. I would like to see Azure Data Studio become the superset of SSMS and eventually supplant it.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
The register functionality is excellent, both from a learning standpoint and an operations standpoint. Cashiers learn how to use the register quickly, and the registers can be configured with hot buttons for fast-moving products. Setting up product variations and additions is straightforward. The web-accessible Back Office has good features, but lacks enough granularity to provide a store manager with the ability to modify inventory settings without giving them access to all of the financial reports as well.
SQL Server Reporting Services (SSRS) can drag at times. We created two report servers and placed them under an F5 load balancer. This configuration has worked well. We have seen sluggish performance at times due to the Windows Firewall.
MSBI natively has a site that allows you to vote on user enhancements and bug fixes. This allows the largest nagging issues to float to the top and the development team can prioritize accordingly. As mentioned earlier, the large community base of MSBI developers assist technical resources in handling technical questions.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. TR verified that a representative sample of customers was invited. More Info
Occasional long waits [5 minutes or more] or call-backs needed for telephone support. Email support replies usually take several hours. Support personnel are generally friendly and knowledgable.
I have used on-line training from Microsoft and from Pragmatic Works. I would recommend Pragmatic Works as the best way to get up to speed quickly, and then use the Microsoft on-line training to deep dive into specific features that you need to get depth with.
We are a consulting firm and as such our best resources are always billing on client projects. Our internal implementation has weaknesses, but that's true for any company like ours. My rating is based on the product's ease of implementation.
If moving from a "dumb" cash register system, spend all the time needed to get starting inventory and product costing and pricing correct. Shopkeep has good tools for reporting inventory, margins, and other critical business info, but the information is only useful if the starting figures are accurate.
We have used the built in ConnectWise Manager reports and custom reports. The reports provide static data. PowerBI shows us live data we can drill down into and easily adjust parameters. It's much more useful than a static PDF report.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
ShopKeep is an inexpensive choice iPad POS system that comes with all of the tools needed to do business without any long-term contracts or expensive fees. It also offers free 24/7 phone and email support along with online live chat during business hours. Coffee Shop Manager offered some of these items, but they also tied you into a long-term contract and you were charged fee after fee for support, etc. Also, the CSM system was big and took up a lot of space compared to ShopKeep's integration with an Apple iPad tablet.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
As a SaaS provider we see being able to provide self-service BI to our client users as a competitive advantage. In fact the MSSQL enabled BI is a contributing factor to many winning RFPs we have done for prospective client organisations.
However MSSQL BI requires extensive knowledge and skills to design and develop data warehouses & data models as a foundation to support business analysts and users to interrogate data effectively and efficiently. Often times we find having strong in-house MSSQL expertise is a bless.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
ShopKeep didn't integrate with my accounting software. I had to double enter all financial data.
Without inventory controls, all of my financial information was inaccurate. It is impossible to grow a business without accurate financial information.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
