business intelligence

Data Analysis With OLAP Tool WebPivotTable

Here I demonstrate data analysis and knowledge of OLAP tool, WebPivotTable. See sample pivot table below:

PostgresSQL: Cube, RollUP, Grouping Sets, Partial Cube, AND Partial RollUP Operators

Continuing my SQL education, I have been working with PostgresSQL while taking online courses via Coursera. I have create some SQL statements using cube, rollup and grouping sets operators. See below: Cube ROLLUP: Grouping Sets: Partial Cube: Partial RollUP:

Entity Relationship Diagram: Conversions

When you finish creating your Entity Relationship Diagram and made sure that there are no errors; you can then start converting to tables by using the conversion rules. See below. Entity Type Rule: Convert the Student, Loan, Institution, Lender and DisburseLine entity types into tables. 1-M Relationships rule for all relationships except Sent relationship. UseContinue reading “Entity Relationship Diagram: Conversions”