Data Warehousing

More than ever, organisations require effective Data Warehouse systems to maintain competitive advantage.

 

Implementing a Data Warehouse solution is more than simply applying technology to achieve a particular business objective or to address a problem. Building cost-effective, reliable and secure Data Warehouse solutions that help you meet your business objectives requires a team of technical experts with broad industry experience, who understand your business.

 

Theta's consulting team of highly skilled professionals is focused on helping organisations maximize the value from their Data Warehouse investments. We provide you with the tools, expertise and experience to plan and build the best Data Warehouse that will help you achieve your business goals in the most efficient, cost effective way.

 

We are experienced in working with the various data integration and Data Warehouse development tools such as Oracle Warehouse Builder, Wherescape Red, Microsoft SQL Server Integration Services and more, as well as database environments such as Oracle and Microsoft SQL Server. Theta has acquired the expertise and experience to architect, design, implement and support simple or sophisticated data warehouse systems. Through its extensive experience in executing Data Warehouse projects in a variety of environments and organisations, Theta has developed proven methodologies and best practices for consistently delivering successful Data Warehouse solutions.

Partners

Partnering with the best

We work closely with a network of leading technology partners, striving to provide our customers with the best and most appropriate solutions to accommodate their unique business environment and goals.

 

We believe that working with best-of-breed technologies and products is essential to achieving excellence and innovation in design, implementation and deployment of Data Warehouse and Business Intelligence solutions.

 

The technologies that we use include the following:

• QlikView
• Microsoft
• Oracle
• Wherescape
• Cognos
• Business Objects

QlikView

Organisations are looking for simplicity as well as a faster deployment of Business Intelligence solutions. End users demand a solution which everyone can use without specialised training. QlikView offers sophisticated in-memory analysis and reporting solutions for the Enterprise as well as individual customers.

QlikTech, the company behind QlikView, is the world fastest growing Business Intelligence software company with over 10,500 customers in 92 countries. QlikTech's revenue is growing at a rate of 50% annually.

To see how this amazing product works click on the link below:

• Focus clearly leans towards the business user as opposed to the technical user, emphasising ease of use, rapid deployment and faster performance.
• Memory access is considerably faster than access to relational or multi-dimensional databases stored on a hard disk.
• Support for 64-bit operating systems dramatically helps in managing and analysing terabyte-sized databases.

Theta's Business Intelligence services incorporates QlikView technology for extracting key data from your Data Warehouse environment, or from any other source of data, providing a simple and cost effective Data Visualisation, Analytical and Reporting solution.

• Find out more about Business Intelligence Dashboard for Microsoft Dynamics NAV

                              

Microsoft Dynamics NAV - Overview

Today's demands put a lot of pressure on your business. In order to outpace your competitors, you need to stay in touch with your customers and partners, you need to find ways to empower your employees so they can be more productive, and you need to stay in control of finances.

The reality may be that your current business software no longer fits your needs and modifying it is impossible or at least very expensive.  Your system may not give you a clear picture of your financial situation, or perhaps your suppliers or customers are demanding a different set of technologies than you currently have.  As importantly, your employees could be wasting a lot of time working around the shortcomings of the system - bending to its rules and whims, rather than the other way around.

Whatever you do can't disrupt your daily business, because we all know that just a few days of downtime can spell disaster for any business.

 

Integrated Functionality

Microsoft Dynamics^TM NAV (formerly Microsoft® Business Solutions-Navision®) is an integrated Enterprise Resource Planning (ERP) solution designed for growing mid-market companies that want the freedom to focus on their business.

Microsoft Dynamics^TM NAV integrates critical financial, operations, customer, distribution, and e-commerce data into one solution you can implement rapidly, learn and use easily, and fully customise and maintain with minimal disruption to your business. 
 
With an integrated ERP system you will eliminate interfaces between different systems and lower the maintenance. With more standardised data you will earn easier and greater reporting capabilities.

Theta Systems can implement Microsoft Dynamics^TM NAV much faster using the Rapid Implementation Methodology (RIM).

The strength of Microsoft Dynamics^TM NAV is its unique and highly flexible architecture which integrates the available modules seamless. You still have the choice of the modules you need:

 

