Seamless connection with tableau, how can this large bank with 5000 + active users realize self-service analysis?

InfoQ 2021-02-23 11:07:28
seamless connection tableau large bank


{"type":"doc","content":[{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","text":" In recent years , Data analysis related job demand is explosive growth , And most of them are high paid jobs , Let many small partners have a half way “ Become a monk ” Open the way for data analysts to learn ."}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","text":" Many years ago , As long as data analysts can use it flexibly Excel You can find a good job . later , If the analyst can operate skillfully BI visualization , If you can give your boss a beautiful report, you can become a star employee in the company . But in recent years , For data analysts, in addition to mastering basic analysis tools such as SQL、Python etc. , You have to learn data cleaning 、 modeling , There are also a series of statistical concepts and precise algorithms for data analysis , It's even more difficult …"}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","text":" Based on the above environment , The market has spawned a number of 「 Data analysis experts 」, They have professional analytical skills and technical reserves , But this kind of talent for enterprises is also “ your ” also “ Difficult to recruit ”. If the enterprise wants to achieve digital transformation , The cost pressure is self-evident ; On the other hand ,Gartner In recent years, it has been pointed out that the digital development of enterprises in the future lies in 「 Data analysis is civilian 」, "},{"type":"text","marks":[{"type":"strong"}],"text":" In other words, enterprise managers need to cultivate or empower more civilian data analysts in the front line of business , To achieve a real bottom-up strategic policy of decision-making with data ."}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"image","attrs":{"src":"https:\/\/static001.infoq.cn\/resource\/image\/6a\/fb\/6a26c51e534yy1bdf14990376299f5fb.png","alt":null,"title":null,"style":[{"key":"width","value":"75%"},{"key":"bordertype","value":"none"}],"href":null,"fromPaste":true,"pastePass":true}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":"center","origin":null},"content":[{"type":"text","text":" The development trend of enterprise data analysis "}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","text":" In recent online sharing ,Kyligence He Jingke, the product director, introduced to you the trend of popularization of data analysis , How to support the daily query and analysis of thousands of users ? "},{"type":"text","marks":[{"type":"strong"}],"text":" We take the most popular BI Tools Tableau For example , Will introduce Kyligence + Tableau Overall solution , What's more Demo Demonstrate how to make front-line business analysts just “ Pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull pull ” Can achieve PB Self help analysis under the level of data volume ! You can also click 「 Read the original 」 Free trial experience !"}]},{"type":"heading","attrs":{"align":null,"level":2},"content":[{"type":"text","text":" Data analysis is an essential element of populization "}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","marks":[{"type":"strong"}],"text":" Automation is the essential element for enterprises to realize the popularization of data analysis ."},{"type":"text","text":" It caters to Gartner stay 2019 Put forward in “Augmented Analytics” Point of view , That is, to enhance the analysis . It will be a mainstream trend of data analysis in the future, and it will reform data management in a wide range 、 machining 、 Analyze the manual work in this series of links ."}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","text":" We used to do data analysis for services , Need data warehouse experts to prepare data models . This requires experts to understand the actual needs of the current business , For example, which dimensions of data need to be combined , It's used to analyze what scenes and so on . The patterns used to synthesize these data It may be abstracted and refined to form a model ."}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","marks":[{"type":"strong"}],"text":" Is it possible to automate the above process ?"}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","text":" In fact, inside the enterprise , Every employee is using their own set of analysis experience to do the query . At the moment of business analysis, these query statements are actually used as the input of the learning system . A smart AI Enhancing database products will make good use of these “ Group intelligence ” To constantly learn the behavior of users , To find something in common , Further refine the data model ."}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"image","attrs":{"src":"https:\/\/static001.infoq.cn\/resource\/image\/98\/38\/98f20f65134611050cdabd40912b4f38.png","alt":null,"title":null,"style":[{"key":"width","value":"75%"},{"key":"bordertype","value":"none"}],"href":null,"fromPaste":true,"pastePass":true}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":"center","origin":null},"content":[{"type":"text","text":" Data management and analysis automation "}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","text":" After automatic data preparation and precomputation, the precomputed multidimensional model can be established , Then these multi-dimensional models prepared by calculation can be exposed to the front-line business personnel inside the enterprise for data analysis through the unified semantic model , The way and perspective of business analysis will become a new pattern recognition for data preparation and processing , The above forms a closed loop of analysis automation . You can also use analysts in the background 、 Engineers and data managers manage and adjust ."}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","text":" in addition , In this link, experts and business managers can also fine tune the content of machine learning , So as to extract the semantic logic in line with the business and data model with usability and intelligence . Through such a set of highly automated data services , It can effectively replace the manual data management work similar to the manual workshop mentioned above ."}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","text":" Next, I will introduce you as a representative of big data circle intelligent analysis engine Kyligence, combination BI The circle is hot Tableau For example , Analyze how to build a high-performance system under the big data architecture 、 Self service analysis platform with high concurrency ."}]},{"type":"heading","attrs":{"align":null,"level":2},"content":[{"type":"text","text":"Kyligence + Tableau Overall solution "}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","text":" In terms of the underlying architecture ,Kyligence As a unified AI Enhanced data management and analysis platform , It can be directly deployed locally or in the cloud ."}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"image","attrs":{"src":"https:\/\/static001.infoq.cn\/resource\/image\/03\/fb\/03114df11920720d3d928d3fd55c50fb.png","alt":null,"title":null,"style":[{"key":"width","value":"75%"},{"key":"bordertype","value":"none"}],"href":null,"fromPaste":true,"pastePass":true}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":"center","origin":null},"content":[{"type":"text","text":"Kyligence + Tableau Scheme Architecture "}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","text":" It can dock with relational data or Hadoop data source , Such as Hive etc. , Shield the underlying data source differences , stay Kyligence End to end unified modeling , Define the dimension index . Go up through ODBC Driver Connect to Tableau Desktop or Tableau Server.Kyligence It also provides other common interface docking PowerBI, Velvety ,SmartBI etc. BI Product data analysis ."}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","text":"Kyligence + Tableau The main advantages are as follows :"}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"bulletedlist","content":[{"type":"listitem","attrs":{"listStyle":null},"content":[{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","marks":[{"type":"strong"}],"text":" Architecture can be expanded , The query response is fast ."},{"type":"text","text":" Use Tableau Live This method can process trillions of lines of data , The direct query is kept within seconds , Support high concurrency while maintaining high performance ."}]}]},{"type":"listitem","attrs":{"listStyle":null},"content":[{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","marks":[{"type":"strong"}],"text":" Unified semantic layer ."},{"type":"text","text":" One click synchronization Kyligence Model semantic definition to Tableau, No need to duplicate modeling ."}]}]},{"type":"listitem","attrs":{"listStyle":null},"content":[{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","marks":[{"type":"strong"}],"text":" Self help analysis ."},{"type":"text","text":" stay Kyligence Supported by multidimensional model and precomputing technology , Give full play to Tableau flexible 、 Self help features , Satisfy BI Civilian self-help analysis needs ."}]}]},{"type":"listitem","attrs":{"listStyle":null},"content":[{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","marks":[{"type":"strong"}],"text":"AI Automatic modeling ."},{"type":"text","text":" Kyligence Automatic modeling technology can be used to quickly design and build data models , Improve data development efficiency , Reduce data analysis cycle ."}]}]}]},{"type":"heading","attrs":{"align":null,"level":2},"content":[{"type":"text","text":"Kyligence + Tableau Development mode "}]},{"type":"heading","attrs":{"align":null,"level":3},"content":[{"type":"text","text":" Development mode : Reduce repetitive labor , Improve efficiency "}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","text":" The best practice of development mode is also the concern of many enterprises , How to carry out the coordination of various functional roles in the enterprise ? We combine the use scenarios of existing customers , A set of development mode is extracted for your reference ."}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","text":" First, four types of characters are abstracted : Developer 、 The modeler 、 analysts 、 Business people . These four types of roles must be strictly corresponding to four people , Maybe a developer in some enterprises is responsible for preparing data 、 modeling 、 The whole set of analysis , To meet the needs of business people , It can be flexibly arranged according to the actual situation of the enterprise ."}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"bulletedlist","content":[{"type":"listitem","attrs":{"listStyle":null},"content":[{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","marks":[{"type":"strong"}],"text":" Developer —— Prepare the data ."},{"type":"text","text":" Based on business needs ,IT The department establishes the data of each subject field in the business market of the platform , Synchronize data from business data warehouse to Hadoop Build clusters ( Off line analysis platform ) in ."}]}]},{"type":"listitem","attrs":{"listStyle":null},"content":[{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","marks":[{"type":"strong"}],"text":" The modeler —— Model development and release ."},{"type":"text","text":" stay Kyligence Enterprise Design a business theme based model in , The created model contains various standard analysis indicators and dimensions that may be used in this topic , At the same time, create a scheduled build task for the current model on the scheduling management platform , It is used to update the data in the model regularly . Then you can build on the model you've created , export Tableau TDS file , And posted to Tableau Server."}]}]},{"type":"listitem","attrs":{"listStyle":null},"content":[{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","marks":[{"type":"strong"}],"text":" The analyst —— Self help analysis ."},{"type":"text","text":" Can be based on Tableau Server The published TDS data source , stay Tableau Server Web End or Tableau Desktop Do self-help multidimensional analysis , Report making , In addition, according to the analysis of the scene , Second definition index 、 Hierarchy, etc ."}]}]},{"type":"listitem","attrs":{"listStyle":null},"content":[{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","marks":[{"type":"strong"}],"text":" Business people —— Direct access to analysis reports "},{"type":"text","text":" Or it can be based on Tableau Server To do data analysis "}]}]}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"image","attrs":{"src":"https:\/\/static001.infoq.cn\/resource\/image\/ca\/1d\/ca6895270f451b89b765c3fe6ce5191d.png","alt":null,"title":null,"style":[{"key":"width","value":"75%"},{"key":"bordertype","value":"none"}],"href":null,"fromPaste":true,"pastePass":true}},{"type":"heading","attrs":{"align":null,"level":3},"content":[{"type":"text","text":" Permission Integration : Strictly control data security , data “ Each has its own use ”"}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","text":" Considering the privacy and security of enterprise data ,Kyligence Provide project level \/ Table level \/ Row and column level fine-grained data access control . Provide different data views for different users ."}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"bulletedlist","content":[{"type":"listitem","attrs":{"listStyle":null},"content":[{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","marks":[{"type":"strong"}],"text":" Unified authority management system ."},{"type":"text","text":" Use Kyligence Unified access control , Line level control , Provide fine-grained access control for users , To meet the diverse data management and control needs of enterprises to the maximum extent ."}]}]},{"type":"listitem","attrs":{"listStyle":null},"content":[{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","marks":[{"type":"strong"}],"text":" More convenient connection experience ."},{"type":"text","text":" Kyligence Connector To provide a smoother Tableau Connect to experience , Save extra connection configuration ."}]}]},{"type":"listitem","attrs":{"listStyle":null},"content":[{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","text":" User permissions are transmitted through the Internet . Report producers can use high authority accounts to develop and publish reports , When browsing the report, the browser will switch the corresponding permissions to restrict the access to the data ."}]}]},{"type":"listitem","attrs":{"listStyle":null},"content":[{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","marks":[{"type":"strong"}],"text":" Check the report without password ."},{"type":"text","text":" Tableau The user is in Server When you view a report on the client side , No need to re-enter the login user and password of the data source , Reduce the cost of administrator operation and maintenance , Enhance the user experience ."}]}]}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"image","attrs":{"src":"https:\/\/static001.infoq.cn\/resource\/image\/ef\/78\/ef0afdc6396146fee350bde692458a78.png","alt":null,"title":null,"style":[{"key":"width","value":"75%"},{"key":"bordertype","value":"none"}],"href":null,"fromPaste":true,"pastePass":true}},{"type":"heading","attrs":{"align":null,"level":2},"content":[{"type":"text","text":" Case study : Self service analysis experience of large banks "}]},{"type":"heading","attrs":{"align":null,"level":3},"content":[{"type":"text","text":" Background introduction "}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","text":" This is a large joint-stock bank , The organization needs to conduct analysis and index statistics from multiple dimensions based on card transaction flow , The main dimensions and indicators include date (( year , month , Japan , Zhou , God )、 Card properties , brand , region , Institutions , Number of transactions , Transaction amount, etc ."}]},{"type":"heading","attrs":{"align":null,"level":3},"content":[{"type":"text","text":" The pain points facing the business "}]},{"type":"bulletedlist","content":[{"type":"listitem","attrs":{"listStyle":null},"content":[{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","text":" Business analysis needs are not quickly responded to , Rely heavily on IT Team development , Once the demand has been adjusted, it needs to enter “ Super long waiting period ”."}]}]},{"type":"listitem","attrs":{"listStyle":null},"content":[{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","text":" Poor data quality , There is a big deviation in the analysis results . Because the background data caliber is different , The business use threshold is high ."}]}]},{"type":"listitem","attrs":{"listStyle":null},"content":[{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","text":" Poor scalability , Many high-value analysis reports cannot be fully shared , The release cycle of thematic analysis is long ."}]}]}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","text":" In the past, due to the limitation of the data warehouse used , The bank needs to establish a separate data model for the data of different business entities , adopt SQL Data retrieval provides data for business analysis , High development cost , Long lead time ."}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","text":" Through the new program , The bank can pass Kyligence Building a unified data model , By exporting TDS The ability to synchronize data models to Tableau Implement a model to analyze the effect of many analysis reports ."}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"image","attrs":{"src":"https:\/\/static001.infoq.cn\/resource\/image\/d3\/d4\/d322c4fe1235988e14b989fa5ac901d4.png","alt":null,"title":null,"style":[{"key":"width","value":"75%"},{"key":"bordertype","value":"none"}],"href":null,"fromPaste":true,"pastePass":true}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","text":" On the other hand , Within the enterprise , Due to the different definitions of data indicators in different departments, the problem of unreliable data also occurs from time to time . Now you can go through Kyligence The first mock exam , The bank has unified the caliber and indicators of business analysis ."}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"image","attrs":{"src":"https:\/\/static001.infoq.cn\/resource\/image\/80\/4a\/80b8bd30b6578bdf41ecd06bd011e94a.png","alt":null,"title":null,"style":[{"key":"width","value":"75%"},{"key":"bordertype","value":"none"}],"href":null,"fromPaste":true,"pastePass":true}},{"type":"heading","attrs":{"align":null,"level":3},"content":[{"type":"text","text":" Use Kyligence After the query effect "}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","marks":[{"type":"strong"}],"text":" As can be seen from the figure below, the bank currently has 5000+ Active users , The total number of queries per month is 100 + ten thousand ,90% The above query < 1 second . Through seamless docking Tableau, It really enables self-service analysis of business ."}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"image","attrs":{"src":"https:\/\/static001.infoq.cn\/resource\/image\/37\/5c\/37926ec7875ec0435d61e06f67c53a5c.png","alt":null,"title":null,"style":[{"key":"width","value":"75%"},{"key":"bordertype","value":"none"}],"href":null,"fromPaste":true,"pastePass":true}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","text":" That's the whole set of Kyligence + Tableau The solution of self-help analysis , If you are interested, click 「 Read the original 」 Free trial !"}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","text":" You can also click on the video below to watch how analysts base on Kyligence Intelligent data analysis platform in Tableau Data analysis on the Internet ~"}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"link","attrs":{"href":"http:\/\/mpvideo.qpic.cn\/0bf2myaagaaal4aaywy2pvqfazwdantaaaya.f10002.mp4?dis_k=33ad9294667c0fa7472cf279d53b454e&dis_t=1613702633&spec_id=MzIyNTIyNTYwOA%3D%3D1613702636&vid=wxv_1723494861149880322&format_id=10002","title":"","type":null},"content":[{"type":"text","marks":[{"type":"strong"}],"text":" Full video "}]}]},{"type":"heading","attrs":{"align":null,"level":2},"content":[{"type":"text","text":" The scene Q&A"}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","marks":[{"type":"strong"}],"text":"Q"},{"type":"text","text":": The dispatching management platform includes kylin and hive The node of , yes kylin Do you provide ?"}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","marks":[{"type":"strong"}],"text":"A"},{"type":"text","text":": The dispatching management platform needs customers to develop or use the third-party tools ,Kyligence Will provide their own data development process API, Provide scheduling management platform for development scheduling ."}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","marks":[{"type":"strong"}],"text":"Q"},{"type":"text","text":": Tableau adopt ODBC How to configure access Kyligence? Do you have a configuration document ?"}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","marks":[{"type":"strong"}],"text":"A"},{"type":"text","text":": Please refer to our user manual for details Tableau chapter :https:\/\/docs.kyligence.io\/books\/v4.2\/zh-cn\/integration\/bi\/tableau\/tableau_desktop.cn.html"}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","marks":[{"type":"strong"}],"text":"Q"},{"type":"text","text":": In addition to publishing to Tableau, Can I publish to other report environments , such as PowerBI?"}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","marks":[{"type":"strong"}],"text":"A"},{"type":"text","text":": At present, the function of one click synchronization data model is temporarily supported Tableau, docking PowerBI Need to be PowerBI According to the Kyligence Manual definition of data model ."}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","marks":[{"type":"strong"}],"text":"Q"},{"type":"text","text":": Can I connect to Azure Abreast of the times Data Lake Storage Gen2? And read Hadoop Documents such as Parquet?"}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","marks":[{"type":"strong"}],"text":"A"},{"type":"text","text":": Kyligence The cloud version supports Azure Data Lake Storage Gen2 As a data source . On the cloud, if you need to read Hadoop Documents such as Parquet, You can put Parquet Put it in the object store , Using object storage as data source to support . If it is a local deployment, it needs to go through Hive To manage the data file corresponding to Schema."}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","marks":[{"type":"strong"}],"text":"Q"},{"type":"text","text":": Calculating metrics , except default Of function, Whether you can define your own measurement logic ? such as YTD\/QTD,Growth Rate these ?"}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","marks":[{"type":"strong"}],"text":"A"},{"type":"text","text":": If it's docking Tableau Under the circumstances , Can be in Tableau To achieve... By defining computational metrics in YTD\/QTD,Growth Rate And so on , stay Kyligence Defining the underlying metrics behind these dynamic calculations , For example, how to calculate sales YTD\/QTD Can be found in kylignece Define the underlying metrics in sum(sales) stay Tableau Sales are defined in YTD\/QTD,Growth Rate Calculation ."}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","marks":[{"type":"strong"}],"text":"Q"},{"type":"text","text":": data source We can support NoSQL Do you , for example Azure Cosmos DB And so on. . In addition, when data source When data is updated ,Kyligence Cub e It needs to be like the others OLAP Cube Go to process table\/database Come on reflect The latest data ?"}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","marks":[{"type":"strong"}],"text":"A"},{"type":"text","text":": stay Azure I don't support NoSQL data source ."}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","text":" stay Cube The refresh mode is flexible , Refresh individual time intervals , You can also refresh the full amount of data , The specific refresh method needs to be selected according to the customer's usage scenarios ."}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","marks":[{"type":"strong"}],"text":"Q"},{"type":"text","text":": How authority and Server The login account is associated with ?"}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","marks":[{"type":"strong"}],"text":"A"},{"type":"text","text":": In short Tableau In the query Kyligence Will send the current login user information to Kyligence, Kyligence The user's information will be used for authentication and query , Please refer to the user manual for details :"}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","text":"https:\/\/docs.kyligence.io\/books\/v4.2\/zh-cn\/integration\/bi\/tableau\/user_delegation_with_tableau_server.cn.html"}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","marks":[{"type":"strong"}],"text":"Q"},{"type":"text","text":": Will the report is real-time connection to the data source to read ? Do you support data extraction ?"}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","marks":[{"type":"strong"}],"text":"A"},{"type":"text","text":": Tableau Real time and data extraction can support ."}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","marks":[{"type":"strong"}],"text":"Q"},{"type":"text","text":": Excuse me, sail soft also passes through connector Are components connected ?"}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","marks":[{"type":"strong"}],"text":"A"},{"type":"text","text":": Soft sails don't need connector Components , In the latest FineBI 5.1.9 Built in support for Kyligence data source ."}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","marks":[{"type":"strong"}],"text":" This article is reproduced from the official account. Kyligence(ID:Kyligence)."}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"text","marks":[{"type":"strong"}],"text":" Link to the original text "},{"type":"text","text":":"}]},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null}},{"type":"paragraph","attrs":{"indent":0,"number":0,"align":null,"origin":null},"content":[{"type":"link","attrs":{"href":"https:\/\/mp.weixin.qq.com\/s?__biz=MzIyNTIyNTYwOA==&mid=2651011036&idx=1&sn=03211353659ecfe2fe6efbb4d902bc7a&chksm=f3f5693bc482e02dfa58569445ec71fb3124f98ee41c4b09381e7dfa0f5183769797f77a2969&scene=0&xtrack=1&version=3.0.36.2330&platform=mac#rd","title":"","type":null},"content":[{"type":"text","text":" Seamless docking Tableau, This month's active users 5000+ How to realize self-service analysis for large banks in China ?"}]}]}]}
版权声明
本文为[InfoQ]所创,转载请带上原文链接,感谢
https://qdmana.com/2021/02/20210223110510689D.html

  1. JS mechanism 3: stack, heap, garbage collection
  2. [grid compression evaluation] meshquan, meshopt, Draco
  3. Deep understanding of Vue modifier sync [Vue sync modifier example]
  4. WebView for front end engineers
  5. React form source code reading notes
  6. Deep thinking about modern package manager -- why do I recommend pnpm instead of NPM / yarn?
  7. On the sequence of event capture and event bubbling
  8. Help you build a systematic understanding of the front end scaffolding
  9. commander.js Principle analysis
  10. Common usage of nginx
  11. H5 jump to wechat app
  12. Front end algorithm interview must brush questions series [14]
  13. Thinking of cross end practice
  14. Vue server rendering principle analysis and introduction
  15. [KT] vscode plug in development example series (2)
  16. Design ideas of react and Vue framework
  17. JavaScript String.prototype.replaceAll 兼容性导致的问题
  18. JavaScript String.prototype.replaceAll Problems caused by compatibility
  19. 爱奇艺体育:体验Serverless极致扩缩容,资源利用率提升40%
  20. Iqiyi Sports: experience the ultimate expansion and contraction of serverless, and increase the utilization rate of resources by 40%
  21. 对前端异常window error捕获的全面总结
  22. A comprehensive summary of front end exception window error capture
  23. 成功解决Problem while trying to mount target]\“. HTTP response code is 400
  24. Problem while trying to mount target] \ ". HTTP response code is 400
  25. 放弃okhttp、httpClient,选择了这个牛逼的神仙工具!贼爽
  26. 前端面试每日 3+1 —— 第679天
  27. How to add elements at the beginning of an array in JS?
  28. Give up okhttp and httpclient and choose this awesome immortal tool! Thief Shuang
  29. Front end interview daily 3 + 1 - day 679
  30. 【2021 第一期】日常开发 26 个常见的 JavaScript 代码优化方案
  31. Daily development of 26 common JavaScript code optimization schemes
  32. 前端的字符串时间如何自动转换为后端Java的Date属性,介绍springMVC中如何解决时间转换问题
  33. How to automatically convert the front-end string time to the back-end Java date attribute, and how to solve the time conversion problem in spring MVC are introduced
  34. 前端面试常考题:JS垃圾回收机制
  35. ReactDOM.render串联渲染链路(一)
  36. 更简洁、更快速!腾讯云 Serverless 云函数创建流程再次升级!
  37. 粗涉Webpack
  38. Frequently asked questions in front end interview: JS garbage collection mechanism
  39. ReactDOM.render Serial rendering link (1)
  40. More concise and faster! Tencent cloud serverless cloud function creation process upgrade again!
  41. 更简洁、更快速!腾讯云 Serverless 云函数创建流程再次升级!
  42. About webpack
  43. More concise and faster! Tencent cloud serverless cloud function creation process upgrade again!
  44. 详解vue静态资源打包中的坑与解决方案
  45. 一篇搞懂TCP、HTTP、Socket、Socket连接池
  46. 字节跳动2021前端技术岗发布+最新内部面试题
  47. Detailed explanation of Vue static resource packaging and Solutions
  48. Understanding TCP, HTTP, socket, socket connection pool
  49. 2008-2021 front end technical post release + latest internal interview questions
  50. 4. Vue基本指令
  51. 4. Vue basic instruction
  52. Java 发起 http 请求
  53. Java initiates HTTP request
  54. 网站由http升级为https图文教程
  55. Upgrade the website from HTTP to HTTPS
  56. 更简洁、更快速!腾讯云 Serverless 云函数创建流程再次升级!
  57. More concise and faster! Tencent cloud serverless cloud function creation process upgrade again!
  58. 混合开发入门 Vue结合Android/iOS开发仿京东项目App
  59. Hybrid development entry Vue combined with Android / IOS to develop app imitating Jingdong project
  60. 无缝对接 Tableau,这家月活跃用户 5000+ 的大型银行如何实现自助式分析?