You're reading from Managing and Visualizing Your BIM Data Understand the fundamentals of computer science for data visualization using Autodesk Dynamo, Revit, and Microsoft Power BI

Product type Paperback

Published in Nov 2021

Publisher Packt

ISBN-13 9781801073981

Length 436 pages

Edition 1st Edition

Tools

AutoCAD

Concepts

Computer Aided Design

Authors (5):

Dounia Touil

Gavin Crump

Ernesto Pellegrino

Manuel André Bottiglieri

Luisa Cypriano Pieper

+1 more

View More author details

Table of Contents (17) Chapters

Preface

1. Section 1: Overview of Digitalization and BIM Data

2. Chapter 1: Introducing Units of Digital Information FREE CHAPTER

3. Chapter 2: Understanding Data Centers

4. Chapter 3: Warming Up Your Data Visualization Engines

5. Section 2: Examples and Case Studies from Experts around the World

6. Chapter 4: Building a Data Bridge between BIM Models and Web-Based Dashboards

7. Chapter 5: Getting Started with Autodesk Dynamo and Data Gathering

8. Chapter 6: Importing Revit Plans in Power BI Using Shape Files

9. Chapter 7: Creating a Revit Model-Check Dashboard Using Dynamo and Power BI

10. Section 3: Deep Dive into Autodesk Dynamo

11. Chapter 8: Deep Dive into Dynamo Data Types

12. Chapter 9: Using Dynamo to Place Family Instances

13. Chapter 10: Gathering a Revit Model's Data from Multiple Models at Once

14. Chapter 11: Visualizing Data from Multiple Models in Power BI

15. Chapter 12: Having Fun with Power BI

16. Other Books You May Enjoy

Packt is searching for authors like you

Importing and formatting the datasets

OK. Our journey to build Power BI charts starts with Microsoft Excel. Let's open up the Excel file we generated in Chapter 10, Gathering a Revit Model's Data from Multiple Models at Once. Before we start using it, however, we need to make a change to the Dynamo script. I don't know if you noticed, but the scale we exported from the Sheets category shows decimal values and not the actual scale. If you saw it, great! Kudos to you! If you don't, don't worry, I'll show you how to fix that in a minute.

So, if you open the Excel file, you'll see that each scale value of each sheet is wrong, the reason being is that when we print something such as 1:100 to Excel, it will be interpreted as numbers to divide. So, Excel will calculate the result of the operation 1:100, and it will type 0.011111.

However, we won't need to add any node to the script to fix the issue. We only need to remove one. Let's follow...