S-branch are speaking at the IBM i2 and Brookcourt Solutions Threat and Counter Fraud Event.

Come and meet us.

If you’re looking into visual analysis products, you will have certainly considered i2. If you’d like to hear a customer user case, then we’d suggest attending the IBM i2 and Brookcourt Solutions Threat and Counter Fraud Event, on 21st February 2019.

We are speaking at the event with our partners Arquebus Solutions on Integrating Ballistic Intelligence – The Real Picture

IBM will be presenting valuable insights and knowledge on how to tackle Threat and Counter Fraud. S-branch was asked if it could give a real customer user case, showing how versatile i2 can be to tackle any kind of threat; in this case, the threat of firearms.

Arquebus provides specialised services and support to assist organisations enhance their response to firearms enabled crime and terrorism. With the support of S-branch, Arquebus has been deploying Firearm Focal Points (FFPs) to countries across Europe. FFPs are designed to collect all the necessary firearm information together, creating accurate investigative leads thereby helping both investigators and prosecutors to tackle the problem at source.

FFPs work because of data collaboration. Analysis of ballistic evidence has advanced hugely but this information should not be analysed on its own. If a cartridge case is found at a location what other crimes have we seen in that area? Were there any ‘shots fired’ call outs at that time? We may know that the cartridge case comes from a particular type of firearm. What intelligence do we have about trafficking those types of firearms? If we are lucky enough to find or have a match to a particular firearm; who is it registered to? Is there any link to other crimes?

We can only answer these questions if we have access to all the information. Analysis tools allow us to understand this information quickly, helping FFP’s provide accurate leads fast. S-branch will showcase how and why i2 was used to provide this functionality and discuss the results we have seen while deploying such a system.

Come see us at:

IBM i2 and Brookcourt Solutions Threat and Counter Fraud Event

Where: London

When: 21st February 2019, 1pm to 4:30pm

Please email to register your attendance. See the full agenda here.

Why Rosoka is the ‘no-brainer’ plug-in for IBM i2 Analyst’s Notebook

Why Rosoka is the ‘no brainer’ plug-in for IBM i2 Analyst’s Notebook

It’s no secret that i2® is a popular choice for visualising and analysing data. That’s why in 2011 IBM paid a rumoured $500 million to acquire the small British software company. Its flagship product: Analyst’s Notebook has now become the standard for charting data and is used in nearly all of the UK police forces. If you have a sporadic flow of data in formats that vary greatly, IBM i2 is still one of the most compelling tools on the market.

IBM i2® products have always worked well with structured data. This has given its users the ability to ‘bring to life’ data hidden in columns and rows. There are many other places that data can hide though and one of those places is in unstructured text.

Unstructured Data

Unstructured text can pose a challenge to analyse and understand, and we keep generating more of it every day. This text can be anywhere from documents, emails or social media posts. In March 2018 we wrote a blog detailing how data hidden in unstructured text can be utilised. It focussed on the use of Natural Language Processing and particularly Entity Extraction. You can read it here. That blog post concentrated on what could be done using freely available tools.

At the time we stated that there are many commercial offerings that offer that functionality but in a much slicker and easy to access interface. One of those tools is Rosoka Text Analytics. Rosoka is an industry leader of text analytics solutions. Their enterprise solution Rosoka Server is great for large scale analysis of unstructured data. This blog is about their standalone solution which is a plug-in for i2.

Rosoka

Rosoka Text Analytics

So, why is it a ‘no-brainer’?

Well, to start off with its fully integrated with IBM i2 Analyst’s Notebook. It’s a plug-in that has been created in close collaboration with IBM and you can tell. We tested the plug-in against several datasets, including the case study we used in the previous blog post. This data can be found here.

