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 Service.
- Application cases in engineering, construction, and BIM.
- Understanding Power BI architecture.
Data Retrieval and Connectivity
- Establishing connections to diverse data sources (SQL, Excel, cloud).
- Ingesting structured and semi-structured data.
- Configuring scheduled and real-time refresh cycles.
Data Preparation and Modeling
- Transforming datasets using Power Query.
- Defining relationships between data sets.
- Developing reusable data models.
Constructing Visual Reports
- Designing dashboards with charts, maps, and tables.
- Implementing drill-through and filter-based interactions.
- Utilizing custom visuals and adhering to design best practices.
Leveraging AI for Trend Analysis
- Incorporating Power BI AI visuals and smart narratives.
- Identifying trends and generating time-based insights.
- Executing forecasts with built-in analytics capabilities.
BIM Data Integration
- Exporting data from BIM applications (e.g., Revit, Navisworks).
- Structuring BIM data for compatibility with Power BI.
- Visualizing BIM-specific metrics and model attributes.
Publishing and Distribution
- Deploying reports to Power BI Service.
- Managing workspaces and access permissions.
- Sharing reports with internal and external stakeholders.
Recap and Future Directions
Requirements
- Foundational knowledge of data structures and visualization principles.
- Proficiency with Excel or comparable spreadsheet tools.
- While not mandatory, familiarity with BIM workflows is advantageous.
Target Audience
- Managers in innovation and technology development.
- Data analysts handling construction or engineering datasets.
- BIM specialists looking to improve 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
The basic structure of Power BI, its main functions, as well as some advanced functions
