Skip to main content

O365: Search and Find Data when you need it

 O365: Search and Find Data when you need it


Pervious posts have illustrated how easy it is to create storage in Office 365 and how you can populate the libraries and lists easily from the office PC or from a mobile or tablet when on the move.

We've also looked at the powerful search and find functions within Office 365 and how users can be enabled to locate items for attention, take necessary action and move the items on in the work flow, while maintaining a full control audit at the highest level.

What Data Do We Need?

Following on from that we should consider -
  1. What data should a business be concerned with
  2. Where that data should be stored
  3. How that data should be stored.

Start with Simple Stuff

To start we can consider a customer name, address and contact details. This is the sort of data that may be captured by a sales person working from the office making cold calls or following warm leads, or maybe at the customers premises using a mobile device.

The sales man/woman will store or update the data in a contacts list and more often than not that list will be a personal list.


Up-to-date customer details are worth their weight in gold, but only to the individuals who have access. A customer record on a sales individual's phone is worth precisely nothing to anyone else.

This can, of course, be improved. The business can
  1. Ensure that the sales individual's phone is synchronised with every on else's contact list. Which means lots of synchronisation activity.
  2. Ensure that everyone keys such data into a CRM. Which means that the CRM must have mobile update capability and must be used faithfully by all users.
    That's great, but if you need that customer data for Sales Order Processing, Invoicing, Sales Analysis or for any other business reason, first you have to extract it from the CRM and import it into another package for processing.
  3. Create a Contacts List in Office 365 SharePoint and generate a mobile app that can be attached to MS Teams. 

Using this all staff, office and field based, can create, access and maintain the same data wherever they may be. This data will also be available for use in any other Office 365 application without the need for synchronisation or replication. 

Now Get More Complex

In a more sophisticated environment, an order placed at a customer site with a sales person, can be immediately available -
  1. To the sales back-office, for print and process.
  2. To production, for the reservation and supply of manufacturing resource.
  3. To purchasing, for the ordering of component parts required.

The above scenario requires little in the way of replication, duplication or synchronisation

Don't be afraid to experiment, make Office 365 work for you.

We can show you how, or we can do it for you.


Comments

Popular posts from this blog

O365: SharePoint List v Spreadsheet - which is best?

O365: SharePoint List v Spreadsheet - which is best? See also - Blogs on  Library ,  List ,  Linking ,  Teams ,   Invoicing ,  Workflow  and  Bulk Invoicing The image shows the same data displayed in different applications. On the left is the information imported into a SharePoint List and on the right is a table representation in Excel What's The Difference? Let's assume you are running Office 365 and you may even have Teams launched. You need to provide your users with access to a table of data, the sort of thing that has traditionally been circulated in spreadsheet format. Only now, you have SharePoint Lists as well.  So, which is the best way to store, maintain and distribute the data? In both apps you can sort and filter the rows and columns, you can add new columns that read original columns and perform arithmetic, mathematical, statistical and text manipulation on the content of the original. In the SharePoint List linking to other lis...

The New Computer Age: Infrastructure and the cloud

Most business managers don’t know it but this is very close to the truth. IT teams across the world live in day to day hope that their servers and networks hold together and pray that the disaster recovery schemes will be adequate in the event of catastrophe. IT people are highly professional and, of course, their server networks do deliver. Massive and expensive failure is surprisingly rare, provided that the IT department gets what the IT department needs in terms of budget. But, where budget is restricted, where the IT manager fails to make the business case for upgrade, then performance and security start to become threatened. In addition, a complex IT infrastructure brings with it the penalties of restrictive practise where a department head can’t get the software, services or technology required for a lean department because what is needed will not fit with the current IT infrastructure. So, what’s the answer? Sole Trader - Read more SME - Read more En...

Knowledge - The Ultimate Resource

Knowledge – the ultimate resource? I can’t argue with that. As a writer I’m in the business of providing knowledgebase elements. I take my own experience and that of others, I then turn it into some form of written document that may be understood and acted upon by the intended audience. Quote from Wikipedia - Human-readable knowledge bases are designed to allow people to retrieve and use the knowledge they contain, primarily for training purposes. They are commonly used to capture explicit knowledge of an organization, including troubleshooting, articles, white papers, user manuals and others. The primary benefit of such a knowledge base is to provide a means to discover solutions to problems that have known solutions which can be re-applied by others, less experienced in the problem area. · The most important aspect of a knowledge base is the quality of information it contains. The best knowledge bases have carefully written articles that are kept up to date, an excellent information ...