|
|
KPI BI Report |
|
|
|
Monday, 27 April 2009 |
Steps for creating a KPI report in SQL Server BI tool.
To create a KPI report (see FIGURE below) with sample AdventureWork's
data came with SQL Server, follow the following steps:
|
|
Read more...
|
|
|
Comparing Analytica and DPL for financial modeling |
|
|
|
|
SAS SQL Tutorials |
|
|
|
|
Usability Check List |
|
|
|
Sunday, 21 October 2007 |
Usability Check List
- Cognitive model
- Goal/Process - Where is the bottle neck?
- Website Feng Shui - art and science of goal/user
process flow
- Design/Color Theory
- neutral vs personalization
- warm & cold balance
- The zen of eye movement.
- ClosetSpace organization - when there are more than 5
choices, use folders, outline, expandable trees.
- Tufty Visualization as navigation model (i.e. US map
with cold to warm dimension)
- Persuasion Architecture and six Sigma (Futurenowinc.com)
- Neuro-linguistic marketing - learning before buying,
infomercial, and parallel .org website
- ClickZ Marketing checklist, i.e. recency, frequency
- Nielsen/Norman , Human Factors International Checklist
- Section 508 Disability Checklist (Adobe study on web user
disability)
- Web analytics model.
- Continuous quality improvement - PKIs, score card
management
- Serving content based on segmentation - user
classification/clusters
|
|
|
Google - DoubleClick Acquisition discussion |
|
|
|
Tuesday, 02 October 2007 |
Even without the
DoubleClick acquisition, according to Game Theory and Auction Theory,
the Adword bidding arena is about to get into another gear as tools
such as SpyFu, Compete, and Alexa
making the keyword bidding process,
and other SEO and SEM processes transparent. Like
English auctions where prices are revealed, as the number of bidders
get
larger, the bids approaches the market price. Auctions or bidding are
used because sellers don't know the real value of the goods - prices
change depending on market conditions - prices are
what buyers willing to pay.
In the web avertising arena, when there are a small number of bidders
for
top positions, the sellers (Google, Yahoo, Ask, etc...) always get
better than market prices.
- which is the current state of Adwords. Imagine if Adwords used the
Dutch auction where bids are offered as Google drops the Ad prices, or
First-Price/Sealed Bid auctions where bids are offered to highest
bidder at certain time of the day. Let's not jump into that just yet.
With the Acquisition of DoubleClick, what will change? Currently
DoubleClick DART helps advertisers with buying ad spaces and helps
publishers minimize unsold space inventory. DoubleClick does a number
of housekeeping processes on top of ad serving. How will these
processes changed? The bottom line (search engines') will drive the
changes.
What about another model, namely ISEDN.org where there
is a flat fee for keywords and fair rotation of advertisement among all
buyers. It certainly will eliminate click frauds, but is it realistic?
For some industries, non profit, and public services, it might work
well. The traffic
report on Alexa for ISEDN.org shows that the idea is not
catching on - traffic steadily declines with only a few exeptions.
Read Google's views on government,
policy, and politics |
|
|
|
Testing Apache Webserver running on a guest Fedora Linux OS |
|
|
|
Thursday, 20 September 2007 |
TUTORIAL: Testing Apache Webserver running on a guest Fedora Linux OS
This tutorial shows the steps for testing if Apache is running.
STEPS
- Create a Fedora Linux virtual machine (guest) on Windows
XP(host) with Vmware.
- Install Fedora Linux. This is now the guest OS.
- Start Linux, than log in as a regular user. Start a shell
to input commands
- Change to root (su - root)
- Start Apache by typing at the command prompt: service httpd
start. Test if service is running by typing: telnet localhost 80 (see
image 1 below). GNOME or KSE GUI tools can also be used to
configure Apache.
- Find the IP address of this server by typing: ifconfig
(this is equivalent to typing at the commnad prompt in Windows:
ipconfig - see image 2 with the black background below) Note
that this is a different IP address than that generated by Windows in
the host machine.
- By default Apache is set to listen to all
available IP addresses (GNOME or KSE GUI tools can be used to verity
this)
- Start FTP service by typing in:
/etc/init.d/vsftpd start
- Create an index.html test page and upload to /var/www/html
(see image 3 below).
- Open a brower on host Windows XP and type in the URL found
in step 6. The test page should appear (see image 1)
|
|
|