Empower Yourself For Free
Join our community of 45 million+ learners, upskill with CPD UK accredited courses, explore career development tools and psychometrics - all for free.
Having trouble Logging In? Get in touch
Sign Up
Log In
Hai dimenticato la password?No worries, we will send reset instructions to your email address.
Beginner Level
Power Query e PowerPivot in Microsoft Excel
2,653Learners already enrolled
3-4 Avg Hours
CPD Accredited
Power Query e PowerPivot in Microsoft Excel
Scopri come utilizzare Power Query e Power Pivot di Microsoft Excel per modellare i dati in questo corso gratuito online di scienza dei dati.
Power Query e Power Pivot di Excel sono strumenti di business intelligence per l'estrazione, la trasformazione e l'analisi dei dati. Questo corso di scienza dei dati spiega come importare più file di dati in... Power Query e Power Pivot di Excel sono strumenti di business intelligence per l'estrazione, la trasformazione e l'analisi dei dati. Questo corso di scienza dei dati spiega come importare più file di dati in un foglio Excel e rimodellarli con Power Query e Power Pivot. Ti mostriamo come consolidare i file, creare misure delle prestazioni e visualizzare i dati elaborati in una tabella pivot. Studiamo anche le principali funzioni DAX utilizzate per la manipolazione e l'analisi dei dati.
COURSE PUBLISHER Ross MaynardProcess improvement business advisor
What You Will Learn In This Free Course
- Identify Power Query and Power Pivo...
- Outline the application of Power Qu...
- Describe the advantages of the Powe...
- Identify the arithmetic operators a...
- Identify Power Query and Power Pivot as data modelling engines in Microsoft Excel
- Outline the application of Power Query and Power Pivot tools in data analysis
- Describe the advantages of the Power Query tool in data cleaning and task automation
- Identify the arithmetic operators and logical functions used in Power Query
- Select the appropriate Power Query operators and functions for your data analysis project
- Analyse data via the performance measures and KPI features of the Power Pivot data model
- List the key DAX query functions used for data analysis in the Power Pivot tool
- Generate DAX query functions and logical statements for data analysis and manipulation
- Create a single power pivot table using the tables obtained from multiple data sources
![]()
Knowledge & Skills You Will Learn
Knowledge & Skills You Will Learn No internet? No problem! Download any course on the Alison App and learn on the go. 📲 Download Courses & Learn Without Internet Coming soon to iOS
Complete This CPD Accredited Course & Get Your certificate!
![]()
Certify Your Skills
A CPD accredited Alison Diploma/Certificate certifies the skills you’ve learned![]()
Stand Out From The Crowd
Add your Alison Certification to your resumé and stay ahead of the competition![]()
Advance in Your Career
Share your Alison Certification with potential employers to show off your skills and capabilities
Learner Reviews & Feedback For Power Query e PowerPivot in Microsoft Excel
Very Helpful.
Nadine Felecia Fabulouscat G. ![]()
Alison Graduate
Alison Graduate This course is all about power pivot allows the creation of a single pivot table, combining data from multiple source tables.
File sizes are smaller in Power Pivot than in Excel, and there is no limit on the rows of data to be stored.
Warren M. ![]()
Alison Graduate
Alison Graduate I got 95% on my course assessment power query and power pivot in microsoft excel
this morning.
Mochamad Fakhri R. ![]()
Alison Graduate
Alison Graduate I really appreciate the quality of the course materials. The content is well-organized, informative, and engaging. It has significantly improved my understanding of the topic. Thank you!
View -1 More Reviews
Back to course information
Want to create a customised learning path for your team?
Our dedicated Learning Advisors are here to help you curate a customised learning path tailored to your organisation's needs and goals.
Not sure where to begin?
Discover the career most suitable for you and get started in the field with a step-by-step plan.
Get your Plan