Leale Solutions's passion for data analytics is deeply rooted in our drive to deliver business results that are meaningful to you.
Our Business Intelligence Solutions are born from a scientific understanding of data and utilize the following scientific concepts:
Cubes: Set of related measures and dimensions used to analyze data. Using Microsoft SSAS, cubes are developed based on tables and views that are modeled in a data source view.
Facts: A transactional value or measurement, often aggregated in a cube across dimensions and based on the dimension hierarchies.
Measure: A fact, which is a transactional value or measurement, these are commonly aggregated. Usually derived or sourced from columns in one or more source tables; grouped into 'measure groups'.
Dimension: Group of attributes that represent data interest areas related to the measures. Used to analyze the measures in the cube. Attributes are sourced from columns in one or more source tables. The attributes within each dimension can be organized into hierarchies to provide paths or drilldowns for analysis. Cubes are then augmented with calculations, key performance indicators (KPIs), actions, partitions, perspectives, and translations.
Leale Solutions's philosophy on data warehousing is SMART. Our methodology is tenacious, and our philosophy includes the elements of being:
Leale Solutions's primary tools are used for the all-important reporting and visualization of your business data, and include:
Microsoft SQL Server Reporting Services (SSRS) is used to display important information. We utilize this suite of tools to create reports that contain gauges, charts, drill downs, drill through and line item reports, which are all interactive. You can read more about our Microsoft SQL Server Reporting Services (SSRS) work here.
Excel Pivot Tables is used to summarize, analyze, explore and display cube data. While very effective, display capabilities in Excel Pivot Tables are limited.
Microsoft's Power BI for Office 365 is cloud-based business intelligence (BI) solution. Power BI launches from within Excel and Office 365 to analyze and visualize data in a 'self-service' way. This tool is designed to help business users gain deep insight. Features include:
Our passion for analytics is brought to life through Microsoft SQL Server Analysis Services (SSAS). We use creative processes, powerful tools, innovative designs and good old fashioned hard work to create solutions that drive deep insight into your corporate data.
Our goal is to use this technology to put this data in the hands of your key business decision makers and stakeholders.
These tools enable confident and informed decision making. As a member of the Microsoft partner network and you experienced Business Intelligence partner, we have the experience and the experience with the right tools to bring the highest quality results to you and your business.