Courses from $13.99 USD plus 20% extra with the code BLACK | We bring you closer to your goals

BLACK

Kickstart your career! Fill your cart with courses starting at $13.99 USD . Limited time offer!

Power BI from Beginner to Advanced

Master Power BI from scratch to an advanced level. Learn how to create interactive dashboards and transform data into impactful visualizations that facilitate decision making. This course will take you through all the tools that Power BI offers, from its basic interface to the most advanced functionalities.

By Alfonso Rinsche | Commercial Engineer | MBA | Instructor at G-Talent

👥2.219
(10)
$15.99 USD $59.99

15 day refund guarantee

This course includes:

▪️ 11h 39min duration on demand

▪️ 138 lessons

▪️ 200 downloadable resources

▪️ Available on mobile devices

▪️ Access forever

▪️ Language:

  • Spanish

▪️ Unlimited consultations

Downloadable guides

⚑ Certificate of completion

What you will learn

🟧 Create Interactive Dashboards: You will learn how to create interactive dashboards in Power BI from scratch, transforming data into striking and dynamic visualizations that facilitate strategic decision-making.

🟧 Mastery of DAX for Complex Analysis: You will develop the ability to use the DAX (Data Analysis Expressions) language to solve complex data analysis cases, improving the depth and accuracy of your reports.

🟧 Integration of Multiple Data Sources: You will be able to integrate and combine data from multiple sources, allowing you to create comprehensive and interactive reports that reflect a holistic view of the information.

🟧 Report Optimization for Decision Making: You will learn how to optimize and customize your Power BI reports to maximize their impact and effectiveness in business decision making.

Course content
U1: Sectioneithern 2 Introductioneithern Excel
  • Home Application
  • Excel Interface - General Explanation
  • File Tab
  • Excel File Formats
  • How to Save a New File
  • How to Open an Already Created File
  • My Excel Version
  • Save As
  • How to Print
  • Save as PDF
  • Save As HTML
  • Data Types Text VS Numbers
  • Quick Access Toolbar
  • Sheet composition and key combinations
  • Organization of Sheets
  • Selecting Cells and Columns
  • Copy, Cut, Paste Rows Columns
  • Hiding Rows and Columns Copy Sheets
  • Column and Row Size
  • Freeze columns and rows
  • Add comments in cells
  • Explanation Challenge 1 Intro Excel

U2: Section 3 Basic Excel

  • Type of References and Mathematical Operations
  • Introduction Basic Graphics
  • Column Chart
  • Line Chart
  • Pie Chart
  • Sorting and Filtering Data in a Table
  • Exercise 1 - Sort
  • Exercise 1 - Filter
  • Exercise 2 - Filter
  • MM List and Duplicate Format
  • AutoComplete
  • Composition and structure of Functions in Excel
  • SUM Function
  • Exercise 1 - Professors' Fees
  • Exercise 2 - Simple Budget
  • AVERAGE and PRODUCT functions
  • Exercise 1 - Simple Average
  • Exercise 2 - Average Product
  • Exercise 3 - Notes
  • SUMPRODUCT Function
  • Exercise 1 - Intro Sum Product
  • Exercise 2 - Monthly Fishmonger Sale
  • Exercise 3 - GOT Commissions
  • COUNTIF and AVERAGEIF functions
  • Exercise 1 - Sales Records
  • Exercise 2 - Attendance
  • MAX and MIN functions
  • Exercise 1 - Max Min
  • Exercise 2 - Kindergarten
  • TODAY Function
  • Exercise 1 - Today
  • SUMIF Function
  • Exercise 1 - SumarSi Teachers' Fees
  • Exercise 2 - Total Products
  • Inspection window
  • Precedents and Dependents in Excel
  • Explanation Challenge 2 Basic Excel
