(Information is Beautiful)

Posts tagged “Learning

Big Bang Data

A brief detour through art

http://bigbangdata.cccb.org/en/

“A NEW ERA OF KNOWLEDGE
The revolution of disciplines after Big Data
From professional football and literary studies to crime prevention, today the fields of knowledge that have been profoundly changed by access to big data sets are countless. Data science methodologies are opening up new paths in numerous disciplines creating specialised fields that are associated with new professional profiles.
Thus, today, in urban planning, we talk of smart city technologies; in the press, of data journalism, and in departments of history, of digital humanities.
The first wave of data-driven products is also generating tensions and rifts in the respective industries, as is happening with the highly controversial personalised genome analysis services.”


Learning SSIS

We’re very fortunate that Microsoft provides very rich tutorials and documentation, so it should be easy to follow some self-guided training. I have provided a list of links for you below, to start becoming familiar with the tool. I would also suggest picking up a book.

SSIS (SQL Server Integration Services)

 

Example Training/Curricula

http://www.kimballgroup.com/microsoft-dw-bi-in-depth/

http://www.microsoft.com/learning/en/us/course.aspx?ID=10777A

http://www.microsoft.com/learning/en/us/course.aspx?ID=6235A

 

Books

http://www.kimballgroup.com/data-warehouse-and-business-intelligence-resources/data-warehouse-books/booksmdwt/

http://www.amazon.com/Knights-24-Hour-Trainer-Microsoft-Integration/dp/0470496924/ref=sr_1_1

http://www.amazon.com/Professional-Microsoft-Server-Integration-Services/dp/111810112X/ref=sr_1_6

 

Reference

http://technet.microsoft.com/en-US/sqlserver/cc511477.aspx

http://msdn.microsoft.com/en-us/sqlserver/cc511477.aspx

http://msdn.microsoft.com/en-us/library/ms141026.aspx

http://msdn.microsoft.com/en-us/library/bb522537.aspx

http://social.technet.microsoft.com/wiki/contents/articles/6752.ssis-list-of-transformations.aspx

 

Development

http://msdn.microsoft.com/en-us/data/tools.aspx

http://technet.microsoft.com/en-us/library/ms124623(v=sql.105).aspx

http://www.codeplex.com/site/search?query=integration%20services&ac=1

 

Social

http://blogs.msdn.com/b/mattm/

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/threads

http://stackoverflow.com/questions/tagged/ssis

 

Lab

https://cmg.vlabcenter.com/default.aspx?moduleid=cbc7fcb5-e91b-4899-af86-1c4cb36f2a1d

 

Tutorials

http://msdn.microsoft.com/en-us/library/bb522500(v=sql.105).aspx

http://msdn.microsoft.com/en-us/library/ms167031(v=sql.105).aspx

 

 

Learnings

http://channel9.msdn.com/shows/toolshed/ToolShed-Tooltip-20-SSIS-Data-Profiling-saves-your-eyeballs/

http://channel9.msdn.com/Events/TechEd/NorthAmerica/2012/DBI310

http://channel9.msdn.com/posts/SSIS-troubleshooting-Demo

http://channel9.msdn.com/Events/TechEd/Europe/2010/BIN302

http://channel9.msdn.com/Events/TechEd/NorthAmerica/2012/DBI322

[http://channel9.msdn.com/search?term=ssis for more…]

 

Videos

http://www.youtube.com/watch?v=dzfZJlN4nzI

http://www.youtube.com/watch?v=I_Ae3suaL-U

http://www.youtube.com/playlist?list=PL6E7A1AB2E25073A9

http://www.youtube.com/playlist?list=PL07DD9B6AB8DEABFF

http://www.youtube.com/playlist?list=PL33BDF0753861ADD4

http://www.youtube.com/watch?v=oTJjGH7eyns&playnext=1&list=PL2900t3sPCl2XP6qMg94IjtQYYlgjIe3x&feature=results_main

http://www.youtube.com/watch?v=hJjH42P427o&playnext=1&list=PL53A0BBD46BDBB881&feature=results_main

[http://www.youtube.com/results?search_query=sql+server+integration+services for more…]

[http://www.youtube.com/results?search_query=ssis for more…]


Learning OBIEE

First of all, I sympathize. If Oracle pays you to use it, and you have to learn it quickly, here are a few resources.

http://apex.oracle.com/pls/apex/f?p=44785:24:0::NO:24:P24_CONTENT_ID,P24_PREV_PAGE:6349,2

http://apex.oracle.com/pls/apex/f?p=44785:24:0::NO:24:P24_CONTENT_ID,P24_PREV_PAGE:5082,2

http://apex.oracle.com/pls/apex/f?p=44785:24:0::NO:24:P24_CONTENT_ID,P24_PREV_PAGE:5690,2

http://apex.oracle.com/pls/apex/f?p=44785:24:0::NO:24:P24_CONTENT_ID,P24_PREV_PAGE:5622,2

http://docs.oracle.com/cd/E23943_01/bi.htm

http://www.obiee123.com/

http://vimeo.com/11255065

http://vimeo.com/12641808

http://www.youtube.com/watch?v=j7Qp32_QjGs

http://www.youtube.com/watch?v=PRB2fZmEBpA

http://www.youtube.com/playlist?list=PLDBE1B8162F9973B7

http://www.youtube.com/user/4CInfotech/videos?query=obiee

http://www.youtube.com/user/MrAlooa2/videos?query=obiee

http://www.youtube.com/user/PerformanceArchHowTo/videos?query=obiee

 

Useful Sites

OBIEEpedia http://obieepedia.wordpress.com/

 

Sources

BI Consulting Group http://www.biconsultinggroup.com/bicg-university/

Rittman Mead http://www.rittmanmead.com/category/obiee/

KPI Partners http://www.kpipartners.com/latest-thinking/

Oracle

http://www.oracle.com/technetwork/middleware/bi-foundation/overview/index.html

http://www.oracle.com/us/solutions/business-analytics/business-intelligence/enterprise-edition/overview/index.html

http://www.oracle.com/technetwork/topics/bi/whatsnew/index.html

https://delicious.com/oracletechnologynetwork/obiee

https://blogs.oracle.com/pa/tags/obiee

http://apex.oracle.com/pls/apex/f?p=44785:2:0:::2:P2_PRODUCT_ID:2001

http://www.youtube.com/user/EvolvingBI

http://vimeo.com/clearpeaks/videos