Microsoft Power BI

Microsoft Power BI is a powerful data analysis tool. It transforms complex data into engaging images that will help you organize, visualize and communicate data for analysis and decision making.

Our live online classes offer hands-on experience with an expert instructor to guide you at every step, and a textbook PDF you can keep for reference. The class utilizes Power BI Desktop and explores Power BI Online.

Upon completion of the class, you will be able to create a Power BI desktop that visualizes data, telling a story that will facilitate further analysis or decision making by your organization or customers.

Part 1

Analyzing data, visualizing data, and storytelling with self-service BI

Data analysis
Data visualization – telling the story
Self-service business intelligence (bi)
Common uses of Power BI
Who uses Power BI?
Key features of Power BI
Microsoft Power BI updates over time
Power BI components
How to use Power BI

Getting started with visualizations

Connecting to a spreadsheet
Creating our first visualization
Power BI Interface tour
- Drill up/down
- The ribbon
- Views
- The canvas
- The visualization pane
- The data pane

Exploring formatting

Visualization pane formatting
- Build visual
- Format visual
Ribbon formatting
- File menu
- Home menu
- Insert menu
- Modeling menu
- View menu
- Optimize menu
- Help menu
- Format menu
- Data / drill

Let’s make things pretty…and pretty useful

Titles
Images, shapes and text boxes
Let’s dip our toe into AI
Arranging the screen
Mobile view
Page view
Adding multiple pages
- Renaming pages
- Adding a page
- Creating navigation between pages
Filtering
Slicers

Part 2

Creating more visualizations

Matrices
Line charts
Area charts
Ribbon charts
Pie and donut charts

Exploring on the fly analysis capabilities

Drilling down on a visual
Interactions between visuals

Focus on pretty

Page formatting
Visualization formatting
Wait a minute! Those are dollars!

More formatting

Changing formatting using the painter
Column tools
Tooltip pages

Accessibility and ADA compliance

Types of accessibility features
- Built-in accessibility features
- Keyboard navigation
- Screen reader compatibility
- High contrast color view
- Focus mode
- Show data table
Built-in accessibility features requiring configuration
- Alt text
- Tab order
- Titles and labels
- Markers
Themes, contrast and colorblind-friendly colors

Interaction between pages

Drill through

Connecting multiple spreadsheets or other data sources

Loading and connecting a second data source
Combining data in reports

Publishing and exporting

Part 3

KPIs

Gauges
Key influencers
Cards

Advanced settings and capabilities

Bookmark and page navigator
Small multiples
Natural language queries
Conditional formatting

More about connecting to data

Data import vs. Live connection
Import file data connections
Model data with relationships

Prior Learning

This noncredit course is beginner-friendly, with no prior expertise required. However, we do recommend that you are competent in Microsoft Excel. Additionally, to ensure success, students should:

Be comfortable reading and understanding English, as all materials are provided in English.
Have basic computer skills, including navigating the internet, downloading/uploading files, installing software, and using applications like Microsoft Word.

$450.00

View Upcoming Dates

Online Instructor-led

Contact Hours: 24

Access to Course: 3 months

3-Part class held every Friday over a three-week period.

Instructor

Stephen Herzig

Microsoft Power BI Course Instructor