MySQL

How to Install MySQL on Mac OS X

The process to install MySQL on Mac OS X is a pretty straight forward process. MySQL is one of the most popular open source databases. It is used in a wide variety of applications. Download MySQL Installer First you will need to download the DMG archive from http://dev.mysql.com/downloads/mysql/ Install MySQL from the downloaded DMG archive as …

Continue reading How to Install MySQL on Mac OS X

SQLite

SQLite for Data Analysis

Before I started using a Mac as my main computer, I would often find myself using Microsoft Access to do some data analysis for a one-off project. Now that I'm using a Mac, I needed to find a tool to do what I used to do with Microsoft Access. In my search I came across …

Continue reading SQLite for Data Analysis

Warcraft 3

Install Warcraft III: The Frozen Throne on Mac OS X Yosemite

March 2016 Update: Warcraft 3 patch 1.27 added native support for Mac OS X El Capitan. From the patch notes: Throw away that old PowerPC Mac in the closet, we’ve created a new installer to support Mac 10.10 and 10.11 The new Warcraft 3 update is at https://www.blizzard.com/en-us/download/?platform=macos Warcraft 3 Mac OS X Install Guide Here …

Continue reading Install Warcraft III: The Frozen Throne on Mac OS X Yosemite

Business Intelligence Data Warehousing

The Challenge of Dashboard BI Projects

If the goal of your business intelligence project is to deliver a dashboard, you should have warning bells going off in your head. What is a Dashboard An easy to read graphical presentation of the current status and historical trends of an organization’s key performance indicators (KPIs) to enable instantaneous and informed decisions to be …

Continue reading The Challenge of Dashboard BI Projects