teradata bi

The concept of business intelligence (BI) has been put forward since 1958 and has been widely used in various industries for a long time, during this period, technologies and application environments related to business intelligence have become more and more mature. Different business intelligence vendors have also provided product series that can solve a full set of business intelligence solutions, this article briefly introduces the related concepts

from the heart.There is a need to use big data architectures, and not full use of big data, but a combination of big Data + traditional databases. We are currently testing this program. Many of these architectures have to be changed, the more fatal is the ETL becomes more complex, the traditional ETL tools many have not followed.If the amount of data is higher than the PB level, all the previous architectures have to be pulled back, using a pure Big data architecture, which is not a common comp

Tags: http data problems ad EF Time Database. Net TT Bi Data Warehouse product database storage A typical example is to compare a logical business to a cube. The product dimension, time dimension, and location dimension are different coordinate axes, and the intersection of coordinate axes is a specific fact. That is to say, a fact table is an intersection of multiple dimension tables. A dimension table is a window for analyzing facts. First, we wi

Microsoft integration services is a platform that can generate high-performance data integration solutions, including extracting, transforming, and loading (ETL) packages for data warehouses. Integration Services includes graphical tools and wizard used to generate and adjust packages; tasks used to execute workflow functions (such as FTP operations), execute SQL statements, and send emails; the data sources and targets used to extract and load data. They are used to clear, aggregate, merge, and

mining. In business intelligence, data mining is the highest level. Nowadays, the value of popular big data is often reflected by data mining. If we say that the Bi process can be seen as the data yesterday, today and tomorrow, and the data yesterday, we can use reports to tell you what happened before the business, the data today, multi-dimensional analysis and other tools tell you why this happened. The data tomorrow is to use data mining algorith

The company has been involved in the development of Bi projects for a period of time, but it is only developed as needed. This afternoon, the company will train you on the knowledge of data warehouses, let's hear about the two to three hours, what latitude, theme, and almost stunned. Finally, we demonstrated the Bi-based cost analysis system, which feels complicated, it is complicated for medical project se

chain, it is necessary to consider whether to establish a new report, how to implement the data source, and how to distribute the responsibility of data entry and maintenance. Conversely, the value and necessity of the existence of a report that is unrelated to any of the indicators needs to be elaborated.The sixth step: after the establishment of the index system and reporting system, how to show more can explain the problem? On the other hand, how to show the source data of the indicator and

directly share a recent in-spread article (http://daily.zhihu.com/story/4360204), is about Excel PivotChart report fever gameplay, often see some bi products in the promotion of the idea of throwing some ideas, Say your product chart is how gorgeous, quickly abandon ugly Excel bar, Excel PivotChart report may indeed not be as good as some professional charting tools, but definitely not ugly, in addition, it is also the advantages of PPT and word seaml

Source: "Bi thing" data stream conversion--character mapping tableThe feature map transformation shows the characteristics of the columns in the data stream, the editing interface is simple, there is only one label interface, click on the column to be mapped, you can choose to add a new column or need to update the column. You can give an alias to the original column in the Output alias column, and select the action you want to take, with the followin

Source: "Bi Thing" data flow conversion-multicast, Union all, merge, merge JoinSet up test data:CREATE TABLEFactresults (NameVARCHAR( -), CourseVARCHAR( -), scoreINT )INSERT intofactresults (Name, Course, score)SELECT 'Zhang San' , 'language' , - UNION All SELECT 'Zhang San' , 'Mathematics' , the UNION All SELECT 'John Doe' , 'language' ,

The original: "Bi thing" analysis of 13 kinds of commonly used data mining technologyFirst, the forefrontData mining is from a large number of incomplete, noisy, fuzzy, random data, the extraction of hidden in it, people do not know beforehand, but also potentially useful information and knowledge of the process. The task of data mining is to discover patterns from the data set, there are many kinds of patterns that can be found, according to the func