Some of the products we resell and implement

  • CubePlayer
  • Effektor
  • Office 365
  • Power BI
  • SQL Server

Typical technical requests

  • Upgrade of existing DWH and/or BI system
  • Migration of DWH/BI system from one server to another
  • Fine-tuning DWH/BI systems
  • Troubleshooting queries and performance (MDX, SQL, DAX)
  • Review of DWH/BI architecture and providing recommendation
  • Assistance in designing and envisioning the architecture of DWH/BI systems
  • Create reports based on MDX/DAX queries
  • Create pivot tables in Excel or Power BI
  • Advise in the process of selecting a vendor for DWH/BI project
  • Play the man in the middle role between business and IT
  • Play the role of a business analyst
  • Play the role of a data expert
  • Educate a team of people while working together on a DWH/BI model
  • Write techincal documentation and/or specification
  • Migrate data from one source to another
  • Automate data migration process
  • Gather requirements for the project
  • Verify data quality
  • And so on, and so on

Some of the services we provide

  • BI architecture and implementation (Microsoft-based)
  • DWH architecture and implementation (SQL Server)
  • Analytics (SSAS, Power BI, Power Pivot, Essbase)
  • Data migration and integration (SSIS, Talend, Informatica, Excel)
  • Reporting (CubePlayer, Excel, SSRS, ....)
  • Querying (SQL, MDX, DAX, SOQL)
  • Data modification (analysis, quality check, cleansing, consolidation, ...)
  • Consulting and education
  • Anything else that involves data and/or brain activity

Typical business requests

  • Enable ad-hoc analysis of business data using pivot tables (dynamic reports created by end-users themselves)
  • Consolidate data from two companies that merged
  • Import budget, plan or other data from Excel and compare that with actual (or prior periods)
  • Import old data, data from the previous business aplication (since the new one has only initial state and new transactions) and consolidate it with the new data
  • Allocate common financial expenses on individual profit centers based on predefined rules
  • Create custom version of business entities and their hierarchies (i.e. custom product hierarchy, custom partner hierarchy, territory hierarchy, seasons througout the year, locations, organization structure, etc.)
  • Create dashboards (multiple reports displayed simultaneously on the same screen, often sharing the same parameters)
  • Implement financial reporting based on a predefined template with positions and accounts
  • Explain where does this cell value in the report come from ("This is not possible" comment)
  • Enable drilldown and drillthrough reporting (getting more into details)
  • Enable drill-across reporting (break-down of a number using different business entities, i.e. customers by products, or products by dates, etc.)
  • Provide various business indicators using the existing data and calcualtions
  • Enable dynamic top N (or bottom N) reports
  • And so on, and so on