deleted1 Posted February 28, 2014 Author Report Posted February 28, 2014 bi nerchukundham anukuntunav ok andhulo chala tools untay nenu microisoft bu stack meedha nerchukubni chesthuna nuvvu e tool decide ayyavo cheppu daani batti cheppachu market ela untundhi anioh ok
kum5758 Posted February 28, 2014 Report Posted February 28, 2014 @DaleSteyn.... Bhayya can u share important sites or links ...real time examples kani reports kani please..
deleted1 Posted February 28, 2014 Author Report Posted February 28, 2014 @DaleSteyn.... Bhayya can u share important sites or links ...real time examples kani reports kani please.. +1
kum5758 Posted February 28, 2014 Report Posted February 28, 2014 bhayyas if anyone in same tech...please include ur real time ideas and suggestions in learning t-sql,ssis,ssrs,ssas...as i am from science background koncham confusion undi...
deleted1 Posted February 28, 2014 Author Report Posted February 28, 2014 neekem kavali naku em teliyadu,BI ante enti andulo em nerchukonte better.... i would like to know these two things....
ReddySaab Posted February 28, 2014 Report Posted February 28, 2014 naku em teliyadu,BI ante enti andulo em nerchukonte better.... i would like to know these two things.... msbi lo moodu nerchuko etl--ssis datawarehousing --ssas reporting-ssrs microsoft sql server--database ivanni kalipi nerchuko endhukante combinations lo aduguthar reks
loveindia Posted February 28, 2014 Report Posted February 28, 2014 www.sqlsaga.com --> I created this as a resource for T-sql and BI related stuff... I am preparing videos , once they are ready, I will post them too...
deleted1 Posted February 28, 2014 Author Report Posted February 28, 2014 msbi lo moodu nerchuko etl--ssis datawarehousing --ssas reporting-ssrs microsoft sql server--database ivanni kalipi nerchuko endhukante combinations lo aduguthar reksthank you
deleted1 Posted February 28, 2014 Author Report Posted February 28, 2014 www.sqlsaga.com --> I created this as a resource for T-sql and BI related stuff... I am preparing videos , once they are ready, I will post them too...thank you
loveindia Posted February 28, 2014 Report Posted February 28, 2014 Business Intelligence is a term to in short to automate or create Intelligent enough (that are fast in terms of performance) business solutions to deliver right data. There are many tools in regards to that... MSBI, OBIEE, DATASTAGE, COGNOS, TERADATA, TABLEU, QLIKVIEW, SAP, MICRO STRATEGY etc etc.., MSBI lo 3 categories unnai.. SSIS -- SQL SERVER INTEGRATION SERVICES(If you want to perform any EXTRACT , TRANSFORM and LOAD operations you choose this tool).. Anything related to data movement between Source and Destination we use this. SSAS -- SQL SERVER ANALYSIS SERVICES -- ETL chestam mostly using SSIS to a Datawarehouse. After moving the data, since it is a data warehouse it will have historical data like 10-20 years... SQL Server will consume a lot of time to query such data.. In such scenarios, we opt to Multi-dimensional data which retrieves data faster because the data is flattened.. We use OLAP cubes in this method.. New Method released in SSAS apart from Multi-dimensional is Tabular model which is getting good demand. You have to learn SSAS only by expertise, training is limited because realtime data warehouses are impossible. SSRS -- SQL SERVER REPORTING SERVICES -- In the top 2 mentioned, we ETL'ed the data to a data warehouse using SSIS and created a multi-dimensional data warehouse model using SSAS.. Now its time for the presentation layer. We write MDX (opposite of SQL) scripts / T-SQL scripts to pull data and place them over the report server to show data for the audience.. In short idi MSBI antey... Training kaavali antey cheppu, classes start cheddam :D ... raavali raavali... line lo raavali....
loveindia Posted February 28, 2014 Report Posted February 28, 2014 endi aadollathoo parachakaalu aadutunnav...
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
.thumb.gif.343fe49c7e1c507ae0056326bd8cf77e.gif)
Recommended Posts