Excel

In Parts I, II and III of this series, Building a High Value Low Cost BI Solution,  I addressed some of the practical matters of project definition, database terminology and the the evolutionary method for migrating your data to a data warehouse while also receiving the immediate benefit of a useful visual reporting system.  In this section I'll describe how you can organize data in Excel to create a Star Schema structure that will facilitate analysis with Tableau. &

In part II of this series, Some Words You Need to Know,  I explained some of the basic terminology required to understand the concepts which will be discussed in later blog posts for this series.