Bon Appetite

MS SQL Desktop used for:

• Transformation and Modeling.

• Create Table and Bulk Insert

• SQL used for Alter Table, Update Tables and Columns

• Created special table for Graphs and Top N Bar reports

• KPIs was a trick and I combined 3 KPIs into 1 table for this exercise.

• Use of SQL Function to Export tables to Computer folders.

• Power Bi Measures used for KPI Reporting

Lessons learned:

• Date Format

• Previous results