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
- Comprehensive overview of Power BI Desktop and Power BI Service.
- Application scenarios in engineering, construction, and BIM sectors.
- Understanding the underlying architecture of Power BI.
Data Retrieval and Connectivity
- Establishing connections to diverse data sources such as SQL, Excel, and cloud platforms.
- Ingesting both structured and semi-structured datasets.
- Configuring scheduled refreshes and real-time data updates.
Data Preparation and Modeling
- Utilizing Power Query for effective data transformation.
- Defining relationships across different datasets.
- Constructing reusable and scalable data models.
Developing Visual Reports
- Designing dashboards featuring charts, maps, and tabular data.
- Implementing drill-through features and filter-based interactions.
- Applying custom visuals and adhering to design best practices.
Leveraging AI Tools for Trend Analysis
- Incorporating Power BI AI visuals and smart narrative features.
- Identifying trends and deriving time-based insights.
- Performing forecasting using built-in analytical capabilities.
BIM Data Integration
- Exporting data from popular BIM tools such as Revit and Navisworks.
- Organizing BIM data to ensure compatibility with Power BI.
- Visualizing key BIM metrics and model attributes.
Publishing and Distribution
- Deploying content to Power BI Service.
- Managing workspaces and access permissions.
- Sharing reports with internal teams and external stakeholders.
Summary and Recommended Next Steps
Requirements
- A solid grasp of data structures and visualization principles.
- Proficiency with Microsoft Excel or comparable data manipulation tools.
- Knowledge of BIM processes is advantageous but not mandatory.
Target Audience
- Managers overseeing innovation and technology development.
- Data analysts specializing in construction or engineering datasets.
- BIM professionals looking to refine their data reporting practices.
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
engagement with the attendees
