Overview

**This course includes downloadable course instructor files to follow along.**Power BI is a powerful business analytics service from Microsoft. It provides interactive visualizations and business intelligence solutions. Power BI has an intuitive interface, enabling users at all skill levels to create their own reports and dashboards.This intermediate training course is designed to be a continuation of the introductory Power BI course. If you have no experience with the software, we recommend starting with that course, which will familiarize you with the Power BI basics and interface, basic knowledge that is a prerequisite for the intermediate level.We start the intermediate course by discussing the data files to be used and some Power BI desktop settings that will set you up for success. The latter part of the course is an intensive exercise to give you practice creating reports and dashboards.This course includes course files to follow along with your instructor and uses the Power BI Desktop version.This course will cover:Importing and transforming data in Power QueryImporting Excel, text, and CSV files and combining filesEnabling/disabling load and report refreshResolving data import errorsData modeling, relationship types, and troubleshooting relationship issuesMeasures vs. calculated columnsCreating a date table with DAXCreating additional and conditional columnsUsing the ROUNDUP and SUMX functionsCreating quick measures and key measures tablesThe DAX - CALCULATE functionTables vs. matrix tablesFormatting visualizations and applying conditional formattingUsing column, line, and map chartsGauge and card visualizationsUsing slicers and filters and applying design elementsCreating a shared workspace in Power BI serviceBuilding reports and dashboardsPinning visualizations to the dashboardSetting up scheduled refreshesThis course includes:6+ hours of video tutorials68 individual video lecturesCourse instructor files so you can follow alongCertificate of completionHere's what our students are saying.★★★★★ "I like everything! Everything is clear and understandable. Perfect courses!" -Jovita Svilainiena

Skills

Reviews