About this project

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

Discussion and feedback(0 comments)
2000 characters remaining