MOVIE: Use QlikView to analyze your Clarizen project data

With CLARIFIED for Clarizen it's possible to analyse, create dashboards or reports with Qlikview on your Clarizen project data. In the video below you can see how it's done.

Main features and benefits of QlikView:

• use of an in-memory data model
• automated data integration and a graphical analytical environment attractive for customers
• fast and powerful visualization capabilities
• flexible - allows unlimited dimensions and measures and can be modified in seconds
• integrated - all in one solution : dashboards, power analysis and simply reporting on a single architecture
• risk free - available as a fully-functional free trial download

Next to Qlikview it's possible to use numerous other BI tools which can connect to a Microsoft Analysis Services cube.

Interested?

You can use CLARIFIED for Clarizen free for 30 days to make sure you like it. We don't ask you 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! Click here to try it free for 30 days.

Clarizen project data in Tableau

As we get more and more questions about if it is possible to use CLARIFIED for Clarizen data in Tableau, I will show you some examples below.


With Tableau it is very easy to create dashboards and analytics on CLARIFIED for Clarizen data. A connection to the CLARIFIED Cube can be made in minutes with the Microsoft Analysis Services connection in Tableau. In addition, Tableau has also a server version in which you can share your worksheets with other users. Read more about Tableau here: www.tableausoftware.com or view the Tableau product demo here : https://www.youtube.com/watch?v=37Mx3uZRwBE

Below are some examples that we have created with Tableau and the Clarizen Demo environment:

- Profitability By Account

- Profitability by Project Type

- Profitabilty by Project Manager

- Active Projects per Project Manager

- Resource Utilization

Profitability by Account


Click here to view the original screenshot.


Profitability by Project Type


Click here to view the original screenshot.


Profitability by Project Manager


Click here to view the original screenshot.

Active Projects per Project Manager

Click here to view the original screenshot.


Resource Utilization

Click here to view the original screenshot.

Resource Utilization

Click here to view the original screenshot.

30-Day free Trial

You can use CLARIFIED for Clarizen free for 30 days to make sure you like it. We don't ask you 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! Click here to try it free for 30 days.

More information

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

CLARIFIED for Clarizen version 1.3.3 released

We are proud to announce that we've released CLARIFIED for Clarizen version 1.3.3 with improved backend processing and increased overall performance! Watch the product video here.

Reporting for billing purposes is now even easier with the added fields:

• Billing Type (Actual Cost, Fixed Price, Not Billable)
• Has Fixed Price, Has Fixed Cost
• Cost Type (Actual Cost, Fixed Cost)

We've also added new count measures:

•  New count measures (Work Item Count, Project Count)

Added value
CLARIFIED for Clarizen’s added value consists of:

• Within a few clicks access to all your Clarizen Project data.
• Out-of-the-box slice and dice functionality.
• No more time needed to develop Excel queries or lookup’s.
• Out-of-the-box dash boarding on an Executive level is. One can even set Revenue or Profit Goals on any given context (like a given Portfolio and Year period) and compare the Actuals against it graphically.
• Out-of-the-box reporting for billing purposes is easy. Fields include Billing Type, Fixed Price and Period selection. So reporting all Revenue that should be billed in a given period is easy and saves a lot of time and errors for the accounting department.
• Resource Utilization can be represented graphically, both on individual and on Group level. Resource Utilization can be shown on Planned and Actual effort.
• Tracing inconsistent data entry in Clarizen is made easy. Like reporting all Time sheet effort that is not approved yet.
• CLARIFIED for Clarizen can connect to numerous BI tools like Tableau, Dundas, Cubeware and TARGIT.

30-Day free Trial
You can use Clarified for Clarizen free for 30 days to make sure you like it. We don't ask you 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! Click here to try it free for 30 days.

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

CLARIFIED for Clarizen Pricing Plan Update

We have updated our CLARIFIED for Clarizen pricing plan for large volume users of Clarizen (75+) and wanted to share this information with you.

The new CLARIFIED for Clarizen plan will include the following:
• A fixed yearly license fee of USD 6,500, for an unlimited user count.
• Optional one-time setup fee of USD 2,300 for custom fields.
• Optional but recommended: prepaid 10 hours of consultancy for USD 1,200.


Why we changed the pricing plan
CLARIFIED for Clarizen has grown and we have learned a lot over the last year, and our users, partners and others have provided valuable feedback to us along the way. We understood that the license fee was getting too high for large volume users of Clarizen (75+) and for that reason we changed it.


30-Day free Trial
You can use Clarified for Clarizen free for 30 days to make sure you like it. We don't ask you 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! Click here to try it free for 30 days.

Clarizen Apps Store
You can also find us in the Clarizen Apps store here.

CLARIFIED for Clarizen - Tableau

Probably you already knew that CLARIFIED for Clarizen is the reporting and analysis service for Clarizen users, offers rich dashboards and enables you to analyze your Clarizen data across all projects, using various criteria. All this within just a few mouse clicks.

But did you know it can be used as a source for bringing your reports and dashboards through Tableau?

Tableau
Tableau is a Business Intelligence software that provides browser-based analytics and reporting anyone can learn and use. It’s a rapid-fire alternative to the slow pace and rigidity of traditional Business Intelligence software. Click here for more information about Tableau.

Experience

After downloading Tableau, it just took me 5 minutes to install and connect Tableau to the CLARIFIED for Clarizen cube. Connecting to the cube was very easy with an Analysis Services Connection in Tableau. Within a view clicks I had instant reporting and visualization!

