About
About Us
Help
Privacy Policy
Terms of Service
LearnDesk
Learn
Academics
Business
Creative
Health and Fitness
Lifestyle
Personal Development
Software
Topics
Admissions
Engineering
Hardware
Hospitality
Humanities
Chinese
Languages
Maths
Pharma
View All Topics
Topics
Accounting
Advertising
Analysis
Analytics
Business Communication
eCommerce
Entrepreneurship
Finance
Finance - India
Freelancing
View All Topics
Topics
Arts & Crafts
Audio Editing
Audio Production
Dance
Design
Film Production
Music
Photography
Video Production
Writing
View All Topics
Topics
Dieting
Fitness
Food Safety
Games
Medical
Medical Professionals
Meditation
Mental Health
Pregnancy
Safety & First Aid
View All Topics
Topics
Beauty & Makeup
Food
Fashion
Gaming
Home Improvement
Parenting
Pet Care & Training
Relationships
Sustainable Living
View All Topics
Topics
Career Development
Learning
Religion and Spirituality
Self-Improvement
View All Topics
Topics
Accounting
Amazon Web Services
App Development
Continuous Integration
Backup Software
Business Automation
Computational Fluid Dynamics
Business Intelligence
Computer Aided Design (CAD)
View All Topics
Teach
Teach Online
Schedule
Items
Billing
Users
Marketing
Analytics
Settings
Change School
Account
Log In
Sign Up
Introduction to PowerQuery
Course Introduction
Introduction
Preview
Connecting To Data
Local Data Sources
Common External Data Sources
Data Access Exercise Files
Challenge: Connecting to Data
Linking and Organizing Data
Standard Organizational Commands
Connecting Data via the Append Command
Append Command Practice File
Append Command Practice Solution
Linking Datasets via the Merge Command
Preview
Merge Command Practice Start
Merge Command Practice Solution
Venn Diagram
Aggregation Commands
Aggregation Commands Excel File
Expand and Contract Data - Column Pivots
Column Pivots Practice File
Column Pivots Solution File
Linking and Organizing Data Exercise
Linking and Organizing Data: Solution Video
Linking and Organizing Data Solution File
Data Transformations
Introduction to Data Types
Data Type Introductory Challenge
Data Type Introductory Challenge Solution
Text Data Types
Text Data Types Practice Set File
Text Data Types Practice Solution
Number Data Types
Number Data Types Practice Set
Date/Time and Duration Data Types
Date/Time Durations Practice Set
Custom Calculation Definitions
Adding New Columns
Adding Columns Practice Set
Creating Conditional Columns
Conditional Columns Practice Set
PowerQuery Intellitext Update
Preview
Creating Custom Columns
Custom Columns Practice Set
Custom Columns Practice Solution
Custom Column Formula Functions
Custom Column Formula Practice Set
Custom Column Formula Practice Solution
Practical Application
Insttructions for Step 1
CSV File For 20170109
Instructions for Step 2
Step 2 Supporting Data
Instructions for Step 3
Step 3 Supporting Data
Practical Application Solution
Preview
Course Wrap-Up
Conclusion
Preview
Text Data Types Practice Solution
Introduction to PowerQuery
Data Transformations
By:
Explainly
Share
Share the link to this page
Copied
Facebook
Twitter
WhatsApp
LinkedIn
Email
Add to Calendar
Add the class to your calendar
Add to Google Calendar
Add to Apple Calendar
Add to Yahoo Calendar
Add to Outlook Calendar
Print
Completed
You need to have access to the item to view this lesson.
One-time Fee
$69.99
List Price:
$99.99
You save:
$30
Buy Class
€65.22
List Price:
€93.18
You save:
€27.95
Buy Class
£56.04
List Price:
£80.07
You save:
£24.02
Buy Class
CA$96.09
List Price:
CA$137.28
You save:
CA$41.18
Buy Class
A$106.44
List Price:
A$152.07
You save:
A$45.62
Buy Class
S$94.93
List Price:
S$135.63
You save:
S$40.69
Buy Class
HK$547
List Price:
HK$781.46
You save:
HK$234.46
Buy Class
CHF 63.65
List Price:
CHF 90.94
You save:
CHF 27.28
Buy Class
NOK kr765.05
List Price:
NOK kr1,092.98
You save:
NOK kr327.92
Buy Class
DKK kr486.48
List Price:
DKK kr695
You save:
DKK kr208.52
Buy Class
NZ$116.68
List Price:
NZ$166.69
You save:
NZ$50.01
Buy Class
د.إ257.06
List Price:
د.إ367.25
You save:
د.إ110.18
Buy Class
৳7,685.71
List Price:
৳10,980.05
You save:
৳3,294.34
Buy Class
₹5,844.71
List Price:
₹8,349.95
You save:
₹2,505.23
Buy Class
RM331.80
List Price:
RM474.03
You save:
RM142.22
Buy Class
₦98,423.43
List Price:
₦140,610.93
You save:
₦42,187.50
Buy Class
₨19,474.95
List Price:
₨27,822.55
You save:
₨8,347.60
Buy Class
฿2,584.73
List Price:
฿3,692.63
You save:
฿1,107.90
Buy Class
₺2,255.06
List Price:
₺3,221.65
You save:
₺966.59
Buy Class
B$356.31
List Price:
B$509.04
You save:
B$152.73
Buy Class
R1,298.99
List Price:
R1,855.78
You save:
R556.79
Buy Class
Лв127.57
List Price:
Лв182.26
You save:
Лв54.68
Buy Class
₩95,950.21
List Price:
₩137,077.60
You save:
₩41,127.39
Buy Class
₪261.40
List Price:
₪373.45
You save:
₪112.04
Buy Class
₱4,015.50
List Price:
₱5,736.67
You save:
₱1,721.17
Buy Class
¥10,912.42
List Price:
¥15,589.84
You save:
¥4,677.42
Buy Class
MX$1,187.01
List Price:
MX$1,695.81
You save:
MX$508.79
Buy Class
QR254.79
List Price:
QR364.01
You save:
QR109.21
Buy Class
P956.45
List Price:
P1,366.42
You save:
P409.96
Buy Class
KSh9,168.69
List Price:
KSh13,098.69
You save:
KSh3,930
Buy Class
E£3,313.80
List Price:
E£4,734.21
You save:
E£1,420.40
Buy Class
ብር4,020.93
List Price:
ብር5,744.43
You save:
ብር1,723.50
Buy Class
Kz58,536.36
List Price:
Kz83,626.96
You save:
Kz25,090.59
Buy Class
CLP$65,519.73
List Price:
CLP$93,603.63
You save:
CLP$28,083.90
Buy Class
CN¥505.79
List Price:
CN¥722.59
You save:
CN¥216.80
Buy Class
RD$4,064.05
List Price:
RD$5,806.04
You save:
RD$1,741.98
Buy Class
DA9,434.16
List Price:
DA13,477.95
You save:
DA4,043.79
Buy Class
FJ$159.43
List Price:
FJ$227.77
You save:
FJ$68.34
Buy Class
Q544.12
List Price:
Q777.35
You save:
Q233.22
Buy Class
GY$14,659.33
List Price:
GY$20,942.80
You save:
GY$6,283.47
Buy Class
ISK kr9,804.19
List Price:
ISK kr14,006.59
You save:
ISK kr4,202.40
Buy Class
DH702
List Price:
DH1,002.91
You save:
DH300.90
Buy Class
L1,236.68
List Price:
L1,766.77
You save:
L530.08
Buy Class
ден4,019.08
List Price:
ден5,741.79
You save:
ден1,722.70
Buy Class
MOP$563.89
List Price:
MOP$805.60
You save:
MOP$241.70
Buy Class
N$1,302.92
List Price:
N$1,861.40
You save:
N$558.47
Buy Class
C$2,577.98
List Price:
C$3,682.99
You save:
C$1,105
Buy Class
रु9,357.62
List Price:
रु13,368.60
You save:
रु4,010.98
Buy Class
S/260.83
List Price:
S/372.63
You save:
S/111.80
Buy Class
K271.34
List Price:
K387.65
You save:
K116.30
Buy Class
SAR262.49
List Price:
SAR375
You save:
SAR112.51
Buy Class
ZK1,913.50
List Price:
ZK2,733.69
You save:
ZK820.18
Buy Class
L324.50
List Price:
L463.60
You save:
L139.09
Buy Class
Kč1,630.34
List Price:
Kč2,329.15
You save:
Kč698.81
Buy Class
Ft25,331.89
List Price:
Ft36,189.97
You save:
Ft10,858.07
Buy Class
SEK kr764.93
List Price:
SEK kr1,092.80
You save:
SEK kr327.87
Buy Class
ARS$61,714.55
List Price:
ARS$88,167.42
You save:
ARS$26,452.87
Buy Class
Bs483.86
List Price:
Bs691.26
You save:
Bs207.40
Buy Class
COP$272,553.83
List Price:
COP$389,379.31
You save:
COP$116,825.47
Buy Class
₡35,845.57
List Price:
₡51,210.15
You save:
₡15,364.58
Buy Class
L1,730.57
List Price:
L2,472.36
You save:
L741.78
Buy Class
₲523,213.21
List Price:
₲747,479.48
You save:
₲224,266.27
Buy Class
$U2,704.33
List Price:
$U3,863.50
You save:
$U1,159.16
Buy Class
zł280.23
List Price:
zł400.34
You save:
zł120.11
Buy Class
Already have an account?
Log In
Previous
Next
Sign Up
Signup to access thousands of classes
Continue with Facebook
Continue with Google
OR
Continue with Email
Already a member?
Log In
By registering for a LearnDesk account, you agree to our
Terms of Service
and
Privacy Policy
.
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.
Share with Google Contacts