Course outline

Analyzing Data with Power BI

Categories: Guaranteed To Run™, Microsoft

msp-logo

Duration: 3 Days

In this course, you will be introduced to the key concepts in business intelligence (BI), data analysis, and data visualization. You will discover the capabilities of a self-service BI solution and learn to create a dashboard and Power BI Desktop queries.

  • Perform Power BI desktop data transformation
  • Describe Power BI desktop modelling
  • Create a Power BI desktop visualization
  • Implement the Power BI service
  • Describe how to connect to Excel data
  • Describe how to collaborate with Power BI data
  • Connect directly to data stores
  • Describe the Power BI developer API
  • Describe the Power BI mobile app
  • Basic knowledge of the Microsoft Windows operating system and its core functionality
  • Basic knowledge of data warehouse schema topology (including star and snowflake schemas)
  • Some exposure to basic programming concepts (such as looping and branching)
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable
  • Familiarity with Microsoft Office applications (particularly Excel)
  • Business analysts
  • Business intelligence developers
  • SQL professionals

 Introduction to Self-Service BI Solutions

  • Introduction to business intelligence
  • Introduction to data analysis
  • Introduction to data visualization
  • Overview of self-service BI
  • Considerations of self-service BI
  • Microsoft tools for self-service BI

 Introducing Power BI

  • Power BI
  • The Power BI service

 Power BI Data

  • Using Excel as a Power BI data source
  • The Power BI data model
  • Using databases as a Power BI data source
  • The Power BI service

 Shaping and Combining Data

  • Power BI desktop queries
  • Shaping data
  • Combining data

 Modeling Data

  • Relationships
  • DAX queries
  • Calculations and measures

 Interactive Data Visualizations

  • Creating Power BI reports
  • Managing a Power BI solution

 Direct Connectivity

  • Cloud data
  • Connecting to analysis services

 Developer API

  • Custom visuals

 Power BI mobile app

  • Using the Power BI mobile app
  • Power BI embedded
  • Guaranteed to Run™. This ensures you will attend the instructor led class or live online class you want as scheduled without any disruptive cancellations*. You book the training you need, get back to focusing on your job and are sure your training requirements will be met saving time, money and ensuring peace of mind.
  • This schedule icon the schedule indicates that this date/time will be conducted as Instructor Led Training (ILT) or a Virtual Instructor Led Training (VILT) depending on the indicated class availablity.
Privacy and Cookies

This website stores cookies on your computer which help us make the website work better for you.

Learn moreAccept and Close
Social media & sharing icons powered by UltimatelySocial