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!

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

Query to find the size of the database and database file

Technique 1:


     EXEC sp_helpdb

Technique 2: For a specific database:

sp_helpdb'adventureworks'

And you get the following output: (this one gives you the database and data file information for a specific database)




Technique 3: be in the context of the database and run sp_spaceusedGives you the database size and certain more properties of it:


     EXEC sp_spaceused

This is what you get:

Technique 4: use sys.master_files


SELECTDB_NAME(database_id)AS DatabaseName,
Name AS LogicalName,
size*8/1024 Size_in_MB,
max_size
FROM sys.master_files
WHEREDB_NAME(database_id)='AdventureWorks'
GO




If you liked this post, do like us on FaceBook at http://www.facebook.com/pages/BI-Architects/249973345047634?sk=wall

SharePoint 2010 Advanced Developer Training

For developers, SharePoint 2010 provides a business collaboration platform to rapidly build solutions and respond to business needs. SharePoint 2010 Advanced Developer Training offers technical training as self-paced modules and hosted labs for SharePoint 2007 professionals who want to upgrade their skills to SharePoint 2010.

Module 8 for example, presents Business Intelligence capabilities in SharePoint 2010. There are improvements in this area to help build Business Intelligence dashboards, which can be used to expose relevant information for business users in a meaningful way.

SharePoint 2010 Advanced Training
01 : Developer Roadmap and Tools
02 : Core Development
03 : User Interfaces and Lists
04 : Data Access in Technologies
05 : Composite Solutions
06 : Enterprise Content Management
07 : Enterprise Search
08 : Business Intelligence
09 : Communities
10 : Development Life Cycle