请选择 进入手机版 | 继续访问电脑版
楼主: lzguo568
1277 1

[数据挖掘理论与案例] Top 10 Data Analysis Tools for Business [推广有奖]

学术权威

56%

还不是VIP/贵宾

-

TA的文库  其他...

统计入门

威望
3
论坛币
10070 个
通用积分
10690.0593
学术水平
2275 点
热心指数
2224 点
信用等级
1485 点
经验
248 点
帖子
5906
精华
14
在线时间
3540 小时
注册时间
2010-8-31
最后登录
2024-1-20

初级学术勋章 初级热心勋章 中级热心勋章 中级学术勋章 初级信用勋章 中级信用勋章 高级学术勋章 高级热心勋章 特级热心勋章 特级学术勋章 高级信用勋章

lzguo568 在职认证  发表于 2016-7-18 08:50:22 |显示全部楼层 |坛友微信交流群

+2 论坛币
k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群
赵安豆老师微信:zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

感谢您参与论坛问题回答

经管之家送您两个论坛币!

+2 论坛币
Top 10 Data Analysis Tools for Business Previous post

Next post


[url=]
[/url]

189

        Tweet


Tags: Data Analysis, Knime, RapidMiner, Tableau, Top 10, Wolfram



Ten free, easy-to-use, and powerful tools to help you analyze and visualize data, analyze social networks, do optimization, search more efficiently, and solve your data analysis problems.

comments

By Alex Jones, June 2014.

As a graduate student in Business Analytics, I have worked the better part of a year to become a giant nerd, excel wizard, big data ninja, data scientist, predictive analytics architect. While the skills I have developed have been invaluable, taking a year of computer science, advanced mathematics, engineering and business classes, is simply not feasible for most people.

Although the challenge of collecting and analyzing "Big Data" requires some complex and technical solutions, the fact is, that most businesses do not realize what they are currently capable of.

Specifically, there are a number of exceptionally powerful analytical tools that are free and open source that you can leverage today to enhance your business and develop skills that can genuinely propel your career.

Rather than just leave you to navigate the frightening and giant world of IT tools and software, I have put together a list of what I see as the Top 10 Data analysis tools for Business. I picked these because of their free availability(for personal use), ease of use (no coding and intuitively designed),powerful capabilities (beyond basic excel), and well-documented resources (if you get stuck, you can Google your way through).

  • Tableau Public: Tableau democratizes visualization in an elegantly simple and intuitive tool. It is exceptionally powerful in business because it communicates insights through data visualization. Although great alternatives exist, Tableau Public's million row limit provides a great playground for personal use and the free trial is more than long enough to get you hooked. In the analytics process, Tableau's visuals allow you to quickly investigate a hypothesis, sanity check your gut, and just go explore the data before embarking on a treacherous statistical journey.
  • OpenRefine: Formerly GoogleRefine, OpenRefine is a data cleaning software that allows you to get everything ready for analysis. What do I mean by that? Well, let's look at an example. Recently, I was cleaning up a database that included chemical names and noticed that rows had different spellings, capitalization, spaces, etc that made it very difficult for a computer to process. Fortunately, OpenRefine contains a number of clustering algorithms (groups together similar entries) and makes quick work of an otherwise messy problem.
    **Tip- Increase Java Heap Space to run large files (Google the tip for exact instructions!)
  • KNIME: KNIME allows you to manipulate, analyze, and modeling data in an incredibly intuitive way through visual programming. Essentially, rather than writing blocks of code, you drop nodes onto a canvas and drag connection points between activities. More importantly, KNIME can be extended to run R, python, text mining, chemistry data, etc, which gives you the option to dabble in the more advanced code driven analysis.
    **TIP- Use "File Reader" instead of CSV reader for CSV files. Strange quirk of the software.
  • RapidMiner: Much like KNIME, RapidMiner operates through visual programming and is capable of manipulating, analyzing and modeling data. Most recently, RapidMiner won KDnuggets software poll, demonstrating that data science does not need to be a counter-intuitive coding endeavor.
  • Google Fusion Tables: Meet Google Spreadsheets cooler, larger, and much nerdier cousin. Google Fusion tables is an incredible tool for data analysis, large data-set visualization, and mapping. Not surprisingly, Google's incredible mapping software plays a big role in pushing this tool onto the list. Take for instance this map, which I made to look at oil production platforms in the Gulf of Mexico. With just a quick upload, Google Fusion tables recognized the latitude and longitude data and got to work.
  • NodeXL: NodeXL is a visualization and analysis software of networks and relationships. Think of the giant friendship maps you see that represent linkedin or Facebook connections. NodeXL takes that a step further by providing exact calculations. If you're looking for something a little less advanced, check out the node graph on Google Fusion Tables, or for a little more visualization try out Gephi.
  • Import.io: Web scraping and pulling information off of websites used to be something reserved for the nerds. Now with Import.io, everyone can harvest data from websites and forums. Simply highlight what you want and in a matter of minutes Import.io walks you through and "learns" what you are looking for. From there, Import.io will dig, scrape, and pull data for you to analyze or export.
  • Google Search Operators: Google is an undeniably powerful resource and search operators just take it a step up. Operators essentially allow you to quickly filter Google results to get to the most useful and relevant information. For instance, say you're looking for a Data science report published this year from ABC Consulting. If we presume that the report will be in PDF we can search
    "Date Science Report" site:ABCConsulting.com Filetype:PDF

    then underneath the search bar, use the "Search Tools" to limit the results to the past year. The operators can be even more useful for discovering new information or market research.
  • Solver: Solver is an optimization and linear programming tool in excel that allows you to set constraints (Don't spend more than this many dollars, be completed in that many days, etc). Although advanced optimization may be better suited for another program (such as R's optim package), Solver will make quick work of a wide range of problems.
  • WolframAlpha: Wolfram Alpha's search engine is one of the web's hidden gems and helps to power Apple's Siri. Beyond snarky remarks, Wolfram Alpha is the nerdy Google, provides detailed responses to technical searches and makes quick work of calculus homework. For business users, it presents information charts and graphs, and is excellent for high level pricing history, commodity information, and topic overviews.
One of my favorite data related quotes is:

Data matures like wine, applications like fish

---James Governor, Founder of Redmonk.

Although these tools make analysis easier, they're only as valuable as the information put in and analysis that you conduct. So take a moment to learn a few new tricks, challenge yourself, and let these tools enhance and complement the logic and reasoning skills that you already have.


Alex Jones is a Graduate Student at U. Texas McCombs School of Business.

Related:


二维码

扫码加我 拉你入群

请注明:姓名-公司-职位

以便审核进群资格,未注明则拒绝

关键词:Analysis Business Analysi Analys alysis Business search social

<img src="static/image/smiley/comcom/5.gif" class="vm&qu
oliyiyi 发表于 2016-7-18 09:06:26 |显示全部楼层 |坛友微信交流群
楼主你的头像可真恐怖

使用道具

您需要登录后才可以回帖 登录 | 我要注册

本版微信群
加好友,备注cda
拉您进交流群

京ICP备16021002-2号 京B2-20170662号 京公网安备 11010802022788号 论坛法律顾问:王进律师 知识产权保护声明   免责及隐私声明

GMT+8, 2024-3-29 03:57