U3: Sectioneithern Excel Intermediate
  • Conditional Formatting
  • Exercise 1 - Red notes
  • Validation and Protection of Sheets
  • Exercise 1 - Fruits and Vegetables The Pandemic
  • Exercise 2 - Cabin Rental
  • Exercise 3 - Hide Information
  • Book Protection
  • Formula Protection
  • SUMIF Function
  • Exercise 1 - Fruits and Vegetables
  • Exercise 2 - Total Products II
  • IF function
  • Exercise 1 - Cash Payment
  • Exercise 2 - Fog
  • Nested Functions with IF, AND, OR Function
  • Exercise 1 - It Can Happen
  • Exercise 2 - Goals
  • Exercise 3 - Days Worked
  • Explanation Set
  • Exercise 1 - SICONJUNTO
  • Exercise 2 - DIABETES
  • VLOOKUP Function
  • Exercise 1 - Intro VSearch
  • Exercise 2 - Person ID
  • Exercise 5 - Payroll of Workers
  • Exercise 3 - Whole Notes
  • Exercise 4 - Exact Notes
  • HLOOKUP Function
  • SIERRAROR Function Explanation
  • Exercise 1 - Pet Store
  • Exercise 2 - ID-IF-ERROR
  • Exercise 3 - Vehicle License Plate
  • Exercise 1 - Sales Hugo, Paco, Luis
  • FILTER Exercise - Employee Salary
  • FILTER Exercise - Salary Employees 2
  • FILTER Exercise - COURSES
  • FILTER Exercise - Pharmacy Headquarters
  • Subtotals
  • Exercise 1 - Sparky Appliances
  • Exercise 2 - Cost per Dept.
  • Pivot Tables and Charts
  • Exercise 1 - Works
  • Pivot Tables with Data Segmentation
  • Exercise 1 - Cell Phone Sales
  • Presentation Pivot tables
  • Exercise 3 - Sales Olympics
  • Explanation Challenge 3 Excel Intermediate
U4: Sectioneithern 5 Din Tablestomicas and AntoData Analysis
  • Pivot Tables and Charts
  • Exercise 1 - Works
  • Pivot Tables with Data Segmentation
  • Exercise 1 - Cell Phone Sales
  • Exercise 3 - Sales Olympics
  • Presentation Pivot tables
  • Data Used
  • Tricks and Connections
  • Source Data Update
  • Blocking Segments
  • Report Filter Pages
U5: Section 6 Advanced Excel
  • Cell Names and Cell Ranges
  • CONCATENATE function
  • Exercise Name Surname
  • Sales Lists Exercise
  • INDIRECT function
  • Indirect exercise
  • Exercise 1 - Cities
  • Exercise 2 - Planes
  • Exercise 3 - Categories
  • Search Target
  • Exercise 1 - Loan
  • Exercise 2 - Market Share
  • Exercise 3 - Saving for Retirement
  • Scenarios
  • Exercise 1 - Currencies
  • Exercise 2 - Loan 2
  • Introduction to Macros
  • Macro Environment
  • Exercise 1 Sales
  • Exercise 2 - Hotel Reservation
  • Explanation Challenge 4 Advanced Excel
Course evaluation
  • This course contains a final exam
G-Tools: For Students
  • Exclusive access to cutting-edge student tools: improve your employability, participate in exclusive events, take advantage of our intelligent virtual assistant, and more.
⚑ Certificate of completion
  • Your personalized digital certificate, a unique badge of your achievements, with international validity, course duration and QR code for instant verification.
__
Downloadable resources:

📎 Downloadable Document Set:
▸ Practice Exercise - Challenge 1: Video Game Sales
▸ Practice Exercise - Challenge 2: International Sales
▸ Practice Exercise - Challenge 3: Power BI

Description

This course "Power BI: Beginner to Advanced" is designed to take you from the basics to advanced techniques in using Power BI, the leading tool for data analysis and visualization. Throughout this course, you will master each of the functionalities that Power BI offers, from creating interactive dashboards to integrating multiple data sources and the advanced use of DAX for complex analysis.

With a practical approach based on real cases, this course will prepare you to transform raw data into valuable information that supports strategic decision-making in any professional field. In addition, you will have downloadable resources, unlimited consultations and a personalized digital certificate upon completion of the course.

This course is ideal for data analysts, business professionals, or anyone interested in mastering Power BI and advancing their career. Enroll today and start harnessing the power of data with Power BI!

Companies from all industries invest in the development of their teams with this course from G-Talent and Alfonso Rinsche

Pack de 3 cursos

Alfonso Rinsche

Commercial Engineer | MBA | Instructor at G-Talent

About Alfonso Rinsche

Commercial Engineer | MBA | Instructor at G-Talent

