This course is designed for professionals responsible for connecting to cloud-based data sources and shaping and combining data for analysis. In this 3-day course, you will learn the same skillset for creating compelling and interactive worksheets, dashboards, and stories, as well as advanced analysis techniques, enhanced reporting, and publishing.
Learning Objectives »
- Analyze data with self-service BI.
- Connect to data sources.
- Perform data cleaning, profiling, and shaping.
- Visualize data with Power BI.
- Add and customize visual elements.
- Model data with calculations.
- Customize and filter visualizations.
- Use advanced analysis techniques.
- Share reports and create dashboards.
- Manage and collaborate in the Power BI Service.
- Enhance reports and dashboards.
Course Agenda
Analyzing Data & Reporting
- Data Analysis and Visualization for BI
- Interact with Reports in Power BI
Connecting to Data Sources
- Creating Data Connections
- Configure and Manage Data Relationships
- Save Files in Microsoft Power BI
- Secure and Troubleshoot Connections
Cleaning, Transforming, & Loading Data
- Load, Clean, and Shape Data
- Profile Data with the Query Editor
- Shape Data with the Query Editor
- Transform Data with the Query Editor
Visualizing Data with Power BI
- Create Visualizations in Power BI
- How to Select Visualization Types
Enhancing Visuals for Data Analysis
- Customize Visuals and Pages
- Incorporate Tooltips
Modeling Data with Calculations
- How to Create Calculated Columns with DAX
- Creating Calculated Measures
- Using Conditional Columns
Customizing & Filtering Reports
- Create Data Hierarchies
- Filter Reports
- Discover Time-Intelligence Insights
- How to Configure Slicers for Interactive Filtering
Sharing Reports & Creating Dashboards
- Publish and Explore Reports
- How to Create Dashboards
- Adding Q&A to Dashboards
Management & Collaboration
- Managing Workspaces and Sharing Content
- How to Collaborate with the Power BI Service
Enhancing Reports & Dashboards
- Optimizing Usability and Performance
- Creating Mobile Reports for Power BI