55400AC : Microsoft Power BI for End Users

Duration : 2 Days (16 Hours)

55400AC : Microsoft Power BI for End Users Course Overview:

This 2 day Microsoft Power BI for End Users course will take students who have little to no knowledge of Power BI to the point where they can create, publish and share rich reports and dashboards.

Audience Profile

This course is for students that are looking to learn how to use the range of Microsoft Power BI tools to refine and model their data into a visual and interactive format. Students considering adopting this course are not required to have any prerequisite knowledge of Power BI or experience working on data modelling related tasks.

At Course Completion

  • You will know which Power BI tool to use for different projects.
  • You will be able to connect to and maintain connections to data sources.
  • You can query your data sources to refine the data you are pulling into your project.
  • You can optimise a data model to enhance the performance of your reports.
  • You will know how to use Data Analyses eXpression (DAX) language to create columns and measures.
  • You can create dimensional hierarchies and plot geographical data.
  • You can create engaging, visual reports from your data model.
  • You’ll be able to publish your project to a workspace and manage it from the Power BI web service.
  • You will be able to build dashboard to aggregate essential visuals from reports.
  • You well be able to share your reports to colleagues.

Module 1: An Introduction to Power BI

In this module we will give a brief overview of what Business Intelligence is and what Power BI is. Power BI consists of multiple tools, which we will explore the purpose of and their core features. We will also make you aware of some essential resources for user learning about Power BI.

Lessons

  • What is business intelligence?
  • Introducing Power BI
  • Power BI tools and services
  • Power BI Report Server
  • Power BI (Online)
  • Power BI Desktop
  • Case studies
  • Support and information
  • Data stories

Lab 1: Getting Ready

  • Sign in to Office 365
  • Download course files
  • Place data sources into OneDrive
  • Create further user accounts

After completing this module, students will be able to:

  • Understand the concepts of business intelligence.
  • Have an overview of Power BI.
  • Be aware of the selection of tools available in the Power BI suite.
  • Know where to go to for support on updates, where to ask questions and which communities to join.

Typically, a business intelligence project focuses on a variety of themes and understanding them will help you take your first steps towards successfully completing a BI project. To start a project, this module will help you understand grain statements, a way of understanding what objectives your project is expected to achieve. This will evolve to understanding the full path of a project including discovering, refining and modelling your data to producing reports and dashboards. This may require you to use just the Power BI web service or the Power BI desktop application based on the needs of your project. You will also learn about workspaces and see how to use your personal workspace to take your first steps using the Power BI web service to create a report. Throughout this course, we will be basing our discussions around a fictitious company called House Rules Board Games to bring the training to life.

Lessons

  • Welcome to House Rules Board Games
  • Beginning a BI project
  • Grain statements
  • Data discovery
  • Refining information
  • Modelling data
  • Building reports
  • Roles
  • Publishing
  • Creating dashboards
  • Choosing workspaces
  • Create and share a report in Power BI

Lab 1: Build a report in Power BI web

  • Connect to an Excel spreadsheet
  • Build visualisations
  • Create a dashboard for desktop and mobile users
  • Share your report and dashboard

After completing this module, students will be able to:

  • Understand the requirements for a business intelligence project.
  • Be aware of the stages of a project and which tools to use.
  • Know how to create a basic report and dashboard in Power BI web.

The Power BI web service is a quick took for creating reports, but it lacks the depth to truly configure your data. In this module we will introduce Power BI desktop, an application that data analysts can use to work on Power BI projects. We will use the application to perform more enhanced data discovery and with that we can refine and format the data. As you will learn in this module, it is not always likely that our data will be a palatable format, therefore learning how to extract, transform and load data as part of a query is essential.

Lessons

  • Creating a project with Power BI desktop
  • Pinning an active project
  • What is in a PBIX file?
  • Connecting to data sources
  • Managing data connections
  • Refine data with Power Query
  • Applied steps
  • M code language
  • Designing your query
  • Choose columns
  • Rename columns
  • Moving columns
  • Formatting columns
  • Replacing values
  • Expanding related columns
  • Star schemas
  • Merge columns
  • Split columns
  • Custom and conditional columns

Lab 1: Starting a project in Power BI desktop

  • Creating a new PBIX project file
  • Connecting to data sources
  • Use the query editor to refine data
  • Review the table relationships
  • Optional – Connect to an Azure SQL database

After completing this module, students will be able to:

  • Start a new Power BI project using Power BI desktop.
  • Connect to a range of data sources.
  • Maintain data connections.
  • Design a query to refine their data.

A data model is the data found in one or more tables, from one or more sources. These tables can be, and often are, related. Understanding and maintaining these relationships between the tables is essential for optimising your data model so that if performs well for your report views. In addition, it is often the case that although you have connected to all the relevant data sources, it may not provide you will all of the information you require for your report. In this module we will show how to generate more data using Data Analysis eXpression language which is like formulas in Microsoft Excel. You can use this language to create new columns and measures which can provide you with even more data to report on. We will also look at how to structure related data into hierarchies, work with geographical data and introduce row level security which can later be combined with roles.

Lessons

  • Understanding relationships
  • Cardinality
  • Cross filter direction
  • Hiding tables and columns
  • Formatting columns
  • Introducing DAX
  • Designing calculated columns
  • Creating measures
  • Adding lookup tables
  • Structuring data with dimensional hierarchies
  • Roles and row level security

Lab 1: Designing a data model

  • Hide and format table columns
  • Create calculated columns
  • Create measures
  • Using geographical data and lookup tables
  • Create a dimensional hierarchy

After completing this module, students will be able to:

  • Format columns.
  • Review and manage table relationships.
  • Use DAX to create columns and measures.
  • Design data hierarchies.
  • Work with geographical data.
  • Implement row level security.

