Information Request Form

Data Warehousing / Data Mart Design and Implementation

We use both top-down usage-based and bottom-up performance-oriented analysis to generate solutions that retrieve the most meaningful information, on time and on budget.

Data Mining / Statistics

Advanced analytic and visualization techniques drive your segmentation strategies, personalization profiles and other predictive modeling applications.

Extraction Transformation and Loading Services

Often underestimated in the design of the data warehouse, ETL services help clean, move and restructure the right information, providing a high level of data integrity.

Secure and Timely Information Access

MACRO adheres to current industry standards such as the Microsoft .NET Framework to produce both client-based and web-enabled channels for the distribution of your critical business information.

Business Intelligence

MACRO understands and manages the transformation of raw information into useful intelligence for action. Data can be found anywhere, from dispersed spreadsheets to access logs to application databases. The Business Intelligence Process brings these diverse sources together to uncover your critical facts and trends. MACRO knows how to locate, interpret and coordinate these data silos to generate the relevant business information needed to manage your entire business.

Whether your company needs reporting and analysis from an ERP system or trend identification from your customer transaction warehouse, MACRO can put together the Business Intelligence solution that supports timely decision making and efficient use of your resources, leading to improvements in profits and quality. We use a synergistic approach that encompasses a wide variety of resources, targeting the toolset most appropriate to your needs. Our BI practice will unleash the full value of your data.

SharePoint™ Business Intelligence Features

SharePoint provides tools analyzing large amounts of unstructured data from disparate systems such as SAP™ or SQL Server databases. Macro can help you maximize analysis features concentrated in:

  • customized SharePoint Report Center sites,
  • integration of preferred Excel workbooks with the Intranet via Excel Services,
  • development of Key Performance Indicators to provide visual indicators of progress toward organizational goals,
  • customized Dashboard pages designed to instantly communicate status, provide a starting point for further inquiry and prompt action.