Introduction to Power BI

Course Overview

Power BI™ is Microsoft’s cloud reporting and business analytics tool suite used to analyze data and share insights. With Power BI, you can supercharge your organization’s ability to monitor your projects, programs, resources, or just about any other data across the enterprise
and get answers quickly with rich dashboards available on every device. This course teaches the core techniques that your business analysts need to use this powerful data intelligence and report authoring tool. Attendees of this course will gain practical examples from an experienced instructor who has deployed and configured Power BI reporting for a wide variety of businesses.

Participants will learn to:

  • Describe the components of the Power BI suite & its benefits to the organization
  • Demonstrate an understanding of the source data schema
  • Perform basic transformations of data
  • Select appropriate visualizations for the data being reported
  • Apply appropriate filters to reports and dashboards
  • Build a report and dashboard, then deploy them to the online Power BI service

This two-day course* utilizes a proprietary project and portfolio management data set, or for a private class, the client organization may choose to use its own data sources to maximize immediate application of knowledge. This course can be delivered in-person or remotely in full or half-day sessions and will teach basic data modeling and shaping concepts. It results in the creation of a two page report illustrating concepts valuable to project, program, and portfolio managers.

*If you wish to customize the course content or duration, please reach out to us directly.

Who Should Attend

This course is targeted at those wanting to get hands-on with development of data queries, data transformations, and the building of reports and dashboards. Microsoft’s goal with Power BI is to make transformation of business data into insightful analytics achievable by end-users, rather than requiring deep technical skills. With that said, we recommend that attendees be prepared for a moderate level of business intelligence & analytics “jargon,” additionally being familiar with foundational database concepts including tables, fields, & relationships.

Course Materials

Course materials are comprised of a proprietary data set, accompanying lab manuals, and two data schema charts. Attendees may also earn Professional Development Units from the Project Management Institute (PMI®).

Learning Objectives

Learn Power BI Solutions
• Power BI solution benefits
• Key concepts in business intelligence
• Components of the Power BI suite

Get Data
• Access a variety of source data
• Selecting & mining relevant tables
• Basic power query

Basic Data Transformations
• Build simple queries
• Filter queries
• Table relationships
• Change data types
• Introduction to custom columns and measures
• Basic DAX (data analysis expressions)
• Understand datasets, reports, & dashboard hierarchy
• Create tables & matrices
• Select appropriate visualizations
• Format & filter visuals, pages, and reports

Publish Reports In Power BI Service
• Publish reports
• Establish data refresh for reporting
• Create dashboards & multi-report dashboards
• Share & distribute dashboards

Pain Points This Course Helps!

⚡ Where do I start?

Learn fundamentals and best practices in Power BI.

⚡ I need my data!

Learn how to access a variety of source data and how to select and mine relevant tables.

⚡ I need to report on my project!

Learn how to publish and refresh reports and how to create and share dashboards to your key stakeholders.

⚡ I don’t get it!

Learn the basics of how to utilize Power BI and all of the benefits is has to offer you, your projects, and your organization.

Course Instructors and Accreditation

Advisicon is a gold partner–Microsoft’s highest partner ranking–with several competencies including Data Analytics and Project and Portfolio Management. This course will be taught by an experienced instructor who has deployed and configured Power BI reporting in a wide variety of organizations.


Advisicon’s goal is to improve your processes and technologies, thus creating measurable results. For over 30 years, we have successfully helped customers learn, scale, and grow.

Download the full course slick here

Power BI™ is Microsoft’s cloud reporting and business analytics tool suite used to analyze data and share insights. With Power BI, you can supercharge your organization’s ability to monitor your projects, programs, resources, or just about any other data across the enterprise
and get answers quickly with rich dashboards available on every device. This course teaches the core techniques that your business analysts need to use this powerful data intelligence and report authoring tool. Attendees of this course will gain practical examples from an experienced instructor who has deployed and configured Power BI reporting for a wide variety of businesses.

Participants will learn to:

  • Describe the components of the Power BI suite & its benefits to the organization
  • Demonstrate an understanding of the source data schema
  • Perform basic transformations of data
  • Select appropriate visualizations for the data being reported
  • Apply appropriate filters to reports and dashboards
  • Build a report and dashboard, then deploy them to the online Power BI service

This two-day course* utilizes a proprietary project and portfolio management data set, or for a private class, the client organization may choose to use its own data sources to maximize immediate application of knowledge. This course can be delivered in-person or remotely in full or half-day sessions and will teach basic data modeling and shaping concepts. It results in the creation of a two page report illustrating concepts valuable to project, program, and portfolio managers.

*If you wish to customize the course content or duration, please reach out to us directly.

Who Should Attend

This course is targeted at those wanting to get hands-on with development of data queries, data transformations, and the building of reports and dashboards. Microsoft’s goal with Power BI is to make transformation of business data into insightful analytics achievable by end-users, rather than requiring deep technical skills. With that said, we recommend that attendees be prepared for a moderate level of business intelligence & analytics “jargon,” additionally being familiar with foundational database concepts including tables, fields, & relationships.

Course Materials

Course materials are comprised of a proprietary data set, accompanying lab manuals, and two data schema charts. Attendees may also earn Professional Development Units from the Project Management Institute (PMI®).

Learning Objectives

Learn Power BI Solutions
• Power BI solution benefits
• Key concepts in business intelligence
• Components of the Power BI suite

Get Data
• Access a variety of source data
• Selecting & mining relevant tables
• Basic power query

Basic Data Transformations
• Build simple queries
• Filter queries
• Table relationships
• Change data types
• Introduction to custom columns and measures
• Basic DAX (data analysis expressions)
• Understand datasets, reports, & dashboard hierarchy
• Create tables & matrices
• Select appropriate visualizations
• Format & filter visuals, pages, and reports

Publish Reports In Power BI Service
• Publish reports
• Establish data refresh for reporting
• Create dashboards & multi-report dashboards
• Share & distribute dashboards

Pain Points This Course Helps!

⚡ Where do I start?

Learn fundamentals and best practices in Power BI.

⚡ I need my data!

Learn how to access a variety of source data and how to select and mine relevant tables.

⚡ I need to report on my project!

Learn how to publish and refresh reports and how to create and share dashboards to your key stakeholders.

⚡ I don’t get it!

Learn the basics of how to utilize Power BI and all of the benefits is has to offer you, your projects, and your organization.

Course Instructors and Accreditation

Advisicon is a gold partner–Microsoft’s highest partner ranking–with several competencies including Data Analytics and Project and Portfolio Management. This course will be taught by an experienced instructor who has deployed and configured Power BI reporting in a wide variety of organizations.


Advisicon’s goal is to improve your processes and technologies, thus creating measurable results. For over 30 years, we have successfully helped customers learn, scale, and grow.

Download the full course slick here

Looking for more information about the course?

Connect with a Trainer

This field is for validation purposes and should be left unchanged.