OCA Tableau Presentation
Transcript: Office of the City Auditor August 2017 What is Tableau? TABLEAU Tableau is a Business Intelligence Tool used for data visualization. With Tableau, you can gain insights by just visualizing the stats that you already have with you and use it for your development of your department. Tableau is an interactive data visualization tools that enables you to create interactive and apt visualizations in form of dashboards, worksheets to gain business insights for the better development of your company. It allows non-technical users to easily create customized dashboards that provide insight to a broad spectrum of information. The OCA Department is gradually converting from using MS Excel to Tableau when reporting data. OCA realized the benefits and value of data visualization when making decisions or data analysis. Office of the City Auditor Office of the City Auditor PROS ADVANTAGES Main Advantages Amazing Data Vizualization Amazing data visualization https://public.tableau.com/en-us/s/gallery/amazon-rainforest?gallery=featured It has the ability to perform fairly complex data visualization in a very intuitive, drag and drop manner. Its data visualization is also impressively interactive. The user can highlight sections and drilldown into charts without extensive skills or assistance from IT. Excellent mobile support Excellent Mobile Support Tableau put a lot of effort into developing a robust mobile client. Touch-optimized controls make accessing and viewing data trouble free, and visualizations are automatically streamlined for mobile devices. Plus, the user doesn’t have to take any steps to make dashboards mobile- Tableau automatically recognizes if the user is using the mobile app and makes adjustments. Low-cost solution to implement and upgrade Low-cost solution to implement and upgrade Tableau is a relatively low-cost solution when compared to the known BI like Business Objects and Domo. Upgrades and implementations are effortless to install. Impressive integration Impressive Integration Tableau integrates with most data types and offers out of the box integration with a variety of big data platforms. Tableau integrates with R, the business intelligence statistical language many data scientists use to dive deep into BI for statistical and advanced analytics. When it comes to Excel and Tableau specifically, there are three core differences to consider: MS Excel vs Tableau MS Excel vs Tableau MS Excel Data Discovery Data Discovery Tableau - drilling into the data is less flexible - harder to explore information on a granualar level - drill-down and data blending features built in - freely explore data MS Excel Automation Functionality Automation Functionality Tableau Both Excel and Tableau can work with static and live data from multiple sources. - Automatically refreshing an Excel worksheet involves manually programming processes or creating macros that automatically update the worksheet’s data when you open the file. - Tableau is a little more intuitive with creating processes and calculations. For example, when creating calculations in a tabular format, the formula can be typed once, stored as a field and applied to all rows referencing that source. In Excel, you first manipulate the data on the cell level, and then manually create visualizations like graphs, charts, PowerPoint presentations, etc. Visualizations Visualizations MS Excel Tableau Tableau visualizes data from the start, allowing you to see the significance right away. Tableau differentiates correlations using color, size, labels and shapes, giving you context as you drill down and explore on a granular level. SEA Report Tableau Version SEA Report Copy and paste the link into a search bar https://public.tableau.com/profile/lyra.pacpaco#!/vizhome/CHAPTER1OnlineReport_0/ServiceEffortsAccomplishments2016?publish=yes Tableau Sample SEA Report Online Version WHAT'S NEXT Fiscal Year 2016 Future KEEP IN MIND KEEP IN MIND Most of the other States have changed their way of reporting. Tableau has a great influence on the efficiency on data interpretations and data visualizations. Is it time to adapt the new technology?