Manipulare date din surse externe (Power Query)

1 Student enrolled
0
0 reviews
  • Description
  • Curriculum
  • Reviews
PQ-DB Academy2.jpg

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.

Share
Get Course
Course details
Lectures 7
Video 01:01:05
Level Advanced

Related Courses

Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview An image can take up to a thous...
Intermediate
€7.90
Microsoft Excel
€12.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview In this 10-clip course, learner...
Advanced
€12.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 ten-part course, you&#8...
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  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 Word 2010 gives you a wide vari...
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 Excel 2010 provides easy-to-use...
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 When used effectively, virtual ...
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 You can add many types of illus...
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 Your presentation needs to be s...
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 provides to...
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 PowerPoint 2019 lets you take y...
Intermediate
€7.90
Microsoft Outlook
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Microsoft Outlook 2016 includes...
Introductory
€7.90
Data Science
€12.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview For any organization, predictiv...
Intermediate
€12.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 allows you...
Introductory
€12.90
Microsoft OneDrive
€6.40
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Once you’ve added files t...
Introductory
€6.40
Microsoft Outlook
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview With Outlook 2010, it’s e...
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 Microsoft Outlook 2016 lets you...
Introductory
€7.90
Microsoft OneNote
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview A well-structured notebook will...
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 For maximum productivity, you n...
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 You can create a series of spec...
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 Business intelligence comes dow...
Intermediate
€7.90
Microsoft Word
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Headers and footers, as well as...
Introductory
€7.90
Microsoft Office
€10
Welcome to the Windows Operating System Course! Whether you’re a beginner looking to master the basics or a professional aiming to refine you...
Introductory
1 Lectures
€10
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
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 provi...
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
Visio
€6.40
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Make your Visio document even m...
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 Using tables, charts, and image...
Introductory
€7.90
Microsoft SharePoint
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview SharePoint 2016 allows you to u...
Introductory
€7.90
Microsoft Delve
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview One of the main benefits of Del...
Intermediate
€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
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
Collaboration tools
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview  About LinkedIn Groups is a gre...
Introductory
€7.90
Microsoft Office
€10
 M365 Copilot este noua soluție Microsoft ce integrează Inteligența Artificială în toată suita M365, de la Outlook la Teams – Word...
Introductory
1 Lectures
€10
The digital experience
€6.40
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Your organization depends on it...
Introductory
€6.40
Data Science
€6.40
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Successful data management in t...
Intermediate
€6.40
Microsoft OneNote
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview  Notes on OneNote for Windows 1...
Introductory
€7.90
Microsoft OneDrive
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview One of the main benefits of One...
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 In order to keep up with the ev...
Introductory
€6.40
Microsoft Outlook
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview There are plenty of design and ...
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 Most of the data collected by o...
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 10-part course, you&#82...
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 LinkedIn is great for de...
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 Visio 2016 offers a variety of ...
Introductory
€7.90
Microsoft Word
€15.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Students will learn in 20 parts...
Introductory
€15.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 ten-part course, you&#8...
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 Power Pivot feature i...
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 This eight-part course shows yo...
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
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?