My Week 5 - Google Gadgets

I know, it might be really late..
Just have a look at it again.. looks really pretty, neat, and elegant..
haha

~lalalala

Week 5 - lecture

This week coverage:
.Technology environment in developing BI apps.
.Role of data warehouse.
.Evolution of OLAP technology.

Quick summary of what I got in this week lecture:
.Technology needed by BI apps:

• intuitive access

• speed

• data from many sources

• flexible, attractive reports

.Simple BI architecture does not work

• revised with new architecture that got DATA WAREHOUSE on it

.BI and data warehouse

• BI may say "I don't need data warehouse" and vice versa

• BUT, main goal of BI: provide an easy, powerful, fast system

.Data warehouse

• may have redundancy

• well integrated

• time variant

• non-noisy data

• subject oriented

.Differences between OLAP and DW(data warehouse)

• DW is better at: Handling sparse data (?), Data volatility, Large numbers of dimensions, Large volumes of data, Development time(application evolution), Learning curve, Standards, interoperability, Data loading time (?)
  

• OLAP is better at: Calculation intensity, complexity, Handling complex drill hierarchies , Query response time, Consistency, reliability, Network impact, General ease of use for end-users, Development time (function evolution), Cost of simple deployment?
  

.DW vs OLAP

• OLAP is FAST!!

• DW deals with gathering data from multiple sources

• The rest is OLAP

.12 Codd's rules

• **Refer to lecture note**

Week5 - tute

I officially start my day in uni today @7pm for tute with Steve..
Today's tute is really really FUN!!! (letting him notice even more that I haven't come to tute last week, that i just start being so excited to play around and get the feel of pivot table)..
I did my tute up to task4 and decided to follow it up tomorrow, or the day after tomorrow, or the next day of the day after tomorrow.. Got enough stuff to do atm..
I was so excited that I decided to take a snapshot of it..

There was error messages comes up to me several times..

First one was my mistake in choosing the type of database that I want to make a connection to.. I just quickly choose the .mdb extension without realizing that i choose the one called "driver do Microsoft database".. I should actually choose "Microsoft access driver" that have the same extension, .mdb
One problem was solved!

Second error message was on my way doing task3 where we were asked to specify the connection to the database server.. I am sure that I have put the right server name and username + password.. So I decided to just re-do and trata... magic!! It works..
I come to Steve and he said it may be because around 30students trying to access the server at the same time that it starts to deny some access.. It does make sense!!

All problems solved!! Go to lecture..