Sunday, February 28, 2021
  • Setup menu at Appearance » Menus and assign menu to Top Bar Navigation
Advertisement
  • AI Development
    • Artificial Intelligence
    • Machine Learning
    • Neural Networks
    • Learn to Code
  • Data
    • Blockchain
    • Big Data
    • Data Science
  • IT Security
    • Internet Privacy
    • Internet Security
  • Marketing
    • Digital Marketing
    • Marketing Technology
  • Technology Companies
  • Crypto News
No Result
View All Result
NikolaNews
  • AI Development
    • Artificial Intelligence
    • Machine Learning
    • Neural Networks
    • Learn to Code
  • Data
    • Blockchain
    • Big Data
    • Data Science
  • IT Security
    • Internet Privacy
    • Internet Security
  • Marketing
    • Digital Marketing
    • Marketing Technology
  • Technology Companies
  • Crypto News
No Result
View All Result
NikolaNews
No Result
View All Result
Home Data Science

Automating SQL Queries to Push Information to Business

June 12, 2020
in Data Science
Automating SQL Queries to Push Information to Business
585
SHARES
3.3k
VIEWS
Share on FacebookShare on Twitter

Most of us working in business intelligence and data science spend a lot of time creating data models, reports and beautiful dashboards. Even though the models are great and reports look fancy, the true value is in your customers actively using it. How often do you find that nobody is actually running the report?

This hurts, but it also makes sense. People get so much information during a day, they really need to be selective. So any important information should pop out of your report or dashboard. But still reports and dashboard are all based on the fact that people run it, pulling the information.

You might also like

The Education Industrial Complex: The Hammer We Have

Increasing Adoption of Informatics will Promote Growth of Data Analytics Outsourcing Market

The Ethereum Virtual Machine (EVM)

From pull to push with simple emails

One of my customers asked me to create a reports about some stuck accounting documents in their ERP system. This happened sometimes, but not very frequent. Business users would run it each morning to find if any new cases required attention. This made me think that I actually should not write any report, but instead isolate the important cases and have it scheduled to run automatically and send the results by email.

The customer was very happy with the results and we could actually run it far more often than daily, which resulted in faster fix times.

From SQL query to Excel attachment with AutoSQL

When I looked for a solution for my need to send a simple mail with an Excel attachment (you better accept it, email and Excel are the most used tools in any business environment), I actually didn’t find any easy solution. Either I had to use complex solutions requiring me to request a lot of authorizations or I had to build something myself.

This is how I created AutoSQL, a simple solution to connect to any database through ODBC and have it scheduled with Windows Task scheduler. It creates Excel or CSV output and sends the results by mail to the recipients. It is actually also possible to put the results straight in the email.

Business can sit back and relax, waiting for actions to arrive in their mail box

Business people have been extremely happy with the trigger to take action on important, rare events. It is directly actionable information and all context is provided through the Excel attachment. No more puling data and checking reports, just get triggered if action is required.


Credit: Data Science Central By: Nanne Sluis

Previous Post

Smug Millennials Tried Outsmarting Warren Buffett on Airline Stocks – And Failed

Next Post

Lion warns of beer shortages following ransomware attack

Related Posts

The Education Industrial Complex: The Hammer We Have
Data Science

The Education Industrial Complex: The Hammer We Have

February 27, 2021
Increasing Adoption of Informatics will Promote Growth of Data Analytics Outsourcing Market
Data Science

Increasing Adoption of Informatics will Promote Growth of Data Analytics Outsourcing Market

February 27, 2021
The Ethereum Virtual Machine (EVM)
Data Science

The Ethereum Virtual Machine (EVM)

February 27, 2021
Levels of Measurement (Nominal, Ordinal, Interval, Ratio) in Statistics
Data Science

Levels of Measurement (Nominal, Ordinal, Interval, Ratio) in Statistics

February 27, 2021
Give Your Business Users Simple Augmented Analytics
Data Science

Give Your Business Users Simple Augmented Analytics

February 26, 2021
Next Post
Lion warns of beer shortages following ransomware attack

Lion warns of beer shortages following ransomware attack

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recommended

Plasticity in Deep Learning: Dynamic Adaptations for AI Self-Driving Cars

Plasticity in Deep Learning: Dynamic Adaptations for AI Self-Driving Cars

January 6, 2019
Microsoft, Google Use Artificial Intelligence to Fight Hackers

Microsoft, Google Use Artificial Intelligence to Fight Hackers

January 6, 2019

Categories

  • Artificial Intelligence
  • Big Data
  • Blockchain
  • Crypto News
  • Data Science
  • Digital Marketing
  • Internet Privacy
  • Internet Security
  • Learn to Code
  • Machine Learning
  • Marketing Technology
  • Neural Networks
  • Technology Companies

Don't miss it

Why would you ever trust Amazon’s Alexa after this?
Internet Security

Why would you ever trust Amazon’s Alexa after this?

February 28, 2021
AI & ML Are Not Same. Here's Why – Analytics India Magazine
Machine Learning

AI & ML Are Not Same. Here's Why – Analytics India Magazine

February 27, 2021
Microsoft: We’ve open-sourced this tool we used to hunt for code by SolarWinds hackers
Internet Security

Microsoft: We’ve open-sourced this tool we used to hunt for code by SolarWinds hackers

February 27, 2021
Is Wattpad and its machine learning tool the future of TV? — Quartz
Machine Learning

Is Wattpad and its machine learning tool the future of TV? — Quartz

February 27, 2021
Oxford University lab with COVID-19 research links targeted by hackers
Internet Security

Oxford University lab with COVID-19 research links targeted by hackers

February 27, 2021
The Education Industrial Complex: The Hammer We Have
Data Science

The Education Industrial Complex: The Hammer We Have

February 27, 2021
NikolaNews

NikolaNews.com is an online News Portal which aims to share news about blockchain, AI, Big Data, and Data Privacy and more!

What’s New Here?

  • Why would you ever trust Amazon’s Alexa after this? February 28, 2021
  • AI & ML Are Not Same. Here's Why – Analytics India Magazine February 27, 2021
  • Microsoft: We’ve open-sourced this tool we used to hunt for code by SolarWinds hackers February 27, 2021
  • Is Wattpad and its machine learning tool the future of TV? — Quartz February 27, 2021

Subscribe to get more!

© 2019 NikolaNews.com - Global Tech Updates

No Result
View All Result
  • AI Development
    • Artificial Intelligence
    • Machine Learning
    • Neural Networks
    • Learn to Code
  • Data
    • Blockchain
    • Big Data
    • Data Science
  • IT Security
    • Internet Privacy
    • Internet Security
  • Marketing
    • Digital Marketing
    • Marketing Technology
  • Technology Companies
  • Crypto News

© 2019 NikolaNews.com - Global Tech Updates