New CLARIFIED for Clarizen product video

Today we have released a new CLARIFIED for Clarizen product video.



Visit our website at www.clarified.biz for more information about CLARIFIED for Clarizen.

Delete duplicates from SQL without having a primary key

Recently I had a problem with finding duplicate records in a SQL table without having a primary key. Because I didn't want to create a primary key in the table, I had to use a different method in my SQL statement.

In the SQL example below you will see how to find the duplicate records. I used the SQL
ROW_NUMBER() function for it to differentiate between duplicate records.

DELETE SubQuery FROM
(SELECT ROW_NUMBER() OVER (PARTITION BY ID ORDER BY ID) NumOccurrences
FROM [dbo].[ClarizenDeletions]) SubQuery
WHERE SubQuery.NumOccurrences > 1

CLARIFIED for Clarizen version 1.3 released

With great enthusiasm we introduce version 1.3 of the Analysis and Reporting extension Clarified for Clarizen to you. Working closely with Clarizen, BI Architects we developed this extension for Clarizen customers who require extensive analysis of their Clarizen project data and/or in need of extensive reporting features including dashboards and KPI's.

CLARIFIED for Clarizen enables you to analyze your Clarizen data across all projects, using various criteria from a management point of view (highlights, KPI’s) or with detailed views for specific projects (Trends, Earned value, CPI, SPI, Resource Utilization etc.). All this within just a few mouse clicks. You can think of criteria like: Customers, Employees, Time periods, Project types and Task types.

In the 1.3 version of CLARIFIED for Clarizen we have improved and speed up the process of importing and refreshing  Clarizen data in the backend. In the frontend we have simplified our information model by gathering the date dimensions and adding the measure group Resource Capacity.

If you are interested in using CLARIFIED for Clarizen please visit and register at clarified.biz. After registration you can use the full functionality of Clarified for Clarizen free for 30 days to make sure you like it. We don't ask your for a credit card when you sign up, so if you don't like it, there's nothing to cancel. And because Clarified is Cloud Based, there is nothing to install!

On the Clarified.biz website, entrance to the Clarified portal, you will find information about the product, dashboard samples and videos on how to use CLARIFIED for Clarizen. When logged in, you will have access to the standard dashboards, Clarified Excel file, the online manuals and frequently asked questions.
For more information on Clarified for Clarizen, please visit the Clarified.biz website or contact us via info@bi-architects.nl.

Hermann-Otto Israël
Customer Success Manager
BIA Architects

Working with graphs in Clarified is easy!

Create a project performance chart within a few clicks.

The following demo shows you the ease of use of the Clarified Excel file. In this demo we use the Clarified Excel and MS Excel pivot table functionality.



Click here to go to the Clarified for Clarizen website.

Clarified for Clarizen published in Apps Marketplace

With great enthusiasm we introduce the Analysis and Reporting extension CLARIFIED for Clarizen to you. Working closely with Clarizen, BI Architects developed this extension. We developed it for Clarizen customers who require extensive analysis of their Clarizen project data and/or in need of extensive reporting features including dashboards and KPI's. The extension is published today in the Clarizen Apps Marketplace here.

Click here to sign up for a FREE 30-Day Trial.


The Clarizen Extension

The extension enables you to analyze your Clarizen data across all projects, using various criteria from a management point of view (highlights, KPI’s) or with detailed views for specific projects (Trends, EVA, CPI, SPI, Milestones etc.). All this within just a few mouse clicks. You can think of criteria like: Customers, Employees, Time periods, Project types and Task types.

To mention some examples what this analysis might bring you:
• Analysis on task types helps you to make reliable estimates for new projects
• Analysis by employee allows you to compare the performance with colleagues
• Analysis of project types will help you better determine what types of projects are successful and
  which are less successful
• Analysis on customers gives you insight into the profitability of customers.

Click here to download our Clarified for Clarizen brochure.