• Financial Management. Manage your general ledger, payables, receivables, inventory, sales process, purchasing, fixed assets and cash flow. Perform bank reconciliation and collections.
• Inventory Management and Forecasting. Having the right goods stocked with the right quantity to fulfil or exceed your customers’ expectations is the key for Efficient Inventory Management. Let the system suggest you when and what to buy based on sales history. The Inventory Forecast module will also identify trends, seasonality and sporadic usage.
• Warehouse Management can help you manage goods and space more effectively, reduce costs and waste, and gain control over warehouse operations. Tightly integrate order processing, manufacturing, and warehouse functionality to help optimise layout and space utilization.
• Analytics & Reporting. Manage budgets, create and consolidate reports and look for trends and relationships in any part of your business.
• HR Management. Manage your human resources, from skills mapping, recruitment and employee registration, to skills development.
• Project Management. Manage your resources, forecast your costs and budgets, track time and expenses, and manage contracts and billing.
• CRM. Manage customer groups, create and launch marketing campaigns, track customer activity, manage sales and after-sales.
• Field Service Management. Set up and manage service contracts, enter and track service calls, view schedules and optimise workloads across resources.
• Manufacturing. Manage your entire manufacturing process from product configuration, supply and capacity requirements planning, to scheduling and shop floor.
• Supply Chain Management. Manage single or multi-site warehouses and handle order promising, demand planning and online collaboration with suppliers.
• Retail Management. Manage retail operations from point-of-sale to delivery, increase customer flow and cash-in, speed up lines and tasks, control inventory, and automate purchasing.
• E-Commerce. Let customers and suppliers do business with you anytime through Web sites or by connecting their system directly to yours.

 

Value Added Services

Software alone won't solve all your company's business challenges. However, Microsoft Dynamics^TM NAV can deliver a key competitive advantage, by integrating your business knowledge and practices directly into your final business management solution. The open and easily adaptable Microsoft Dynamics^TM NAV architecture allow us to build in your own "best practices" along with other customised functionality for limitless system options.

As a Microsoft Certified Dynamics^TM Partner and business consultant specialist, Theta Systems understands the needs of medium-sized companies like yours. After discussing your requirements we can leverage the strength of the solution to create a vertical and customised version which meets your company's specific requirements.

Our services include:

• Project Planning. Design an efficient implementation strategy for Microsoft Dynamics^TM NAV and plan how it can be managed into the future to obtain maximum value.
• Integration. Integrate Microsoft Dynamics^TM NAV safely and effectively with your existing technology systems.
• Testing. Design and implement an effective test strategy to ensure that there are no surprises, now and into the future.
• Training. Transfer the knowledge and skills to your staff, so that they understand how the application works and can therefore make maximum use of its potential.
• Support. Obtain online support throughout the lifecycle of your application.

 

Add-ons for Microsoft Dynamics NAV

We have developed a series of add-ons to extend the capabilities of Microsoft Dynamics NAV:

• Advanced Landed Cost - precise accounting for costs associated with importing goods
• Consignment Management - streamlined parcel management, from labelling, manifests and dangerous goods to tracking of shipments and costs
• EFT - electronic funds transfer, remittance advice and reporting
  
  

 

Business Intelligence Dashboard for Microsoft Dynamics NAV

Business Intelligence Dashboard for Microsoft Dynamics NAV compliments Microsoft Dynamics NAV by adding a fast and affordable BI solution.

Theta Systems has developed a fast track implementation using QlikView to deliver a working BI solution in just one week!

It provides an easy and immediate solution to help management make business critical decisions quickly and effectively.

To view a demo video click on the image below:

(01:46 min/2.6MB)

BI Dashboard provides the following benefits:

• Rapid Deployment – BI Dashboard is completely configurable allowing deployments to be measured in days not weeks reducing implementation costs.
• Easy-To-Use - QlikView applications are easy to learn, for developers and end-users reducing adoption time and increasing employee productivity from the start.
• No Data Warehouse required - QlikView pulls data direct from Microsoft Dynamics NAV and non-Microsoft Dynamics NAV sources.
• Analysing and running reports does not effect the performance of the operational users  

Example. View your KPIs including top customers based on sales whilst also plotting their margin and margin %. You can quickly view this information in a number of ways over time, whilst also analysing trends. You can also easily switch dimensions to view the information by Product, Category, Region or your specific Microsoft Dynamics NAV Dimensions. See below: 

 

 

Example. View KPI’s including warehouse volume capacity. You can view daily or weekly receipts by volume including bin capacity in each location allowing management to plan workloads. You can also view the quantity and available quantity to pick for each bin. See below:

  

Please contact us to find out how QlikView can unlock the value of your data to help you make better decisions and accelerate your business.

Upgrading to Microsoft Dynamics NAV 2009

Users of Microsoft Dynamics NAV 4 or a previous version are most likely aware that Microsoft will end the support for Microsoft Dynamics NAV 4 SP3 mid January 2010. Support has already ceased for earlier versions. 

 

