Microsoft Power BI for Construction Management

Lecture Notes: Creating Information Cards in Microsoft Power BI from Construction Project Daily Progress Report Excel Sheet

Objective: The objective of this lecture is to guide you through the process of creating information cards in Microsoft Power BI from a Construction Project Daily Progress Report Excel Sheet. The information cards will include essential project details such as project start date, completion date, balance days, days completed, tender value, budget cost, and estimated profit. Additionally, we will explore the application of filters for enhanced data analysis.

1. Open Power BI:

• Launch Microsoft Power BI on your computer.

2. Load Data:

• Click on "Get Data" and select "Excel" as the data source.

• Browse and select your Construction Project Daily Progress Report Excel Sheet.

• Choose the appropriate data range and load the data into Power BI.

3. Data Modeling:

• Navigate to the "Data" view to review and clean the data if necessary.

• Create relationships between relevant tables if your data is spread across multiple sheets.

4. Create Information Cards:

• Go to the "Home" tab and select "New Page" to create a new page for the information cards.

• Drag and drop a "Card" visual onto the new page for each of the following fields:

  • Project Start Date-Select actual  date -Apply Filter head- Select start Date

  • Completion Date-Select actual  date -Apply Filter head- Select Completion Date

  • Balance Days--Select Duration -Apply Filter head- Select Balance Days

  • Days Completed-Select Duration -Apply Filter head- Select Days Completed

  • Tender Value-Select Estimated Revenue -Apply Filter head- Select Tender

  • Budget Cost-Select Cost -Apply Filter head- Select Budget

  • Estimated Profit-Select Table chart-Select column Estimated revenue & Cost-Apply Filter Head-Select Tender and Budget-Create new Quick measure-Calculation type Subtraction for Estimated revenue minus Cost for filtered head - result will be estimated Profit. Add this measure to New Card  Named Estimated Profit.

5. Arrange and Format:

• Arrange the information cards on the page for clarity.

• Format the cards to make them visually appealing and easy to read.

6. Apply Filters:

• Go to the "Data" view and identify relevant columns for filtering, e.g., project name, location, or status.

• Return to the information cards page.

• Drag a filter element onto the page and connect it to the relevant visualizations.

• Users can now filter the information cards based on specific criteria, providing a dynamic view of the project data.

7. Save and Share:

• Save your Power BI file to retain the created visualizations.

• Share the Power BI file or publish it to the Power BI service for collaboration.

Tips:

• Utilize calculated columns or measures to calculate fields like balance days, days completed, and estimated profit based on your data.

• Explore additional Power BI features such as drill throughs and bookmarks for a more interactive dashboard.

Conclusion: By following these steps, you can effectively create information cards in Power BI from your Construction Project Daily Progress Report Excel Sheet. The use of filters enhances the flexibility and usability of the dashboard, allowing for detailed analysis and reporting. Feel free to explore additional features in Power BI to further customize and enhance your construction project dashboard.

Title: Microsoft Power BI Mastery Camp for Civil Engineers

Description:

Join our Microsoft Power BI Mastery Camp tailored exclusively for Civil Engineers, where you will delve into the art of harnessing Power BI to elevate your project management skills. This comprehensive training will focus on the creation of Labor, Plant, and Material (LPM) visual charts derived from daily progress reports.

Key Highlights:

1. Dynamic Cost Center Bifurcation: Explore the intricacies of segregating project costs into various heads, such as Labor, Staff, Plant, and Material. Learn how to leverage Power BI to create detailed visualizations that provide a transparent breakdown of expenditures.

2. Visual Chart Techniques: Dive into the world of visual representation using charts like Waterfall and Pie charts. Understand the nuances of employing these visual tools to communicate complex information effectively, aiding in better decision-making throughout the project lifecycle.

3. Comparative Analysis with Budgeted Costs: Uncover the power of comparison by utilizing Power BI to juxtapose the LMP costs during the progress phase with the initially budgeted costs. Gain insights into potential deviations and strategize adjustments to ensure project success.

4. Project Revenue and Profit Visualization: Learn to present project revenue and profit with precision using date slicers. Understand how to customize visuals based on required periods and dates, enabling you to communicate financial performance effectively to stakeholders.

5. Critical Role of LMP in Project Management: Grasp the significance of Labor, Plant, and Material in every phase of a project, from estimation and budgeting to the progress phase. Understand how Power BI can be a game-changer in streamlining processes and enhancing project management efficiency.

By the end of this camp, you will be equipped with the skills to harness the full potential of Microsoft Power BI for creating insightful visualizations, optimizing project cost management, and ensuring the success of your civil engineering projects. Don't miss this opportunity to elevate your proficiency in project management with the cutting-edge tools provided by Microsoft Power BI.

