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…
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 expenses align with organizational goals Effectively managing resources allotted for I.T. is critical for the success of an organization, especially as competition for those resources continues. I.T. managers must utilize budgets as their primary strategy for managing these resources. Comprehensive budgets should include precision and categories which encompass the entire technological enterprise. Such categories…
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…
Keeping projects in balance. Though simple, this little diagram represents what occurs during all projects and its concepts are crucial to remembering when managing project work. Three aspects of all projects The Budget The irony of the budget is that many projects treat it as an island which allows the other two sides: Time and Scope, to constantly threaten…
TechMbaBi 