Our founding partners, Dan Marina and Adrian Nagy, currently deliver world class consulting services at some of the worlds leading companies. Obviously their level of experience is beyond the BI budget of most Romanian companies.
We will be recruiting the best and brightest graduates to join our company and we will put them through our unique training programs.
In the early days of our company we will focus our efforts on a more limited set of service offerings as described on this page.
As we are able to hire and train the best and brightest graduates we will expand the services we will offer you.
Very soon we will be able to offer you end to end BI solutions across a range of technologies and industries.
World Class Skills at Romanian prices is our promise to you!
If you use SQL Server for your data warehouse we will certainly be able to save you time and money via our service offerings.
If you are a MicroSoft Navision ERP user, we are especially interested to discuss with you our coming Navision BI Solution product.
This is the list of our initial service offerings:
- SQL Server Manual Partitioning
- ETL Performance/Reliability Improvement
- Data Model Improvements
- ETL Support And / Or Migration
- Data Analysis for Business Improvements
- Microsoft Navision ERP BI Solution
If you need BI help that is not on our list? Please contact us to discuss the help you need. It is very likely that we will be able to help you.
SQL Server Manual Partitioning
For SQL Server BI customers. You know that from 2012 SQL Server only supports the partitioning feature in the Enterprise Edition for a cost of more than USD20K per core.
We have long term experience of manually partitioning large fact tables so that the far less expensive Standard Edition can be used. With manual partitioning of SQL Server fact tables nearly all the benefits of partitioning can still be achieved at a fraction of the cost.
If you are running Standard Edition for your data warehouse and you have not implemented partitioning because you do not know how to?
We have developed a detailed white paper that explains to you the benefits of partitioning large fact tables and exactly how to implement this partitioning in SQL Server.
Our first service offering will be to implement manual partitioning on SQL Server data warehouses.
You can request a copy of this white paper on this blog post. This blog post describes partitioning and it’s benefits in more detail.
ETL Performance Improvement
Many companies who implement a data warehouse soon run in to performance and/or reliability problems with their ETL systems. It is very common. We have seen these issues all over the world.
In Romania there is a relatively low level of skills in the area of performance tuning and/or reliability improvements for ETL systems. This is because there are so few companies who need high performance ETL systems. There is little opportunity for Romanians to gain these skills in Romania.
We have long term experience at developing very high performance and very reliable ETL subsystems across many database platforms using many tools.
If you are experiencing ETL performance issues on SQL Server and you would like to improve your ETL performance?
Our second service offering will be to review your ETL subsystem for performance and/ or reliability improvements and to deliver you a written report with recommendations on improvements.
If you would like to learn more about this offering please refer to this blog post.
Data Model Improvements
In Romania there is relatively low skills in designing data warehouse data models. This is because there are so few companies who need sophisticated data models. There is little opportunity for Romanians to gain these skills in Romania.
We have long term experience in developing sophisticated, high performance, BI data models across many database platforms across many industries.
We will focus on Retail in our early days because we have vast amounts of experience and a local retailer as our Navision ERP development partner.
Most companies in Romania do not have the knowledge and skills to implement incremental update of many summary tables. We are specialists at introducing daily incremental updates of summary tables to improve query performance for the users of BI systems.
Our third service offering will be to review your BI Data Models and to deliver you a written report with recommendations on design and performance improvements that you may wish to consider implementing for your data warehouse.
If you would like to learn more about this offering please refer to this blog post.
ETL Support And / Or Migration
Here in Romania only a small amount of companies could afford to purchase DataStage or Informatica as part of their BI Solution.
This has created the situation where support services for these tools is more expensive than you might wish to pay.
Many companies decided to go in to production with Stored Procedures (SPs) for ETL systems because of the lower price of properly trained support staff.
We are able to support DataStage, Informatica or Stored Procedures on any of our supported databases.
If you feel your ETL development and support “costs too much and takes too long” you will be interested in reviewing our BIDA ETL software.
Experience has shown that we should be able to deliver support for your ETL development and support for around 20% less than you can do the same work with permanent Romanian IT staff.
Our fourth service offering will be ETL support and/or migration to reduce your costs of ETL support in the future.
If you would like to know more about our ETL support and/or migration offering, please read this blog post.
Data Analysis for Business Improvements
In our start up phase we will support application development in Microsofts Report Services, Power BI and Excel. Most companies running SQL Server make heavy use of these three tools.
In the early days of BIDA we will not be building front end applications using many of the standard suite of BI tools available on the marketplace. The reason is there are too many products out there for a start up company to support. We will partner with other companies for development work with other tools like Tableau, Qlikview, Cognos, Business Objects, MicroStrategy and others.
Our main offering in this area will be “heavy duty” data analytics for business performance improvement.
We have a vast amount of experience across many companies as to the most valuable areas of analysis. In retail, where you know the customer via their purchase history, the most valuable area of analysis is usually cross-selling and up-selling products and services to existing customers.
In our “heavy duty” data analysis we will use Meta5 from www.meta5.com. This is very famous software from a company Ralph Kimball founded. It used to be very expensive. A recent price change has made it affordable for us to use in our data analysis practice.
Our reports for “heavy duty data analysis” will be delivered in Excel workbooks and PDF reports.
Our fifth service offering is “heavy duty data analysis” leveraging our wealth of experience to see if we can find proposed ways to improve your business performance.
If you would like to learn more about our proposed data analysis service offering please read this blog post.
MSFT Navision BI Solution
We have a very well known Romanian company as our development partner for our Navision BI Solution. They run Navision 2009 R2. They have 280+ stores selling 300-400K items per day. They have quite a substantial data warehouse.
In production we are bringing ALL changed data from the Navision ERP in to the staging area 2x per day. This extraction and staging area processing has been in production for 3 years. This means we can already run queries against 100% of the production Navision data in the staging area with any query tool.
We can build a Navision staging area for you in about 2 weeks. After this there is the time to run the initial loading of the data. This might take a while.
We propose to forward ALL data from the staging area to the Navision BI Solution. We are working on this in development.
For our Navision BI solution we have the major business entities mapped. We are testing this processing in development.
We propose to be able to integrate data from other sources with the Navision Data in the data warehouse. We are already integrating data from Sharepoint with Navision ERP data in the production data warehouse.
We are now looking for our first 5 Navision BI solution customers.
We will only accept 5 customers during our start up period so that we can get you all in to production and properly supported. We will not seek further customers for this product until we exit our start up phase.
If you are running Navision 2009, or later, and you would like to know more about our Navision BI Solution and be one of the first 5 in to production? Please read this blog post.