Besides using Tableau other third party Business Intelligence or reporting solutions like Dundas, Targit, QlikView or RoamBI can be used to create your own dashboards.

Interested in CLARIFIED for Clarizen? Please contact us via info@bi-architects.nl or visit our www.clarified.biz portal for more information and to start your trial of today!

CLARIFIED for Clarizen is going mobile!

Probably you already knew that CLARIFIED for Clarizen is the reporting and analysis service for Clarizen users, offers rich dashboards and enables you to analyze your Clarizen data across all projects, using various criteria. All this within just a few mouse clicks.

But did you know it can be used as a source for bringing your reports and dashboards to your mobile phone or tablet?

We have setup dashboards in RoamBI, a mobile business intelligence solution that transforms data from major BI Systems into dashboard-style mobile analytics for iPhone or iPad, for one of our customers using our CLARIFIED for Clarizen service.

Besides using RoamBI other third party (mobile) BI or reporting solutions can be used to create your own dashboards and make it accessible on any device. Similar to monitoring the financial markets on TV, you now can focus on the Clarizen metrics that matters most to you.

Interested? Please contact me via H.O.Israel@BI-Architects.nl or visit our clarified.biz portal for more information and to start your trial today!

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.

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.

Clarizen in top 25 most important Online PM Software

Clarizen, the online project management solution, was selected as one of the top 25 of the most important Online project Management Apps by GetApp.com. The infographic on Top Online Project Management Software can be found here.

BI Architects uses Clarizen for managing its projects and has developed a BI solution for Clarizen. More on our BI solution can be found in this blog Business Intelligence extension for Clarizen.

Clarizen posts BI Architects video to Social Media

We were very happy to see the posts of Clarizen, leading global provider of collaborative online project management software, in the Social Media referring to the video we made of our Clarizen BI Solution.

Thank you, Hilee Avrahami of Clarizen, for bringing this video to your customers and followers attention!

Here you can have another look at our video:



Our Business Intelligence solution for Clarizen adds reporting functionality that helps the project managers monitor, track and report project progress (including KPI's and earned values), the finance department enable swift and correct detailed invoicing and the management team gaining direct insight in the performance/profitability of projects.

For more information about the extension for Clarizen please contact our sales manager Erik Rongen-Kleintjens (E.Rongen-Kleintjens@bi-architects.nl).

Hermann-Otto Israël

BI Architects project manager

Business Intelligence extension for Clarizen - Presentation

Two weeks ago i posted about the Clarizen's online project management software. In the presentation below our Business Intelligence extension for Clarizen is described.

For more information about the extension for Clarizen please contact our sales manager Fred Booms (f.booms@bi-architects.nl)


Hermann-Otto Israël
BI Architects project manager

BI solution additional to use of Clarizen's online project mgt software

BI Architects develops Business Intelligence solutions for its customers. Furthermore it has developed BI solutions for managing its own business processes, such as the solution that helps the project managers monitor, track and report project progress (including KPI's and earned values), the finance department enable swift and correct detailed invoicing and the management team gaining direct insight in the performance/profitability of projects.


BI Architects has chosen the Clarizen's online project management software for the registration of customers, projects, milestones, tasks and writing time. The Clarizen tool takes care of the complete project administration/resource management/and much plus it gives basic insight in performance via reporting. What it lacks is giving a more detailed insight in the performance of project phases over projects (for comparing project performances and quality improvement), earned values (current status and expected outcome) of projects and more figures needed for project management that are available without starting reports, setting parameters, running the report and opening the result in MS Excel.


What we have done is developing a standard Microsoft SQL Server Integrated Services/SQL Server Analysis Services (SSIS/SSAS) solution that adds what we miss in the Project Management tooling. SSIS is used for the extraction, transformation and loading of data from the Clarizen database into a staging environment (dimension tables), while SSAS delivers actionable insights (cubes and its dimensions) and made available via a pivot table in Microsoft Excel.


All information is now available via MS Excel and on the fly customizable serving several purposes within the BI Architects (project) organization.


For more information on our project management BI solution please contact me via H.O.Israel@bi-architects.nl . For more information on Clarizen's online project management software go to Clarizen.com .


Hermann-Otto Israel
BI Architects project manager

Welcome to our blog!

Welcome! Before we describe what you can get from reading our new blog, we want to introduce ourselves to anyone new to this space. BI Architects is a specialist in Business Intelligence Solutions and is located in the Netherlands. Our mission is to offer customized Business Intelligence and System Integration, through honest advice and implementation projects where quality, commitment, up to date knowledge and understanding in and optimizing of the processes of our customers stands central.

What can you find at the BI Architects blog? Our blogging team will cover a wide-range of Business Intelligence topics, including Dimensional Modeling, System Integration, Project Management, News, Information on trends, and more. Check back on a regular basis to read about:

• Project Management approaches in Business Intelligence projects
• Business Intelligence with online Project Management software from Clarizen
• Business Intelligence in Trading & Risk Management with Commodity XL (CXL) from Triple Point
• Sharepoint 2010 dashboard solutions
• Innovations in Business Intelligence software

Our blogging team will also describe practical solutions for challenges we have with tools like:

• Microsoft Visual Studio
• SQL Server
• SQL Server Integration Services (SSIS)
• SQL Server Analysis Services (SSAS)
• SQL Server Reporting Services (SSRS)
• Sharepoint 2010
• etc.

So, enjoy reading, and don’t forget to comment. We want to hear from you.

The BI Architects Blogging Team