# Mastering SQL+Data analytics with Excel **URL:** \ **Category:** General Discussion\ **Tags:** database\ **Created:** [February 24, 2018, 6:14am UTC](https://forum.inductiveautomation.com/t/mastering-sql-data-analytics-with-excel/17121 "2018-02-24T06:14:46Z")\ **Posts on this page:** 6\ **Page:** 1
**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:14am UTC](https://forum.inductiveautomation.com/t/mastering-sql-data-analytics-with-excel/17121/1 "2018-02-24T06:14:46Z")
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 just copy and paste on your db workbench!!. Today many decision makers are showing a lot of interest in Business Intelligence, Machine learning and Artificial Intelligence. All these tools need data. The SCADA control room database has got a huge amount of data accumulated over a period of many years, lying unused. There’s an elephant in the control room. Time to dig deeper and make some money 😉 Let me share whatever i found interesting. You also please share your ideas, tips and tricks. Cheers. **Retrieve Data From MySQL Database Using MS Query** **Caution** : When you practice and play with these tools, don’t do it on the production database. Export the db to your test db and practice. ---
**Author:** ![gracylayla6](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/gracylayla6/32/4698_2.png) [@gracylayla6](https://forum.inductiveautomation.com/u/gracylayla6)\ **Post date:** [February 24, 2018, 6:50am UTC](https://forum.inductiveautomation.com/t/mastering-sql-data-analytics-with-excel/17121/2 "2018-02-24T06:50:23Z")
Nice Explanation On MySQL Database. Thank for sharing! ---
**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, 7:25am UTC](https://forum.inductiveautomation.com/t/mastering-sql-data-analytics-with-excel/17121/3 "2018-02-24T07:25:38Z")
To master Excel data analytics, we must familiarize ourselves with 3 tools: 1. Pivot Table (mandatory). 2. Power Query + Power Pivot 3. MS Query **1. Pivot Table quick tutorial:** **2. Pivot Table step by step:** **3. Excel 2013 PowerPivot Basics** **4. Excel 2016 Power Query + Power Pivot:** https://www.youtube.com/embed/ohGFPF12Qwc?feature=oembed&wmode=opaque&list=PLrRPvpgDmw0m3ohSvgwoHvd0KO8QsQdiK ---
**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 27, 2018, 2:54am UTC](https://forum.inductiveautomation.com/t/mastering-sql-data-analytics-with-excel/17121/4 "2018-02-27T02:54:41Z")
To design a database or to build queries, understanding ER is very important. Watch on and dig deeper 🙂 ---
**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:** [March 17, 2018, 10:39am UTC](https://forum.inductiveautomation.com/t/mastering-sql-data-analytics-with-excel/17121/5 "2018-03-17T10:39:50Z")
**SQLeo Visual Query Builder** [https://sourceforge.net/projects/sqleo/files/](https://sourceforge.net/projects/sqleo/files/) You can visually build and generate sql code for many databases. Very good. ---
**Author:** ![GeraGarcia](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/geragarcia/32/18471_2.png) [@GeraGarcia](https://forum.inductiveautomation.com/u/GeraGarcia)\ **Post date:** [March 22, 2019, 3:49pm UTC](https://forum.inductiveautomation.com/t/mastering-sql-data-analytics-with-excel/17121/6 "2019-03-22T15:49:26Z")
@R.Alamsha excellent post, congratulations for sharing these topics Regards GeraGarcia