# DB Query adjustments

**URL:** <https://forum.inductiveautomation.com/t/db-query-adjustments/17096>\
**Category:** General Discussion\
**Tags:** database\
**Created:** [February 22, 2018, 5:19pm UTC](https://forum.inductiveautomation.com/t/db-query-adjustments/17096 "2018-02-22T17:19:05Z")\
**Posts on this page:** 1\
**Showing post:** 8

<div class="post-metadata">

**Author:** ![R.Alamsha](https://avatars.discourse-cdn.com/v4/letter/r/e5b9ba/32.png) [@R.Alamsha](https://forum.inductiveautomation.com/u/R.Alamsha)\
**Post date:** [February 24, 2018, 6:30am UTC](https://forum.inductiveautomation.com/t/db-query-adjustments/17096/8 "2018-02-24T06:30:05Z")

</div>

When i tried to answer your requirement, i found many SI's (including myself) are struggling with SQL queries and reports ever since. So i decided to open up a new topic which can help all of us to share our ideas, tools, tips and tricks in one place. Thanks 🙂

> [@Mastering SQL+Data analytics with Excel](http://forum.inductiveautomation.com/t/mastering-sql-data-analytics-with-excel/17121):
>
> Few weeks back, a SAP specialist and a professional data scientist friend of mine commented: “All the BIG Data in SAP has no value without Excel. Nothing can beat Excel when it comes to data analytics”. This triggered my curiosity to dig deeper and i started playing around with Pivot Tables. I was astonished to realize, how much was i struggling all these days to build SQL queries and generate reports by ignoring this powerful tool. Yes!!. Excel can generate complex SQL queries which you can jus…

---

_[View the full topic](https://forum.inductiveautomation.com/t/db-query-adjustments/17096)._