Adding to Zoho Analytics’ versatility is the ability to work with all of the tables in SQL. Now, format the data in new ways to build even better, more insightful reports and dashboards.
Charts, pivot and summary tables, KPI widgets—they’re all really useful. However, once you learn how to work with data in SQL, you will take your data analysis to the next level.
In this course, you will
- analyze an existing query table and learn how it’s structured
- learn how to join tables together
- stack data vertically from different tables
- architect your own query table to build a really helpful report for a business overview
I've been exploring Zoho analytics on my own and this is the only feature of Analytics that I didn't explore yet. This course is so helpful. It made me understand the use of query. At first, I thought that the purpose and desired result of SQL would be the same when you use pivot, summary, charts, but it just making your life harder. lol. But I was wrong! Again, thank you 🙂