Settings for your viewing comfort
Close settings

Case Study Booknet Canada

Toronto, Ontario
Associations

Canadian retail book sales statistics made accessible to subscribers

BookNet is a not-for-profit agency offering online data resources to book retailers and publishers throughout Canada. Growing at a rapid speed, BookNet approached FD Solutions to replace their existing SalesData application with an Internet portal capable of storing and distributing a massive amount of data. This portal needed to be highly customizable in order to update data regularly, offer extensive administrative control over its functionality, and support a large amount of content uploaded from various locations while making it available to the user base in a timely and secure fashion.

Read Details

Challenge accepted

Redesign the server architecture of the existing SalesData application. Design and implement the user and administration websites. Make data available to the user base in a timely manner.

Solution delivered

A flexible high-performance solution that makes book sales data available to publishers, retailers, agents, and libraries over the Internet. Able to incorporate sales data feeds, bibliographic data and update business intelligence database within hours.

Technologies

  • ASPX
  • C#
  • Microsoft SQL Server
  • .NET
  • Microsoft SSAS
  • ASPX
  • C#
  • Microsoft SQL Server
  • .NET
  • Microsoft SSAS
  • ASPX
  • C#
  • Microsoft SQL Server
  • .NET
  • Microsoft SSAS
  • ASPX
  • C#
  • Microsoft SQL Server
  • .NET
  • Microsoft SSAS

Benefits of deliverable

Easy and consolidated access to book sales data provided by BNC SalesData helps retailers and publishers to predict trends, manage inventories and limit potential mistakes, which in the long run saves money.

Data is available to subscribers in a timely manner, as it is constantly being updated by 1,000 retailers with the most up-to-date sales information.

The data collected spans all retail sources, including but not limited to chains, independents, universities and colleges, specialty stores, and online. Providing the user a comprehensive view of industry data.

The site features flexible reporting and charting for users to correlate data quickly.

Ability to merge reports and export into Excel Workbook, CSV file or PDF.

Solution details

FD designed and implemented both the server and client components of the SalesData application. Through sophisticated user and administration websites built using C# and .NET technologies, FD was able to create a flexible, high-performance application that provides sales data feeds for reporting and charting. The server side system consists of a complex set of components that handles data uploads of approximately 4 million rows per week from across Canada. The system also merges weekly updates of bibliographic data for roughly one million titles, including new titles, pricing changes, and corrections. Users can access current weekly sales data and historical data spanning over 5 years.

Another component vital to the solution was the creation of multiple large OLAP cubes for pulling bestseller, title/ISBN, and market share reports. This business intelligence component allows users to efficiently access the data and slice & dice it as they see fit, in order to generate custom reports. These essential reports provide details on books in the market and can easily be converted into Excel workbooks, PDFs, or CSV files all with the click of a button. Moreover, the reports can be merged into existing in-house Point of Sale systems.

This process of transmitting data can also be automatically incorporated into the regular end-of-day or weekly procedures by the client's Point of Sale system. This feature is ideal for book retailers and publishers everywhere to efficiently evaluate sales targets, trends, pricing, budgeting, and more.

Booknet Canda Screenshot. There are multiple tabs; the open one is a multi-page sortable table displaying sales information

BNC SalesData currently tracks sales information provided by a 1,000 retailers. SalesData is now properly equipped with a high-quality system large enough to handle the extensive amount of data provided to its subscribers.

A few words about the project

Feedback

Our attention to detail and continued refinement of the solution ensured that Booknet got exactly the product they wanted.

— Senior Software Engineer at FD

Back to top