Learn how to transform Excel data into visually striking and interactive reports using Microsoft Power BI in this 30-minute tutorial. Import data from an Excel workbook, create relationships between tables, and design various chart types including line, map, and column charts. Master essential skills such as writing DAX expressions for measures and tables, customizing visuals, and applying themes to enhance your report's appearance. Discover how to filter data using slicers and share your finished Power BI report with others. Download Power BI for free and follow along with provided practice data to create professional-looking data visualizations.
How to Transform Excel Data into a Striking Visual Report with Microsoft Power BI
Overview
Syllabus
Introduction to Power BI
Get data into Power BI
Transform data
Making changes to columns in Power BI
Examining the fields in Power BI
New Measure - Write Dax Expression - Total Units Sold = SUMfinancials[Units Sold]
New Table - Write Dax Expression - Calendar = CALENDARDATE2020,01,01,Date2021,12,31
Create a relationship between two tables in Power BI
Add a title in a text box in Power BI
Add visual first visual, modify it to a line chart
Add a map chart in Power BI
Add a column chart
Filter data more by adding a slicer visual in Power BI
Customizing your report. Making it look fantastic!
Changing themes in Power BI
Sharing your Power BI report with others
Taught by
Teacher's Tech
