What is Data Analytics and what tools or software can I use to work with this

Hello in a conversation the subject of data analytics arose, companies worldwide are spending more on data analytics.   Can some expert give me example of what is data analytics and possible tools or apps that can be used?
LVL 1
janaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

AlexProject Systems EngineerCommented:
Short of having a source of data, I.E a search engine or social  media, you'd have to buy your data which has been harvested from another company. Facebook for example... lol!!!

Regards

Alex
janaAuthor Commented:
I thought it was more toward intelligence apps that would analyze your MSSQL databases in order to get detailed reports.  Prior the question I googled the term and it was confusing.  Some said it was a company like you say, other say it was apps that can installed in their database, thus for, transform said DB to fast business data access via Excel or other apps.
►Yolanda Cuesta Excel Contabilidad TICECONOMISTACommented:
Data analytics is used to process of inspecting, cleaning and transforming data with the objective of highlighting useful information, suggesting conclusions, and supporting decision-making. Data analysis has multiple facets and approaches, encompassing various techniques in a variety of names, in different businesses, science, and the domains of the social sciences. The data is collected and analyzed to ask questions, test guesses or prove the invalidity of theories. (Wikipedia)
You can use Excel tools as Power Query, Pivot, View for do it.
Also Power BI Desktop can be used to data analytics and make dashboards.
I have a post in my blog (spanish but you can use a translator) about these tools: https://excelcontabilidadytic.com/complementos-power-excel-2016/
Regards,
Yolanda Cuesta

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

Ryan ChongSoftware Team LeadCommented:
Data analytics is all about the art of manipulating data to have deep observations on what already happened, what will happen, and what you should do. By using various advanced tools with the application of business intelligence or artificial intelligence, or purely human defined rules, we try to find the answers and then make the decisions
janaAuthor Commented:
Thank you very much!

Yolanda, great link (I have help here to translate)
janaAuthor Commented:
Do Power Query works with Excel 2010? if not, are there an option? or add-on?
janaAuthor Commented:
No need, found it and installing now.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Business Management

From novice to tech pro — start learning today.