For those wishing to retain or recommence support, or to simply take advantage of increased functionality and ease of use, upgrading to Microsoft Dynamics NAV 2009 would be a very good next step. You will benefit from the new 3-tier architecture and the use of WebServices for easier integration with your other systems. And the newly introduced RoleTailored Client gives you a completely new user experience as shown below. 

 

RoleTailored Client for Microsoft Dynamics NAV2009

 The NAV team at Theta Systems can help you upgrade to the latest version of Microsoft Dynamics NAV, train your users on the new features and functionality and bring your system integration to another level by using the new WebServices interfaces.

 

For further information or a demo of Microsoft Dynamics NAV 2009 contact the NAV team.

Smart Move to Microsoft Dynamics NAV

'Smart Move' is a package for organisations who want to move to a new Financial Management and Enterprise Resource Planning (ERP) system with the minimum fuss at a very economical guaranteed fixed price.

 

What is included?

The ‘Smart Move’ package includes licences for 5 concurrent Microsoft Dynamics NAV users and our services to implement the system for a fixed price.

 

What does it cost?

The ‘Smart Move’ package for five users has a fixed price of $39,900 (excl GST).

 

What do I get?

• We will install the full Microsoft Dynamics NAV Business Essential edition on your server. We configure and setup the Financial Management module, which includes General Ledger, Account Payables and Account Receivables.
• We help you with setting up your own Chart of Accounts, Posting Groups and User permissions.
• We will provide you with data migration templates and run the data import for you.
• We will perform more than standard training. The training for your users will be tailored for your processes and your needs.
• We also provide a Project Manager for the time of the project.
• We will be on site for the first week after Go Live to help you get started smoothly.
• We will throw in an EFT bank add-on for online banking.

 

What else do I get?

We have included the Business Ready Enhancement Plan for the first year, which gives you:

• Unlimited online training via E-Learning (online courses) and Learning Plans
• Unlimited download of training material
• Access to the Knowledge Base database
• Entitles you to
  • Version and Product Upgrades
  • Service Packs and Hot Fixes
  • Tax and Regulatory Releases
• Protected List Price
• Transition Investment Credits for:
  • Product Transition
  • Edition Transition
  • License Model Transitions

 

What happens if I need more concurrent users or functionality?

Tell us how many users or which modules (e.g. Sales, Purchasing or Inventory Management) you need and we apply the same package discount for these licences. There may be additional services costs, e.g. additional training classes. We will also offer fixed price implementation for the additional modules you choose.

 

How can I get it?

Contact us either via email or phone today. This campaign is only available for a limited time.

Integration

Integration between systems can be required for a whole range of reasons including:

• Creating unified views of data to get one source of the truth
• Coordinating internal systems into overarching business processes, and
• Transacting with business partners online

Delivering the best integration solutions involves gluing systems together using the right tools so that they share the right data and messages at the right time. Theta can help you select the best glue for your needs - whether it is data or messaging integration you require - and then design and build the end-to-end solution. Our approach to integration is to do it right and doing it light. We are certified specialists in Microsoft BizTalk Server. And we work with leading open source technologies too. See below for more on the integration tools we use:

Microsoft .NET

Theta designs and develops custom Microsoft .NET applications in C# and VB.NET.

We have a specialist Microsoft technologies team that have been delivering Microsoft solutions since the days of Visual Basic. In fact we still support VB applications that we created 10 years ago - because they are still delivering for the customer.

More recently we have built a broad range of sophisticated applications - both Windows Forms applications as well as ASP.NET web applications. These include ongoing development of complex risk management software for the utilities sector, healthcare procurement software, and B2B integration using Web Services.

Java

Theta develops custom Java solutions using a range of predominately Open Source Java tools and frameworks. We have a dedicated Java development team that has delivered a wide range of projects over several years. We create both web and 'thick-client' Swing applications as well as Web Service-based integration solutions. We use tools such as Tomcat, JBoss, and frameworks such as Java Server Faces (JSF), Java Server Pages (JSP), Struts, Spring and Hibernate. We also use higher-level frameworks such as LifeRay portal. Some of the applications we have delivered include complex, graphically and computationally intensive energy trading tools, B2C pre-pay solutions, B2B web applications and web services for utilties metering and job management, weighbridge applications and reporting portlets.

Oracle PL/SQL

