Automated dashboards have transformed daily trend analysis and now drive faster business decisionsOne of the best features that Looker offers is LookML, which allows us to develop dashboards directly rather than dragging and dropping. We can also customize some fields that are not available in the table by combining different tables using LookML. Compared to other reporting tools, Looker is somewhat more customizable and interactive. With the help of Views and Explore in Looker, we can combine different tables and create a unique column that is not available in the table, and then use that column in our reporting dashboard. Since we brought Looker into our project, it has improved data visibility and enabled faster interaction between us and our client. Rather than simply using free form or Essbase, seeing customizable and visualized data in Looker allows the business users to understand the trends in the data more easily rather than just seeing numbers. It has helped us save a lot of time. The automated dashboards that we develop allow us to run the dashboard for the coming years with only some modifications, which has reduced some manpower and working hours. When I joined this project, there were around eight to nine people for developing Looker dashboards. Once the development part is completed for almost all cases, the next part is just monitoring the dashboards and making some minor changes required to align with business goals. After development, the team was reduced to three or four people, so the manpower has significantly reduced, and time taken has decreased as well. For a business user to understand data from free form or Essbase, it usually takes thirty minutes to an hour to go through the previous day's trend. However, with the visualization tools in Looker, they can easily understand the data and compare it to the previous one or two years using a bar graph, pie chart, or other graphs. The return on investment has been very good. The number of employees has reduced to half, and time is saved by nearly two to three hours a day because of automated reports. We are just monitoring the reports to ensure they are released. This has saved nearly two hours per day, and the team has been reduced to half.
