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.
Duration 21 hours
Course Outline
Introduction to Power BI
- Overview of Power BI Desktop and Power BI Service.
- Application scenarios in engineering, construction, and BIM.
- Understanding the Power BI architecture.
Data Retrieval and Connectivity
- Establishing connections to multiple data sources (SQL, Excel, cloud services).
- Importing both structured and semi-structured data.
- Utilizing scheduled and real-time refresh mechanisms.
Data Preparation and Modeling
- Transforming data using Power Query.
- Defining relationships between different datasets.
- Constructing reusable data models.
Creating Visual Reports
- Designing dashboards featuring charts, maps, and tables.
- Implementing drill-through and filter-based interactions.
- Applying custom visuals and design best practices.
Leveraging AI Tools for Trend Analysis
- Utilizing Power BI AI visuals and smart narratives.
- Identifying trends and extracting time-based insights.
- Performing forecasting using built-in analytics tools.
Integration with BIM Data
- Exporting data from BIM tools (e.g., Revit, Navisworks).
- Structuring BIM data for compatibility with Power BI.
- Visualizing BIM-specific metrics and model attributes.
Publishing and Distribution
- Publishing reports to Power BI Service.
- Managing workspaces and access controls.
- Sharing reports with internal and external stakeholders.
Conclusion and Future Steps
Requirements
- A foundational understanding of data structures and visualization principles.
- Proficiency with Excel or comparable spreadsheet tools.
- Knowledge of BIM processes is beneficial but not mandatory.
Target Audience
- Innovation and technology development managers.
- Data analysts handling construction or engineering datasets.
- BIM professionals aiming to enhance their data reporting capabilities.
Testimonials (2)
How to use relationships in Power BIand the differences between columns and measurements
LEUNG Chun Hei - HAESL
Course - Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics
Method of training.