Learn comprehensive data cleansing, shaping, modeling, visualization, and analysis techniques. Perform advanced data analysis using both Power BI Desktop and service platforms. Build professional visualizations and interactive reports. Develop skills in managing Power BI resources, including reports, dashboards, workspaces, security settings, performance optimization, and sophisticated analytical methods. This course prepares you for the Microsoft Power BI certification.
Topics and Learning Outcomes
- Analyzing Data with Self-Service BI: Tour the Power BI Desktop interface, including views, datasets, reports, canvas design, fields pane, and visualizations pane.
- Connecting to Data Sources: Connect to various data sources and configure relationships between datasets.
- Performing Data Cleaning, Profiling, and Shaping: Use the Query Editor to clean, profile, and shape data effectively.
- Visualizing Data with Power BI: Create a variety of visualizations, including tables, maps, gauge and number cards, combination charts, scatter plots, and KPI indicators.
- Enhancing Data Analysis: Customize visuals and report pages, configure custom tooltips, and report page tooltips.
- Modeling Data with Calculations: Create calculations using DAX, build calculated measures, and establish conditional columns.
- Creating Interactive Visualizations: Build data hierarchies, apply filters and slicers to reports, and create comprehensive dashboards.
- Advanced Analysis Techniques: Construct calculated tables, apply statistical analysis, including reference lines, trend lines, averages, and forecasting. Implement Key Influencers and Decomposition Tree visualizations.
- Enhancing Reports and Dashboards: Create navigation buttons, apply bookmarks and alternate text, and use Performance Analyzer. Add quick insights to dashboards, apply themes, set data alerts, and configure mobile layouts.
- Publishing and Sharing Reports and Dashboards: Publish reports, manage data refresh schedules, create and manage workspaces, and configure row-level security.
