No Messages
Power BI Intermediate Course - Beyond the Basics
Description
Power BI is a powerful, self-service Business Intelligence (BI) solution from Microsoft. It aims to provide interactive visualizations and is used to import, transform, and analyze data. Power BI has a user-friendly interface ideal for people with a limited technical background to create stunning Power BI reports and Power BI dashboards. If you are brand new to Power BI, you can take this course, but we also suggest you search for Power BI Simon Sez IT to see our beginners Power BI course! This Power BI course starts by recapping some of the Power BI basics such as Power Query, DAX in Power BI, and sorting and cleaning data in Power BI, before moving on to how to create Power BI visualizations and Power BI Dashboards. In this course, we start off by going through the data In the final part of this Power Bi course, we take you through a follow-along exercise so you can put what you have learned into practice. This course also includes course files to follow along with the instructor and uses the Power BI Desktop version. In this course you will learn: ● How to Import and Transform Data in Power Query ● How to import Excel, Text, and CSV files and combine files ● How to enable/disable Load and Report Refresh ● How to resolve Data Import Errors ● Data Modelling, Relationship Types, and Troubleshooting Relationship Issues ● Measures vs Calculated Columns ● How to create a Date Table with DAX ● How to create Additional and Conditional Columns ● How to use ROUNDUP and SUMX ● How to create Quick Measures and a Key Measures Table ● The CALCULATE Function in DAX ● Tables vs Matrix Tables ● How to Format Visualizations and apply Conditional Formatting ● Column, Line, and Map Charts ● Gauge and Card Visualizations ● How to use Slicers and Filter and apply Design Elements ● How to create a Shared Workspace in Power BI Service ● How to create Reports and Dashboards ● How to pin Visualizations to the Dashboard ● How to set up Scheduled Refreshes 6+ hours of video tutorials 68 individual video lectures Course Instructor Files included to follow along