Enroll Now

Hello There!

Information

Follow Us

Courses / Data Science / Analytics / Power BI
Data Science / Analytics

Power BI: Basics to Advanced

Salim Rana
Couse Completed

105

Category

Data Science

Upcomming Batch

15 Sept, 2024

Review

About Course

The Power BI Course Curriculum is designed by Microsoft Power BI Certified Experts. Our Power BI Course Syllabus covers basic to advanced level concepts that consist of Report Designing, Visual Sync, Grouping, Hierarchies, Filters, Bookmarks, Azure, Modeling, DAX Functions - Level 1, DAX Functions - Level 2, Power BI Cloud, Excel & RLS, Report Server, RDL and more. Get Practical Exposure on Microsoft Power BI for Data Analytics and Visualization with Our Updated Power BI Training Course Content

Show more

Course Objectives

  • Recognizing the key characteristics of Power BI and the differences between Power BI (PBI) and business intelligence (BI).
  • To become proficient with the building blocks, architecture, and regional settings of Power BI, as well as the program's user interface. Power BI Desktop installation and configuration, ensuring best practices are followed.
  • You become familiar with Power BI's many connectors and learn how to use the query editing tools to efficiently convert and manipulate data.
  • Gaining expertise in data transformation methods, such as gathering and aggregating data, working with text, numbers, and dates, and constructing index columns.
  • To generate reports, use conditional formatting, basic charts, and graphics, and explore the "Report" feature in Power BI Desktop.
  • Gaining a thorough understanding of Power BI data modeling, including table relationship creation and the distinction between data and lookup

Course Curriculum

An Overview of Power BI Features
Course Resources to help you get started
Understanding BI vs PBI
Analogy of waves to explain the different behavioral patterns
Optimisation techniques in Power BI
Key components of Power BI
Power BI Architecture and its working
Building blocks of Power BI
Microsoft Power BI future demand and other key metrics
Power BI Desktop Download & installation settings
The Regional settings in PBI

Choose the right type of Connector in Power BI
Using Power BI query Editor with query editing tools
Create basic data transformations in your table in Power BI
Working with Text, Number & Date Tools
Generate Index and create conditional index column
Group a column by using an aggregate function
Power BI Grouping & Aggregating Data
Pivoting and Unpivoting data
Append Queries vs Merge Queries

Exploring the "Report" View in PBI Desktop
Greetings and introduction
Adding Simple Objects to the PBI Report Canvas
Inserting Basic Charts & Visuals
Report Formatting and Filtering Options
Exploring Data with Matrix Visuals
Filtering with Date Slicers
Showing Key Metrics with Cards & KPI Visuals
Inserting Text Cards
Visualising Geospatial Data with Maps
Visualising Data with Treemaps
Showing Trends with Line & Area Charts
Adding Trend Lines & Forecasts
Goal Pacing with Gauge Charts
Editing Power BI Report Interactions
Adding Drill through Filters
Using Power BI Report Bookmarks
PREVIEW: Designing for Phone vs. Desktop Report Viewers
PREVIEW: Publishing to Power BI Service

The data model in Power BI
Understanding Data Tables vs Lookup Tables
Understanding Table Relationships vs Merged Tables
Creating Table Relationships
Understanding Filter Flow
Filtering & Cross-Filtering
Hiding Fields from the Power BI Report View
Use of snowflake schema in Power BI
Managing & Editing Table Relationships
Managing Active vs Inactive Relationships
Understanding Relationship Cardinality

Intro to Data Analysis Expressions (DAX)
DAX Columns vs Measures
Adding Columns & DAX Measures in Power BI Desktop
Implicit vs Explicit DAX Measures
Understanding DAX Syntax & Operators
Common DAX Function Categories
Basic Date & Time Functions
Conditional & Logical Functions (IF/AND/OR)
Text, Math & Stats Functions
COUNT Functions (COUNTA, DISTINCTCOUNT, COUNTROWS)
CALCULATE, ALL & FILTER Functions

Ratings & Reviews

4.5

Rated 4 out of 1 Rating

5 star
82%
4 star
30%
3 star
15%
2 star
6%
1 star
10%

Featured review

Reena

2 weeks ago

I learned so much from this course. The real-world examples and hands-on projects made the concepts easy to understand. I'm now able to create detailed reports and dashboards with confidence.

Helpful?

santhosh

2 weeks ago

he course was challenging, but in a good way. The assignments pushed me to think critically and apply what I learned. By the end, I felt confident in my ability to build and evaluate ML models.

Helpful?
This course includes:
Duration 40 hrs
Skill Level Beginner
Language Tamil / English
Certificate Yes
Enquire NoW

Related Courses

Data Science / Analytics

Explore Tableau

Master Tableau to build insightful and interactive data dashboards.

5.0 /5

Preview this Course
Data Science / Analytics

Data Science using Python

Data Science is the practice of extracting actionable insights from data using statistical

5.0 /5

Preview this Course
Data Science / Analytics

R Programming

R programming is a language and environment for statistical computing,

5.0 /5

Preview this Course