Often the part of the project that is seen by most is the report. The report uses information refined and calculated in your data model to create a visual experience that is interactive and tells a clear narrative. To do this, the report utilises a wide selection of visuals which we will focus on in this module. Visuals range from bar charts to maps. This extensive range can be enhanced by accessing the store, which is rich with custom visuals. You can use slicers and filters to help users drill down through your data and navigational buttons to help users move between your report pages.

Lessons

  • Adding pages and navigation buttons
  • Using shapes, text and images
  • Creating a theme
  • Adding visualisations
  • Using filters and slicers
  • Controlling filters
  • Adding drill throughs
  • Adding custom visualisations
  • Configure phone layouts
  • Report tips

Lab 1: Creating a report

  • Creating new pages and adding basic content
  • Adding and configuring visualisations
  • Design slicers
  • Create bookmarks and navigational buttons

After completing this module, students will be able to:

  • Create pages in a report and design navigational buttons.
  • Add visualisations to a report.
  • Configure visualisations.
  • Implement filters and slicers.
  • Download new custom visualisations.

Once you have finalised your report, it is ready to be published. In this module we will cover the last stages of producing a report which covers publishing and configuring a published project. Your ability to publish a project, and to what type of workspace depends on your license, so this module will outline the types of license and workspaces you may encounter. We will also cover dashboards, which are ways that you can share your content and as well as ways you can restrict your content.

Lessons

  • Power BI licensing
  • My workspaces
  • App workspaces
  • Premium capacity workspaces
  • Creating a new workspace
  • Publishing a project
  • Parallels with Microsoft Excel
  • Publishers and viewers
  • Reconnecting with data sources
  • Introducing the on-premises data gateway
  • Scheduling the data refresh frequency
  • Assigning security roles
  • Creating and populating dashboards
  • Customising dashboard tiles
  • Creating tiles using Q&A and quick insights
  • Creating a mobile dashboard
  • Sharing reports and dashboards
  • Publishing apps in a workspace
  • Publishing content to websites

Lab 1: Publish and share reports and dashboards

  • Publish your project to Power BI
  • Create a dashboard
  • Use quick insights and pin visuals
  • Use Q&A to query your data source
  • Share your dashboard with marketing

After completing this module, students will be able to:

  • Publish your project and understand what licenses are required.
  • Configure a published data model to refresh periodically.
  • Understand what features Power BI shares with Microsoft Excel.
  • Use the on-premises data gateway.
  • Designate roles for row level security.
  • Create desktop and mobile dashboards.
  • Share reports and dashboards.
  • Publish apps and feature your reports on websites.

55400AC : Microsoft Power BI for End Users Course Prerequisites:

No previous experience of Power BI is required

Q: What is the 55400AC: Microsoft Power BI for End Users training?

A: The 55400AC training is a comprehensive course designed to provide end users with the knowledge and skills to effectively utilize Microsoft Power BI for data analysis and visualization. This training focuses on empowering participants to create insightful reports and interactive dashboards using Power BI’s robust features.

A: This Microsoft Power BI for End Users training is suitable for end users who want to leverage the power of Microsoft Power BI for data analysis and visualization. It is ideal for business professionals, analysts, managers, and anyone involved in working with data and making data-driven decisions within an organization.

A: The training covers a range of topics, including an introduction to Power BI, connecting to data sources, transforming and modeling data, creating visualizations and reports, designing interactive dashboards, sharing and collaborating on Power BI content, and utilizing Power BI’s advanced features and functionalities.

A: By completing this training, you will acquire essential skills in using Microsoft Power BI as an end user. You will learn how to connect to data sources, perform data transformation and modeling, create visually appealing reports and visualizations, design interactive dashboards, share and collaborate on Power BI content, and utilize advanced features such as DAX calculations and custom visuals.

A: There are no specific prerequisites for this training. However, a basic understanding of data analysis concepts and familiarity with Microsoft Office applications will be beneficial.

A: Yes, participants will receive comprehensive course materials, including step-by-step instructions, hands-on exercises, and reference materials to support their learning throughout the training.

A: No, this training does not include an exam or certification. It focuses on providing practical knowledge and skills in using Microsoft Power BI as an end user.

A: To enroll in the Microsoft Power BI for End Users training, click Enroll Now button or contact our training department for more information and registration details.

A: While this training specifically focuses on Microsoft Power BI, many of the concepts and principles learned can be applied to other data visualization tools as well. However, there may be differences in the user interface and specific features among different tools.

A: This training will enable your organization to leverage the power of Microsoft Power BI for data analysis and visualization. It will enhance data-driven decision-making, enable users to create insightful reports and interactive dashboards, and improve overall data analysis capabilities. By harnessing the potential of Power BI, your organization can gain valuable insights from data, drive efficiency, and make informed business decisions.

Discover the perfect fit for your learning journey

Choose Learning Modality

Live Online

  • Convenience
  • Cost-effective
  • Self-paced learning
  • Scalability

Classroom

  • Interaction and collaboration
  • Networking opportunities
  • Real-time feedback
  • Personal attention

Onsite

  • Familiar environment
  • Confidentiality
  • Team building
  • Immediate application

Training Exclusives

This course comes with following benefits:

  • Practice Labs.
  • Get Trained by Microsoft Certified Trainers (MCT).
  • Access to the recordings of your class sessions for 90 days.
  • Digital courseware
  • Experience 24*7 learner support.

Got more questions? We’re all ears and ready to assist!

Request More Details

Please enable JavaScript in your browser to complete this form.

Subscribe to our Newsletter

Please enable JavaScript in your browser to complete this form.
×