Bases de Datos, Reportes y Dashboard con Excel
Master business intelligence! Learn data reporting, dashboards, and insightful analysis. Become a data expert.
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.
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.