Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction to Power BI
- Overview of Power BI Desktop and Service.
- Use cases within engineering, construction, and BIM.
- Overview of the Power BI architecture.
Data Retrieval and Connection
- Connecting to multiple data sources, including SQL, Excel, and cloud platforms.
- Importing structured and semi-structured data.
- Utilizing scheduled and real-time refresh options.
Data Preparation and Modeling
- Transforming data using Power Query.
- Establishing relationships between different data sets.
- Constructing reusable data models.
Building Visual Reports
- Creating dashboards featuring charts, maps, and tables.
- Implementing drill-through and filter-based interactions.
- Designing custom visuals and applying best practices.
Applying AI Tools for Trend Analysis
- Utilizing Power BI AI visuals and smart narratives.
- Identifying trends and gaining time-based insights.
- Performing forecasting using built-in analytics tools.
Integrating with BIM Data
- Exporting data from BIM tools, such as Revit and Navisworks.
- Structuring BIM data to ensure compatibility with Power BI.
- Visualizing BIM-related metrics and model attributes.
Publishing and Sharing
- Publishing reports to the Power BI Service.
- Managing workspaces and access permissions.
- Sharing reports both internally and externally.
Summary and Next Steps
Requirements
- A solid understanding of data structures and visualization concepts.
- Practical experience with Excel or comparable tools.
- Familiarity with BIM processes is beneficial but not mandatory.
Audience
- Innovation and technology development managers.
- Data analysts working with construction or engineering data.
- BIM professionals looking to improve data reporting capabilities.
21 Hours
Testimonials (2)
The basic structure of Power BI, its main functions, as well as some advanced functions
Alessandro Binaghi - Great Place to Work(R) Institute Italia Srl
Course - PL-300: Microsoft Power BI Data Analyst
engagement with the attendees