Microsoft Power BI Super User (55400)
Empower your team or yourself with the capabilities of Microsoft Power BI in our Microsoft Power BI Super User course. Dive into the world of Business Intelligence and harness the power of visual data representations to enhance decision-making processes within your organization. This course is tailored to guide you through the essential facets of Power BI, from foundational concepts to the creation of insightful dashboards and reports.
We begin with An Introduction to Power BI, familiarizing you with the core tools and features of Power BI, including the Power BI Report Server and Power BI Desktop. This module offers a comprehensive overview of Business Intelligence concepts and shows you where to access ongoing support and information.
Next, you'll explore Requirements Gathering, focusing on the initial stages of a BI project. Grasp the importance of grain statements and data modeling as you navigate through the project lifecycle, using the Power BI web service to produce compelling reports and dashboards.
In the Extract, Transform, and Load Data module, engage with Power BI Desktop to manipulate and format data effectively. Learn to extract, transform, and load data as part of your queries, setting the foundation for robust data analysis and visualization.
Creating a Data Model will guide you in optimizing data relationships within your projects. Understanding and managing these connections are key to building efficient models, along with mastering Data Analysis Expressions (DAX) to craft new columns and measures for enriched reporting.
The Designing Reports segment emphasizes crafting visually engaging and interactive reports. Discover how to customize themes and integrate various visualizations, along with filters and slicers to refine the user experience. Enhance your reports with custom visuals and intuitive navigation features.
Conclude your learning journey with Using Workspaces and Dashboards, where you'll publish your work and learn about the different licensing and workspace options. You'll also explore creating and sharing dashboards, engaging with mobile platforms, and utilizing the on-premises data gateway for secure data access.
By the end of this course, you or your organization will be proficient in utilizing Power BI to transform raw data into meaningful insights. You'll be equipped to design and share impactful data stories that drive informed business decisions, utilizing the full suite of Power BI capabilities efficiently.
- 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 optimize a data model to enhance the performance of your reports.
- You will know how to use Data Analysis 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.
Public expert-led online training from the convenience of your home, office or anywhere with an internet connection. Guaranteed to run .
Private classes are delivered for groups at your offices or a location of your choice.
- An Introduction to Power BI
- 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: Getting Ready
- Sign in to Office 365
- Download course files
- Place data sources into OneDrive
- Create further user accounts
- Requirements Gathering
- Welcome to House Rules Board Games
- Beginning a BI project
- Grain statements
- Data discovery
- Refining information
- Modeling data
- Building reports
- Roles
- Publishing
- Creating dashboards
- Choosing workspaces
- Create and share a report in Power BI
- Lab: Build a report in Power BI web
- Connect to an Excel spreadsheet
- Build visualizations
- Create a dashboard for desktop and mobile users
- Share your report and dashboard
- Extract, transform and load data
- 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: 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
- Creating a data model
- 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: Designing a data model
- Hide and format table columns
- Create calculated columns
- Create measures
- Using geographical data and lookup tables
- Create a dimensional hierarchy
- Designing Reports
- Adding pages and navigation buttons
- Using shapes, text and images
- Creating a theme
- Adding visualizations
- Using filters and slicers
- Controlling filters
- Adding drill throughs
- Adding custom visualizations
- Configure phone layouts
- Report tips
- Lab: Creating a report
- Creating new pages and adding basic content
- Adding and configuring visualizations
- Design slicers
- Create bookmarks and navigational buttons
- Using workspaces and dashboards
- 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
- Customizing 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: 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
Each student will receive a comprehensive set of materials, including course notes and all the class examples.
Experience in the following is required for this Microsoft Business Intelligence class:
- Understanding core data concepts.
- Knowledge of working with relational data in the cloud.
- Knowledge of working with non-relational data in the cloud.
- Knowledge of data analysis and visualization concepts.
Live Public Class
$1,190.00 / student
Live Private Class
- Private Class for your Team
- Live training
- Online or On-location
- Customizable
- Expert Instructors