custom report development

Strategic

image29

Strategic reports are commonly used to align a company’s strategic goals. They track performance metrics against enterprise-wide targets. As a result, these reports tend to summarize performance over set time frames: past month, quarter or year.

Though they can provide opportunities for drill down and further analysis, strategic reports are usually fairly high-level.


HarborView can automate the preparation of Management Review reports so you never have to cut and paste again!

Operational

image30

Operational reports are the most used report. They monitor and analyze a company’s activities in a given business area. These reports are focused on exception alerting and are based on real time data.  Operational reports are used by those with operational responsibilities. This often leads to more direct action, then further analysis. Because of this, operational reports often are more detailed than strategic reports.


Operational reports help departments stay proactive and ahead of problems. For example, a manufacturing firm may use an operational report to track products manufactured along with the number of defects, complaints or returns. With a report , any adverse trends would be highlighted in real time.


Operational reports are designed to be viewed multiple times throughout the day. They are often used to monitor progress towards a target

Analytical

image31

An analytical report is used to analyze large volumes of data to allow users to investigate trends, predict outcomes, and discover insights. The data behind an analytical report needs to be accurate and may only be updated infrequently. Analytical reports often include advanced BI features like drill-down and ad-hoc querying.


An example of an analytical report is one that monitors process capability or method variability to facilitate process improvement

Training

Self-Service BI for Quality Engineers

The creation of reports and dashboards no longer needs to be the sole task of IT. Thanks to Power BI, users can create ad hoc reports and dashboards to support other end users (usually within their line of business) themselves.

BI Report Design

Our training provides best practices for designing reports in Power BI. Starting with planning, it discusses principles of design that you can apply to your reports and to the pages and individual visuals that make up that report. 

Dimensional Modeling

 A dimensional model is a data structure technique optimized for Data Warehousing tools. The concept of Dimensional Modeling was developed by Ralph Kimball and utilizes "fact" and "dimension" tables. 


 Dimensional models enable drag and drop analysis.

Extract, Transform & Load Data with Power Query

 Power Query is a data connection technology that enables you to extract, transform and load data to meet your analysis needs. Features in Power Query are available in Excel and Power BI Desktop. 

Building DAX Measures

Data Analysis Expressions (DAX) is a library of functions and operators that can be combined to build measures in Power BI Desktop, Azure Analysis Services, SQL Server Analysis Services, and Power Pivot in Excel. 

Statistical Analysis with R

 The free R programming language is among the most widely used programming languages by statisticians, data scientists, and business analysts. 


 Visuals created with R scripts can present advanced analytics such as process capability (CpK), PK/PD/pharmacometrics and genomics. 


The rich analytics and visualization power of R used with Power BI provides a cost-effective alternative to JMP, Minitab and SAS.