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

Практики создания аналитических панелей в среде Microsoft Power BI
Saint Petersburg State University via Coursera
Практики анализа экономических данных от простого к сложному
Saint Petersburg State University via Coursera
Getting Started with Power BI Desktop
Coursera Project Network via Coursera
Curso Completo de Power BI Desktop
Coursera Project Network via Coursera
Inteligencia Artificial en Power BI
Coursera Project Network via Coursera