Menu

Executive Programs

Workshops

Projects

Blogs

Careers

Student Reviews



More

Academic Training

Informative Articles

Find Jobs

We are Hiring!


All Courses

Choose a category

Loading...

All Courses

All Courses

logo

Effective Dashboards using Power BI for Construction Management

Learn about Effective Dashboards using Power BI for Construction Management.

nsdc
Approved Training Partner

Book a Class, for FREE

RELATED RECENT PLACEMENTS

Rohit Mali

William O'Neil India

NMIMS MUMBAI

Dhiraj Satghare

RD Civil Solution

Acharya Shrimannarayan Polytechnic

Namrata Rao

Piaggio & C. S.p.A.

Rajeev Gandhi College of Engg and Research Institute

Siddhi Parab

C.C Engineers

lokmanya tilak college of engineering

Anil Katarkar

3D engineering

NATIONAL INSTITUTE OF TECHNOLOGY

Bhavesh Kumbhare

Dar Al-Handasah Engineering company

Rashtrasant Tukadoji Maharaj Nagpur University

Akash Bhadkumbe

XS CAD

Dr. D Y Patil College of Engineering & Innovation, Varale

Madhura Joshi

NEILSOFT LIMITED

Government Polytechnic Ratnagiri

Syllabus

This course is full of best-in-class content by leading faculty and industry experts in the form of videos and projects

Course Overview

  • Business intelligence tools like Power BI drive organizations towards better decision outcomes that put them ahead of competitors in the industry.
  • With Power BI, businesses can effectively visualize and interpret data to make informed decisions and draw strategic insights about the future. 
  • As data interpretation and visualization is crucial to business across all industries, an understanding of Power BI has become essential. 
  • This course will provide learners with the skills needed to build professional business intelligence reports and dashboards from the ground up.

Course Syllabus

On a daily basis we talk to companies in the likes of Tata Elxsi and Mahindra to fine tune our curriculum.

Week 01 - Introduction to Power BI

  • Introduction to the Power BI
  • Why Power BI?
  • Installing Power BI Desktop
  • Introduction to Power BI Query Editor
  • Types of Power BI Data Connectors
  • Basic Table Transformations

Week 02 - Transform Data (Query Editor)

  • Transform Data in Power BI
  • Basic Table Transformation
  • Text, Number, and Date Tools
  • Index and Conditional Columns
  • Grouping and Aggregating Data
  • Pivoting and Unpivoting

Week 03 - Transform Data (Query Editor)

  • Merging, Modifying, and Appending Queries
  • Connecting to Folders
  • Defining Hierarchies and Categories
  • Best Practices of Query Editing and Power BI

Week 04 - Relational Data Model

  • Data Model
  • Database Normalization
  • Data Table Types
  • Creating Power BI Table Relationships
  • Table Schemas
  • Relationships

Week 05 - Relational Data Model Part -2

  • Relationship Cardinality
  • Connecting Multiple Data Tables
  • Filter Flow
  • Two-way Filter
  • Filtering and Cross-filtering
  • Hiding Fields from the Power BI Report View
  • Data Modeling and Power BI Best Practices

Week 06 - Part 1 - Basics of DAX

  • Introduction to Data Analysis Expressions (DAX)
  • Calculated Columns vs Measures
  • DAX Syntax and Operators
  • Common DAX Functions
  • Basic Date and Time Formulae

Week 07 - Part 2 - Basics of DAX

  • DAX Syntax
  • Common DAX Functions
  • Text Functions
  • Related
  • Basic Mathematical and Statistics Functions
  • Calculate all Filter
  • Time Intelligence Functions

Week 08 - Advanced DAX Functions

  • Calculated Joins between Tables
  • Relationship Functions
  • Advanced Time Intelligence

Week 09 - Creating Interactive Reports

  • Introduction to the Power BI Report View
  • Adding Basic Charts to Power BI Reports
  • Create a Visualization
  • Filtering Options
  • Matrix Visualization
  • Slicers and Timelines
  • Key Performance Indicator (KPIs) Chart
  • Power BI Map Visuals (Basic, Fill, ArcGIS)

Week 10 - Creating Interactive Reports

  • TreeMaps, Lines, Areas, and Gauges
  • Editing Report Interactions
  • Adding Drill-through Filters
  • Linking to Report Bookmarks
  • Using "What-If" Parameters
  • Managing and Viewing Roles

Week 11 - Creating Interactive Reports

  • Introduction to Power BI Service
  • Power BI Service Administration
  • Connecting to Multiple Types of Data

Our courses have been designed by industry experts to help students achieve their dream careers

Industry Projects

Our projects are designed by experts in the industry to reflect industry standards. By working through our projects, Learners will gain a practical understanding of what they will take on at a larger-scale in the industry. In total, there are 2 Projects that are available in this program.

Analysis of Supply and Demand Gap Using Power BI

  • Students will have to identify the gap between demand and supply so that organizations can take action to minimize those gaps.
  • The candidates can choose any domain, like Human Resources, Retail, Automobile, Cab Services, Renewable Energy, and Food Industry.

Vaccinations Trend Analysis

  • In this project, students have to track and analyze COVID-19 vaccination trends to see doses administered by manufacturer, country, region, age, and gender.
  • This project is to analyze the Vaccination Trends while answering the questions listed below and help the government implement more awareness programs to meet 100% vaccinations.
    • What vaccination schemes are used in various countries across the globe?
    • A total number of vaccinations and percent of vaccinations by various regions.
    • Total people vaccinated and percent of people vaccinated, etc.

Our courses have been designed by industry experts to help students achieve their dream careers

Ratings & Reviews by Learners

Skill-Lync has received honest feedback from our learners around the globe.

Google Rating
4.8

Effective Dashboards using Power BI for Construction Management

Instructors profiles

Our courses are designed by leading academicians and experienced industry professionals.

image

1 industry expert

Our instructors are industry experts along with a passion to teach.

image

10 years in the experience range

Instructors with 10 years extensive industry experience.

image

Areas of expertise

  • Power BI

Similar Courses

Got more questions?

Talk to our Team Directly

Please fill in your number & an expert from our team will call you shortly.

Please enter a valid number