Top 10 Open Data Resources Online

There’s a lot of hype around big data these days. And it isn’t any wonder with everything going digital. We’ve been generating a large mass amount of data that’s becoming more and more valuable.

Think of publicly available and open data.  You may be asking why is it so important? Using open or publicly available data can be extremely useful. Some examples include:

  • Analyzing global trends
  • Measuring the efficiency of government policies
  • Innovating a new service
  • Improving your company’s products

Because of the wide range of applications, not just data scientists, but journalists, marketers, business professionals, and even freelancers, are learning how to access, clean and interpret raw data.

While you may already have access to data analytics tools or a topic to research, all that may be missing are the big data sources to work with. Wondering where to find statistical data? Below is a list of databases you can start with.

1. The World Factbook –The CIA website has an open source library where you can find its World Factbook, which offers the public opendata on 267 countries on topics ranging from history and government to geography and military.

2. Amazon Web ServicesAmazon Web Services offers a suite of cloud computing services for database, computing, storage and analytic solutions to name a few. AWS also hosts a number of public datasets, which you can access. You will need to have an AWS account or access to its command line tools.

3. Open Government Data—Looking for data from major governments? You can search through data available publicly from the Governments of Canada, the USA and the UK. The official portal for European data – data.europa.eu – can give you access to a range of data produced by member countries of the European Union.

4. Open Data Network – The Open Data Network, launched by Socrata.com in 2014, is an online data catalogue that makes finding the data you need as easy and familiar as finding data with Google. Its latest enhancements include updates for elements like autosuggestion and easier mobile navigation. This site covers all major US regions including public data sources for areas like finance, health, infrastructure, education and social services to name a few.

5. Google Public Data Explorer– What better place to explore datasets than on Google? Google Public Data Explorer makes it easy for anyone to access and interact with public data from international organizations and academic institutions. You can upload, share and visualize datasets. Here’s an overview to get an idea of how to use Google Public Data Explorer.

6. DBpediaDBpedia is a crowd-sourced effort to pull structured data from Wikipedia into an accessible database form on the web. According to the site, the advantages of the DBpedia knowledgebase are that “it covers many domains; it represents real community agreement; it automatically evolves as Wikipedia changes, and it is truly multilingual.”

7. Worldbank.org—Made up of five international organizations, the World Bank Group is the largest development bank in the world, working towards ending poverty and shared prosperity. The organization offers “free and open access to data about development in countries around the globe.”

8. UNDataUNData is an internet based data service from which you can access datasets that include statistics from countries that are part of the United Nations.

9. World Census Open Data—Need census data from other countries? Get census results from other places around the globe like Argentina, New Zealand, Romania, and Egypt. This source is valuable for those gathering geographical or localized statistics. In addition, you can find census data for the USA and Statistics Canada in the linked sources for easy access.

10. Open Data Portals –At Dataportals.org you can find a curated list of open data resource portals around the world. It will help you start broadly and then narrow down your search by location. With 519 portals, as of this writing, the site welcomes additions or feedback to create one of the most widely curated free public data sources online that every user can benefit from.

Dealing with datasets can get overwhelming. You can expect your data to be disorganized and unruly. And as easy as these sites are to visit, be warned that you may come across hard to access formats requiring you to first convert a scanned PDF to Word before being able to use it. But don’t get discouraged. The potential of that data is unlimited.

Did we miss any? Add your own main sources to this collection—the more on this list, the better!

27 Microsoft Excel Experts Predict The Future Of Excel In Business Intelligence

With over 750 million users worldwide, Microsoft Excel is the traditional tool of choice for presenting and analyzing data.

And now, it’s in a position to be the new BI tool of choice, as well. With Excel 2016, Microsoft announced some forward thinking built in Business Intelligence (BI) features. In the age of big data, this is huge.

This announcement, however, raised many questions in the field of big data manipulation. Is Excel powerful enough? Can it manipulate the amount and types of data businesses deal with today? Does Excel have a future in Business Intelligence workflows?

In the search of answers to these questions, we rounded up renowned MS Excel experts and picked their brains on it. We asked them one visionary question:

Where do you see the future of MS Excel in Business Intelligence Workflows?

And here is what they shared with us:

1. Purna Duggirala – Chandoo

Chandoo.org // @r1c1

Purna DuggiralaThere is a running joke in BI communities.

“What is the most used feature in any business intelligence solution?”
It is the Export to Excel button.

Jokes aside, Excel continues to be the #1 platform when it comes to analyzing data, finding information, preparing charts and presenting them to decision makers. In that sense, I see Excel playing a strong role in BI workflows in future.

Excel continues to be the #1 platform when it comes to analyzing data, finding information, preparing charts and presenting them to decision makers. In that sense, I see Excel playing a strong role in BI workflows in future.

– Purna Duggirala

With the addition of features like Power BI (Power Pivot, Power Query, Power View, Power Maps etc.) that naturally integrate with Excel, analysts, reporting professionals and BI people are finding Excel more relevant for full-length BI implementations.

In order to remain the favorite analytics app of everyone, Excel needs to do what it is amazingly good for. These are – offer a sandbox-like environment where anyone can play with data and come up with information, keep the Excel software offerings clean & simple (with the addition of Power BI, buying and using Excel has become a complex process), give users competent & compatible Excel apps for tablet & phone devices and include features to do powerful data analytics processes with one-click (as against a complex set of formulas, pivot tables & manual steps that many analysts do now).

Long live Excel.

2. Ken Puls – Excel Guru

Excelguru.ca // @kpuls

Ken PulsI personally see Excel as THE future of Business Intelligence workflows.

No matter how many systems a company has, how big they are, or how many millions of dollars have been spent on them, the reality is that the majority of data is exported to Excel before decisions of serious consequence are made. I’d go so far as to say that there are only a handful of finance departments in the world who don’t run their critical decision making analysis through Excel.

With the increasingly diverse toolset being added to Excel — Power Query to source and clean data from disparate dirty sources, Power Pivot to aggregate those disparate sources into business intelligence models, Power View to create dynamic dashboards from those models and Power Map to tell the data story on a geo-spatial plane – it’s very clear that Microsoft is investing heavily to make Excel the Business Intelligence tool of choice.

I personally see Excel as THE future of Business Intelligence workflows.

– Ken Puls

The killer for Excel today is not the fact that it isn’t the best out there for building business intelligence, it is the fact that far too many users are ignorant of the vast amount of capability that was added in the last five years. The attitude of “Excel can’t do that” is still pervasive and relied upon by its competitors to sell THEIR products.

My advice to anyone looking at building business intelligence systems today and considering switching to a competitor’s product: find a business intelligence expert who REALLY uses Excel. Ask them what can be done. Chances are you already own the software that will do it all, you’re just not aware of how.

3. Bill Jelen

Mrexcel.com // @MrExcel

Bill Jelen

The new Power BI Desktop offering from Microsoft will make it easy to create powerful dashboards that you can share to various end points such as iPads within your organization. The easiest way to get data into Power BI is from an Excel file, so Excel continues to be the most important component in the Power BI workflow.

Continue reading →