Knoware Blog/News

Data Governance in the Real World 2018

Date: 4th April 2018

Location: Wellington

This seminar aims to provide you with the confidence to introduce and manage your data governance programme with step by step practical solutions for all types and sizes of organisations.

Audience: 
Information managers, data governance professionals, data strategy delivery leads – anyone responsible for managing organisational risk around data, building organisational capability and safe reuse of data

Back to Events
Data Governance in the Real World 2018
read more

Data Governance in the Real World

Date: 6th December 2017

Location: Wellington

This seminar aims to provide you with the confidence to introduce and manage your data governance programme with step by step practical solutions for all types and sizes of organisations.

Audience: 
Information managers, data governance professionals, data strategy delivery leads – anyone responsible for managing organisational risk around data, building organisational capability and safe reuse of data

Back to Events
Data Governance in the Real World
read more

Hooking up SAS and Excel: Q4 2017

Date: 30th November 2012

Location: Wellington

Explore the 20 or more different ways to interface SAS and Excel, either to read Excel data into SAS or to produce or update Excel spreadsheets from SAS.  Make sure you know the best and latest ways to integrate SAS and Excel to get the right results and save you time.  Get an overview of all the main techniques, their pros and cons, and see them in action.

Audience: 
SAS users of any level who currently use or wish to use Excel in combination with SAS, or whom have end users with Excel skills.

Back to Events
Hooking up SAS and Excel: Q4 2017
read more

Hooking up SAS and Excel: Q3 2017

Date: 17th August 2017

Location: Wellington

Explore the 20 or more different ways to interface SAS and Excel, either to read Excel data into SAS or to produce or update Excel spreadsheets from SAS.  Make sure you know the best and latest ways to integrate SAS and Excel to get the right results and save you time.  Get an overview of all the main techniques, their pros and cons, and see them in action.

Audience: 
SAS users of any level who currently use or wish to use Excel in combination with SAS, or whom have end users with Excel skills.

Back to Events
Hooking up SAS and Excel: Q3 2017
read more

Scheduling in SAS: Covering the various options

Date: 24th August 2017

Location: Wellington

This more technically orientated seminar provides a comprehensive overview of the ways you can schedule SAS work to run. The seminar covers:

  • Standard SAS jobs, SAS Enterprise Guide projects, SAS Visual Analytics data queries and SAS Visual Analytics report distribution
  • Administration set-up, as well as actual scheduling of jobs from the SAS user perspective
  • Different approaches for scheduling – centralised using defined administrators versus distributed
  • Real examples in action

Audience: 
SAS administrators or SAS users

Back to Events
Scheduling in SAS: Covering the various options
read more

SAS Visual Analytics Data Loading techniques

Date: 27th July 2017

Location: Wellington

This more technically orientated seminar ensures you are aware of all the main ways to load data into SAS Visual Analytics, their pros and cons, and how to use them

  • it covers VA Administrator import, user import, auto-load, VA data builder, Enterprise Guide, Data Integration Studio and the full flexibility of using SAS code
  • and includes table design guidelines for effective use in SAS VA

Audience: 
SAS administrators, data integration developers and anyone preparing data for use in SAS VA

Back to Events
SAS Visual Analytics Data Loading techniques
read more

Best Practice for SAS Analysts and Developers – one of Knoware’s popular seminar series

Date: 20th June 2017

Location: Wellington

Best Practice for SAS Analysts and Developers (2 half-day workshops)

Ensure your analysts and developers:

  • work in the most productive, effective and efficient ways
  • produce correct and consistent results
  • meet the needs and goals of their customers for improved satisfaction

There are 2 different workshop sessions – Technical and Non-Technical

The Non-Technical session covers common issues; work lifecycle (including Agile) from work requests to delivery of results; communications and data management overview

The Technical session is for SAS users and covers data and information management in more detail, understanding “under the covers”, efficiency and effectiveness tips and documentation

