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
Power BI Fundamentals
- Overview of Power BI Desktop and Service components.
- Application scenarios in engineering, construction, and BIM.
- High-level view of the Power BI architecture.
Data Acquisition and Connectivity
- Establishing connections to diverse sources such as SQL, Excel, and cloud services.
- Importing both structured and semi-structured datasets.
- Utilizing scheduled and real-time refresh mechanisms.
Data Preparation and Modeling
- Data transformation processes using Power Query.
- Defining relationships between different data sets.
- Developing reusable data models for consistent analysis.
Visual Report Development
- Constructing dashboards incorporating charts, maps, and tables.
- Implementing drill-through capabilities and filter-based interactions.
- Applying custom visuals and adhering to design best practices.
AI-Driven Trend Analysis
- Leveraging Power BI AI visuals and smart narrative features.
- Identifying trends and extracting time-based insights.
- Generating forecasts using built-in analytics tools.
BIM Data Integration
- Exporting data from common BIM tools like Revit and Navisworks.
- Organizing BIM data to ensure compatibility with Power BI.
- Visualizing key BIM metrics and model attributes.
Publishing and Distribution
- Publishing reports to the Power BI Service.
- Managing workspaces and user access permissions.
- Sharing reports with internal teams and external stakeholders.
Conclusion and Future Actions
Requirements
- Fundamental understanding of data structures and visualization principles.
- Prior experience with Excel or equivalent spreadsheet tools.
- Basic familiarity with BIM processes is advantageous but not mandatory.
Target Audience
- Managers in innovation and technology development.
- Data analysts specializing in construction or engineering sectors.
- BIM specialists looking to elevate their data reporting capabilities.
21 Hours
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.
