This course is designed for professionals responsible for connecting to cloud-based data sources, as well as shaping and combining data for the purpose of analysis. The Data Analysis Professional course picks up where Data Analysis Practitioner leaves off and dives deeper into features often used by data scientists, such as advanced analysis techniques, enhanced reporting and publishing, and extending Power BI beyond the desktop.
Learning Objectives »
- Analyze data with self-service BI.
- Perform data cleaning, profiling, and shaping.
- Enhance data analysis with visual elements.
- Model data with calculations.
- Create interactive visualizations.
- Use advanced analysis techniques.
- Enhance reports and dashboards.
- Extend Power BI beyond the desktop.
Course Agenda
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
- Configure and 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 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
Using Advanced Analysis Techniques
- Calculated Tables, Variables, & Parameters
- Enhance Visuals with Statistical Analysis
- Perform Advanced Analysis
Enhancing Reports and Dashboards
- Enhance Reports
- Enhance Dashboards
Publishing and Sharing
- Publish Reports
- Create and Manage Workspaces
- Share Reports and Dashboards
Extending Power BI
- Use Power BI Mobile
- Extend Access with the Power BI API