Renowned international university professor with more than 20 years of teaching experience. Since 2006, he has taught at the Adolfo Ibáñez University, one of the most prestigious universities in Chile, where he teaches Excel, Access and Marketing to final-year students. His commitment to educational excellence earned him recognition in 2012 as the best professor at the Adolfo Ibáñez University Business School, an award given by his own students.

Alfonso Rinsche has dedicated his career to higher education, combining his business background with a deep passion for teaching. Over more than two decades, he has trained hundreds of students, equipping them with the tools and knowledge necessary to succeed in the business world. His pedagogical approach, based on the practical application of complex concepts, has been key to his success as a teacher both in face-to-face classes and on online platforms.

In 2012, Alfonso began to expand his educational impact globally, teaching online courses on the world’s largest teaching platform. His ability to adapt to new formats and innovative approach to teaching have allowed his lessons to reach a wider and more diverse audience. Since 2017, he has also been teaching at the American University of Paraguay, strengthening his influence on education in Latin America.

What makes Alfonso different?

▪️ International Recognition: His award as best professor at Adolfo Ibáñez University highlights his ability to connect with his students and provide high-quality education.
▪️ Global Experience: With an MBA in the United States and teaching experience in Chile and Paraguay, Alfonso brings a global perspective and accessible, practical teaching.
▪️ Specialization in Business Tools and Strategies: Their Excel, Access, and Marketing courses are designed to offer students practical skills that are highly valued in the workplace.

If you want to learn from a teacher with an international career and a focus on educational excellence, Alfonso Rinsche is the perfect choice.

Discover the added value: G-Tools and much more

In addition to high-quality content, this course gives you access to G-Tools, a suite of tools and resources designed to enhance your learning and your career.

Employability support resources, live events and take advantage of Aixa.IA's artificial intelligence to resolve your questions at any time.

Customer Reviews

Based on 10 reviews
40%
(4)
60%
(6)
0%
(0)
0%
(0)
0%
(0)
S
Stephanie Blanco
Curso práctico y completo. Buen contenido y certificado

Ideal para dominar Excel de principio a fin. Muy completo y bien estructurados

D
Dayanara Mora
Curso práctico y completo. Buen contenido y certificado

Perfecto para quienes buscan un aprendizaje integral de Excel. El certificado es un buen incentivo

J
Jhon Peña
Aprendí desde lo básico hasta lo avanzado. Muy recomendable

Excelente curso para aprender Excel a fondo. El certificado final es un gran añadido

J
Jennifer Mejias
Gran curso para todos los niveles

Este curso de Excel superó mis expectativas. La progresión de los temas es lógica y bien estructurada. Los ejercicios prácticos fueron especialmente útiles para consolidar los conocimientos.

A
Andrea Romero

Curso exhaustivo que cubre desde lo básico hasta técnicas avanzadas. El certificado es un plus.

O
Omaira Porras
Bastante dinamico, facil de aprender.

Como alguien que trabaja en el análisis de datos, este curso me ayudó a mejorar mis habilidades en Excel significativamente. Las lecciones están bien diseñadas y el material adicional es muy útil.

K
Katiuska Rodriguez
Curso claro, útil y fácil de aplicar.

Me encantó el curso. La explicación de las funciones avanzadas, como tablas dinámicas y macros, fue clara y fácil de seguir

J
Jean Mendez
Transformó mi forma de trabajar con datos. Muy útil

Curso dinámico y bien estructurado.El instructor es muy capacitado y el certificado final es una excelente recompensa

A
Andres Torres
Perfecto para dominar Excel

Cobertura total de Excel, desde lo básico hasta avanzado. Muy recomendable para profesionales.

L
Laura Morales
"Estructura clara y práctica.

Desde fundamentos básicos hasta funciones avanzadas. El curso ofrece una formación completa y útil

View all

Explore other courses from Alfonso Rinsche

Discover other courses and learn something new today. Learn from the best!

Best Selling Courses in Personal Development

What to expect from G-Talent courses?

  • Study at your own pace

    Get video courses, taught by top instructors, to study at your own pace

  • Learn from the best

    Provides high quality courses developed by carefully selected experts

  • Quality guaranteed

    Not sure? All our courses offer a 15-day success guarantee

  • Permanent accompaniment

    Learn at your own pace, with lifelong updates, access and support.

  • Personalized certificate

    Get a world-class certificate, with international validity and a unique encrypted QR code

  • G-Tools: For Students

    Find all the tools you need for your employability in one place.