Manipulare date din surse externe (Power Query)

Acest curs conține exerciții practice despre soluțiile de manipulare a datelor.

Vei putea afla din acest curs (cu ajutorul exemplelor 100% practice):

  • cea mai bună metodă pentru a lucra cu fișiere .csv
  • cum se face o interogare pentru a putea prelucra date provenite din surse externe
  •  Prelucrarea datelor folosind Power Query Editor:
    • cum se adaugă o coloană nouă care conține calcule
    • cum se modifică poziția coloanelor
    • sortarea și filtrarea datelor
    • schimbarea sursei inițiale de import
    • combinarea interogărilor cu Append

Pentru o ințelegere mai bună a cursului și pentru memorarea informațiilor pe termen lung, recomandăm parcurgerea integrală a cursului în ordinea afișată, precum și efectuarea exercițiilor împreună cu instructorul, precum și luarea de notițe.

Be the first to add a review.

Please, login to leave a review
Get Course
Get course
Enrolled: 1 student
Lectures: 7
Video: 01:01:05
Level: Advanced

Related Courses

Microsoft Outlook
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview  Discover all the ways in which...
Introductory
€7.90
Microsoft Word
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview We all know that in order to cr...
Introductory
€7.90
Microsoft Word
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Students will discover the adva...
Introductory
€7.90
Microsoft Word
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview In this nine-part course, learn...
Introductory
€7.90
Microsoft Excel
€12.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Microsoft Excel 2016 gives you ...
Intermediate
€12.90
Digital soft skills
€6.40
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Successful business-IT alignmen...
Introductory
€6.40
Microsoft Word
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Once you’ve created an at...
Introductory
€7.90
Microsoft Word
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Microsoft Word 201 includes sev...
Introductory
€7.90
Microsoft Word
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Word 2010 makes it easy to appl...
Introductory
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Excel has more to offer than ju...
Introductory
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview The Excel 2010 Function Library...
Introductory
€7.90
Essential for Digital Transformation
€6.40
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview An essential innovation associa...
Introductory
€6.40
Microsoft SharePoint
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview In SharePoint 2016, you can use...
Introductory
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Excel 2010  provides a number o...
Introductory
€7.90
Microsoft Word
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Microsoft Word 2016 allows user...
Introductory
€7.90
Microsoft Word
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Word 2010 lets you efficiently ...
Introductory
€7.90
Power point
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview To make your presentation stand...
Intermediate
€7.90
Microsoft OneNote
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview  Notes in OneNote for Windows 1...
Introductory
€7.90
Microsoft Word
€12.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Microsoft Word 2016 offers a nu...
Introductory
€12.90
Microsoft Teams
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview In addition to creating message...
Introductory
€7.90
Microsoft Outlook
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview To help you with the various ta...
Introductory
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview  Excel 2010 Provides powerful d...
Introductory
€7.90
Essential for Digital Transformation
€3.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Companies should always be look...
Introductory
€3.90
Microsoft Teams
€6.40
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview This course covers methods for ...
Introductory
€6.40
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview This 8-clip course explores the...
Advanced
€7.90
Microsoft Word
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Word 2010 offers a variety of i...
Introductory
€7.90
Microsoft Word
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Word 2010 gives you a wide vari...
Introductory
€7.90
Microsoft Teams
€12.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview In order to work effectively as...
Introductory
€12.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview  In Excel for Office 365, you c...
Advanced
€7.90
Microsoft Word
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview In Microsoft Word 2016, the Nav...
Introductory
€7.90
Microsoft Project
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Microsoft Project 2016 facilita...
Introductory
€7.90
Microsoft Project
€12.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview There are many factors that can...
Introductory
€12.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Formulas are an integral and im...
Introductory
€7.90
Power point
€12.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Create slides and finish them o...
Introductory
€12.90
Power point
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview PowerPoint 2019 lets you take y...
Intermediate
€7.90
Power point
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview In this nine-part course, stude...
Introductory
€7.90
Essential for Digital Transformation
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Do you think that outages will ...
Introductory
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Using the chart feature in Exce...
Introductory
€7.90
Data Science
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Predictive analysis provides th...
Intermediate
€7.90
Collaboration tools
€6.40
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview  About LinkedIn provides more t...
Introductory
€6.40
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview The ability to handle data easi...
Introductory
€7.90
Microsoft Word
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Students will learn how to send...
Introductory
€7.90
Microsoft Visio
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Using shapes in Visio charts ca...
Introductory
€7.90
Power point
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Microsoft PowerPoint 2016 makes...
Introductory
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview A PivotTable is a useful tool f...
Introductory
€7.90
Microsoft Outlook
€12.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Microsoft Outlook 2016 includes...
Introductory
€12.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Explore ways to analyze trend d...
Advanced
€7.90
Microsoft Outlook
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview The ability to handle data easi...
Introductory
€7.90
Microsoft Word
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Word 2010 gives you a variety o...
Introductory
€7.90
Collaboration tools
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview  About To get the most out of L...
Introductory
€7.90
Individual
Business
Partner

Register as Individual

For those who are individual learners, team members of a business, business professionals.

{{this.errorMessage}}

{{this.successMessage}}

By registering you accept terms and conditions

Already on DB Academy?

Register as Business

Business Leaders / HR Responsibilities / Other company representatives who want to upskill employees.

{{this.errorMessage}}

{{this.successMessage}}

By registering you accept terms and conditions

Already on DB Academy?

Register as Partner

For companies which want to colobrate with DB Academy and publish educational content for their customers.

{{this.errorMessage}}

{{this.successMessage}}

By registering you accept terms and conditions

Already on DB Academy?

Login

Authanticate to DB Academy.

{{this.errorMessage}}

{{this.successMessage}}

New to DB Academy?

Forgot your password?