Building a Cube - US County Business Patterns

1) In this video, we are going to explore

1. Data sources
2. Data source views
3. Measures and Dimensions, formatting of measures
4. Processing a Cube
5. Browse a Cube
6. Browse a Cube in Excel, Create line charts and column charts

2) Few screen shots while building the cube:

    Datasource view:

    

    User-Defined hierarchies:

   Browse cube:

   Cube in Excel:

   Cube in Excel + Column Charts:

4) Key highlights are in the video:

NOTE:

We observed that "GrandTotal" for the "Mid March Employees" is being displayed as a negative number.
The reason is data type is "Integer" for "Mid March Employees" and the "Grand Total" column value is exceeding the limit of an "Integer". So let's change the data type to "BigInt" to fix the issue.

Before correction:

Correction: Changing the data type to "BigInt" for "Mid March Employees"

After correction: