Articles with this tag assume a beginner knowledge within this category.
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…
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…
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…
Please see my other Business Intelligence articles. SQL Server Analysis Services (SSAS) An Overview of OLAP BIDS Cube Browser BIDS Exploring a Cube Creating a Cube Creating a Named Calculation Data Cube Data Warehouse Designing a Cube Dimension Hierarchies OLAP Schemas Refining a Dimension Viewing a Cube in Excel
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,…
Ensuring Tasks with Dependencies Occur within Sequence Often within during the execution phase of a project, tasks occur which are dependent on other tasks being completed before they can begin. This analysis should obviously be realized during the planning phase. In Microsoft Project, you can instruct the program to ensure tasks with dependencies occur in…
Ensuring Project Files Adhere to Proven Practices When using Microsoft Project, the project manager (PM) will ensure their time spent managing tasks and resources is most efficient by leveraging practices commonly used by the project management community as illustrated below. Auto Scheduled Task Mode When entering new tasks, the PM can save a lot of…
While technical skills are crucial to deliver and product/service, leadership and project management or “soft skills” are just as important to ensure those resource are expended wisely to achieve strategic goals. My articles below provide a road map to such success. Project Management What is Project Management? The purpose and benefits of project management. Process…
Understanding Variables & Unexpected Results Analyzing data invariably presents results may seem confusing, especially when analyzing independent variables (IVs, link to article). For example, let’s say you are analyzing age groups (IVs) to for the average chosen employment (Dependent Variable – DV). You might think with respect to differing groups employment groups of trade and…
View Multiple Sheets to Understand Statistical Anomalies
TechMbaBi 