Here are the reasons why we think it’s a ‘no-brainer’ plug-in:

  • It extracts entities and links from unstructured files such as PDF’s, Word documents and txt files. It then allows users to generate Analyst’s Notebook charts based on the content
  • Processing time is quick compared to reading the documents manually and quicker than the free extraction engines used in our previous blog
  • During testing we found the entity extraction to be very accurate. What was more impressive was the relationship extraction. In our previous blog we inferred links based on how many times two entities are mentioned in the same document. What Rosoka do is far more sophisticated and is based on the language around the two entities
  • Entity extraction is good but it can create a lot of noise. Rosoka’ s use of Salience (relevance) means we could always find the most relevant extracted entities and ignore the others
  • Rosoka applies entity resolution to its extraction. This meant that if Theresa May is mentioned as ‘Theresa’, ‘Mrs May’ or even ‘She’ in a document, Rosoka will be able to resolve these different texts as one entity.
  • It’s easy to reclassify an extracted entity from say a person to a company (for example Robert Dyas the UK hardware store). Rosoka can also learn from your decisions so it doesn’t make the same mistake again
  • Rosoka is truly multilingual. We tested this by running several news articles about Islamic State through Rosoka in different languages. The organisation Islamic State was mentioned in both the Russian and the Arabic news articles. On the chart they were resolved into one entity, despite them originating from two different languages. That meant that when we expanded Islamic state we got linked items from both the Russian and the Arabic articles.
  • The most surprising reason Rosoka is a no-brainer though is the price. For a fraction of the cost of IBM i2 Analyst’s Notebook the plug-in delivers accurate, multilingual, unstructured data analysis. We’ve looked at costs for this type of technology for clients before and often the requirements were dropped, due to budget restrictions; well not with Rosoka!

In conclusion, we believe Rosoka is a ‘no-brainer’ plug-in for i2 Analyst’s Notebook. The functionality, ease of use and price will just make any analysts life easier!

For more information on Rosoka visit their website or contact S-branch. If you’d like to find out more about unstructured data analysis, then feel free to call.

S-branch offers independent advice, meaning if Rosoka is not for you at this time, we can help you find the solution that is.

Who ya gonna call? A Forensic Accountant…

Forensic Accounting Software

A lot of people won’t know what a forensic accountant is. I didn’t. It was only when I started working with a team of them at a prestigious accountancy firm that I really got to appreciate the importance of the role and the people that do it.

A forensic account is someone who applies accountancy skills to investigate financial discrepancies and inaccuracies. These investigations will be used to find fraudulent activity, financial misrepresentation or even misconduct.

There is one word I would use when describing forensic accountants and that is versatile

Who ya gonna call?

The truth is a forensic accountant could be useful to a lot of us.

If you run a business, for example, you may believe that there is some internal fraud going on – who ya gonna call? A forensic accountant. You may be about to buy a business and want to know more about its books – who ya gonna call? A forensic accountant.

On a personal level you and your siblings may have been left money or maybe you are going through a divorce and believe money is being hidden from you. That’s right, a forensic accountant can help with these things.

Business evaluations, tax audits, insurance term reviews, stolen paper records; there are a lot of situations where a forensic accountant can help.

Skills

There is one word I would use when describing forensic accountants and that is versatile. I’ve seen them successfully deal with sporadic and often unhelpful data to help a client. This is due to the diverse range of investigations they may conduct.

Applying technology to help clients make sense of sporadic and often unhelpful data is what S-branch does best.

Alongside obvious structured data sources such as companies house records, a forensic accountant may receive data in all manner of ways: boxes full of documents, ceased laptops or mobile phones, ancient financial records, interview videos and recordings to name but a few.

How S-branch can help

S-branch

Trusted Analytics Consultancy

Applying technology to help clients make sense of sporadic and often unhelpful data is what S-branch does best. S-branch is truly independent and remains software agnostic, ensuring our clients get the best solution for their needs; whether they need forensic accounting software or just somewhere to store their intelligence.

Here are some of the ways S-branch can help forensic accountants.

Visualisation Software

Finding hidden connections between different data sources, whether that be financial transactions or social media, requires a good eye. This becomes especially important when you are trying to ‘follow the money’.

