Please see my other Business Intelligence articles. SQL Server Analysis Services (SSAS) An Overview of OLAP BIDS Cube Browser BIDS Exploring a Cube Creating a Cube Creating a Named Calculation Data Cube Data Warehouse Designing a Cube Dimension Hierarchies OLAP Schemas Refining a Dimension Viewing a Cube in Excel
Business Intelligence (BI) encompasses leveraging descriptive and inferential statistical analysis upon massive organizational data stores to enable strategic decision-making. SQL Server Integration Services (SSIS) SQL Server Integration Services (SSIS) is the most-used tool for Extract-Transform-Load (ETL) operations inherent within BI solutions. SQL Server Reporting Services (SSRS) SQL Server Reporting Services (SSRS) represents the most popular reporting platform,…
Determine Outcomes with Relationship Types Understanding relationships between variables during analytical study is important as they often affect outcomes. Variables may have positive relationships whereby the outcome of one variable results in a positive outcome for the other. Also this positive relationship may be recursive in the second variable’s positive outcome results in a positive…
Understanding Variables & Unexpected Results Analyzing data invariably presents results may seem confusing, especially when analyzing independent variables (IVs, link to article). For example, let’s say you are analyzing age groups (IVs) to for the average chosen employment (Dependent Variable – DV). You might think with respect to differing groups employment groups of trade and…
Leveraging the Benefits of a Structured Approach In this article I will illustrate a structured approach to statistical analysis. Structured approaches provide the following benefits: Discreet: efforts in each step don’t overlap with other steps. Measurable: since each step’s efforts are discreet, reporting progress or forecasting completion is simple. The same benefit applies to resource…
View Multiple Sheets to Understand Statistical Anomalies
Make Distributions More Clear with Bins
Using Tableau to A/B Test Whether Using Tutors Produces Higher Grades
Calculating a New Column from Existing Columns When solving a data problem sometimes you are not provided all values and need to create new values by calculating existing values. In this example, I will demonstrate how to create a calculated field from an existing dataset showing sales by region. I’ll begin by connecting to my…
Tableau: Styling With Colors
TechMbaBi 