Dashboard with Power Bi

Course Overview

Learn to uncover and draw insights hidden in your data, Improve your productivity in reporting and analytical work by combining the various tools and features of Microsoft Power BI. This course masters your skills on creating a data-driven culture with business intelligence, transform company’s data into rich visuals, develop dashboards from published reports, and help discover better insight from data to spot business trends and push your business further.

Who is this course for?

This course is specifically for those whose companies are nominated as Critical Information Infrastructure Providers in the Marine, Shipping, Refinery, FPSO, Manufacturing, Shipyard, Construction and oil and gas.

  • Project Managers
  • Analytics Professionals
  • BI & Reporting Professionals
  • IT Developers & Testers
  • Junior Data Scientists
  • And anyone with a passion to data and data interpretation towards operational excellence

Duration: 2 days (15 hrs)

Mode of Delivery: Trainer led Virtual session

Prerequisite: None

Learning Outcome

Upon completion of the course, participants will be able to,

  • Enable everyone at every level of your organization to make confident decisions using up-to-the-minute analytics
  • understand and learn the formulae, functions, and tools in Power Query to conduct basic to advanced data analysis and model building
  • discover multiple ways to visualize data to transform information into actionable insights

Course Outline

  • Day 1 – Module 1
    • Foundation
    • Introduction to Analytics
    • Types of Analytics
    • Area of Analytics
    • Desktop Layout, Features and Views
    • Connecting to common data sources
    • Query Editor Layout & Functionality
    • Creating Data Model & Relationships
    • Built – in Aggregations
    • Calculated columns & Measures
    • Advanced Measures
    • Developing Reports & Dashboards
    • Exercise
  • Day 2 – Module 2
    • Dynamic Visualization with Dashboard
    • Create Dashboard from Existing Reports
    • Generate quick insights
    • Question your Data with dynamic charts
    • Customize Dashboard
    • Collaborate with Microsoft Teams
  • Day 2 – Module 3
    • Practical hands-on session (3 hrs)

The training comprises presentations Highly participative and interactive, group discussions, practical exercise, critique sessions, handouts, course templates and case studies to provide hands-on understanding of the process audit approach and its application.