The use of visualisation analysis tools or graph visualisations to understand complex data is now common among analysts. Otherwise unseen connections between data can be identified and drilled down upon with ease. Visualisation tools also offer a clear way to present findings and share results.

Unstructured Data Analysis

Large amounts of text can pose a challenge to analyse and understand. We keep generating more of it every day. This ‘unstructured text’ can be in documents, emails or social media posts. Indexing this text can help when searching for keywords, but what if you don’t know the keywords? What if you don’t know where to start?

Unstructured data analysis software allows machines to ‘read’ unstructured text. This could give an understanding of what entities (for example people, organisations or locations) are present in the text. Some of these tools also extract relationships from the sentences and are even multi-lingual making the initial analysis of large amounts of documents quick and easy.

Visual/Audio Analysis

Manually documenting the content of video and audio files is a time-consuming process. Depending on what you are investigating it may also be an impossible task.

The use of cognitive technology to transcribe or even reference known items held within audio and video content can unlock the intelligence held within this kind of media.

Intelligence Data Stores

Having a secure and audited place to hold intelligence as part of a case is of real importance to a forensic accountant. A place where all details of an investigation can be quickly and accurately searched.

A lot of good data stores use the POLE model (People, Objects, Locations, and Events). By framing data in this way, relationships can easily be captured and explored. Intelligence stores will also hold relevant charts, visualisations or even referenced documents, ensuring everything of relevance is in one place.

Companies House Integration

Companies house is a great free resource where you can get access to company information, current and resigned officers or insolvency information.

Making regular queries of companies house through their website is easy, but taking that information and collaborating it with other data sources can be a manual task which is time-consuming. By integrating this resource alongside your intelligence data store it is easier and quicker to see the full picture.

Are you a forensic accountant? Are the technologies above of interest? Or are you struggling with some other form of data you’ve received? Either way, S-branch would love to help.

 

i2 iBase dashboards with PowerBI – Unlock your data

iBase and PowerBI - Unlock your data

Who doesn’t love a good dashboard? What better way to gain a high-level understanding of your data than to see it come alive in bright colours before your eyes? They’re great for presentations but can also give valuable insights into where the peaks and troths in your data lie. From an analytical perspective, it can give you a starting point for your analysis; which with large datasets is very useful.

Dashboards need data. i2 users will store most of their data in iBase; which is very sensible. They do this because items can be quickly retrieved using the intuitive search tools, while the details and hidden connections are easily drilled down upon using i2 Analyst’s Notebook.

It is not always possible, or indeed sensible to place your entire iBase database onto an Analyst’s Notebook chart.

So i2 users have the data, they also have the ability to drill down into the detail. What they sometimes lack is the high-level statistics that a dashboard can provide.

Analyst’s Notebook – Bar Charts and Histograms

One way of doing this is to use the Bar Charts and Histograms functionality within Analyst’s Notebook. This functionality has proven itself very popular as it provides interactive statistical information. The only limitation to this functionality is: it only works with data that is on an Analyst’s Notebook Chart. Statistical information works best with lots of data and it is not always possible, or indeed sensible to place your entire iBase database onto an Analyst’s Notebook chart.

PowerBI

Power BI is a dashboard and reporting analytics tools that can connect to existing data sources and deliver insights that might otherwise have been missed. It allows its users to produce beautiful, interactive reports and then publish them for your organization to consume.

The example below shows national crime information. The data (although fake) is being held in an iBase database. The dashboard shows a location heat map (top left), number of crimes by type (top right), crimes by ward (bottom left) and crimes by date (bottom right).

PowerBI Crime Type Dashboard

PowerBI is interactive, meaning a user can drill down into a specific area of the data. In the example below a user has concentrated on pedal cycle crime.

PowerBi Pedal Crime Dashboard

From here the user can glean insights into this crime type. They can see the areas of the country that have the most pedal cycle crime. The time of the year which it most occurs (July to October) and which wards are most affected (Thames Valley Police and Cambridgeshire).

