3

MS Excel and Power BI for Business

Free access to CISCO courses with international certification.

Hours48 hrs. (24 synchronous hours and 24 asynchronous hours)
Duration4 weeks
Modality 100% online
This course is designed for participants to master the use of Ms Excel and Power BI as key tools for analysis, visualization and decision making in business environments. Through practical cases, they will learn to structure and model data, create executive dashboards, connect multiple sources of information and generate dynamic reports aimed at strategic management in areas such as sales, finance, logistics and projects. All with a practical, business approach and directly applicable to the reality of the business from the first session.

Aimed at:

Professionals, business analysts, coordinators, executive assistants, students and the general public who need to improve their skills in data analysis.

Thematic Content

Commercial Intelligence with Data Analytics
Sales and commercial analysis
Data connection
Cleaning in Power Query
Sales visualization
Financial Control with BI
Finance and profitability management
Income/expense modeling
Basic DAX
Cash flow visualization
Customer and Risk Analytics part 1
Customer management and risk prevention
Customer segmentation
Customer and Risk Analytics part 2
Churn analysis
Risk dashboards
Optimization of Logistics and Operations with Strategic Data
Logistics optimization and inventory control
Critical stock analysis
Logistics KPIs
Delivery display
Customer Experience Management using Business Intelligence
After-sales service and customer satisfaction
Claims tracking, NPS calculation
Viewing resolution times
Intelligent Monitoring of Strategic Projects
Management and control of strategic projects
Physical-financial monitoring of projects
Deviation alerts
Executive Simulation: Decisions Based on Business Intelligence
Decision making integrated into business
Dashboard integration
KPI Crossanalysis
Strategic recommendations

Benefits

Icono 1
Access to recording classes for reinforcement
Icono 1

Access to digitized material 24/7

Icono 1

Free CISCO self-study courses with international certification

Icono 1

Project-based learning (PBL)
Development of a project applied to the participant's work environment, which consolidates the knowledge acquired during the course.

Icono 1
Instructor profile
  • Internationally certified instructors.
  • Academic experience and in the implementation of AI tools in education.
Icono 1
Requirements
  • Basic knowledge of Windows and Ms Excel
  • No prior Power BI experience required
  • Familiarity with business processes
Icono 1
Certification
Certificate of Approval issued by the César Vallejo University (digital format).

ATTRIBUTES

Formulario Segunda especialidad