Using the Chi-Squared Test to Validate Results When analyzing data it is important to demonstrate confidence the results found using the sample reflects would be found throughout the population, and not random phenomenon. In this article, I will begin with a simple A/B Test determining between two age groups (1-50, 51-100) which constitute the larger…
Use a Bar Chart to Communicate Important Trends In my Charts article, I briefly described how to create the most common types of Excel charts. In this article I will highlight important considerations when designing a bar chart to ensure its ability to intuitively illustrate patterns within data. First, I’ll begin with a simple dataset…
Please see my other Statistics articles. Choosing the Correct Method to Intuitively Communicate Data Patterns. Many options exist to intuitively communicate patterns in data for enable strategic decision-making. The following table recommends charts depending on your goals. Chart Purpose Example Bar Chart Simplest method for summarizing data, especially for a smaller number of categories and…
Describing Central Tendency of Data Descriptive statistics is concerned with describing important aspects of set of measurements, organizing and summarizing data. Here’s an example of descriptive statistics using the following dataset: There are 20 statistics classes at a university for which all the ages of the students in one class have been collected – a…
Designing OLAP Data Cubes OLAP Data cubes represent the primary logical object for providing critical, multidimensional analysis common to business intelligence which may be viewed using a variety of tools such as BIDS or Excel. Cubes contain data from two types of tables – a fact or “measure” table (typically one) and multiple dimension tables.…
The Data Store for OLAP Analysis Before an organization may engage in OLAP analysis, leveraging cubes, the data must be denormalized from its primary operational OLTP system into a data warehouse, which consists of measures or “fact tables” for analysis, supporting by dimensions which provide context to the organization’s facts. Once analytical requirements have been…
The Foundation of Business Intelligence (BI) Online Analytical Processing (OLAP) is the mechanism by which vast amounts of data is leveraged for strategic decision-making, allowing organizations desiring to achieve and maintain a competitive lead in their market. OLAP is chosen for its ability to deliver faster querying capability, from numerous types of data stores, utilizing…
Since the browser replaced the traditional software client as the primary consumer of logic-intensive applications and content, web development remains one of the most critical tech-skills within organizations. The following pages demonstrate my skills within programming-both client and server side, as well as crucial concepts for delivering highly robust and maintainable applications: Object-oriented Programming (OOP)…
SharePoint is Microsoft’s leading Intranet/Extranet platform in the market. My articles below illustrate some of the more robust features provided with this product. SharePoint Active Alerts Collaborate via a Blog Custom Lists Customizing Workflow Emails Document Library Document Workspace List Approval Process List Versioning Meeting Workspace Publish MS Project Tasks Task Workflows Workflow to Parse…
Leveraging an organization’s data stores is crucial to enabling strategic decision-making. My articles below illustrate skills necessary for an firm to achieve its goals. MANAGEMENT, UTILITIES Normalization SQL Server: Disaster Recovery SQL Server: Maintenance Plan SQL Server: SSMS Object Explorer Filter xSQL Data Compare T-SQL T-SQL: Binary_Checksum T-SQL: Bitwise Arithmetic T-SQL: Checksum T-SQL: Complex…
TechMbaBi 