Preparing Your Data With Power BI
Learn how to prepare and format data in Power BI for professional looking reports.
Your data is only as good as the information you can derive from it. Power BI enables you to gain better business insights and make more informed business decisions. In 90% of cases, the data that you load into Power BI (from a database, an Excel® file, a website, etc.) needs work before it can be considered report-ready. Unnecessary columns may need to be deleted, dates reformatted, filters applied and so on.
In this material, you will learn, using practical examples, how to clean and transform your imported data to make it report-ready. Take your reporting capabilities to the next level by learning how to leverage the functionality of Power BI with this information.
• You will be able to describe how to remove columns from your imported data.
• You will be able to identify how to apply filters.
• You will be able to recognize how to clean and transform your imported data to make it report-ready.
• You will be able to explain how to split a single column into multiple columns.