Effective Dashboards using Power BI for Construction Management
Learn about Effective Dashboards using Power BI for Construction Management.
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.
Instructors profiles
Our courses are designed by leading academicians and experienced industry professionals.
1 industry expert
Our instructors are industry experts along with a passion to teach.
10 years in the experience range
Instructors with 10 years extensive industry experience.
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.