The course is presented in three parts.

First, the course reveals the 3 shortcomings of presenting a pro-forma report. They are: o Hard to slice and dice o Hard to build a collapsible table on timeline o Not for self-service

Next, the course presents 3 challenges in building a Pro-Forma report and provide solutions for the challenges. They include: o How to Track On-hire Days for Each Vessel? o How to Track Daily Hire Rates for Each Vessel? o How to Calculate Net Hire Revenues?

Last, the course presents another 3 challenges in building a Dashboard report and provide solutions for the challenges. They include: o How to convert Pro-forma report to a Dashboard report? o How to build the Slice-and-dice function of a dashboard? o How to display budgets, actuals and off-hires all in one chart?

Course Search Keywords

• Pro-Forma report
• Dashboard report
• Power Query
• Unpivot
• Reference
• Merge queries
• Slicer
• Timeline
• PivotChart
• Combo Chart
• Secondary Axis