Excel Power BI Course

Excel Power BI Training Course

Excel Power BI Training Course

Microsoft Power BI is a suite of interactive data visualisation business analytics tools that deliver insights throughout your organization.
Click Here to Register

  • You can use Power BI to connect to hundreds of data sources, simplify data prep, and drive ad hoc analysis.
  • It produces beautiful reports, then publishes them for your organization to consume on the web and across mobile devices.
  • Everyone can create personalised dashboards with a unique, 360-degree view of their business. And scale across the enterprise, with governance and security built-in
  • Power BI is used to Analyse Business statistics that help to deliver insights to enable fast, informed decisions.

Duration: 2-day training (9:30-5:00)

Venue: 10 Anson Road, 26-08A International Plaza, Singapore 079903

Course Objectives:

In this course, you will explore and visualize data with Power BI.

You will:

  • Analyze data with self-service BI.
  • Connect to data sources.
  • Perform advanced data modeling and shaping.
  • Visualize data with Power BI.
  • Enhance data analysis.
  • Model data with calculations.
  • Create interactive visualizations.

Prerequisites:

To ensure your success, you should have experience managing data with a spreadsheet program such as Microsoft Excel or Google Sheets.

  Microsoft Power BI Training Outline

 

Lesson 1: Analyzing Data with Self-Service BI

  • Data Analysis and Visualization for Business Intelligence
  • Self-Service BI with Microsoft Power BI

Lesson 2: Connecting to Data

  • Create Data Connections
  • Model Data with Relationships
  • Save Power BI Files

Lesson 3: Performing Advanced Data Modeling and Shaping

  • Clean and Transform Data with the Query Editor
  • Shape Data with the Query Editor
  • Combine and Manage Data Rows

Lesson 4: Visualizing Data with Power BI

  • Create Visualizations in Power BI
  • Chart Data in Power BI

Lesson 5: Enhancing Data Analysis

  • Enhance Analysis with Customized Visuals and Pages
  • Enhance Analysis with Tooltips

Lesson 6: Modeling Data with Calculations

  • Create Calculations with Data Analysis Expressions (DAX)
  • Create Calculated Measures and Conditional Columns

Lesson 7: Creating Interactive Visualizations

  • Create and Manage Data Hierarchies
  • Filter and Slice Reports
  • Create Dashboards in Power BI

Our Clients