Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Explore Power BI Desktop World! [Basics+2022]

Name: Explore Power BI Desktop World! [Basics+2022]
Rating: 4.5 (1079 reviews)

Step into creative, data analyzing & reporting

Created bySama Tamhidi

Last updated 7/2022

English

English [Auto],

What you'll learn

Power Bi Steps
Get Data
Transform Data
Use Dax
Model the Data
Visualize the Data
Publish the Data

Course content

3 sections • 17 lectures • 1h 30m total length

introduction3:56
learn to build a practical power bi dashboard from excel data, transform models, and visualize insights to tell a compelling data story.

1. What is Power BI?2:00
Power BI Desktop is the core tool for connecting data resources, transforming queries, modeling data, and visualizing insights. Share reports via Power BI cloud and access them on mobile apps.
2. Download and Install Power BI3:34
Power BI Desktop is a free tool for visualizing reports; download and install via the Microsoft page, choose 64-bit or 32-bit, select English, and complete the setup.
3. General Acquaintance of Power Bi4:03
Navigate the Power BI Desktop interface, mastering ribbons and tabs, left options, and right fields to fetch data from Excel workbooks, transform and model it, then visualize reports.
4. What should I do Now2:55
Design a Power BI desktop dashboard by integrating Primavera and Excel data to compare budget plan costs, actual costs, physical percent complete, and plan cost percentile charts.
5. Start Power BI by getting Data4:23
Open excel workbooks, load planned cost and actual cost data into Power BI, transform the data, build a model, and visualize weekly timelines for cost tracking.
6-1. Second Step-Transform Data6:15
Set headers from the first row, remove blank rows, filter out zeros, change the total column to fixed decimal numbers, pivot columns, and load the transformed data into Power BI.
6-2. Second Step-Transform Data4:23
Transform actual cost data in Power BI by importing from Excel, setting headers, cleaning rows, filtering zeros, formatting numbers, selecting columns, pivoting by state and actual cost, and applying changes.
7. Third Step-Data Model4:23
Learn how to create a data model in Power BI by linking plan costs and actual costs through a shared activity key, enabling linked visualizations.
8. Fourth Step-Visualization9:38
Build Power BI dashboards by configuring page size, adding budget, plan costs, and actual costs cards, creating visuals like stacked area chart, donor chart, clustered bar chart, and waterfall chart.
9-1. Dax in Power BI7:13
Learn to create a DAX measure in Power BI that calculates overruns by subtracting actual cost from budget, using if logic to show the overall result, including absolute value.
9-2.Dax in Power BI5:52
Create dax measures for actual cost and planned costs percent, add them to charts, and build a dashboard with a slicer for interactive filtering.
10. Designing Power BI Report9:57
Resize and align visuals in Power BI dashboard, adjust colors and wallpaper, add a title and date card, import and configure a timeline visual, and use slicers for dynamic filtering.
11-1. Tell Story with Power BI by Designing6:11
Design a dashboard as a story in Power BI by choosing a suitable design frame, unified colors, and readable fonts to guide the audience without confusion.
11-2. Tell Story with Power BI by Designing7:41
Learn to tell a story in Power BI by designing visuals—adjusting colors, backgrounds, titles, and images; grouping cards, renaming fields, and refreshing data to publish a polished dashboard.
12.Publish the Report6:14
Publish your Power BI reports from desktop to the cloud using Power BI Pro or Power BI Service, then share, access on mobile, or export to PDF.

Requirements

A Computer
An enthusiasm Learner
Having Excel Knowledge is beneficial

Description

Explore Power BI World with illustrated, visualized, and well-framed Course.

In this Trip which we start Together you will learn the steps of Power BI, first we Get the Data then Transform it, model the data and use dax finally visualise then publish the report:

What you learn

This course teaches you to create well-designed Power BI dashboards.

You will be familiar with essential Power Bi steps, use Dax, transforming data, modeling and linking two data, create a unique report, and Publish it.

Power Bi Steps:

· Get Data

· Transform the Data

· Model the Data (Link Data)

· Visualize The Data

· Update the Data

· Use Dax in Power BI (dax or it is called Measure in Power BI)

· Create a Unique Report

· Publish the Report

(this happens with PDF Format, but for publishing for a range of people we need to sign in to Power BI Cloud (pro) with Microsoft Account)

In this course, we tried to simplify the way of learning by using the most important knowledge you need to run a report, after that with high-quality videos and act of needs to present the data or even Analyse the data.

We would be happy to see you on this Trip.