mcse bi

, more convenient and more timely analysis of multi-dimensional, free drilling, dimensional analysis, without relying too much on the information sector.3, rapid integration implementation, put into operationIt is hoped that the BI visual analysis system of human resources can be successfully launched in the short term to assist the analysis decision of human resources.Sail Soft Finebi Solution:1, data integration, provide a clear view of human resour

The alert attribute in the "sequence" of a dashboard in a bi system can be manually populated with fixed values, or you can set the alert range from the data set to enable dynamic alerts. Where the "range" property is manually entered a fixed value should be a percentage (0-1), while the drop-down selection of the binding column value is numeric. The "Color" and "text" can also be taken from the dataset, and when the attribute "sequence-range-text" is

Most of the typical recommendation system for the "user-commodity" this model down to research, and then in reality there is another mode of "user-user" or "commodity-commodity" phenomenon, the former such as dating and marriage network, the latter is a job network and so on. For friends and marriage network, in addition to the husband of the woman has a good opinion, the woman also to the man's heart to match the situation can be paired with a love, the same job site to recommend me a Google CE

flow analysis, return analysis, return analysis, sales performance analysis. Through the analysis of these implementation can assist the decision-maker to find out the problems in the sales process and make corresponding timely adjustments.Throughout the manufacturing industry, can no longer "behind closed doors", the traditional way of cost control as the core needs to reform, to increase revenue as the core, user market demand-oriented, through BI

?10000 Telephone Consultation, more than 3,000 people in person to see the room, 1600 families of eager hope ... bi Guiyuan: Park Uptown on August 27, the global public recognition, about 93-144 square meters hardcover mansion, worth owning! Recognition and benefit:before September 4:20,000 to 60,000, September 4 after: 20,000 to 40,000. The House war is about to come on, join it! VIP Registration Hotline: 13432772915 September 11 "Zhang Yu" in per

?10000 Telephone Consultation, more than 3,000 people in person to see the room, 1600 families of eager hope ... bi Guiyuan: Park Uptown on August 27, the global public recognition, about 93-144 square meters hardcover mansion, worth owning! Recognition and benefit:before September 4:20,000 to 60,000, September 4 after: 20,000 to 40,000. The House war is about to come on, join it! VIP Registration Hotline: 13432772915 September 11 "Zhang Yu" in per

In the past, the dimension tables, fact tables, data analysis, BI and other concepts have some ambiguity. These days of study finally let these have some clues:A dimension represents the amount of data you want to analyze , such as when you analyze a product's sales, you can choose to analyze it by category , or by region . Such a press. The analysis forms a dimension. The previous example can have two dimensions: type and region. In addition, each d

Source: "Bi thing" data stream conversion-conditional splitPartitioning data based on conditions is a way to add complex logic to a data flow that allows you to output data to different paths based on criteria. For example, you can output totalsugar"Bi thing" data stream conversion-conditional split

In the original: "Bi thing" cube storageRelational OLAP (ROLAP)The basic data and aggregated data of ROLAP are stored in the relational database;The ROLAP storage mode enables the aggregation of the partitions to be stored in the tables of the relational database (specified in the partitioned data source). However, you can use the ROLAP storage mode for partitioned data instead of creating aggregations in the relational database.The data that uses the

A preliminary study of data mining in the "Bi Thing"What is data mining? Data Mining, also known as Information Discovery (Knowledge Discovery), is the use of automated or semi-automated methods to find potentially valuable information and rules in the data. Data mining technology originates from database, statistic and artificial intelligence. What data mining can doAnalyze the large amount of data generated in the enterprise and fi

Source: "Bi thing" data stream conversion--auditThe audit transformation allows you to add audit audit data to the data flow, and in the past when using Hippa and Sarbanes-oxley (SOX), you must keep track of who inserted the data at what time, and the audit transformation can implement this capability. For example, to track that task to insert data into the table, you can add the appropriate columns in the audit transformation. In the output Column Na

Original: "BI Project Notes" Analysis on the change of the mean value of sensory assessment in the past years the establishment of cubeAnalysis topicsMain dimensions:Tobacco leaf grade, tobacco leaf grade by grade information, tobacco leaf grade according to grading standard (standard dimension)Place of origin (parent-child dimension)Detection time (Time dimension, to Tqc_raw_smokingtest. Checktime field derived checkdate field)Dimension of sampleMain

Original: BI project note failed to decrypt protected XML node "Dts:password" workaroundDescription: Unable to decrypt the protected XML node "Dts:password", error 0x8009000b "This item is not suitable for use in a specified state. ”。 You may not have permission to access this information. This error occurs when there is a cryptographic error. Make sure that you provide the correct key.Workaround:1. In Integration Services, locate the package to execu

Source: "Bi thing" data stream transformation--perspectiveThis is the same as the pivot in T-SQL and the Unpivot function. A pivot transformation can make a data specification or makes it more readable in a report.Through the input data of the pivot column values, the perspective transformation transforms the canonical dataset into a slightly less canonical, but more concise version. For example, in an Orders dataset with a specification of customer n

Source: "Bi thing" data stream conversion--word Lookup transformationThe term Lookup transformation matches the words extracted from the text of the converted input column to the words in the reference table, and then calculates the number of occurrences of the word in the lookup table in the input dataset and writes the count to the column in the transformation output with the word in the reference table. This conversion is useful for creating a cust

Source: "Bi thing" data stream conversion--aggregationThe aggregation transformation can perform aggregation operations on the data like the function group by, Average, Minimum, Maximum, and Count in T-SQL. In the figure, you can see that the data is grouped in SampleID, and the Totalsugar does average, Maximum, Minimum, and count operations. This results in 4 columns of new data for other operations.In the Aggregation Operations Editor Aggregate Tran

In the original: BI Project notes report information Analysis cubeData Source settings:Data processing logic:--handling lost foreign key relationship dataSELECT * fromT_reportleafgradeWHEREFsubfid not inch(SELECTFID fromt_raceleafreport)DELETE fromT_reportleafgradeWHEREFsubfid not inch(SELECTFID fromt_raceleafreport)--dealing with supplier relationshipsSELECT * fromT_raceleafreportWHEREV_customer not inch(SELECTC_custcode fromt_providerinfo)--Chan

Original: BI project note creation Time dimension (2)To create a step: Serial number Selected properties Renamed name Property category 1 DateKey DateKey Conventional 2 Month Key Month Key Month 3 中文版 Month Name 中文版 Month Name One month of the year 4 Month Number of year Month Number of year Conventional

The original: "Bi thing-the art of data" understanding Dimension Data Warehouse-fact table, dimension table, aggregation tableFact tableIn a multidimensional data warehouse, a table that holds a detailed value or fact for a measure is called a fact table. A fact table that stores sales and sales by state, product, and month has 5 columns that are conceptually similar to the following example. Sate Product Mouth Units

This series is used to document the experience of using SSAS and Excel for data analysis in the work, in the Days of Goodness (SSAS Excel BI Tips), which is now intended to share small skills in the form of blogs, which is not enough to be explained as a separate course, but a lot of BA, Bu unfamiliar but very useful skills, dedicated to the needs of friends.This article is about the what-if hypothesis analysis of Excel, and the what-if writeback of