We may earn an affiliate commission when you visit our partners.
Course image
Leire Ahedo

Introducción a DAX en Power BI

Enroll now

What's inside

Syllabus

Visión general del proyecto
En este proyecto guiado aprenderás todo lo relacionado con DAX

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Perfecto para quienes buscan dominar DAX, un lenguaje crucial para el análisis de datos en Power BI
Impartido por Leire Ahedo, una instructora experta en DAX
Proporciona una base sólida para los principiantes que desean ingresar al campo del análisis de datos

Save this course

Save Introducción a DAX en Power BI to your list so you can find it easily later:
Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Introducción a DAX en Power BI with these activities:
Revisa los conceptos básicos de SQL
Refresca tus conocimientos sobre SQL, que te ayudará a comprender mejor las relaciones y la manipulación de datos en Power BI.
Browse courses on SQL
Show steps
  • Revisa los conceptos básicos de SQL, como SELECT, JOIN y WHERE.
  • Practica escribiendo consultas SQL simples.
Sigue el tutorial interactivo de DAX de Microsoft
Familiarízate con los conceptos básicos de DAX con este tutorial guiado, que te brindará una base sólida para el resto del curso.
Show steps
  • Accede al tutorial interactivo de DAX en el sitio web de Microsoft.
  • Sigue las instrucciones paso a paso.
  • Completa los ejercicios prácticos.
Organize Course Resources
Facilitates effective learning by organizing and reviewing course materials, promoting active engagement with the content and enhancing retention.
Show steps
  • Create a dedicated folder or notebook for course materials
  • Organize notes, assignments, and quizzes by topic
  • Review and summarize key concepts regularly
13 other activities
Expand to see all activities and additional details
Show all 16 activities
Revisit DAX Concepts
Brush up on the fundamentals of DAX to ensure a strong foundation for this course.
Browse courses on DAX
Show steps
  • Review online documentation or tutorials on DAX.
  • Complete practice exercises or quizzes to test your understanding.
Review Excel formulas and functions
Brushing up on Excel formulas and functions will help you to solidify your understanding of the basics and prepare you for the more advanced content in this course.
Browse courses on Excel Formulas
Show steps
  • Review the basics of Excel formulas and functions.
  • Practice using formulas and functions in Excel.
Resuelve ejercicios de práctica de DAX
Refuerza tu comprensión de DAX resolviendo ejercicios de práctica, que te ayudarán a dominar la sintaxis y las funciones.
Show steps
  • Encuentra ejercicios de práctica de DAX en línea.
  • Resuelve los ejercicios con cuidado.
  • Compara tus respuestas con las soluciones.
Review Excel Modeling
Reinforces foundational skills in Excel modeling, ensuring readiness for advanced data analysis and visualization techniques covered in the course.
Browse courses on Excel
Show steps
  • Review basic Excel functions and formulas
  • Practice creating and formatting spreadsheets
  • Build simple data models using Excel tables
Explore Power BI Tutorials
Provides hands-on experience with Power BI's interface and core functionalities, complementing theoretical concepts learned in the course.
Show steps
  • Follow official Microsoft Power BI tutorials
  • Explore third-party resources for Power BI guidance
Crea un resumen de las funciones DAX
Mejora tu comprensión de las funciones DAX creando un resumen completo, que te ayudará a recordar y utilizarlas eficazmente.
Browse courses on DAX
Show steps
  • Lista todas las funciones DAX.
  • Describe la sintaxis y los argumentos de cada función.
  • Proporciona ejemplos de cómo utilizar cada función.
Join a Power BI Study Group
Provides opportunities for collaboration, discussion, and peer support, fostering a deeper understanding of course concepts and encouraging knowledge sharing.
Show steps
  • Connect with classmates or join online study groups
  • Discuss course topics, share insights, and ask questions
Explore DAX Functions
Delve deeper into the specific functions available in DAX to enhance your data analysis capabilities.
Browse courses on DAX Functions
Show steps
  • Follow guided tutorials on DAX functions.
  • Experiment with different functions in the Power BI environment.
Solve DAX Expression Challenges
Strengthens DAX proficiency through targeted practice, improving problem-solving abilities and solidifying understanding of formula syntax and logic.
Show steps
  • Attempt online DAX expression challenges
  • Create custom DAX expressions for practice
Crea un panel de Power BI utilizando DAX
Aplica tus conocimientos de DAX en un proyecto práctico, que te ayudará a desarrollar habilidades de resolución de problemas y toma de decisiones.
Browse courses on Power BI
Show steps
  • Recopila datos para tu panel.
  • Crea un modelo de datos en Power BI.
  • Crea medidas y cálculos utilizando DAX.
  • Visualiza tus datos en un panel.
Build a Power BI Dashboard
Applies knowledge gained from the course to create a practical data visualization tool, fostering hands-on experience and solidifying understanding of dashboard design principles.
Show steps
  • Identify a dataset and define the dashboard's purpose
  • Design and create visualizations using Power BI
  • Format and publish the dashboard
Create a Power BI dashboard
Creating a Power BI dashboard will help you to apply your DAX skills to a real-world project and develop your data visualization skills.
Browse courses on Data Visualization
Show steps
  • Gather data for your dashboard.
  • Create a Power BI dashboard.
  • Use DAX to create measures and calculations.
  • Visualize your data using charts and graphs.
  • Share your dashboard with others.
