Contacts

Business Analytics Solutions (BI)

BTS Ltd. has over 20 years of experience in implementing Business Intelligence solutions in various business areas:

| Banks | Insurance | Telecommunications | Production | Commerce | Holdings | Oil companies | Pharmacy |

The best solution is an individual solution that our specialists will prepare for you and that will lead to quick, visible and quality results. 
What we offer
  • Data Warehouse design
    Create and manage ETL processes, data validation and cleansing.
  • Designing systems for ad hoc analysis, reporting and visualization
    Създаване на висококачествени, интерактивни отчети, “what-if”, ad hoc и drilldown анализи и управленски табла за визуализация на данните.
  • A wide range of solutions and products
    Different visualization tools enable the data to be interpreted, i.e. to turn into useful and valuable information. In this way, users are empowered to make effective, informed decisions based on solid data and analytics. 
  • A step-by-step implementation that leads to fast, visible results.
    The implementation of the BI solution can be done in stages, either by organizational structure (divisions, departments) or business areas and processes (sales, marketing, etc.). With this approach, the business benefits begin to manifest already in the course of the project, and thus the implementation turns from a project into a way of managing the company.
    Because of this, it is not necessary to make large investments at the beginning of the project, and according to the needs and priorities of the company, the various components are implemented at different times.
Consulting services
  • Administration
    • Administrating users and content including users, folders, categories, objects, inboxes, calendars, events and applications security and integration with 3rd party security infrastructures (Microsoft Active Directory and LDAP).
    • Deployment infrastructure, clustering, load balancing and server settings optimization.
  • Meta-data layer (universes)
    • Universe design tips including creation of dimensions, attributes, measures and filters; security, hierarchies, list of values, security, connections and loop resolution techniques.
  • Web portal, dashboards and analytics
    • Setting appropriate viewers/editors for each type of document. Regional and language settings; Search; Discussions; Folders; Categories; Sending documents; Scheduling documents.
    • Creating and customizing personal and corporate dashboards.
  • Ad-hoc analyses, reports, visualizations
    • Creating reports; Using multiple data providers (including personal data providers), prompts, filters, sets, tables, charts, ranking, sorting, variables, hyperlinks, contexts; Merging dimensions; Multilanguage support.
    • Creating workspaces based on OLAP data.
    • Creating dashboards for data visualization and “what-if” analysis.
    • Retrieve data from universe queries or published reports in Microsoft Office (Excel, Word, PowerPoint, Outlook); Using query prompts in Excel.
  • Data Services
    • Data Warehouse design Data Warehouse design tips and techniques; Data Warehouse concept and architecture.
    • ETL processes Creating and managing ETL jobs; Data profiling; Performance tips; Monitoring and reporting on ETL activities.
    • Data validation & Cleansing Validating data; Data cleansing techniques and workflows.
BI implementation
  • Analysis
    • Business processes analysis
    • Data source analysis
    • Reporting requirements analysis
  • Data Services
    • Data Warehouse design
    • Data Warehouse design based on the reporting requirements.
  • ETL processes
    • Creating ETL jobs to feed the data warehouse structure from the operational systems’ data sources and/or flat files.
    • Data validation & Cleansing
  • Meta-data layer (universes)
    • Building meta-data layer on top of the data warehouse structure or directly over the operational systems data structures (RDBMS or OLAP). The process involves creation of classes, dimensions, attributes, measures, filters, hierarchies, lists of values, etc.
  • Ad-hoc analyses, reports, visualizations
    • Creating reports based on universes and/or personal data providers.
    • Creating dashboards for data visualization and “what-if” analysis.
  • Dashboards and analytics
    • Creating and customizing personal and corporate dashboards.
  • Deployment
    • Deployment, configuration and performance tuning of all Business Objects products.
  • Training
    • BTS provides standard and customized trainings and workshops.
    • Topics:
      • Administration
      • Data Services
      • Universes
      • Reporting