Was Sie vorher wissen sollten
bevor Sie beginnen

Beginnt 4 June 2026 19:18

Endet 4 June 2026

00 Tage
00 Stunden
00 Minuten
00 Sekunden
course image

End-to-End SQL Server PowerPivot

Explore SQL Server PowerPivot add-ins for Excel and SharePoint, enabling large-scale data analysis, multidimensional modeling, and collaborative BI solutions with scheduled data refreshes and IT management.
PASS Data Community Summit via YouTube

PASS Data Community Summit

6076 Kurse


1 hour 31 minutes

Optionales Upgrade verfügbar

Not Specified

Lernen Sie in Ihrem eigenen Tempo

Conference Talk

Optionales Upgrade verfügbar

Übersicht

Explore SQL Server PowerPivot add-ins for Excel and SharePoint, enabling large-scale data analysis, multidimensional modeling, and collaborative BI solutions with scheduled data refreshes and IT management.

Lehrplan

  • Introduction to SQL Server PowerPivot
  • Overview of PowerPivot and its capabilities
    Key benefits for data analysis and business intelligence
  • Setting Up the Environment
  • Installing PowerPivot for Excel
    Configuring PowerPivot for SharePoint
    Connecting to SQL Server data sources
  • Data Import and Transformation
  • Importing data into PowerPivot
    Using Power Query for data transformation
    Managing and creating relationships between tables
  • Creating Multidimensional Models
  • Designing data models in PowerPivot
    Understanding measures, KPIs, and hierarchies
    Using DAX (Data Analysis Expressions)
  • Data Analysis and Visualization
  • Creating PivotTables and PivotCharts
    Advanced data visualization techniques
    Tips for effective data storytelling using PowerPivot
  • Collaborative BI Solutions
  • Sharing PowerPivot workbooks via SharePoint
    Managing access and security in SharePoint
    Utilizing Power BI for enhanced collaboration
  • Scheduled Data Refreshes
  • Configuring scheduled data refreshes in PowerPivot
    Monitoring and managing refresh schedules
    Troubleshooting common refresh issues
  • IT Management and Best Practices
  • Governance and administration of PowerPivot solutions
    Optimization techniques for performance
    Best practices for organizational use of PowerPivot
  • Case Studies and Applications
  • Real-world examples of PowerPivot implementations
    Hands-on projects to solidify learning
  • Conclusion and Next Steps
  • Recap of key concepts
    Resources for further learning and practice
    Introduction to advanced topics in Power BI and SQL Server BI tools

Fachgebiete

Conference Talks