Course Outline

Introduction

Excel to Power BI

  • Introduction to Power BI and its relationship with Excel
  • Importing data from Excel into Power BI
  • Transforming Excel data for Power BI
  • Best practices for Excel and Power BI integration

Power BI Basics

  • Overview of Power BI components
  • Connecting to data sources
  • Data modeling basics
  • Creating simple visualizations

Power BI Dashboards

  • Design principles for dashboards
  • Interactive dashboard features
  • Sharing and publishing dashboards
  • Dashboard navigation and actions

Power BI Dashboard Design

  • Advanced design techniques
  • Utilizing themes and templates
  • Mobile dashboard design considerations
  • User experience and accessibility

Advanced Power BI

  • DAX (Data Analysis Expressions) fundamentals
  • Advanced data transformations
  • Complex data modeling
  • In-depth analysis techniques
  • Security and administration in Power BI

Summary and Next Steps

Requirements

  • An understanding of basic data concepts and structures
  • Experience with Microsoft Excel and data manipulation
  • Familiarity with basic statistical concepts

Audience

  • Data analysts
  • Business intelligence specialists
 35 Hours

Number of participants


Price per participant

Testimonials (5)

Upcoming Courses