The Course Power Pivot. Business Intelligence tools with Excel offers you the chance to delve into the fascinating world of data analysis, a skill that is increasingly in demand in the job market. With the growing importance Given the importance of data in business decision-making, knowing how to import and manipulate data using Power Query and Power Pivot has become a competitive advantage essential. You’ll learn how to create striking visualisations that transform complex data into clear and strategic information. This course, designed to be accessible from anywhere, will enable you to acquire key knowledge in a flexible way that is tailored to your needs. Upon completion, you will be equipped to optimise processes and add value to any organisation, using the tools of Business Intelligence Excel’s most powerful features. Don’t miss this opportunity to enhance your professional profile and advance your career.
Power Pivot. Business Intelligence tools with Excel
Big Data
40 hours
Introduction
Objectives
-
To understand the main functions and features of Power Pivot in Excel.
-
Learn how to import data efficiently using Power Query.
-
Develop skills to to model data using Power Pivot.
-
Explore advanced techniques for visualisation data.
-
Mastering the creation of dashboards interactive features in Excel.
-
Integrate data from various sources in a single model.
-
Apply functions DAX for complex data analysis.
Table of Contents
TEACHING UNIT 1. INTRODUCTION AND PRIOR KNOWLEDGE
Import data
Pivot Tables (I)
Pivot Tables (II)
Charts and dashboards
Business intelligence tools in Excel
TEACHING UNIT 2. IMPORTING DATA. POWER QUERY
Data sources. Import directly into Excel
Import from the web using Power Query
Connect and convert CSV files
Importing and processing data from Excel
Importing and transforming data from an Access database
TEACHING UNIT 3. POWER PIVOT
The data model
Working on the data model
DAX functions and measures
DAX time-based functions
Hierarchies and KPIs
TEACHING UNIT 4. VISUALISATIONS
An Introduction to Visualisations
Creating charts in Excel
Power map - 3D maps
Power View
Power BI Desktop
More related courses
Your questions answered
Why choose Educa.Pro?
Educa.Pro enables organisations to centralise training management, personalise learning and gain clear insights into the impact of training programmes. Thanks to its AI-powered technology, organisations can optimise their learning strategies, enhance talent development and make data-driven decisions.
Can the courses be taken at your own pace?
Yes. Most of the courses on Educa.Pro are self-paced and on-demand, allowing users to progress at their own pace without missing out on progress tracking or assessments, which makes it easier to fit them around work or study commitments.
What levels of security and compliance does the platform offer?
Educa.Pro complies with security standards designed to protect user and organisational data. Furthermore, it supports the traceability of certifications, digital signatures and the management of assessments, thereby ensuring regulatory and legal compliance in both educational and corporate environments.
What support and guidance does Educa.Pro offer?
The Educa.Pro team offers comprehensive support throughout implementation, roll-out and adoption, ensuring that organisations get the most out of the platform and achieve measurable results from day one.