Udemyalles

Bases de Datos, Reportes y Dashboard con Excel

Master business intelligence! Learn data reporting, dashboards, and insightful analysis. Become a data expert.

4.1(107)
401students
11h 13m
Certificate
Jose Gregorio Guevara Liendo
Jose Gregorio Guevara LiendoLic. en Administración, Tec. Univ. en Inform, Facilitador

Course Content

Bases de Datos, Reportes y Dashboard con Excel is an all-levels Udemy course taught by Jose Gregorio Guevara Liendo. It runs 11h 13m, is taught in Spanish, and includes a certificate of completion. Learners rate it 4.1 out of 5 from 107 reviews, with 401 students enrolled. It is a paid course, last updated August 2020.

Unlock the Power of Excel for Business Intelligence: Reports & Dashboards

Transform your Excel skills and become a sought-after expert in Business Intelligence (BI)! This comprehensive course reveals the hidden potential of Excel's free add-ins for creating stunning reports and dashboards. Learn to leverage these powerful tools and elevate your career – join the top 1% of Excel and BI professionals.

Course Objectives:

  • Master Data Modeling: Learn to work with tables, defined names, and Microsoft Query to build robust data models.
  • PowerPivot Expertise: Discover how to use PowerPivot to consolidate and combine data from diverse sources like CSV files, Excel tables, databases, and the web. This is essential for creating dynamic reports.
  • Dynamic Reporting: Create dynamic tables and charts with integrated data – a capability only achievable with PowerPivot.
  • Impactful Dashboards: Design visually compelling dashboards using Power View and Power Map.
  • BI Without IT Dependence: Gain the skills to perform Business Intelligence (BI) analysis independently, without relying on IT support.

Who Should Attend?

This practical course is designed for a wide range of professionals and students:

  • Managers & Executives: Directors and HR, Administration, Sales, Marketing, and Operations leaders.
  • Administrative Professionals: Directors and Technicians in Administration of Personnel.
  • Business Professionals: Managers and Technicians in any area of the company.
  • Career-Minded Individuals: Professionals and technicians seeking to improve their performance and efficiency.
  • Students: All levels of students looking to gain a competitive edge in the job market.

Course Content:

  • Excel Essentials: Review of key Excel tools and formulas, defined names, table creation, total rows, conditional queries, and MS Query for relational database modeling.
  • Power Query (Power Query): Practical application of Power Query to consolidate and combine data from various sources.
  • Pivot Tables: Master pivot tables (1, 2, and 3-dimensional), calculated fields, and dynamic charts.
  • Power Pivot Environment:
    • Data Import: Importing data using the import wizard, copy & paste, linked Excel tables, and custom queries.
    • Data Sources: Importing data from Access and SQL Server.
    • Relationship Building: Creating and managing relationships between tables.
    • Model Design: Optimizing your data model for performance.
    • Data Updates: Refreshing and updating data.
  • Dynamic Tables & Charts: Creating dynamic tables, KPIs, and using DAX functions.
  • DAX Functions: Learn basic and advanced DAX functions for filtering, relationships, calculated fields, sorting, date handling, and creating hierarchies.
  • Power View:
    • Report Creation: Generating and saving visual reports.
    • Visualization: Creating tables, matrices, cards, and mosaic views.
    • Formatting & Filtering: Applying filters, special scaling, and updating data.
    • Chart Types: Creating various chart types (column, bar, line, pie, geographic).
    • Advanced Features: Adding classifications, defining relationships, and creating custom dashboards with dynamic ranges, controls, and macros.
  • Power Map:
    • Geospatial Data: Understanding and visualizing geographic data.
    • Tour Creation: Building interactive tours with custom formatting, categories, scenes, annotations, and text boxes.
    • Time-Based Visualization: Visualizing data over time.
    • Video Generation: Creating presentation videos.

Delivery:

This course is offered both in-person and online, with numerous practical exercises, downloadable models, manuals, and practical exercises to reinforce learning.

Power BI: Your Path to Data-Driven Decisions

This course equips you with the skills to leverage Power BI as a professional tool for business intelligence and data analysis.

$ whoami — the devs behind tutorialsearch.io

Hire the developers behind TutorialSearch.io

We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.

5.0(1,107)
4h 31m
intermediate
5.0(10)
1h 10m
beginner
5.0(1)
2h 30m
intermediate
5.0(1,020)
3h 44m
all
5.0(29)
15h 7m
all