logo-mooc
search-iconsearch-icon
menu-whitemenu-blue
GRATIS
Inicio / Buscador / Negocios / Microsoft PowerApps
Harvard vía Coursera
GRATIS

Power Pivot Fundamentals

  • money

    Cursos gratis (Auditar)

    question-mark
  • earth

    Inglés

  • folder

    Siempre Abierto

  • certificate

    Guía de Registro en Coursera

    arrow
VER CURSO arrow
Acerca de este curso

  • Course Orientation
    • In this module, you'll explore how Power Pivot transforms Microsoft Excel, bringing business intelligence and analysis capabilities to the forefront. Discover the key benefits, from creating pivot tables with multiple sources to performing powerful time period comparisons, and elevate your analysis skills to the next level with simple formulas and advanced functionalities.
  • Module 1: A Basic Data Model
    • Dive into the world of data modeling as we guide you through the process of building a relational data model in Power Pivot. Unleash the power of new functionalities and learn to import, relate, summarize, and interact with your data using measures, tables, and slicers for enhanced Excel capabilities.
  • Module 2: Basic Measures
    • Welcome to the next chapter of our Power Pivot Mastery course! Now that you've mastered data consolidation and interaction, this chapter delves into the world of DAX measures. Learn how to create metrics, leverage DAX as a powerful formula language, and unlock new possibilities for data aggregation and analysis in your Excel data model.
  • Module 3: Working with a Star Schema
    • Welcome to our Advanced Power Pivot Techniques module! Building upon your understanding of the Power Pivot data model and DAX, explore how to efficiently aggregate and summarize data with reusable formulas. This chapter introduces the Star Schema data model, guiding you through expanding datasets, managing multiple dimension tables, and creating interactive dashboards with a logical flow. Learn the significance of the Star Schema, leverage timelines, pivot charts, and enhance data import efficiency by combining Power Query with Power Pivot for a cohesive and consistent dashboard experience.
  • Module 4: From Number to Narratives
    • In this module, explore the art of turning data into meaningful insights and compelling data stories. Learn to create advanced DAX measures, employ the CALCULATE function for percent of total calculations, delve into DAX Time Intelligence for year-over-year comparisons, and enhance dashboard aesthetics with conditional formatting, KPIs, and visual cues. Elevate your data presentation skills and gain a solid foundation for crafting professional-looking dashboards that communicate insights effectively.
  • Module 5: Extended Practice
    • Welcome to the end-of-course exercise! Apply your skills to the Big Wings Airline case study, where you'll independently create a competitor analysis dashboard. Utilize your data modeling, metrics creation, and dashboard formatting knowledge to meet the provided requirements and communicate key insights effectively. Happy practicing!
  • Course Conclusion
    • Congratulations on completing our Power Pivot course! You've mastered the art of building three insightful dashboards, creating data models, understanding DAX basics, and delving into time intelligence calculations. Continue your data analysis journey by earning the Excel Data Analysis specialization and consider expanding your DAX skills in our recommended next course. Reach out on LinkedIn—I'd love to hear about your data journey. Well done, and see you next time!