Power BI Finance Dashboard; Power BI Tutorial Videos; New BI
4.2 (16 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
185 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Power BI Finance Dashboard; Power BI Tutorial Videos; New BI to your Wishlist.

Add to Wishlist

Power BI Finance Dashboard; Power BI Tutorial Videos; New BI

Power BI Training Course: Power BI desktop; From Excel to Power BI; Microsoft Power BI DAX; Advanced Power BI;
Bestselling
4.2 (16 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
185 students enrolled
Created by Amy Smith
Last updated 7/2017
English
Current price: $14 Original price: $100 Discount: 86% off
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 25 Articles
  • 16 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Create a Custom Theme in Power BI
  • Create a Dynamic Date Table in Power BI
  • Create a Dynamic Custom Date Table in Power BI
  • Create and use IF Functions in DAX with two or more conditions
  • Load data files to OneDrive for Business and find the OneDrive URL
  • Save time and money: Sync and refresh data automatically to the Power BI Service
  • Create Year to Date, Month to Date and Week to Date formulas in the Query Editor and in DAX
  • Compare data between Custom Quarter Periods in Power BI
  • Create Alert notifications in Power BI and automatically email alerts by using Microsoft Flow.
  • Post Power BI Alert notifications to your team with Microsoft Flow and Slack
  • Create A Finance Dashboard in Power BI.
  • Learn how to add Liquidity Ratio's and Activity Ratios to your Finance Dashboard in Power BI.
View Curriculum
Requirements
  • Power BI Beginner Basics
  • Know the basic of Power BI desktop such as "Get Data" and create basic Power BI visuals.
Description

Microsoft Power Bi Training Tutorials and Videos

Learn how to make less use of Excel, and how to use Power BI to analyse data.

Power BI is the Free business Intelligence software from Microsoft.

Microsoft Power BI is a suite of business analytics tools to analyze data and share insights. Monitor your business and get answers quickly with rich dashboards available on every device.


In this course you will learn how to:

  • Create a Financial Dashboard in Power BI Desktop.
    • Power BI Desktop: Data cleaning and structure
    • Create a Table for the Current Accounts
    • Add Profitability Ratio's.
    • Create an Income and Expense Statement
    • Create a Gross Profit % Graph (Compare to previous year and target)
    • Create a Sales Revenue Graph (Compare to target)
    • Create an Earnings Before Interest and Tax Graph (Compare to previous year and target)
    • Liquidity Ratio's: Add Current Ratio's and Quick Ratio's to the Power BI Dashboard
    • Activity Ratio's:  Add the Inventory Turnover and Average Collection Period to the Power BI Dashboard.
    • Activity Ratio's: Add the Average Payment Period and Total Asset Turnover
    • Add Debt Ratio's to the dashboard.
    • Publish and Share your dashboard in the Power BI Service.
  • Power BI Desktop: Create Dynamic Date Tables which will add days to the table automatically , on a daily basis.
  • Power BI: Create Dynamic Custom Date Tables: If the financial year do not start on the 1st of January.
  • Power BI: Create and compare data between custom quarter periods
  • Power BI: Create Year to Date, Month to Date and Week to Date formulas in the Query Editor and in DAX
  • Power BI: Create IF Functions - use multiple conditions
  • Power BI: Use OneDrive for business to sync and refresh files automatically
  • Power BI: Create a Custom Theme in Power BI
  • Power BI: Create Alerts and email alerts automatically with Microsoft Flow.
  • Power BI: Post Power BI alert notifications to your teams with Microsoft Flow and Slack.

The Power BI Service:

  • Use Content Packs to share your dashboards to the entire organisation.
  • Learn how to create and publish an APP in the Power BI Service: Apps are replacing Content Packs- Share your dashboards and reports.

Start reading and learning DAX.

With Reference to:

Power BI Training Tutorials and Video's

Microsoft BI

Microsoft Power BI

Power BI Tutorial

Power BI Training

Power BI Microsoft

MS Power BI

Power BI Dashboard

BI Online

Power BI Examples

Power BI Service

MSBI Tutorial

Power BI online training Courses and tutorials:  Learn about Power BI business intelligence.   

Power BI online training Courses and tutorials:  Learn to use the Power BI desktop toolset.   

Power BI online training Courses and tutorials:  We provide online Power BI training videos.   

Power BI online training Courses and tutorials:  Online training videos - learn how to analyze and visualize    data.

Power BI Training Courses How to create dashboards  

Power BI Training Courses Learn how to use the query editor  

Power BI Training Courses Learn how to create calculated columns  

Power BI Training Courses Learn how to use measures in dashboards  

Power BI Training Courses DAX functions  

Power BI Training Courses DAX formulas  

Power BI Training Courses Design Dashboards  

Power BI Training Courses Create Interactive graphs  

Power BI Training Courses Use the query editor  

Power BI Training Courses Refresh data automatically  

Power BI Training Courses Create your own theme  

Power BI Training Courses Use custom colors in dashboards  

Power BI Training Courses Learn Power BI fast  

Power BI Training Courses The fastest learning path  

Power BI Training Courses Data Cleaning  

Power BI Training Courses Data Modelling  

Power BI Training Courses Visualisations  

Power BI Training Courses Publishing and sharing  

Power BI Training Courses BI Business Solutions  

Power BI Training Courses Power BI Desktop  

Power BI Training Courses Guided Learning  

Power BI Training Courses Power BI Alerts  

Power BI Training Courses Power BI and Microsoft Flow  

Power BI Training Courses Use One Drive for Business  

Power BI Training Courses Gain Business Insights  

Power BI Training Courses Quick insights  

Power BI Training Courses Create and manage relationships  

Power BI Training Courses Connect to many different data sources  

Power BI Training Courses Calculated Tables  

Power BI Training Courses DAX formulas and Expressions  

Power BI Training Courses Content Packs and Groups  

Power BI Training Courses Data Security  

Power BI Training Courses Share your dashboards  

Power BI Training Courses Download to PowerPoint  

Power BI Training Courses Unlock Data Insights  

Power BI Training Courses Auto Publish Dashboards  

Power BI Training Courses Auto Refresh Dashboards  

Power BI Training Courses Learn at your own pace.  

Power BI Training Courses Visualize and share data insights  

Power BI Training Courses Easy to understand and learn  

Reference:   

   

Power BI Financial Dashboard   

Power BI Finance Dashboard   

Power BI Finance Dashboard 1   

Power BI Report Themes   

Power BI Dynamic Date Table   

Power BI Custom Date Table   

Power BI Year to Date, Month to Date, Week to Date   

Power BI If Functions   

Power BI OneDrive for Business   

Power BI OneDrive Auto Refresh and Sync Files   

Power BI Alerts Microsoft Flow   

Power BI Alerts Microsoft Slack   

Power BI Service   

Power BI Apps   

Power BI Content Packs   

Power BI On Premises Data Gateway   

Power BI Excel

Power BI Microsoft

Power BI Desktop

Power BI Free

Power BI advanced

Who is the target audience?
  • Anyone who wants to learn more about the Power BI Query Editor & M Language
  • Anyone who wants to learn how to Power BI with OneDrive for Business
  • Anyone who wants to learn how to create Power BI Alerts and Email Alerts with Microsoft Flow.
  • Anyone who wants to learn how to create a Finance Dashboard in Power BI.
Curriculum For This Course
47 Lectures
03:08:46
+
Power BI: Introduction and Preview of the Course
1 Lecture 01:40

Hi, and welcome to this Power BI Course.  This course is for anyone who wants to learn Query Editor and DAX functions.  This course will also show you how to use OneDrive for business and Microsoft Flow.

I hope that you will enjoy this course. 

Preview 01:40
+
Power BI Financial Dashboard
11 Lectures 41:08

Power BI Finance Dashboard: Learn How To:

Clean and Structure the Data - Get ready to create the Finance Dashboard.

  • Power BI: Add a matrix for the Current Assets and Current Liabilities
  • Power BI: Add a matrix for the Income and Expense Accounts
  • Power BI: Add a Sales Revenue Graph
  • Power BI: Add the Gross Profit % and compare to the prior year and to the target.
  • Power BI:  Add the Earnings Before Interest and Tax % and compare to the prior year and to the target.


Power BI Finance Dashboard: Add Current Accounts, Income / Expense, Etc.
14:13

Activity: Data Structure and Profitability Ratio's
00:25

Power BI Finance Dashboard:

In this lecture, I will show you how to add Liquidity Ratio's such as the Current Ratio and  Quick Ratio to the Power BI Finance Dashboard.

Power BI Finance Dashboards: Add Liquidity Ratios to Power BI Finance Dashboard
08:28

Activity: Add Liquidity Ratio's to the Finance Dashboard
00:15

Power BI Finance Dashboard:

Add Activity Ratio's such as the Inventory Turnover Period, Average Collection Period, Average Payment Period and Asset Turnover to the Power BI Finance Dashboard.

Power BI Finance Dashboard: Add Activity Ratios to Power BI Finance Dashboard
09:49

Activity: Add Activity Ratio's to your Finance Dashboard
00:10

Power BI Finance Dashboard:

Add the Debt Ratio and Times Interest Earned Ratio to your Power BI Dashboard.

Power BI Finance Dashboard: Debt Ratio's
05:04

Activity: Add Debt Ratio's to your Power BI Desktop.
00:07

List of Financial Ratio's
00:02

Publish your dashboard to the Power BI Service and Share with your teams.

Preview 02:24

Activity: Publish and share your Power BI Report
00:09
+
How to Create a Color Theme in Power BI
2 Lectures 05:50

Power BI: In this video you will learn how to use custom colors to create a Theme in Power BI.  Create the Theme in a Json file by using Hex color codes and change the colors of your dashboard instantly, by importing the Theme.

How to Create a Custom Color Theme in Power BI
05:49

Activity: Download the list of colors
00:01
+
Power BI: Create a dynamic Date Table: Preview
1 Lecture 00:37

Power BI:  Preview of the Date Table Lecture.

Preview 00:37
+
Power BI : Create a Dynamic Date Table in the Query Editor
1 Lecture 11:05

Power BI: Create a dynamic Date table which will automatically add a day to the calendar, daily. The Date table is the most important table in your data model, as you can only use time intelligence DAX functions if your date table was created correctly. In Power BI date tables are important to allow you to create relationships.

Power BI: Create a Date Table in the Query Editor
11:05
+
Power BI: Create a Custom Date Table
1 Lecture 14:20

Power BI:  Sometimes it may happen that the financial year of your company is different from the calendar year.  In this video, I will show you how to create a custom date table which, for example, starts on the 27th of December    (and not on the 1st of January).

Power BI: How to Create a Custom Date Table.
14:20
+
Power BI: Create Year to Date, Month to Date and Week to Date Functions
1 Lecture 06:49

Power BI:  In this video I will show you how to create Year to Date, Month to Date and Week to Date functions in the Power BI Query Editor and in DAX.  Use YTD, MTD and WTD functions to highlight important information  and to gain insights into the data of your dashboards.

Power BI: Create Year to Date, Month to Date and Week to Date Functions
06:49
+
Power BI: Compare Data between Custom Quarter Periods
1 Lecture 12:05

Power BI:  In this video you will learn how to create a function which will show you the last value in a period as well as how to compare data between Custom Quarter Periods. 

Power BI: Compare Data between Custom Quarter Periods
12:05
+
Power BI: IF Function with Two or More Conditions
1 Lecture 04:17

Power BI:  You probably already know how important the IF function is to create data models.  In this video I will show you how to create the IF Function, which can be used with more that one conditions.   For example, if you want to write a formula to state that IF the season is "Summer" and the number is "1200" and the grade is "B", then the answer must be "Great". I will show you how to create an IF function across different data tables. 

Power BI: IF Function with Two or More Conditions
04:17
+
Power BI: Find the OneDrive for Business URL and Sync Files
1 Lecture 08:20

Power BI:  Learn how to create an OneDrive for Business account and how to find the OneDrive URL to be used in the Power BI desktop. 

Preview 08:20
8 More Sections
About the Instructor
Amy Smith
4.1 Average rating
84 Reviews
3,058 Students
5 Courses
VR BI Business Intelligence

VR BI Business Intelligence was created to provide step by step online Power BI training which will be easy to follow and implement in your business.

Power BI is the free business analytics tool from Microsoft.

Our goal is to focus on you - the Power BI user - and to provide training which will help you in your career and business.

We have more than 35 years experience in Business, Finance and Business Intelligence.

Our team members have gained experience in many business areas such as retail, manufacturing and consulting.

Our team members have the below university degrees which proof that we have the relevant credentials to provide business training:

ACMA;  CGMA

CIMA (Chartered Institude of Management Accounting)

Honours Degree: Management Accounting

Bcom Degree: Management Accounting