YoVDO

How to Transform Excel Data into a Striking Visual Report with Microsoft Power BI

Offered By: Teacher's Tech via YouTube

Tags

Microsoft Excel Courses Data Visualization Courses Microsoft Power BI Courses DAX (Data Analysis Expressions) Courses Data Transformation Courses

Course Description

Overview

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.

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

Related Courses

Introduction to Computational Finance and Financial Econometrics
University of Washington via Coursera
Excel 2010
Miríadax
The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd
Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity
Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard