Articles with this tag assume no knowledge prior to reading them.
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 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…
The “nuts and bolts” of a project. Areas of Responsibility There are four major areas of responsibility for a project manager: Identify requirements for project: Get project details, figure out what it will take to make the project a success. Establish objectives that can be achieved: Plan goals that the team will work toward and the way in…
The purpose and benefits of project management. As I describe in my Bio my second Bachelors degree was in Project Management. Not only did I learn and was challenged more than originally planned, I was most struck by how of my knowledge related to it was incorrect and even dangerous to apply within technical management. Thankfully, the Project…
TechMbaBi 