ArticleDirectory
What is bi?
What is the problem with querying your company database?
Support for decision making
Running bi
Microsoft Bi Stack
Solution Development Method
Getting started
Subsequent steps
Business Intelligence:
Plan your first Mic
the 32-bit and 64-bit SQLite ODBC driver.The article is provided later, so as not to repeat the same, very painful.The installation process is simple, remember to remember: To install your power BI desktop corresponding to the 32-bit or 64-bit version.If you don't know what your power BI desktop version is, open: File->help->about, such as:2.Power BI Desktop Con
Question:
Why Bi, statistics and analysis of massive data through BI solutions, compared with pure tsql statistics, can improve query and analysis performance, in addition, multidimensional analysis can help customers better understand data.
Recently, I have been asked a few similar questions, so I have summarized some of them and gradually gained an unformed accumulation, which is roughly recorded as follo
few similar questions, so I have summarized some of them and gradually gained an unformed accumulation, which is roughly recorded as follows.
Microsoft may be subject to some restrictions, so the support of many products in China is not very powerful, and there are fewer people engaged in related development. Based on my experience over the years, this article provides some reference projects for your evaluation.
According to different situations, th
Introduction to the outsetFrom Tian Shan College A student's question, how to import data from an ACCESS datasheet in SSIS.Import ACCESS database data in SSISAccess is actually a lightweight desktop database that is stored directly in the form of files. There is not much use of access as a BI data source in the country, but it is more used abroad, especially in the United States, because their IT base starts early. In my first American health insuranc
This series of articles mainly combines the actual project with their own summary and a series of project notes, involving the multidimensional analysis module in the Business Intelligence Development of Microsoft SQL server2008:
Bi project notes: Dimensional Design Based on snowflake model
Bi project notes Data Source view settings
Two days ago, ziliang (DAI ziliang) sent me a text message, today, the Microsoft Bi pioneer conference and two technical lectures on business intelligence and data mining will be held in the yongyu le conference hall of Kingsoft on the 20 th Floor of baiyan building, my former colleagues, Jin Ligang and Wang rutao, are both senior lecturers and practitioners in the field of business intelligence in China, I
Microsoft (Microsoft) In the simplest terms, business intelligence is an effort to acquire and analyze enterprise data to better understand the market and customers, improve business processes, and more effectively participate in competition. Provide the right information to the right decision makers at the right time. business intelligence enables enterprises to make better decisions at a better time than
In the original: "Bi thing" Microsoft neural network algorithmThe Microsoft Neural Network is by far the most powerful and complex algorithm. To find out how complex it is, look at the SQL Server Books Online description of the algorithm: "This algorithm establishes a classification and regression mining model by establishing a multi-layered perceptual neuron net
In the original: "Bi thing" Microsoft sequential analysis and clustering algorithmThe Microsoft Sequential Clustering algorithm is a sequential parsing algorithm provided by Microsoft SQL Server Analysis Services. You can use this algorithm to study data that contains events that can be linked by the following path or
A few months ago, the study of Microsoft Power BI technology, because there is no documents and materials, only in the English official website Blind Toss, but also published the relevant articles in English documents:, just last week to publish the article, the results of the Simplified Chinese version on the line. Haha, the heart has bitter ah, early know so fast, I will save a little time.1. Why the Simp
Introduction
This article specifically records the Syntax problems in the conversion process of XSLT style sheets.Incorrect value and attribute inversion
The style sheet has been modified several times, but an error is reported as before. The error message is as follows:
[XML task] error: An error occurred with the following error message: "attribute and namespace nodes cannot be added to the parent element after a text, comment, PI, or sub-element node has already been added. ".
Obviously, the
In the original: "Bi thing" Microsoft logistic regression algorithm--Forecast stock rise and fallData preparation:A set of stock history sold data (stock code: 601106 China One heavy), starting Date: 2011-01-04 to date, where variables are "open", "highest", "minimum", "close", "Total hand", "Amount", "ups and downs" and so onUPDATEFactstockSET [Ups and Downs] =N'Rise'WHERE [gains] > 0UPDATEFactstockS
Original: "Bi Thing" Microsoft cluster analysis algorithm--three-person identity divisionWhat is cluster analysis?Cluster analysis is an exploratory method of data analysis. In general, we use clustering to group and categorize seemingly unordered objects to better understand the object of study. Clustering results require that the similarity of objects in group is higher, and the similarity between groups
based on the model name to ensure that the test group remains the same when the model is re-processed.Maximum_input_attributes: Specifies the maximum number of input variables that the algorithm can handle. Setting this value to 0 disables the input variable.Maximum_output_attributes: Specifies the maximum number of output variables that the algorithm can handle. Setting this value to 0 disables the output variable.Maximum_states: Specifies the maximum number of variable value states supported
the relationship between two contiguous columns. For example, you can use linear regression to calculate trend lines based on production or sales data. You can also use linear regression as a basis for developing more complex data mining models to evaluate the relationships between columns of data.Although there are many ways to calculate linear regression, and these methods do not require data mining tools, the advantage of using the Microsoft linea
only say it is a suspected bug. But from this perspective, it may also be by design. Here is my personal opinion: on this question, I also mentioned it to Microsoft. I can visit SSIS 2012 readonlyvariables in script task doesn' t work to follow the final confirmation from Microsoft's technical team. For this problem, including the above two very Nb
MVPAnd the other two cool people in the post SSIS script task 'readonlyvariables 'I have dug up.
MVPArt
that are set to be predictable, the algorithm generates a separate decision tree for each predictable column.ExampleAdventure Works Cycles's marketing department wants to identify some of the characteristics of previous customers, which may indicate whether these customers will be able to purchase their products in the future. The ADVENTUREWORKS2008R2 database store describes demographic information about its previous customers. By using the Microsoft
SELECT 3 , 2 UNION All SELECT 4 , 3 UNION All SELECT 5 , 5 UNION All SELECT 6 , 8 UNION All SELECT 7 , - UNION All SELECT 8 , + UNION All SELECT 9 , the UNION All SELECT Ten , - UNION All SELECT One , the UNION All
Bu, Zhao Yun, Zhangliao, Ma Chao, Sun Ce, Sun Jian, Zhang Fei, Deng Ai, ganningSELECT TOP Ten * fromFactSanguo11WHERE [Command] + [Armed Forces] > MaxORDER by [Command] + [Armed Forces] DESC--intellectual politics Top 10: Zhuge Liang, Xunyu, Sima Yi, Cao, Zhou Yu, Lu Su, Guo Jia, brag, Zhow, Pang TongSELECT TOP Ten * fromFactSanguo11WHERE([Intelligence] + [political] > the ) and([Intelligence] >= - )ORDER by [Intelligence] + [political] DESCAnalysis Process:"
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.