DAX Measures and Formulas in Power BI
By Nohelia Bastidas | Master in Administration | Bachelor in Business Administration
15 day refund guarantee
This course includes:
▪️ 4h 50m duration on demand
▪️ 25 lessons
▪️ 13 downloadable resources
▪️ Available on mobile devices
▪️ Access forever
▪️ Language:
- Spanish
▪️ Unlimited consultations
✦ Bonus: Set of downloadable guides and templates
⚑ Certificate of completion
What you will learn
What you will learn
🟧 You will be able to perform powerful analysis in DAX by mastering the essential concepts of DAX and Measure calculations.
🟧 You will produce calculated tables using values function tables, formulas such as Union, Distinct, Intersec, use of CalendarAuto and Calendar.
🟧 You will create dynamic graphics, interactions,
filters and segmenters to make your reports totally advanced.
🟧 You will learn to work with multiple Tables and Budgets by developing complex calculations and creating DAX expressions with Variables.
🟧 You will perform time-based calculations: Previous year, accumulated over the period, month, comparatives, etc.
🟧 You'll start working with Excel's game-changing data modeling and business intelligence tools
Course content
Course content
U1: Measures, Columns and Tables in Power BI
- Measures in Power BI
- Calculated columns in Power BI
- Calculated tables in Power BI
- Differences between Measures and Columns
- Creating Impactful Dashboards to Visualize Data and Make Smart Decisions
- Power BI Essentials Measures, Columns, and Tables for Complete Analysis
U2: DAX Formulas
- Data Analysis Expression (DAX)
- DAX Formula Syntax
- Contexts in DAX Formulas
- Unlocking the power of DAX Formulas for advanced analytics in Power BI
U3: Use of Measures
- Automatic measurements
- Change of aggregation
- Interaction in automatic measurements
- Quick measures
- Creating Manual Measures
- Measure within a report
- Measures with segmentation
- Measures within another measure
U4: Calculated Columns
- Creating Calculated Columns
- Calculated columns in a report
- Using conditionals in calculated columns
- Creating Professional Dashboards in Power BI Desktop
U5: Calculated Tables
- Creating Calculated Tables
- Using tables values function
- Formulas: Union, Distinct, Intersec
- Using CalendarAuto in Calculated Tables
- Using Calendar in Calculated Tables
- Transforming Data into Understandable Stories
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 Guide Set:
▸ Measures Guide in Power BI
▸ Data Analysis Expressions (DAX) Guide
▸ Power BI Dashboards and Reports Guide
▸ Power BI Introduction Guide
Description
Description
Get the most out of your data by creating effective DAX formulas. We teach you the most suitable tools to achieve accurate data analysis.
DAX, short for Data Analysis Expressions, is the language behind Power BI.
With this course you will not only learn DAX formulas, you will learn to create your own columns, measures and calculated tables, and you will be able to create high-level reports.
With the information we'll provide you, you'll be able to start solving real business problems that impact your bottom line. Sign up today!
Companies from all industries invest in the development of their teams with this course from G-Talent and Nohelia Bastidas
Nohelia Bastidas
Master in Administration | Bachelor in Business Administration
About Nohelia Bastidas
About Nohelia Bastidas
Master in Administration | Bachelor in Business Administration
Financial sector expert with over 20 years of experience in finance and business development. Throughout her career, Nohelia has demonstrated a deep understanding of cash flow management and optimization, making her a leading professional in her field. Her focus on improving administrative and technical functions has led her to develop innovative Business Intelligence solutions that automate and present financial information intelligently.
Since 2001, Nohelia has worked in various engineering and consulting firms, always with the aim of optimizing processes and providing strategic value. Her passion for the management and presentation of financial information has been the driving force behind the creation of tools that facilitate strategic decision-making based on relevant and automated data.
Why choose to learn with Nohelia Bastidas?
▪️ Proven experience: Over 20 years in the financial sector, developing a deep understanding of cash flow management and optimization.
▪️ Innovative solutions: Co-creator of Business Intelligence tools that automate the presentation of financial information to facilitate strategic decisions.
▪️ Practical approach: Nohelia shares her real, practical experience in improving administrative and technical functions, providing learning applicable to your career.
▪️ Guaranteed results: Your course is designed to transform your financial management, teaching you to master cash flow and improve the efficiency of your business.
Take advantage of the opportunity to learn with Nohelia Bastidas and transform your financial management! Enroll now in her Cash Flow course and master the tools you need to take your business to the next level.
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.
El curso me ha ayudado a mejorar la eficiencia y la productividad en mi trabajo al aprender a automatizar tareas repetitivas con DAX. Ahora puedo crear informes y dashboards más rápido y con menos esfuerzo, lo que me ha permitido dedicar más tiempo a otras tareas importantes
Agradezco a G-talent por ofrecer este curso de alta calidad que ha contribuido significativamente a mi desarrollo profesional
El curso Medidas y Fórmulas DAX en Power BI es una excelente opción para aprender a utilizar DAX de forma avanzada. El contenido está muy bien estructurado y el instructor explica los conceptos de forma clara y concisa.
El curso cubre un amplio abanico de temas, desde los conceptos básicos de DAX hasta las funciones más avanzadas. También incluye ejercicios prácticos para que los alumnos puedan aplicar lo aprendido.
El curso Medidas y Fórmulas DAX en Power BI es un curso imprescindible para cualquier usuario de Power BI que quiera crear informes y paneles de datos avanzados. En general, estoy muy satisfecho con el curso y lo recomiendo a todos los usuarios de Power BI que quieran mejorar sus habilidades con DAX
Estoy muy satisfecho con el curso online Medidas y Fórmulas DAX en Power BI. El contenido es muy completo y está explicado de forma clara y sencilla. El instructor tiene una gran experiencia y es capaz de transmitir sus conocimientos de forma eficaz.
El curso me ha permitido aprender a crear medidas y fórmulas DAX de forma avanzada. Ahora soy capaz de crear informes y paneles de Power BI mucho más completos y personalizados.
Me gusta la diversidad de información que ponen a disposición, y no únicamente del curso que realices sino también de otros cursos que ofrecen!!
El curso, la plataforma así como también los videos y material de apoyo me dejaron muy conforme. Le recomiendo 100% esta capacitación
Buen método de aprendizaje, entendí el origen de muchas funciones
Gracias, excelente curso y fácil interpretación. Power BI superará siempre a cualquier otra plataforma de BI
Excelente curso, muy detallado en sus clases. Explican bien los casos importantes de las medidas
Explore other courses from Nohelia Bastidas
Discover other courses and learn something new today. Learn from the best!
Best Selling Courses in Personal Development
-
Handling Difficult People at Work: Effective Strategies to Improve Your Work Environment
★★★★★(18)$15.99 USD$59.99Unit price /Unavailable -
-
-
-
-
Analytics and Artificial Intelligence with Power BI
★★★★★(10)$15.99 USD$75.00Unit price /Unavailable -
ChatGPT for Professional Tasks and Microsoft Office
★★★★★(13)$15.99 USD$67.00Unit price /Unavailable -
-
-
B2B Consultative Sales: Innovation and techniques for extraordinary results
★★★★★(9)$15.99 USD$97.00Unit price /Unavailable -
-
-
-
-
-
-
-
Training of Internal Auditors in Quality Management Systems
★★★★★(179)$15.99 USD$74.99Unit price /Unavailable
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.