Data Services


AIM uses the Microsoft business intelligence library of tools to plan, develop, and deliver "single version of the truth" data warehouse and business intelligence solutions. We specialize in designing and creating a dynamic and visually stimulating presentation layer that will encourage business users to be engaged with their role in the company, while empowering the business users with the ability to initiate action and change into the organization.

In order to deliver business driven data solutions, we investigate and discover, both the numerical and contextual details of the source data. By interviewing business analysts, executive leadership, middle management, and the impacted business users, we pick and choose from many different data presentation techniques including user based dashboards, key performance indicators (KPIs), ad hoc / mash-up reporting, balanced score-cards, and business intelligence portals in order to make better informed decisions and resolve issues faster.



  • Data Modeling
  • Vision, Scope, and Effort
  • Extract, Transform, and Load
  • SSAS Semantic Layers
  • Visualization

  • Performance Tuning
  • Migrations and Upgrades
  • Security and Governance
  • Maintenance

  • Governance
  • Compliance
  • Master Data
  • Data Quality

In the content below, topics are divided into 3 sections:

  • Microsoft Cloud Business Intelligence Products
  • Microsoft On-Premises Business Intelligence Products
  • Report Types Delivered by these Products
Read about the AIM Data Methodology here... AIM Data Methodology

Microsoft Cloud Business Intelligence Products



SQL Database
  • Structured Data
  • Application Databases
  • Elastic Pools
  • Monitoring and Alerting
  • High Availability
  • Intelligent Threat Detection
  • Dynamic Data Masking
  • Row Level Security
  • Auditing and Logging
  • Conditional Processing

Azure Data Warehouse
  • Data Warehouses and Marts
  • Data Staging
  • Star Schema
  • Elastic Pools
  • Unlimited Scale
  • Limitless Concurrency
  • Lightning Fast Provisioning
  • Fully Managed Infrastructure
  • Global Availability
  • Advanced Security

Azure Analysis Services
  • xVelocity In-Memory Analytical Engine (VertiPaq)
  • In-Memory Columnar Database
  • One Version of the Truth
  • Scale with Efficiency
  • Anytime Access from Anywhere
  • Tabular Models
  • Time Intelligence
  • Currency Conversion
  • Translations
  • Perspectives
  • Roles

Data Lake Store
  • Hadoop Distributed File System (HDFS)
  • Peta-byte Size and Trillions of Objects
  • Provision Hadoop Clusters
  • Provision Spark, Hive, R Server


Power BI
  • Cloud Analytics
  • Deliver Organizational Insights
  • Dashboards and KPIs
  • Camera and GPS Location
  • Forms and Business Logic
  • Leverage your SharePoint Lists
  • Simplify Data Prep
  • Drive Ad Hoc Analysis
  • Scale Across the Enterprise
  • Governance and Security
Azure Stream Analytics
  • Internet of Things (IoT)
  • Massively Parallel Complex Event Processing
  • Build Real-Time Dashboards
  • Enterprise grade availability & Auditing

Azure Data Factory
  • Hybrid Data Integration Service
  • Ingest and Prepare
  • Transform and Analyze
  • Monitor and Manage

Microsoft On-Premises Business Intelligence Products



SQL Server Reporting Services
  • Scheduled and Ad-Hoc Reports
  • Dashboards and KPIs
  • Tables and Lists
  • Summary Charts
  • Data Driven Reports
  • Parameter Reports
  • Alerting and Highlighting
  • Analysis Services (OLAP)

Microsoft Excel
  • On-Demand Reports
  • Dashboards and KPIs
  • Tables and Lists
  • Summary Charts
  • Pivot Tables
  • Alerting and Highlighting
  • Analysis Services (OLAP)

SQL Server Integration Services
  • Cross Server Connections
  • Extract, Transform, and Load Data
  • Auditing
  • Tasks and Transformations
  • Conditional Processing
  • Configurations
  • Expressions
  • Data Sources
  • Data Destinations
  • Data Flows
  • Error Flows
  • Merging
  • Parsing
  • Processing Analysis Services (OLAP)

SQL Server Database (T-SQL)
  • Data Warehouses
  • Data Marts
  • Data Staging
  • Extract, Transform, and Load Data
  • Data Repositories
  • System Databases
  • Application Databases
  • Star Schema
  • Link Servers
  • Referential Integrity
  • Tables
  • Views
  • Stored Procedures
  • Functions
  • Auditing
  • Logging
  • Conditional Processing
  • Merging
  • Parsing

SQL Server Analysis Services
  • Cubes (OLAP)
  • Tabular Models
  • Multidimensional Models
  • Star Schema
  • Facts
  • Measures
  • Dimension Relationships
  • Hierarchies
  • Hierarchy Relationships
  • Data Source Views
  • Data Sources
  • Calculations
  • Currency Conversion
  • Translations
  • Aggregations
  • Perspectives
  • Roles

Report Types Delivered by these Products

Select examples of report types and the business needs they satisfy are provided below. As you read through these examples, you will quickly see that a list of business intelligence services offered by AIM are limitless.

Types of Reports
  • dashboard (KPIs) reports
  • balanced score-card reports
  • ad-hoc reports
  • data driven reports
  • scheduled reports
  • analytic grid reports
  • analytic chart reports
  • auditing reports
  • meta-data reports
  • exception reporting
  • comparison reporting
  • time-period reports
  • date-in-time reports
  • daily operational reports
  • forecasting reports
  • process reports
  • policy reports
  • summary reports
  • detail reports
  • error reports
  • list reports
  • count reports
  • sub-reports
  • drill-reports
  • correlated-reports
  • nested-reports
  • parameter-reports
Customer Analytics
  • Customer profiling
  • Targeted marketing
  • Personalization
  • Collaborative Filtering
  • Customer satisfaction
  • Customer lifetime value
  • Customer loyalty
Human Capital Productivity Analytics
  • Call center utilization and optimization
  • Production effectiveness
Sales Channel Analytics
  • Marketing
  • Sales performance and pipeline
Business Productivity Analytics
  • Defect analysis
  • Capacity planning and optimization
  • Financial reporting
  • Risk management
  • Just-in-time
  • Asset management and resource planning
Supply Chain Analytics
  • Supplier and vendor management
  • Shipping
  • Inventory control
  • Distribution analysis
Behavior Analysis
  • Purchasing trends
  • Web activity
  • Fraud and abuse detection
  • Customer attrition
  • Social network analysis
Monetary Amounts
  • The cost of raw materials
  • The value of a sale
  • Operational Expenses
  • Labor Expenses
Counts
  • Number of items produced
  • Number of items ordered
  • Number of items shipped
  • Number of items returned
  • Number of customer service calls
Time Periods
  • Minutes, hours to produce products
  • Days required to fill orders
  • Time between product failures