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

jana
jana used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
AlexSenior Infrastructure Analyst

Commented:
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

Author

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.
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
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Ryan ChongSoftware Team Lead

Commented:
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

Author

Commented:
Thank you very much!

Yolanda, great link (I have help here to translate)

Author

Commented:
Do Power Query works with Excel 2010? if not, are there an option? or add-on?

Author

Commented:
No need, found it and installing now.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial