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 Reso…
Civil · Course
Effective Dashboards using Power BI for Construction Management
Learn about Effective Dashboards using Power BI for Construction Management.
- Duration
- 12 weeks
- Content
- 7 hours
- Projects
- 2
- Mode
- Online
OverviewWhat you'll
What you'll
be able to do.
- 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.
Tools you'll use
Power BI
Curriculum11 modules,
11 modules,
built with industry.
01Effective Dashboards using Power BI for Construction Management
- Introduction to Power BIW01
- 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
- Transform Data (Query Editor)W02
- Transform Data in Power BI
- Basic Table Transformation
- Text, Number, and Date Tools
- Index and Conditional Columns
- Grouping and Aggregating Data
- Pivoting and Unpivoting
- Transform Data (Query Editor)W03
- Merging, Modifying, and Appending Queries
- Connecting to Folders
- Defining Hierarchies and Categories
- Best Practices of Query Editing and Power BI
- Relational Data ModelW04
- Data Model
- Database Normalization
- Data Table Types
- Creating Power BI Table Relationships
- Table Schemas
- Relationships
- Relational Data Model Part -2W05
- 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
- Part 1 - Basics of DAXW06
- Introduction to Data Analysis Expressions (DAX)
- Calculated Columns vs Measures
- DAX Syntax and Operators
- Common DAX Functions
- Basic Date and Time Formulae
- Part 2 - Basics of DAXW07
- DAX Syntax
- Common DAX Functions
- Text Functions
- Related
- Basic Mathematical and Statistics Functions
- Calculate all Filter
- Time Intelligence Functions
- Advanced DAX FunctionsW08
- Calculated Joins between Tables
- Relationship Functions
- Advanced Time Intelligence
- Creating Interactive ReportsW09
- 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)
- Creating Interactive ReportsW10
- TreeMaps, Lines, Areas, and Gauges
- Editing Report Interactions
- Adding Drill-through Filters
- Linking to Report Bookmarks
- Using "What-If" Parameters
- Managing and Viewing Roles
- Creating Interactive ReportsW11
- Introduction to Power BI Service
- Power BI Service Administration
- Connecting to Multiple Types of Data
- Introduction to Power BIW01
Industry projects2 projects
2 projects
you'll ship.
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.
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 anal…
Go further
Part of a PG program.
FeeOne fee.
One fee.
Everything included.
Become job ready with our comprehensive industry focused curriculum for freshers & early career professionals
Premium
₹40,000
Inclusive of all charges- 1 Year Access
- Personalized Page
- Live Individual & Group Sessions
- Personalized & Hands-On
- Job-Oriented Industry Relevant Curriculum
Related
You might also like.
PG program · 24 weeksConstruction Project Management→PG program · 48 weeksHigh-Rise Building Design & Analysis→PG program · 48 weeksSteel Structures→PG program · 48 weeksBridge Design and Analysis→PG program · 32 weeksInfrastructure - Engineering Design and Project Management→PG program · 48 weeksBuildings - Engineering Design and Project management→
Next stepNot sure it's
Not sure it's
the right fit?
A counsellor will walk you through the syllabus, projects and fee options — and tell you honestly if another course suits you better.