Articles with this tag assume an intermediate knowledge within this category.
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
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
