This series is designed for professionals responsible for connecting to cloud-based data sources and shaping and combining data for analysis. The Data Analysis Practitioner and Professional Series combines the Practitioner and Professional Courses for a power-packed 3-day series. You will learn to create compelling and interactive worksheets, dashboards, and stories. You will also apply 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.
- Enhance data analysis with customized visual elements.
- Model data with calculations.
- Create interactive visualizations.
Course Agenda
Data Analysis Practitioner
Analyzing Data with Self-Service BI
- Data Analysis and Visualization for BI
- Self-Service BI with Microsoft Power BI
Connecting to Data Sources
- Create Data Connections
- Manage Data Relationships
- Save Files in Power BI
Data Cleaning, Profiling, and Shaping
- Clean, Transform, and Load Data
- Profile Data with the Query Editor
- Shape Data with the Query Editor
- Combine and Manage Data Rows
Visualizing Data with Power BI
- Create Visualizations in Power BI
- Chart Data in Power BI
Enhancing Data Analysis
- Customize Visuals and Pages
- Incorporate Tooltips
Modeling Data with Calculations
- Use Data Analysis Expressions (DAX)
- Calculated Measures and Columns
Creating Interactive Visualizations
- Create and Manage Data Hierarchies
- Filter and Slice Reports
- Create Dashboards
Data Analysis Professional
Using Advanced Analysis Techniques
- Tables, Variables, and Parameters
- Visuals with Statistical Analysis
- Perform Advanced Analysis
Enhancing Reports and Dashboards
- How to Enhance Reports
- How to Enhance Dashboards
Enhancing Reports and Dashboards
- Publish Reports
- Create and Manage Workspaces
- Share Reports and Dashboards
Extending Power BI
- Use Power BI Mobile
- Extend Access with the Power BI API