Prerequisites:-
1.Apache drill should be installed in distributed mode, if not first set-up Apache drill in distributed mode.
2.Install Tableau 9 desktop version - Desktop version is not free,download trial version and install it.
3.Apache ZooKeeper set-up, if not existing refer ZooKeeper installation
Set-up Apache Drill with Tableau 9 Desktop
1. Download ODBC driver(provided by MapR) - Tableau 9.0 Desktop 64 bit can use either the 32-bit driver or the 64-bit driver. Download 32 bit driver installer2. Install downloaded driver(keep default settings) and after installation verify the installation. Refer this for the same. Installing the ODBC Administrator installs Drill Explorer and the Tableau TDC file.
3. Configure ODBC driver - here we have to create a Data Source Name using ODBC Administrator app. Go to start-> find 32-bit ODBC Administrator. Refer this for more detail.
Click System DSN tab in ODBC Administrator window and click on configure. Update fields : Direct to Drillbit and port (IP address of my machine where Apache drill instance is running) and port number 31010 is default port used.Click on test and check for connectivity with Apache drill.
 |
| ODBC configuration for Apache Drill connection |
4. Now connect Tableau to Drill via ODBC- Start tableau and create new data source of type(Other oracle ODBC).Click More servers -> Other oracle ODBC and select DSN as "MapR ODBC Driver for Drill DSN", update port number as 31010(default port unless modified).
1. SELECT * FROM `dfs`.`default`.`./home/zytham/data/employee.json`
2. SELECT * FROM `dfs`.`default`.`./home/zytham/data/department.json`
These employee.json and department.json sample shipped with Apache drill, download it from here.
 |
| Click New custom SQL and execute both query mentioned above one after another. |
7. Click on Sheet 1(bottom left). right click on marital status and gender field from EMP_SQL_QUERY(Dimension section) and do "Add to sheet". Similarly, right click on salary from EMP_SQL_QUERY(Measures section) and do "Add to sheet". It will generate a bar graph automatically based on gender and marital status with total salary. Change total salary to average salary - Right click on Sum(salary) -> Measure -> Average.
References :-
https://drill.apache.org/docs/using-apache-drill-with-tableau-9-desktop/
I must appreciate you for providing such valuable content for us. career option in business analytics have skyrocketed in recent years. Most companies are looking for freshers in this sector with less than five years of experience. So, Join Now.
ReplyDeleteThe step-by-step process of configuring a DSN, connecting Tableau to Drill, selecting the appropriate schema, and executing custom SQL queries provides a useful example of integrating business intelligence tools with big data technologies. Working with JSON files such as employee and department data also demonstrates how data can be prepared for analysis and visualization through Data Visualization Course.
DeleteThe joining of employee and department datasets based on department_id is an important part of the workflow because it enables information from separate sources to be analyzed together. The subsequent use of gender, marital status, educational level, and salary fields demonstrates how interactive charts can be created to examine different aspects of the data. Similar visualization concepts can also be practiced using Matplotlib Course.
DeleteThe final examples show how Tableau can quickly transform connected data into bar charts and comparative visualizations, including changing salary aggregation from total to average. This illustrates the value of combining data integration with interactive visualization when exploring business information. Such integration and analytical workflows can also provide useful inspiration for Data Science Projects for Final Year involving data processing and visualization.
DeleteĐặt vé máy bay tại Aivivu, tham khảo
ReplyDeletevé máy bay đi Mỹ bao nhiêu
lịch bay từ mỹ về việt nam hôm nay
bay từ nhật về việt nam
chuyến bay từ đức về hà nội hôm nay
vé máy bay từ canada về việt nam
vé máy bay từ hàn quốc về việt nam
khách sạn cách ly ở đà nẵng
this is a topic which might help me in my assignment work as the student of C.S i want to read such kind of blogs related to my field and this is an basic computer knowledge topic on which you written great. but whenever i didn't have so much time to complete my work i mostly go to do my assignment cheap service as they are very expert in this field.
ReplyDeleteReading through this content was easy because everything is explained clearly. I had fun playing Slope Game Unblocked. The endless challenges, quick reactions, and responsive controls make it a great game for anyone who enjoys fast arcade action.
ReplyDelete