Using Microsoft Power BI

Using Microsoft Power BI

Basics of using Power BI to build visual reports and connecting to your Solver data.

About this course

NOTE: Effective January 2021, users of Solver see a new user interface (UI) with some updated terminology. Where possible, documents within this course have been updated to the new UI. There are also ongoing updates to Power BI. For the latest, click here.

Explore the new integration between Solver Cloud/Private Host 5.0 and Power BI.  Topics include:

  • Getting started with Power BI
  • Enabling the Solver Cloud API access
  • Power BI Desktop - using Get Data
  • Navigating the Power BI Desktop
  • Building visuals
  • Publishing reports 
  • Quick measures
  • Custom columns (Period dimension)
  • Manipulating data 
  • User setup - COMING SOON

Posted 5/19, Revised 3/21

Curriculum~ 60 minutes

  • Getting Started in Power BI
  • Create & Maintain Connections with Solver
  • Visualizations Overview
  • Hands-on: Build Visuals
  • Introduction to Measures & Custom Columns
  • Publishing in Power BI service
  • Manipulating Data
  • Quiz - Using Power BI

About this course

NOTE: Effective January 2021, users of Solver see a new user interface (UI) with some updated terminology. Where possible, documents within this course have been updated to the new UI. There are also ongoing updates to Power BI. For the latest, click here.

Explore the new integration between Solver Cloud/Private Host 5.0 and Power BI.  Topics include:

  • Getting started with Power BI
  • Enabling the Solver Cloud API access
  • Power BI Desktop - using Get Data
  • Navigating the Power BI Desktop
  • Building visuals
  • Publishing reports 
  • Quick measures
  • Custom columns (Period dimension)
  • Manipulating data 
  • User setup - COMING SOON

Posted 5/19, Revised 3/21

Curriculum~ 60 minutes

  • Getting Started in Power BI
  • Create & Maintain Connections with Solver
  • Visualizations Overview
  • Hands-on: Build Visuals
  • Introduction to Measures & Custom Columns
  • Publishing in Power BI service
  • Manipulating Data
  • Quiz - Using Power BI