Archive for the ‘How-to’ Category
Monday, January 16th, 2012
When using Excel ODBC with PHP please use the following settings
All settings are done in the connection_methods.php
Windows 7 and Excel 2007
(support for .xls, .xlsx, .xlsm, .xlsb)
$db_url="DRIVER={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};FIL=Excel 12.0;DriverID=1046;Dbq={$excelFile};DefaultDir={$excelDir};ImportMixedTypes=Text";
Windows XP and older Excel (just .xls)
$db_url="Driver={Microsoft Excel Driver (*.{$fileinfo['extension']})} ;DriverId=790;Dbq={$excelFile};DefaultDir={$excelDir};ImportMixedTypes=Text";
Posted in How-to | Comments Off
Tuesday, November 15th, 2011
When you use the Add Date hierarchy columns for any date, by default it brings all calendar quarter and calendar month.
How do you get Fiscal Quarter
Let say your fiscal year begins from 1st July then
First Quarter = { 7 , 8 , 9}
Second Quarter = { 10, 11, 12}
Third Quarter ...
Posted in Excel, How-to | Comments Off
Thursday, November 3rd, 2011
Previous Step: Excel Dashboards - Part 1
Launch Dashboard Software and Connect
Launch InfoCaptor Dashboard Software on your Desktop and click on the connect button on the toolbar
The connection wizard has items that simplify connecting to different data sources.
For Excel Files, Click on the Excel button
Once you click, it automatically selects the ...
Posted in Excel, How-to | Comments Off
Wednesday, November 2nd, 2011
Once you launch Infocaptor, you can click on the connect button.
In this example we are using the northwind sample database
Click on connect
Once connected it will open the Option wizard
Since there is no dashboard open, the "Build New Query" is disabled.
Click on the "New Blank Dashboard"
Enter some name for the dashboard ...
Posted in How-to, MS Access | 3 Comments »
Wednesday, November 2nd, 2011
Databases are often under lock-n-key of the IT Department and not possible to connect directly due to security reasons. So if you plan to build a Dashboard prototype or a Dashboard Mockup it makes sense to export the data to Excel and build it.
Modular Dashboard Design
Lot of the online tutorials ...
Posted in Excel, How-to | Comments Off
Wednesday, November 2nd, 2011
Previous step : Excel Dashboards - 2
Create Dashboard and Table portlet
Once connected, it will show you a list of action items to pick from
We will click on "New Blank Dashboard"
In the Dashboard Name, we type in "Order Management Analytics"
Click OK.
It will present you with a table browser showing all the ...
Posted in Excel, How-to | Comments Off
Saturday, October 15th, 2011
In this article we will take an Excel source containing scorecard information and convert into dials and speedometer charts.
We will also create few bar trending charts.
Consider the below sample data
Source File: You can download the excel file here
The above excel file tracks few metrics such as safety, quality and revenue. ...
Posted in Excel, How-to, MS Access | Comments Off
Monday, September 26th, 2011
This tutorial explains how to drill between a table to another table
The below article will explain how to drill from a bar or pie chart to another chart or table.
From the tutorial above, we need to prepare the child portlet in order to receive the parameters for drill purpose.
This is ...
Posted in How-to | Comments Off
Wednesday, August 31st, 2011
HTML5 Font rendering is tricky. It is not consistent across browsers.
Read how MockupTiger fixed the font rendering issue. You will also notice that with the fix, it is now possible to add any of your favourite font for wireframes. Why just limit to Comic Sans or Arial. Try the Google ...
Posted in How-to | Comments Off
Sunday, August 28th, 2011
When you build website wireframes or prototypes, clickable mockups is a standard requirement.
MockupTiger when released had Clickable prototyping feature using the Text widgets
Now all the text widgets, icons can be linked. There is a new element called hotspot that you can overlay on any kind of object/widget to simulate Clicking ...
Posted in How-to | Comments Off
