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. 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 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 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…

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.   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…

Statistics

Please see my other Business Intelligence articles. Leveraging descriptiven and inferential statistics to deliver a competitive, data-drive strategy. Leveraging Free Tools in Statistics I’ve found the following free tools to be very useful when analyzing data. Mockaroo: Easily create large test data sets. https://mockaroo.com/ Meta-Chart: Easily create diagrams and charts. https://www.meta-chart.com/ Descriptive Statistics Descriptive statistics…

Tableau

Please see my other Business Intelligence articles. 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. Tableau A/B Testing Grades vs. Study Tutor Clarify Distributions with Bins Calculated Field Comparing Workbooks Formatting With Labels Mapping Geographic Data Styling With…

SQL Server Reporting Services (SSRS)

Please see my other Business Intelligence articles. SSRS is Microsoft’s reporting platform which was designed to deliver reports with robust features to support analytical decision-making and part of the Business Intelligence (BI) lifecycle (SQL Server, SQL Server Integration Service (SSIS), and SQL Server Analysis Services (SSAS).  For more information, read An Overview.   SQL Server…

SQL Server Integration Services (SSIS)

Please see my other Business Intelligence articles. SSIS is Microsoft’s ETL platform which was designed to migrate and manipulate data in support of the Business Intelligence (BI) lifecycle (SQL Server, SSIS, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS). For more information, please read SSIS: An Overview. SQL Server Integration Services (SSIS) An…

Business Intelligence

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,…