Articles with this tag assume a beginner knowledge within this category.
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. 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 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:…
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…
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:…
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
