The bi thing-the art of Data Catalog index

Source: The bi thing-the art of Data Catalog index

Original • "Bi Thing-data Art" tutorial free release

Ladies and gentlemen, hello, I am Bobby, in the process of learning bi and development of the project has some sentiment and ideas, sorting and writing some learning materials, originally just internal learning to use, but in order to facilitate more BI developers, promote BI enterprise application development, decided to organize into a tutorial, And on the network free of charge to publish this tutorial, want to contribute to the BI era humble!
This tutorial is by Bobby Reference official documents, comprehensive market-related books, through the full absorption of digestion, combined with the development of the practice of the creation of an original work, in order to this tutorial early to meet with the vast number of readers, share, special use of the final part of the release of a part of the serial way released. Park friends can get the latest content in this blog.

"Original • Tutorial • Serial" bi thing-the art of Data Catalog index

1. "Bi Thing" SQL Server 2008 Architecture
2. "Bi thing" OLTP and OLAP
3. "Bi thing" common bi terminology--Key performance indicators
4. "Bi thing" meta data (metadata)
5. "Bi Thing" Data Warehouse Modeling: Star-mode, snowflake-mode
6. "Bi thing" cube storage
7. The query language used in the BI Business BI solution--mdx
8. The query language used in the BI Business BI solution--dmx
9. The query language used in the BI Business BI solution--xmla
10. The query language used in the BI Business BI solution--rdl  

"Original • Serial" Microsoft BI Project Note series
This series of articles is based on the actual project, together with their own summary, organized a series of project notes, involving Microsoft SQL Server2008 in Business Intelligence development in the SSAS, SSIS module

Integration Services Conversion

Business Intelligence Transformation

1. "Bi thing" data stream transformation--Slowly changing dimension transformation
2. "Bi thing" data stream transformation--Fuzzy Grouping transformation
3. "Bi thing" data stream transformation--Fuzzy Lookup transformation
4. "Bi thing" data stream conversion--word extraction transformation
5. "Bi thing" data stream conversion--word Lookup transformation
6. "Bi thing" data stream transformation--Data Mining query transformation

Row conversions

1. "Bi thing" data stream conversion--character mapping table
2. "Bi thing" data stream conversion--Copy Column transformation
3. "Bi thing" data stream conversion--data conversion
4. "Bi thing" data stream transformation--derived columns
5. "Bi thing" data flow conversion--Import columns, export columns
6. "Bi thing" data stream transformation--Script Component
7. "Bi thing" data stream conversion--ole DB command Conversion

Rowset conversions

1. "Bi thing" data stream conversion--aggregation
2. "Bi thing" data stream conversion--sort
3. "Bi thing" data stream conversion--percent sampling, row sampling
4. "Bi thing" data stream transformation--perspective
5. "Bi thing" data stream conversion--Inverse perspective transformation

Split and join transformations

1. "Bi thing" data stream conversion-conditional split
2. "Bi thing" data flow conversion-multicast, Union all, merge, merge Join
3. "Bi thing" data stream conversion--Lookup transformation
4. "Bi thing" data stream conversion--cache conversion

Audit conversions

1. "Bi thing" data stream conversion--audit
2. "Bi thing" data stream conversion--row count conversion

Custom transformations

Business intelligence and data mining applications

2. A preliminary study on data mining of "Bi's little Thing"
4. The main method of data mining in the bi thing
6. "Bi thing" analysis of 13 kinds of commonly used data mining technology
8. The relationship between data mining and related fields in Bi thing
10. "Bi Thing" Microsoft Association algorithm
12. "Bi thing" Microsoft Clustering algorithm
14. "Bi Thing" Microsoft cluster analysis algorithm--three-person identity division
16. "Bi thing" Microsoft Decision Tree algorithm
18. "Bi thing" Microsoft decision Tree algorithm--Find out the characteristics of the Three Kingdoms, dedicated to the broad three enthusiasts
20. "Bi thing" Microsoft linear regression algorithm
22. "Bi thing" Microsoft logistic regression algorithm
24. "Bi thing" Microsoft logistic regression algorithm--predicting the rise and fall of stocks
26. "Bi thing" Microsoft Naive Bayes algorithm
28. "Bi thing" Microsoft Naive Bayes algorithm--three-person identity division
30. "Bi thing" Microsoft neural network algorithm
32. "Bi thing" Microsoft sequential analysis and clustering algorithm
34. "Bi Thing" Microsoft time Series algorithm
36. "Bi Thing" Microsoft time Series algorithm--Verifying the magical Fibonacci sequence
38. "Bi thing" data mining algorithms--verification of accuracy

SSRS Charts and Gauges

1. "Bi thing" SSRS charts and meters--analysis of the Three Kingdoms Superior counsellors, Commander data (illustrated)
2. SSRS charts and gauges--k line chart
3. SSRS charts and gauges-Bubble chart

Three Data Analysis series
Dedicated to the vast number of the three enthusiasts, hope to like the three countries friends to discuss, deepen the legend of the three times of understanding

1. "Bi thing" Microsoft decision Tree algorithm--Find out the characteristics of the Three Kingdoms, dedicated to the broad three enthusiasts
2. "Bi thing" SSRS charts and meters--analysis of the Three Kingdoms Superior counsellors, Commander data (illustrated)
3. "Bi thing" three data analysis series--Shuhan five tigers will and Wei thrombosis will force analysis, Absolute Classic analysis
4. "Bi Thing" Microsoft cluster analysis algorithm--three-person identity division
5. "Bi thing" Microsoft Naive Bayes algorithm--three-person identity division

The bi thing-the art of Data Catalog index