Power BI Desktop hosted by Marquee Group

Sign up for Marquee’s interactive MBA Career Workshop to learn about how to use Power BI Desktop!

Workshop details:

Wednesday, January 25

• Time: 9 am – 5 pm (ET)
• Location: Virtual
• Cost: $66.37
• Register both on OSCARplus and the Marquee website
• Registration deadline: Sunday, January 22 at 11:59 pm (ET)

This course provides an introduction on how to refine, analyze and visualize data with Power BI Desktop.

• Connecting & Refining Data
  • Overview of Power BI interface and workflow
  • Review some common types of data connections
  • Discuss best practices for editing queries
  • Settings for defining data categories
  • Demonstration of basic table transformations Tools used to manipulate text, numbers and dates
  • Creating Index and conditional columns
• Building a Relational Data Model
  • Review of best practices for data modeling
  • Common guidelines for database normalization
  • Discussion of lookup tables and data tables
  • Understanding primary keys and foreign keys
  • Creating, defining and editing table relationships
  • Review of star schemas and snowflake schemas
  • Discussion of relationship cardinality
• Data Visualization with Reports
  • Best practices and guidelines for report design
  • Introduction and layout of the Report View
  • Adding various visualizations to reports
  • Visualization options for fields and formatting
  • Using slicers to filter report visualizations
  • Filtering at various levels in Report View
  • Editing interactions to control cross-filtering

For more information, please email Disha Patel at pated148@mcmaster.ca.