SSAS: An Overview of OLAP

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…

Web Development

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. My articles below illustrate skills within programming-both client and server side, as well as crucial concepts for delivering highly robust and maintainable applications. C# ADO.NET Transactions C#:…

SharePoint Development

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 SharePoint: Collaborate via a Blog SharePoint: Custom Lists SharePoint: Customizing Workflow Emails SharePoint: Document Library SharePoint: Document Workspace SharePoint: List Approval Process SharePoint: List Versioning SharePoint: Meeting Workspace SharePoint:…

Database Development

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. Common tasks during database development Normalization 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 Queries T-SQL: Compound Operators T-SQL: Control…

Statistics

Leveraging descriptive and inferential statistics to deliver a competitive, data-drive strategy. Descriptive Statistics Descriptive statistics leverages method to uncover and interpret patterns in data. A/B Testing Grades vs. Study Tutor A Structured Approach Averages Charts Clarifying Distributions with Bins Chi-Squared: Validating Results Confounders Cumulative Frequency Mapping Geographic Data Optimization Population versus Sample Sampling Methods Variables:…

Excel

Leveraging Excel to deliver analytics. Repeat Headers when Printing Averages Batch-rename images Charts Charts: Line Chart Chi-Squared: Validate Results Combine Worksheets Convert Column Headers to Rows Cumulative Frequency Database Reporting Merging Worksheet Data Optimization Power Query Introduction Power Query Transformations Power Query Transformations (Advanced) Solver Statistics String Split Tables VLookUp  

Tableau

Tableau is a very powerful, yet easy-to-use tool to statistically-analyze data and present engaging and intuitive reports. Please click the links below to view examples. A/B Testing Grades vs. Study Tutor Clarify Distributions with Bins Calculated Field Comparing Workbooks Formatting With Labels Mapping Geographic Data Styling With Colors