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.
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.
