Question

You work for a manufacturing company, you are constantly being tasked with creating reports out of the SQL database, it consumes a good portion of your day setting up and generating these reports. What would be a good solution as a database administrator in solving this problem?

Answer 1

--> You work for a manufacturing company, you are constantly being tasked with creating reports out of

      the SQL database, it consumes a good portion of your day setting up and generating these reports.

--> If it is taking so much time, which is a repetitive task If we can automate it using some method

     We can simply run that program which will generate the reports automatically and we can do some

     useful work instead.

--> One such method is you can use python for that.

--> Since you will be getting the data of the same format.

---> Write a python script by using 'sql' and 'matplotlib' packages which are used to read the sql data

       and generate some very good reports.

--> you can also use 'seaborn' package.

--> So, daily you have to just give that database to that script, which will generate those reports

      automatically.