What is Power BI
Using Power BI Desktop
Connecting to data sources
Creating Visualizations
Data Modeling
Using Query Editor
Matrixes, Tables, and Charts
Anyone who needs a solid understanding of the skills required to use Power BI.
- Participants should have a strong knowledge of Excel 2010, 2013 or 2016 and have and understanding of data analysis.
- Getting Started
- An Introduction to Power BI
- What is Power BI?
- The Building Blocks of Power BI
- The Power BI Desktop Interface
- Important Information About Power BI Updates
- The Power BI Web App
- Working with Power BI Desktop Files
- Opening Files
- Saving Files
- Creating a New File
- Publishing to the Power BI Web App
- Connecting to Data Sources with Power BI Desktop
- Connecting to an Excel Workbook
- Connecting to an Access Database
- Viewing All Connection Options
- Creating a Manual Dataset
- Managing Data Sources
- Creating a Report with Visualizations
- Using the Visualizations Pane
- Using the Fields Pane
- Creating a Visualization
- Interacting with Visualizations
- Changing the Visualization Type
- Moving and Resizing Visualizations
- Doing More with Visualizations
- Formatting Visualizations
- Viewing Visualization Data
- Using Focus Mode and Spotlight
- Removing a Visualization
- Working with Data
- Transforming and Sanitizing Data
- Using Data View
- Cleaning Irregularly Formatted Data
- Managing Columns
- Sorting Table Data
- Using the Query Editor
- Opening the Query Editor
- The Query Editor Interface
- Using the Query Settings Pane
- Using Merge Queries
- Using Append Queries
- Data Modeling
- What is DAX?
- Creating a New Table
- Creating a New Calculated Column
- Creating a New Measure
- Managing Relationships
- Using the Relationships View
- Creating Relationships
- Editing Relationships
- Deleting Relationships
- Using the Manage Relationships Dialog
- Working with Reports and Visualizations
- Managing Report Pages
- Navigating Through Pages
- Showing and Hiding Pages
- Adding Pages
- Deleting Pages
- Renaming Pages
- Changing Page Order
- Changing Report View Options
- Setting Page View Options
- Customizing Your View
- Using Phone vs. Desktop Layout
- Working with Visualizations
- Understanding Drill through Options
- Changing Category and Summarization Options
- Arranging Visualizations
- Editing Interactions
- About Custom Visualizations
- Adding Static Objects to a Report 190
- Inserting Pictures
- Inserting Text Boxes
- Inserting Shapes
- Working with Static Objects
- A Closer Look at Visualizations
- Matrixes, Tables, and Charts
- Creating a Table
- Creating a Matrix
- Overview of Chart Types
- Creating Charts
- Maps
- Creating a Treemap
- Creating a Bubble Map
- Creating a Filled Map
- Cards, Gauges, and KPIs
- Creating a Card
- Creating a Gauge
- Creating a KPI
- Slicers
- Creating a Slicer
- Using Slicers
- Customizing Slicer Display
- Changing Slicer Mode
- Changing Slicer Orientation
- Introduction to the Power BI Web App
- Getting Started
- Opening the Power BI Web App
- The Web App Interface
- Web App Building Blocks
- Key Differences
- Connecting to Data Sources with the Power BI Web App
- Connecting to Local Data
- Connecting to Live Data
- Connecting to Content Packs
- Connecting to Samples
- Using Workspaces, Dashboards, and Reports
- Viewing and Managing Power BI Content
- Viewing a Workspace
- Viewing Dashboards and Reports
- Managing Reports
- Creating Custom Dashboards
- Creating a Dashboard
- Pinning Visualizations to a Dashboard
- Adding Custom Tiles
- Managing Dashboards
- Power BI Web App Features
- Using Insights
This course is designed to provide participants with a fundamental understanding of the capabilities of Power BI. Students will discover how to quickly gather, cleanse and transform data with just a few clicks. They will also learn that to enhance results by integrating disparate data sources and add simple calculations using DAX functions and queries. Participants will create visualizations and incorporate them into dashboards that can provide up to the minute reporting. At the end of this course, participants will have a solid understanding of the skills required to use Power BI.
Training Exclusives
* Terms and conditions may apply. Learn more about our training exclusives by contacting training@dunnsolutions.com
Live Virtual:
Get engaging and impactful live, instructor-led training, regardless of your location.
Our Virtual Classroom Live online training format combines premium skills development technologies and our industry-leading instructors, content, exercises and peer collaboration to ensure that you get the highest quality professional development experience possible. Gain the skills and expertise that matter from the convenience of your home, work or wherever you have an Internet connection.
Engage with your instructor and fellow students via a learning platform and course material designed to ensure a stimulating and productive skills development experience.
Choose from sessions across a variety of time zones for training options that suit your schedule. Save time, money and effort without sacrificing learning quality by accessing our expert-led online training from the convenience of your home, office or anywhere with an Internet connection.
Attend from your PC, Mac or any iOS/Android tablet or smartphone. Connect with the class through your device audio or via toll-free phone number†, depending on available technologies and your interaction preferences.
Learn to leverage the power of Power BI. Discover how you can quickly gather, cleanse and transform your data with just a few clicks.