Since Theta began as a software services consultancy in 1995 Oracle has always been one of the product sets we use. We have created a huge number of solutions that range from those that use the Oracle database purely for data storage, for example Microsoft and Java based multi-tier web applications, to those that also use the Oracle development tools. Oracle PL/SQL is one example, and is the preferred programming language for developing complex and high performance logic within Oracle databases. PL/SQL also forms the underlying technology used by other Oracle products such as Oracle Warehouse Builder used in our Business Intelligence practice. Theta has a number of dedicated and extremely experienced PL/SQL developers. Some Oracle database projects we have worked on include insurance claims systems, real time energy trading systems, large, near realtime data warehouses.

Cloud Development

Imagine being able to use the cloud to run your own custom business application. If done properly you could:

• Quickly launch your application without upfront investment in infrastructure, and
• Set up the development and test environments in a snap, while
• Making savings from reduced licensing, hardware and maintenance costs, and at the same time being able to
• Scale capacity quickly and cheaply in an elastic fashion,
• Get high availability for little outlay, and
• Only pay for what you use

Theta can help you navigate the cloud offerings out there and harness its full power to achieve these things. We can help you figure out what the best approach is to cloud development, what strategy you should use and how to deal with the uncertainties of this new paradigm - such as subscription pricing and security. Theta has embraced cloud platforms and we are currently developing project estimation tool on the Microsoft Azure platform (contact us if you'd like a peak at the beta http://thetaconz.cloudapp.net/) Contact us about using our cloud development experience to assist you to build or migrate applications to Azure or other cloud platforms.

Drupal

Drupal is an open source web content management system.  Theta has several years of experience implementing complex Drupal sites - both public facing and internal Intranets. In fact the site you're viewing right now is built using Drupal.

Drupal is a highly productive framework with a huge collection of extension modules.  Using Drupal, Theta can build complex, data driven sites very quickly.  These sites are fully content managed so daily maintenance can easily be done by customers with a minimum of training.

For example, this theta.co.nz site includes features such as news items, job listings, application forms, customer satisfaction survey's and newsletters as well as cross tagging features that allow us to automatically display content in the right side bar that is related to what you are viewing at the time.

Drupal is used by some of the largest companies in the world and by high profile New Zealand sites too. Some example sites include:

New Zealand sites:

• New Zealand Government - http://beehive.govt.nz
• National Business Review - http://www.nbr.co.nz
• Sorted.org.nz - http://sorted.org.nz

International sites:

• United Nations -  http://www.standagainstpoverty.org/
• Nokia - http://research.nokia.com
• Universal Music - http://universalmusic.com/
• SourceForge - http://web.sourceforge.com/

Contact us about developing or supporting your Drupal site.

PowerBuilder

Theta is one of the few software development companies in Auckland that still offers Sybase PowerBuilder design and development services. We have well over a decade of experience delivering mission critical PowerBuilder applications and we continue to maintain and enhance highly reliable and productive systems for our customers. Although PowerBuilder is not so fashionable these days it is still a highly functional and productive environment. However, customers seeking to migrate from PowerBuilder to .NET or Java will find Theta a particlarly good fit, as we have experts in all of these technologies under one roof.

Our Methodology - Pragmatic Agile

Theta's software development methodology is called Pragmatic Agile. Pragmatic Agile is a proven, common sense, method that utilises practical techniques from Agile Software Development and applies them within an overall waterfall model.

Under Pragmatic Agile, waterfall stages such as initiation, business requirements definition, high-level design, build and test are followed as broadly sequential steps. Within the delivery phases, however, Agile approaches are used. This includes an Agile design philosophy supported by a delivery approach that uses iterations (called sprints), and management techniques such as scrum meetings and large visible wall charts, all with a strong focus on people.

Theta is focussed on you, the client. While Pragmatic Agile is our preferred way of working, we're happy to work the way you are most comfortable and will adapt our methods to suit your style. We find we can often use parts of our methodology within the framework of a client's own methodology.

 

Why Pragmatic Agile?

Waterfall methods are common, easy to understand and easy to plan to. Their sequential steps suit the way businesses typically fund projects and the predictive and repeatable nature of the methods are comforting.

The pitfalls of waterfall projects, however, are well known. If good requirements gathering and change management processes are absent, projects can fail to deliver what the business really wants.  Projects also frequently overrun due to the risky 'big-bang' style of delivery. The software delivered under this method can also be over-engineered and costly to maintain.

Agile methods advocate iterative delivery of prioritised requirements with a strong focus on people and collaboration. These methods are better able to handle changing requirements and use lightweight designs. When run well, Agile projects can deliver a solution that is both what the business wants and is cheaper to maintain in the long run. For many organisations, however, using purely Agile methods requires a significant change of culture and expectations. Buy-in across the business - often difficult to achieve - is needed.

The intention of Pragmatic Agile is to offer the best of both of these worlds. Contact us to discuss using Pragmatic Agile on your project.

IT Strategy Alliance & IT Governance

We usually begin our engagements with a thorough current-state assessment. After consulting with various business units regarding key drivers, we apply proprietary methods to develop IT strategy and define and plan the future-state. We adapt our methodologies to our clients' needs by extracting various strategy related tasks from frameworks and standards as defined by COBIT®, ITIL®, and TOGAF®. 

Database Administration

Theta's Database Administration service is a cost-effective support service that includes the following activities:

• Routine, automated database system monitoring, delivering high levels of system uptime to customers by proactively preventing conditions that might lead to outages
• Routine, automated database alerting, providing a rapid return to operation of critical databases if unexpected outages occur
• Continuous improvement of database environments, eg:
  • automation of housekeeping
  • database reorganisations, rebuilds, upgrades and relocations
  • evaluation and implementation of new database system features
• Database performance analysis and best practice advice
• Database problem diagnosis (as opposed to Return To Operation activity)

Theta provides these services for the following database technologies

• Oracle
• SQL Server
• DB2
• MySQL
• PostgreSQL

Technical Architecture

Theta's Technical Architecture service provides physical and logical designs for IT infrastructure solutions.

 

The objective of any technical architecture is to deliver the required outcome in terms of cost, stability, uptime, longevity, and ease of operational management. This involves the specification and design of: 

• processing capacity
• storage technology
• network devices and topology
• operating system(s)
• database technology
• application technology

Theta develops comprehensive technical architectures incorporating any of the database and operating system technologies listed in our service overview. Once specified, Theta can manage and resource the implementation process, including hardware selection, project management, vendor coordination and management, and migration of systems to the new environment if required.

 

Theta can also review existing architectures and provide strategic planning advice to ensure that technical infrastructure does not constrain business systems.

 

Some of our Technical Architecture customers are:

• Affco
• Auckland International Airport
• Genesis
• Stevensons
• Touchpoint
• Unitec

Operational Audits

Theta has extensive operational experience gained from many years of managing a variety of customers' infrastructure. We are able to audit and recommend proven best practice in areas including:

 

• Hardware configuration reviews
• Operating system configuration reviews
• Service configuration (eg: databases, firewalls, application servers) reviews
• Application software configuration reviews
• Storage systems configuration reviews
• Operational process design
• Process automation
• Backup and recovery audits
• Security audits

 

Some of our Operational Audits customers are:

• Auckland International Airport
• Genesis
• McDonalds
• Procare
• Touchpoint

Virtualization

The benefits of virtualization are well known and include simplification of the hardware landscape, better utilisation of hardware, ease of migration of logical servers between physical devices, improved disaster recovery, and isolation of operating environments enabling commoditised hardware platforms.

 

Theta has experience with a number of virtualization technologies, including:

• VMWare
• VirtualBox
• Solaris Containers
• Xen

Theta plans and implements server consolidation programmes using any of these technologies and manages the virtual environments cost-effectively thereafter. Some of our Virtualization customers are:

• Affco
• Port Taranaki
• Stevensons
• Theta (our own internal systems)

Operating System Support

Theta offers a cost-effective operating system support service consisting of the following activities:

• Routine, automated operating system monitoring, delivering high levels of system uptime to customers by proactively preventing conditions that might lead to outages
• Routine, automated operating system alerting, providing a rapid return to operation of critical systems
• Continuous improvement of operating system environments, eg:
  • automation of housekeeping
  • implementation of upgraded software tools
  • operating system upgrades and patches
  • evaluation and implementation of new operating system features
• Operating system performance analysis and best practice advice
• Operating system problem diagnosis, as opposed to Return To Operations (RTO) activity

 

Theta provides these services for the following operating systems:

• All Linux flavours
• Solaris
• HP-UX
• AIX
• Windows

 

Some of our Operating System Support customers are:

• Affco
• Auckland International Airport
• Genesis
• Kordia
• Port Taranaki

Business Continuity and Disaster Recovery

Theta has extensive experience in business continuity (BC) and disaster recovery (DR), including business requirements analysis, business process design, technical design, technical implementation, and operational management of the BC/DR infrastructure.

 

From a purely technical perspective, Theta has implemented database-oriented DR solutions using Oracle DataGuard, log shipping, and fast recovery techniques. We have collaborated on large-scale DR implementations involving Border Gateway Protocol switching, standby operating systems, VMware virtualisation, and agent-based replication technologies.

 

Some of our BC/DR customers are:

• Genesis
• Unitec