Effective Dashboards using Power BI
Become an expert in the development of effective visual dashboards using Power BI.
RELATED RECENT PLACEMENTS
DHIRAJ KADAM
Tech Mahindra
MIT Group of Institutions Aurangabad
Mukesh Kanna S
Tech Mahindra
Panimalar Engineering College
SATHIYA MOORTHY A
Tech Mahindra
Apollo Engineering College
G Harish Jairaj
IIT Madras
Velammal Engineering College
Gorle Balaram
Relaince Jio
Sri Venkateswara College Of Engineering & Technology
Prakash Shukla
Escorts
Kamla Nehru Institute of Technology, Sultanpur (U.P.)
Gunashekar Srinivas
Equilibrium Solutions
Vellore Institute of Technology - VIT Chennai
Durga Varaprasad
Tata Elxsi
Osmania University Hyderabad
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, as well as 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 an essential element.
- This course will provide learners with the skills needed to build professional business intelligence reports and dashboards from the ground up.
- Learners will understand how to blend and transform raw data into interactive dashboards.
- This course will explain relational data models, Data Analysis Expressions (DAX), and how to create interactive reports.
- Learners will complete projects that require extensive use of Power BI that they can showcase to demonstrate their job-ready skills.
Who can take this course?
Engineering graduates and working professionals with a background in similar fields.
Course Syllabus
On a daily basis we talk to companies in the likes of Tata Elxsi and Mahindra to fine tune our curriculum.
Week 1 - Introduction to Power BI
This week will cover
- Power BI: Introduction
- Why Power BI
- Installing Power BI
- Power BI Query Editor: Introduction
- Types of Power BI Data Connectors
- Basic Table Transformation
Week 2 - Transform Data (Query Editor) - Part 1
This week will cover
- Data Transformation in Power BI
- Basic Table Transformation
- Text, Number & Date Tools
- Index & Conditional Columns
- Grouping & Aggregating Data
- Pivoting & UnPivoting
Week 3 - Transform Data (Query Editor) - Part 2
This week will cover
- Merging, Modifying & Appending Queries
- Connecting to Folders
- Defining Hierarchies & Categories
- Best Practices of Query Editing & Power BI
Week 4 - Relational Data Model - Part 1
This week will cover
- Data Model
- Database Normalization
- Data Table Types
- Creating Power BI Table Relationships
- Table Schemas
- Relationships
Week 5 - Relational Data Model - Part 2
This week will cover
- Relationship Cardinality
- Connecting Multiple Data Tables
- Filter Flow
- Two Way Filter
- Filtering & Cross-Filtering
- Hiding Fields from the Power BI Report View
- Data Modeling & Power BI Best Practices
Week 6 - Basics of DAX - Part 1
This week will cover
- Data Analysis Expressions (DAX): Introduction
- Calculated Columns vs Measures
- DAX Syntax and Operators
- Common DAX Functions
- Basic Date and Time Formulas
Week 7 - Basics of DAX - Part 2
This week will cover
- DAX Syntax
- Common DAX Functions
- Text Functions
- Related
- Basic Mathematical & Statistics Functions
- Calculate
- All
- Filter
- Time Intelligence Functions
Week 8 - Advanced DAX Functions
This week will cover
- Calculated Joins between Tables
- Relationship Functions
- Advanced Time Intelligence
Week 9 - Creating Interactive Reports - Part 1
This week will cover
- Power BI Report View: Introduction
- Adding Basic Charts to Power BI Reports
- Create a Visualization
- Filtering Options
- Matrix Visualization
- Slicers & Timelines
- Key Performance Indicator (KPIs) Chart
- Power BI Map Visuals (Basic, Fill, ArcGIS)
Week 10 - Creating Interactive Reports - Part 2
This week will cover
- TreeMaps, Lines, Areas & Gauges
- Editing Report Interactions
- Adding Drill through Filters
- Linking to Report Bookmarks
- Using "What-If" Parameters
- Managing & Viewing Roles
Week 11 - Creating Interactive Reports - Part 3
This week will cover
- Power BI Service: Introduction
- 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.
Supply and Demand Gap Analysis
Learners 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, Food Industry. Using this, you will have to:
- Understand the business problem
- Provide data-driven insights for better decision-making to minimize the gaps between supply and demand
- Understanding the source of the gap and what is driving the gap
When submitting the project, you will have to deliver the following:
- Detailed document of your work with a description of the challenges you faced and the solutions to them
- List of formulas created in the report
- Power BI Report/.PBIX file
- Presentation of the project like a case study using PowerPoint
COVID-19 Vaccinations Trend Analysis
In this project, learners have to track and analyze COVID-19 vaccination trends to see doses administered by manufacturer, country, region, age, and gender. This project requires learners to:
- Work with large datasets
- Provide data-driven insights for better decision-making to increase vaccination awareness
- Identify vaccination schemes
- Understand where the vaccination progress is low, as well as the root cause of this
At the end of the project, you will have to deliver the following:
- Detailed document of your work with the challenges you faced when working on it, as well as the solutions to the problems
- List of formulas created in the report
- Power BI report/.PBIX file
- Presentation of the project like a case study using PowerPoint
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.
Flexible Pricing
Talk to our career counsellors to get flexible payment options.
INR 45,000
Inclusive of all charges
Become job ready with our comprehensive industry focused curriculum for freshers & early career professionals
1 Year Accessto Skill-Lync’s Learning Management System (LMS)
Personalized Pageto showcase Projects & Certifications
Live Individual & Group Sessionsto resolve queries, Discuss Progress and Study Plans.
Personalized & Hands-OnSupport over Mail, Telephone for Query Resolution & Overall Learner Progress.
Job-Oriented Industry Relevant Curriculumavailable at your fingertips curated by Global Industry Experts along with Live Sessions.
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.