Power BI and BIM: Analysis and Visualization

2h 30mIntermediate2020-11-02

Authors

Brian Myers

VDC Design Office Lead at Jacobs

Course details

Do you want to build a career in BIM (building information modeling)? Are you interested in learning how to leverage Revit, Power BI, and Excel together? Instructor Brian Myers introduces you to tools that can help you. Learn what Microsoft Business Intelligence is and how it benefits the design communication process. Examine the differences between Power BI versions. Find out how to start a Power BI project, then explore the Power BI interface. Learn about sources for design data. Next, Brian explains Power BI project essentials, such as page size, text placement, use of images, and dividing your data into presentation options. Learn how to create a schedule in Revit and how to format and export data from Revit to Excel. Review types of data sources and how fields are used. Brian also goes into how to associate data sources, use visualizations, and filter your data. After this, he teaches a variety of floor plan tricks.

Skills covered

Power BIRevitData VisualizationBIMBusiness AnalyticsBusiness IntelligenceAutodeskData AnalysisAECData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoftOne-Off

Concepts

0. Introduction

01 - Course introduction
02 - Prerequisites
03 - How to use the files

1. Introduction to Power BI Installation and Features

04 - Where you can get Microsoft BI, free and paid
05 - Discover the difference between Power BI versions
06 - Starting a Power BI project
07 - Explore the Power BI interface
08 - Understanding where design data comes from
09 - Software used in this course and what it does

2. Power BI Essentials

10 - Opening a Power BI project
11 - Set the page size for your presentations
12 - Place text in a Power BI project
13 - Use images in a Power BI presentation
14 - Discover how shapes can be used to add to your presentation graphics
15 - Divide your data into various presentation options
16 - Why is it important to clearly present your data

3. Using Data

17 - Create a schedule in Revit
18 - Format and export data from Revit to Excel
19 - Discover your data sources
20 - What do fields and data mean
21 - Associate data sources to each other
22 - Display your data the way you want using visualizations
23 - Filter your data for desired results

4. Floor Plan Tricks

24 - Examples from the Power BI community
25 - Capture an image
26 - Install the Synoptic Visualization
27 - Create an SVG file
28 - Interactive floor plans
29 - Floor plan colors
30 - Understanding the value

Conclusion

31 - Next steps