Build a DAX Dashboard
Apply your DAX knowledge to create a comprehensive dashboard that showcases your data analysis skills.
Browse courses on Data Visualization
Show steps
  • Gather and prepare your data.
  • Design and implement your dashboard using DAX measures and visualizations.
  • Present and share your dashboard with others.

Career center

Learners who complete Introducción a DAX en Power BI will develop knowledge and skills that may be useful to these careers:
Business Analyst
A Business Analyst helps businesses understand their data and make better decisions. They use data to identify problems, develop solutions, and improve processes. They may also work with stakeholders to gather requirements and define project scope. This course may be useful for Business Analysts who want to learn how to use DAX to analyze data in Power BI.
Data Analyst
A Data Analyst uses data to solve business problems and improve decision-making. They collect, clean, and analyze data to identify trends and patterns. They may also develop data visualizations to communicate their findings to stakeholders. This course may be useful for Data Analysts who want to learn how to use DAX to analyze data in Power BI.
Operations Research Analyst
An Operations Research Analyst uses data to improve the efficiency and effectiveness of business operations. They use mathematical models and other techniques to analyze data and develop solutions to business problems. This course may be useful for Operations Research Analysts who want to learn how to use DAX to analyze data in Power BI.
Statistician
A Statistician collects, analyzes, and interprets data to provide insights into a variety of topics. They may work in a variety of fields, such as healthcare, education, and business. This course may be useful for Statisticians who want to learn how to use DAX to analyze data in Power BI.
Software Engineer
A Software Engineer designs, develops, and maintains software applications. They work with other engineers and stakeholders to define software requirements, develop software solutions, and test software products. This course may be useful for Software Engineers who want to learn how to use DAX to analyze software data in Power BI.
Web Developer
A Web Developer designs, develops, and maintains websites. They work with other developers and stakeholders to define website requirements, develop website solutions, and test website products. This course may be useful for Web Developers who want to learn how to use DAX to analyze website data in Power BI.
Financial Analyst
A Financial Analyst uses data to make investment decisions. They analyze financial statements, market data, and other sources of information to identify investment opportunities. This course may be useful for Financial Analysts who want to learn how to use DAX to analyze financial data in Power BI.
Product Manager
A Product Manager is responsible for the development and launch of new products and services. They work with engineers, designers, and other stakeholders to define product requirements and ensure that products meet customer needs. This course may be useful for Product Managers who want to learn how to use DAX to analyze product data in Power BI.
Data Engineer
A Data Engineer builds and maintains the infrastructure that stores and processes data. They work with data scientists and data analysts to ensure that data is available and accessible for analysis. This course may be useful for Data Engineers who want to learn how to use DAX to analyze data in Power BI.
Risk Manager
A Risk Manager identifies and assesses risks to an organization. They develop and implement strategies to mitigate risks and ensure that the organization is prepared for potential threats. This course may be useful for Risk Managers who want to learn how to use DAX to analyze risk data in Power BI.
Market Research Analyst
A Market Research Analyst collects and analyzes data to understand market trends and consumer behavior. They may use surveys, interviews, and other methods to gather data. This course may be useful for Market Research Analysts who want to learn how to use DAX to analyze market data in Power BI.
Teacher
A Teacher educates students in a variety of subjects. They work with students to develop their critical thinking skills, problem-solving skills, and communication skills. This course may be useful for Teachers who want to learn how to use DAX to analyze student data in Power BI.
Project Manager
A Project Manager plans and manages projects to ensure that they are completed on time, within budget, and to the required quality standards. They work with stakeholders to define project scope, develop project plans, and track project progress. This course may be useful for Project Managers who want to learn how to use DAX to analyze project data in Power BI.
Writer
A Writer creates content for a variety of purposes, such as marketing, advertising, and journalism. They work with editors and other stakeholders to develop content strategies, create content, and edit content. This course may be useful for Writers who want to learn how to use DAX to analyze content data in Power BI.
Data Scientist
A Data Scientist uses data to solve complex problems and develop new products and services. They use data analysis, machine learning, and other techniques to extract insights from data. This course may be useful for Data Scientists who want to learn how to use DAX to analyze data in Power BI.

Reading list

We've selected seven books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Introducción a DAX en Power BI.
Mastering DAX proporciona una base sólida en los fundamentos de DAX y profundiza en técnicas avanzadas. Es un recurso integral para profesionales que buscan dominar el lenguaje DAX.
Este libro proporciona una guía práctica para resolver problemas empresariales con DAX. Cubre patrones comunes y técnicas avanzadas, complementando el curso con ejemplos del mundo real y estudios de casos.
Power BI Pro Tips and Tricks comparte consejos y trucos poco conocidos para mejorar la productividad y aprovechar al máximo Power BI. Es un recurso útil para usuarios que buscan optimizar su uso de Power BI.
Este libro proporciona una referencia completa de fórmulas y funciones DAX. Cubre todas las funciones DAX disponibles, incluyendo funciones de agregación, funciones de filtro y funciones de texto.
DAX in a Nutshell es una guía de referencia rápida que proporciona una visión general concisa de DAX. Es un recurso útil para profesionales que necesitan una referencia rápida o un repaso.
Este libro introduce los conceptos básicos de Power BI, incluido DAX. Proporciona una descripción general complementaria del curso, adecuada para principiantes o aquellos que buscan un repaso.
Este libro proporciona una introducción fácil de seguir a DAX para principiantes. Cubre los conceptos básicos de DAX, así como ejemplos prácticos y ejercicios para ayudarte a aprender.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Similar courses are unavailable at this time. Please try again later.
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser