Resource Center¶
Here are links to a variety of business analytics and Excel related resources.
General business analytics¶
Analytics Magazine It’s published by INFORMS - the Institute for Operations Research and Management Science. They are the premier professional society for analytics and it’s inexpensive to join as a student. Full disclosure, I’ve been an INFORMS member since about 1986 (when it was still ORSA/TIMS). We were doing analytics before it was called analytics. :)
Competing on Analytics - This is the Harvard Business Review article that brought analytics to the forefront in business (even though it had been around for decades). The article led to a book of the same name that was a best seller in the business world.
Excel resources¶
Tons of Excel resources exist on the web. Here are a few.
Blogs and metasites¶
ExcelIsFun - Huge You Tube channel of Excel how-to videos
ExcelJet - Excel learning resources (some free, some not)
Excel Help, Resources and Tutorials - Good collection of organized links including a list of Best Books for Learning Excel. Found out about this one in the Excel Developers LinkedIn group.
Daily Dose of Excel - blog posts by various Excel folks
Peltier Tech Blog - longtime Excel blogger
Top 69 Blogs in the World for Learning Excel - nice list with good descriptions
Excel modeling and analysis¶
Albright, Winston Textbooks - I’m a longtime user of several of these guys textbooks. This page contains numerous files related to their books. Great stuff - also check out the Free Downloads page.
ModelOff - Financial modeling world championships. Must see to believe. But…, things have changed. Even though this link now leads to a commercial set of learning resources, I’m leaving it here because it’s an interesting statement on the evolution of modeling in the finance world. You can find some of the classic ModelOff competitions on YouTube.
Publicly available data¶
DrivenData Competitions - not suggesting you compete (you can) but these are a great source of high quality datasets. You’ll need to create a free account to be able to download data. I used this site as a motivation for my series of blog posts on algal bloom detection from satellite imagery.
Kaggle Datasets - need to create a free Kaggle account
Data is Plural - links to many interesting datasets
Data.gov - US government data
Census.gov - US census data
Bureau of Transportation Statistics - tons of transportation rel
OpenML Datasets - site with many ML resources
cs109 Resources (2014) - Many links to datasets (as well as links to Python and misc data science stuff)
https://github.com/rstudio/RStartHere#data - From the RStartHere site
Modern plain text computing - this course has a list of practice data sources on the main page (check out tidy Tuesday)
Communities¶
StackOverflow Excel tags - excel, excel-vba, excel-formulas, more…
Mr. Excel - Community message board, blog, consulting services and more
Online Excel courses¶
I haven’t taken any of these.
Coursera - tagged “excel”
EdX - tagged “excel, data analysis, statistics”
Udemy - tagged “excel”
Chandoo.org - well known online Excel training