Business Intelligence Archives - Page 2 of 2

Got Technology, Need Data? Here’s Where to Get It…For Free

The Data Challenge Have you ever wanted to assess or explore a new BI, analytics, data visualization, data science, etc. technology, but struggled to find a data set to use for your assessment and exploration activities? Have you grown tired of analyzing the “typical” datasets–think census, stock market, and employment and inflation rate data–known to be publicly available? […]

Got Technology, Need Data? Here’s Where to Get It…For Free Read More »

Big Data, Business Intelligence, Data Integration, Data Visualization, General, Tips

Keeping Tabs on Tableau

[vc_row][vc_column][vc_column_text] Tableau has been around for awhile now and is sort of the “name brand” when referring to new cloud and lightweight BI platforms. Given its stature I thought I would download the newest version (Tableau 10), kick the tires, and see what it’s all about. You can download a free trial and test it

Keeping Tabs on Tableau Read More »

Business Intelligence, Data Visualization, Excel, Tableau

How to get BI with Excel

I know it sounds like I am writing about 1980s technology, and I am, but the fact remains that Excel is still a widely used tool in the business world. Besides, what else would you put your data dumps into? Often Excel reports get used for management reporting, which comes with a number of issues.

How to get BI with Excel Read More »

Analytics, BICS, Business Intelligence, Cloud, Coding, Data Visualization, Excel, Oracle, Tips, VBA

Preparing Excel Data For Analysis

Whether you are using Excel as a data source for your Business Intelligence (BI) platform, or you are doing the actual analysis within Excel, your data will need to be in a format that is queryable. Often though, the data is formatted to be read visually, whether an export from a system, or manually entered.

Preparing Excel Data For Analysis Read More »

Big Data, Business Intelligence, Excel, Red Pill Analytics Tips, Tips, VBA