This can assist with strategic planning. If tasked with reducing pedal bike crime, a team could concentrate on university towns (Thames Valley and Cambridgeshire both hold large universities) between the date ranges of July to October.

What’s the catch?

In order to use iBase data with PowerBI you need a good understanding of your iBase security set-up and the underlying table structure; both of which S-branch can help you with. Regarding costs, the desktop version of PowerBI is free; yes free. This allows users to produce dashboards locally. Most organisations will choose a paid for package where they publish dashboards other colleagues within their organisation. To view a published dashboard all that is needed is a web browser.

For more information on PowerBI, visit the website here. For information on how to integrate it with your iBase implementation (new or old) please contact us

Visallo – plug and play cognitive technology

VisalloCognitive

Cognitive Technology

In its simplest form, cognitive technology is software mimicking the human brain. A human brain can read text, listen to sound and spot objects in videos. A human brain understands context, it can learn from previous experience and it can adapt as new information comes its way. In short: the human brain is brilliant. Why would we use anything else?

Well, we are in an age of data generation. On average users of the Internet generate 2.5 quintillion bytes of data each day. It’s not just reserved for the Internet either, companies are generating more internal data than ever and as storage becomes cheaper the data only grows.

The key to a company’s success may be hidden in their own data. The meaning of life may well be held on the Internet; you never know.

With this newly acquired data comes great opportunity. The key to a company’s success may be hidden in their own data. The meaning of life may well be held on the Internet; you never know. The problem of course is the sheer volume. The task of understanding the data and obtaining anything useful from it is impossible to do manually; although I’ve seen people try!

This is where cognitive technology comes in. Forms of artificial Intelligence, computer vision, machine learning, natural language processing and speech recognition; that can be used to understand the data for us. It is only then that we can then gain intelligence from the huge amount of data. All that is needed is an analytics system with cognitive technology…

All that is needed is an analytics system with cognitive technology…

Build your own

One option is to build a system from scratch.  By cherry picking the best technology companies (as well as open source resources) that provide cognitive analytics. You could feed data to and from these technologies into the system. You could pick a high-performance graph database to deal with the data and build a cutting edge browser-based UI to give statistical and visual analytics to the users.

This option is a viable but costly one. It will require a good solutions architect who understands the problem, some high-end developers, a data scientist and a project manager. It’s also a time-consuming proposition. You aren’t going to be getting results tomorrow.

Off-the-shelf

Why build something when somebody else has already developed it? Another option is to buy an ‘off the shelf’ solution. Here the deployment will be fast, you will get support when you get stuck and the UI and back end database have already been thought through.

This option is appealing and may be cheaper. It is common though that you are then tied in to any technology that the software vendor has partnered with. This may mean: if you want improved voice recognition or natural language processing in Arabic, you may not find the solution you want.

Visallo – Plug ang Play Cognitive Technology

Visallo is one of the ‘off the shelf’ solutions described above. It is based on a high-performance graph database and it allows users to perform: statistical, visual (graph), temporal and geo-spatial analysis all from one intuitive browser-based UI.

Visallo

Visallo

While that is all appealing, the interesting part to Visallo is their attitude to extension and customization. They actively encourage it. Jeff Kunkle, the President of Visallo actually wrote a blog entitled ‘We love when customers replace our software’

Visallo was designed with extension and customization in mind. From the underlying data store to data processing algorithms and UI plugins, you’re not stuck with a one-size-fits-all solution.

This means if the default OpenNLP plug-in that analyses text and extracts entities (People, Organisations, Locations and Vehicles) from unstructured data doesn’t fit your needs; choose another one. If you want to integrate with you existing investment in voice recognition technology; no problem.

analyticplugin

Plug and Play

This attitude to ‘plug and play’ technology allows the fast deployment and support of an off-the-shelf product, with the flexibility of a build-your-own solution.

For more information on Visallo visit their website or contact S-branch to find out more. If you’d like to find out more about cognitive technologies and the application into crime and fraud; feel free to call.

S-branch offers independent advice, so even if Visallo is not for you, we can help you find the solution that is.