Power Pivot: Business Intelligence Tools with Excel

Name: Power Pivot: Business Intelligence Tools with Excel
Brand: Educa PHAROS
SKU: AFO028MTX
Availability: InStock

Cross-cutting

Digital Skills

Duration

40 hours

PRESENTATION

The Course Power Pivot: Business Intelligence Tools with Excel offers you the opportunity 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 compelling visualizations that transform complex data into clear and strategic information. This course, designed to be accessible from anywhere, will allow you to acquire key knowledge in a flexible way tailored to your needs. Upon completion, you will be able to optimize processes and add value to any organization by 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.

Objectives

Learn about 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 with Power Pivot.
Explore advanced techniques for visualization data.
Mastering the creation of dashboards Interactive features in Excel.
Integrate data from multiple sources in a single model.
Apply functions DAX for complex data analysis.

Syllabus

TEACHING UNIT 1. INTRODUCTION AND PREREQUISITES Importing Data Pivot Tables (I) Pivot Tables (II) Charts and Dashboards Business Intelligence Tools in Excel TEACHING UNIT 2. IMPORTING DATA. POWER QUERY Data sources. Importing directly into Excel Importing from the web using Power Query Connecting to and transforming CSV files Importing and transforming data from Excel Importing and transforming data from an Access database LEARNING UNIT 3. POWER PIVOT The data model Working with the data model DAX functions and measures DAX time-related functions Hierarchies and KPIs LEARNING UNIT 4. VISUALIZATIONS Introduction to visualizations Creating dashboards in Excel Power Map – 3D maps Power View Power BI Desktop

Request for Information

Name *

Last Name *

Country

Phone

Email *

Company

Job Position

Sector

Message

I have read and agree to the Privacy Policy

Related MOOCs

Workplace Risk Prevention, Ergonomics, and Mental Health

The Course on Workplace Risk Prevention, Ergonomics, and Mental Health addresses the growing need to ensure environments...

Digital Disconnection and Legal Compliance in the Workplace

In the age of remote work, hyperconnectivity has put companies under the scrutiny of the Labor Inspectorate....

The Right to Digital Disconnection, Health, and Work Ethics

In a world of global digitization, hyperconnectivity has gone from being an advantage to becoming a challenge...

Are the Educa PHAROS courses eligible for credit?

Many courses can be credited toward the master's programs at Structuralia.

Facts about our area

+ 1.483

Hours

+88.999

Minutes

264

Courses

Are the masterclasses live?

Who is it intended for?

What features does Educa PHAROS have?

What guarantees does Educa PHAROS offer?

Why is Educa PHAROS the best solution?

Educa PHAROS is a next-generation training model that places a company’s human capital at the forefront. Through a platform that adapts to each company’s corporate identity and offers a total of more than 900 courses, it provides tailored training for each organization. The unlimited flat-rate plan provides each company with the number of courses that best suits its needs, as well as the ability to determine which employees will have access.