00:00
00:00
34
views
Share the link to this page
Copied

About the Class

In today's busy world, we are all presented with overwhelming amounts of data, and we are given the task of making sense of that data. It can be a very time-consuming task to pull all of this data together and somehow make sense of this large amount of data.

Microsoft has come up with 2 great tools, Power Query and Power BI, which can help you gather your data, and report on it in many ways. This course will show you how to gather and manipulate your data using Power Query, and then how to make the data visually appealing and dynamic with PowerBI. Power Query is really built into the desktop version of Power BI.

Topics covered:

  • Downloading Powe rBI
  • Tour of screen
  • Importing data from Excel Normal data, Formatted data
  • Text Access SQL
  • Server web building and managing different visuals
  • Adding and managing Slicers
  • Add columns, Delete column, Merge columns, Split columns, Conditional column
  • Date fields, Number fields, Text fields
  • Quick measure: Filters Running, Total Year to Year Change

Author

Tom Fragale - Microsoft Certified Trainer

Tom Fragale - Microsoft Certified Trainer - PCWebinars.com
Tom Fragale is a computer professional with over 30 years of professional experience. He is a Microsoft Certified Trainer, a Microsoft Certified Office Master, and a Microsoft Certified Expert in Word and Excel., and a Microsoft Certified Specialist in Access, Outlook, and PowerPoint. He has trained over 30,000 business people in on-line...

School

Tom Fragale - Microsoft Certified Trainer's School

Requirements

There are no additional requirements.
One-time Fee
$39.99
List Price:  $99.99
You save:  $60
€33.91
List Price:  €84.79
You save:  €50.88
£29.28
List Price:  £73.22
You save:  £43.94
CA$54.35
List Price:  CA$135.90
You save:  CA$81.54
A$60.81
List Price:  A$152.06
You save:  A$91.25
S$50.90
List Price:  S$127.29
You save:  S$76.38
HK$313.91
List Price:  HK$784.91
You save:  HK$470.99
CHF 31.70
List Price:  CHF 79.26
You save:  CHF 47.56
NOK kr402.73
List Price:  NOK kr1,006.99
You save:  NOK kr604.25
DKK kr253.03
List Price:  DKK kr632.67
You save:  DKK kr379.64
NZ$65.86
List Price:  NZ$164.67
You save:  NZ$98.81
د.إ146.88
List Price:  د.إ367.26
You save:  د.إ220.38
৳4,877.63
List Price:  ৳12,195.90
You save:  ৳7,318.27
₹3,411.06
List Price:  ₹8,528.94
You save:  ₹5,117.87
RM168.87
List Price:  RM422.25
You save:  RM253.38
₦61,129.91
List Price:  ₦152,847.71
You save:  ₦91,717.80
₨11,376.21
List Price:  ₨28,444.79
You save:  ₨17,068.58
฿1,295.62
List Price:  ฿3,239.55
You save:  ฿1,943.92
₺1,594.95
List Price:  ₺3,987.98
You save:  ₺2,393.03
B$217.25
List Price:  B$543.21
You save:  B$325.96
R700.58
List Price:  R1,751.73
You save:  R1,051.14
Лв66.28
List Price:  Лв165.73
You save:  Лв99.45
₩54,435.07
List Price:  ₩136,108.10
You save:  ₩81,673.03
₪134.41
List Price:  ₪336.07
You save:  ₪201.66
₱2,251.63
List Price:  ₱5,629.93
You save:  ₱3,378.30
¥5,752.84
List Price:  ¥14,384.26
You save:  ¥8,631.42
MX$750.15
List Price:  MX$1,875.65
You save:  MX$1,125.50
QR145.40
List Price:  QR363.56
You save:  QR218.16
P529.27
List Price:  P1,323.39
You save:  P794.11
KSh5,168.70
List Price:  KSh12,923.70
You save:  KSh7,755
E£1,973.48
List Price:  E£4,934.44
You save:  E£2,960.96
ብር5,501.69
List Price:  ብር13,756.30
You save:  ብር8,254.60
Kz36,469.08
List Price:  Kz91,186.39
You save:  Kz54,717.30
CLP$37,041.13
List Price:  CLP$92,616.73
You save:  CLP$55,575.60
CN¥286.35
List Price:  CN¥715.99
You save:  CN¥429.64
RD$2,370.01
List Price:  RD$5,925.92
You save:  RD$3,555.91
DA5,171.86
List Price:  DA12,931.59
You save:  DA7,759.73
FJ$89.40
List Price:  FJ$223.54
You save:  FJ$134.14
Q307.45
List Price:  Q768.75
You save:  Q461.29
GY$8,365.34
List Price:  GY$20,916.50
You save:  GY$12,551.16
ISK kr4,835.59
List Price:  ISK kr12,090.79
You save:  ISK kr7,255.20
DH358.50
List Price:  DH896.39
You save:  DH537.89
L673.46
List Price:  L1,683.90
You save:  L1,010.44
ден2,086.74
List Price:  ден5,217.64
You save:  ден3,130.89
MOP$323.30
List Price:  MOP$808.38
You save:  MOP$485.08
N$704.53
List Price:  N$1,761.61
You save:  N$1,057.07
C$1,467.47
List Price:  C$3,669.24
You save:  C$2,201.76
रु5,466.79
List Price:  रु13,669.04
You save:  रु8,202.24
S/142.03
List Price:  S/355.14
You save:  S/213.11
K165
List Price:  K412.57
You save:  K247.56
SAR149.97
List Price:  SAR374.99
You save:  SAR225.01
ZK958.24
List Price:  ZK2,395.96
You save:  ZK1,437.72
L171.60
List Price:  L429.06
You save:  L257.46
Kč836.06
List Price:  Kč2,090.48
You save:  Kč1,254.41
Ft13,541.18
List Price:  Ft33,858.04
You save:  Ft20,316.85
SEK kr381.56
List Price:  SEK kr954.05
You save:  SEK kr572.49
ARS$48,227.94
List Price:  ARS$120,587.94
You save:  ARS$72,360
Bs276.28
List Price:  Bs690.81
You save:  Bs414.53
COP$160,620.32
List Price:  COP$401,611.06
You save:  COP$240,990.74
₡20,148.37
List Price:  ₡50,378.49
You save:  ₡30,230.12
L1,042.32
List Price:  L2,606.20
You save:  L1,563.87
₲318,937.74
List Price:  ₲797,463.99
You save:  ₲478,526.25
$U1,577.97
List Price:  $U3,945.53
You save:  $U2,367.55
zł144.32
List Price:  zł360.85
You save:  zł216.53

What's Included

Language: English
Level: Intermediate
Skills: Power Query, Power Bi, Excel, Dashboards, Slicers, SQL, Microsoft, Data Management
Age groups: All ages
Duration: 2 hours 14 minutes
1 Video
0
Saves
34
Views
This class has not been saved

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.