00:00
00:00
31
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
€35.23
List Price:  €88.09
You save:  €52.86
£29.97
List Price:  £74.95
You save:  £44.97
CA$55.49
List Price:  CA$138.76
You save:  CA$83.26
A$62.52
List Price:  A$156.34
You save:  A$93.81
S$52.53
List Price:  S$131.36
You save:  S$78.82
HK$310.20
List Price:  HK$775.63
You save:  HK$465.42
CHF 33.18
List Price:  CHF 82.97
You save:  CHF 49.79
NOK kr417.12
List Price:  NOK kr1,042.97
You save:  NOK kr625.84
DKK kr262.98
List Price:  DKK kr657.56
You save:  DKK kr394.57
NZ$67.22
List Price:  NZ$168.07
You save:  NZ$100.85
د.إ146.88
List Price:  د.إ367.27
You save:  د.إ220.38
৳4,854.94
List Price:  ৳12,139.17
You save:  ৳7,284.23
₹3,400.46
List Price:  ₹8,502.43
You save:  ₹5,101.97
RM174.47
List Price:  RM436.25
You save:  RM261.78
₦64,370.30
List Price:  ₦160,949.90
You save:  ₦96,579.60
₨11,244.10
List Price:  ₨28,114.47
You save:  ₨16,870.37
฿1,345
List Price:  ฿3,363.01
You save:  ฿2,018.01
₺1,537.35
List Price:  ₺3,843.97
You save:  ₺2,306.61
B$227.56
List Price:  B$568.99
You save:  B$341.43
R746.31
List Price:  R1,866.07
You save:  R1,119.75
Лв68.86
List Price:  Лв172.18
You save:  Лв103.32
₩57,748.25
List Price:  ₩144,392.30
You save:  ₩86,644.04
₪145.20
List Price:  ₪363.07
You save:  ₪217.86
₱2,254.59
List Price:  ₱5,637.33
You save:  ₱3,382.74
¥5,737.21
List Price:  ¥14,345.18
You save:  ¥8,607.97
MX$781.41
List Price:  MX$1,953.82
You save:  MX$1,172.41
QR145.64
List Price:  QR364.17
You save:  QR218.52
P550.79
List Price:  P1,377.18
You save:  P826.39
KSh5,170.70
List Price:  KSh12,928.70
You save:  KSh7,758
E£2,032.60
List Price:  E£5,082.28
You save:  E£3,049.67
ብር5,332.81
List Price:  ብር13,334.03
You save:  ብር8,001.21
Kz36,690.82
List Price:  Kz91,740.82
You save:  Kz55,050
CLP$37,388.65
List Price:  CLP$93,485.65
You save:  CLP$56,097
CN¥291.43
List Price:  CN¥728.69
You save:  CN¥437.26
RD$2,363.55
List Price:  RD$5,909.76
You save:  RD$3,546.21
DA5,303.53
List Price:  DA13,260.83
You save:  DA7,957.29
FJ$90.33
List Price:  FJ$225.87
You save:  FJ$135.53
Q307.75
List Price:  Q769.50
You save:  Q461.75
GY$8,360.05
List Price:  GY$20,903.27
You save:  GY$12,543.21
ISK kr5,126.31
List Price:  ISK kr12,817.71
You save:  ISK kr7,691.40
DH370.67
List Price:  DH926.83
You save:  DH556.15
L685.05
List Price:  L1,712.89
You save:  L1,027.84
ден2,168.44
List Price:  ден5,421.92
You save:  ден3,253.48
MOP$319.26
List Price:  MOP$798.27
You save:  MOP$479.01
N$754.10
List Price:  N$1,885.54
You save:  N$1,131.43
C$1,470.41
List Price:  C$3,676.59
You save:  C$2,206.17
रु5,457.63
List Price:  रु13,646.12
You save:  रु8,188.49
S/146.77
List Price:  S/366.98
You save:  S/220.21
K163.05
List Price:  K407.70
You save:  K244.65
SAR150.01
List Price:  SAR375.08
You save:  SAR225.07
ZK1,115.81
List Price:  ZK2,789.96
You save:  ZK1,674.14
L175.39
List Price:  L438.55
You save:  L263.16
Kč879.98
List Price:  Kč2,200.28
You save:  Kč1,320.30
Ft14,280.72
List Price:  Ft35,707.16
You save:  Ft21,426.44
SEK kr387.22
List Price:  SEK kr968.20
You save:  SEK kr580.97
ARS$46,738.10
List Price:  ARS$116,862.79
You save:  ARS$70,124.69
Bs276.12
List Price:  Bs690.41
You save:  Bs414.28
COP$170,645.83
List Price:  COP$426,678.59
You save:  COP$256,032.75
₡20,225.84
List Price:  ₡50,572.20
You save:  ₡30,346.35
L1,035.92
List Price:  L2,590.19
You save:  L1,554.27
₲319,640.26
List Price:  ₲799,220.57
You save:  ₲479,580.30
$U1,670.31
List Price:  $U4,176.41
You save:  $U2,506.09
zł150.68
List Price:  zł376.76
You save:  zł226.08

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
31
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.