Course Title: Creating Daily Progress Report in Microsoft Excel for Construction Projects and Power BI Integration

Course Description:

Module 1: Introduction to Project Data Entry

• Overview of the importance of daily progress reports in construction projects

• Understanding the key elements in project data capture

• Introduction to the preferred use of Excel sheets for site information management

Module 2: Excel Sheet Structure for Daily Progress Report

• Detailed exploration of the tailored table format for efficient data entry

• Column head breakdown: Project Phase, Key Events, Start Date, Finish Date, Duration, Actual Date, Head, ITEM NO, BOQ, DESCRIPTION, Vendor/Company Name, Name of Resource, Executed QTY, Purchase QTY, Consumed QTY, Unit Rate, Cost, Estimated Revenue, Revenue Amount

Module 3: Building Interactive MIS Dashboards in Excel

• Importance of capturing data in a structured format

• Step-by-step guide to entering project information into the dataset

• Leveraging Excel's features to create interactive dashboards

Module 4: Data Set Usage for Various Project Transactions

• Exploring different types of project transactions: Tender BOQ, Estimate, Budget BOQ, and Daily Progress

• Ensuring all project transactions are captured in the daily progress report

• Demonstration of using Excel or Google Sheets for cross-departmental data entry

Module 5: Transforming Data into Actionable MIS Reports with Power BI

• Introduction to Power BI and its role in transforming data into actionable insights

• Linking the DPR dataset to Power BI for seamless integration

• Enabling data access for various departments and the head office

Module 6: Power BI Mastery Camp - Creating Civil Engineering Dashboards

• Understanding the significance of DPR dataset as the backbone of Power BI Mastery Camp

• Following the lecture video to enter project details and create historic civil engineering dashboards

• One-click refresh button for instant actionable MIS reports

Who Should Take This Course:

• Civil engineers, project managers, and professionals involved in construction projects

• Individuals interested in mastering Excel for efficient data entry and Power BI for advanced MIS reporting

Benefits:

• Gain practical skills in entering project information in a structured dataset

• Learn to build interactive dashboards for daily progress reports

• Unlock the potential of Power BI for transforming data into actionable insights

Join us in this groundbreaking course and be part of creating the first-ever civil engineering dashboards in history!

Welcome to Lecture 7 of the Power BI Mastery Camp for Civil Engineers

In this session, we delve into the heart of project management - the meticulous preparation of a Construction Project Resources Dashboard. As any seasoned civil engineer knows, efficient resource management is the linchpin of project success. Join us as we empower you with the skills to master this critical aspect of your construction projects.

Whether you're a seasoned project manager or a budding civil engineer, this lecture equips you with the tools to streamline resource management and enhance decision-making. Don't miss this opportunity to elevate your Power BI skills and revolutionize your construction project management approach!

Lecture 7: Preparing Construction Project Resources Dashboard

Overview: Resources play a pivotal role in driving project progress, and their efficient management is imperative for staying within budget and achieving success. This lecture focuses on creating a comprehensive Construction Project Resources Dashboard using Power BI. We cover key resource categories such as Material Purchase, Material Consumed, Machinery, Labor and Subcontractor, Fuel, Site Expenditure, and Staff.

Key Learning Objectives:

• Importing Daily Progress Report Data Set to Power BI.

• Updating data on a daily basis to ensure real-time reflection of resource visuals.

• Utilizing dynamic filters to select resource names, quantities, and costs.

• Implementing date slicers for a detailed cost analysis over specific periods or dates.

• Empowering project managers to monitor expenses by comparing them with budgeted costs.

• Exploring diverse possibilities for comparing resource heads across estimation, budgeting, and execution phases.

• Creating interactive and live resource tables

• Power BI  visuals are directly connected with the daily progress report data set. Our charts are meticulously prepared using table chart techniques, incorporating columns like resource name, quantity, unit, and amount. These charts are filtered based on project phases and resource heads, providing a clear visual representation of your project's resource utilization. Crosscheck your table total with the LMP table created in Lecture 6 for comprehensive project insight.

  
  

Why Attend this Lecture? This session equips you with the tools to seamlessly integrate daily progress data into Power BI, providing a dynamic and visual representation of your construction project's resource landscape. Learn how to navigate and analyze Material Purchase, Material Consumed, Machinery, Labor, Subcontractor, Fuel, Site Expenditure, and Staff metrics, enabling you to make informed decisions and maintain control over your project's financial health.

Who Should Attend:

• Civil Engineers

• Project Managers

• Construction Professionals

• Anyone involved in construction project resource management

Prerequisites: Basic understanding of Power BI is recommended but not required.

Join us for an insightful journey into the realm of Construction Project Resources Dashboard creation. Unlock the potential to optimize resource utilization and ensure the success of your construction projects. Enroll now and elevate your skills to new heights!