Audience: 
Quantitative and qualitative analysts, Business analysts, Developers creating BI or analytical systems, Managers and Project Managers.

Back to Events
Best Practice for SAS Analysts and Developers – one of Knoware’s popular seminar series
read more

SUNZ 2017

Date: 11th May 2017

Location: Wellington

This years conference was held at the Michael Fowler Centre
111 Wakefield Street in Wellington. It was a really great opportunity to talk to your peers, make new contacts and catch up on the latest news.

Here is the official SUNZ 2017 website

Knoware again supported the AS community NZ wide by participating as both as a sponsor and speaker and with members of our team. If you have any questions about SUNZ then please either call SAS NZ or give us a call at Knoware

Back to Events
SUNZ 2017
read more

Storytelling and Data Visualisation: from Analytics to Infographics

Date: 21st March 2018

Location: Wellington

This half day seminar  will introduce you to the power of data-driven design and communications. The workshop is for anyone working with data, with a need to increase insights, share knowledge or engage the public. Relevant for both government and commercial organisations.

Audience: 
Anyone who needs to have a greater understanding of data visualisations, infographics and animation and how to use these to add value to analytics.

Back to Events
Storytelling and Data Visualisation: from Analytics to Infographics
read more

Why is it important to manage “unstructured data” in your organisation

What are the differences between structured and unstructured data?

Structured data is usually stored in a database, in labeled information fields and is easily searched for using a query i.e. a customer information system in which you can search by customer name or number.

Unstructured data may have a structure such as an email, but the information contained in the email has no structure, and is difficult to find unless there is a method for indexing and storing this information.

Examples of “unstructured data” are:

  • Emails
  • Books
  • Documents
  • Journals
  • Paper based information or records
  • Audio recording such as that from a Call Centre phone logs
  • Video
  • Blogs, Tweets, SMS text messages, faxes

What are some reasons for needing to store and retrieve and analyse unstructured data?

  • To answer a media, ministerial or management query.
  • To analyse the performance of your organisation or business and make better decisions.
  • Legal compliance
  • Customer complaint handling
  • Quality management
  • To make decision on pricing, staffing, location of branches or offices or outlets

What should a plan for managing unstructured data cover?

  • An information lifecycle strategy and roadmap.
  • A recordkeeping strategy and roadmap (what information should you store and what to discard.
  • Plus how long should you store it?
  • Details on how to integrate the new approach into your organisation and make it operable.
  • Identify data sources and repositories.
  • Set out storage needs and strategies.
  • Define formats, indexes and language (taxonomy)
  • Enable compliant retention and disposal in systems
  • Plan for migration of data or content to new solutions.
  • Strategies for data access using techniques and tools for data mining and analytics.

Be aware of the relevant NZ and international standards

Relevant international standards are to be found at:

  • International Organization for Standardization (ISO)
  • The International Congress of Archives (ICA)
  • The European Model Requirements for the Management of Electronic Records (MoReq)
  • The United States Department of Defence 5015.2-STD Design Criteria Standard for Electronic Records Management Software Applications (DoD 5015.2).

New Zealand standards are:

  • Archives NZ Digital Recordkeeping Systems (DRS) standard(itself an adoption of the following ICA/ISO standards)
  • ISO TR 23081-3 Information and documentation — Managing metadata for records — Part 3: Self-assessment method.
  • “N800R1 Where to start – advice on creating a metadata schema or application profile v8 Functions”
  • ISO 15489 Information and documentation – Records management.

Use Knoware’s experienced team to make progress in managing and using unstructured data.

We have worked on developing and using the ISO standards.
Our team has presented papers on this subject for example at the International Council on Archives Congress and the NZ Computer Society.
We work with NZ Archives and understand the direction that government is heading towards.
Our analytics and data mining specialists are experienced in helping organisations find answers using tools and techniques for both unstructured and structured information.

Why is it important to manage “unstructured data” in your organisation
read more