Power BI Training Course | Master Data Visualization & Modeling

08 WEEKS

Power BI with AI Training Course

Instructor: Vijay
Category: Application Development
Last Update: September 2024
Review:

Rated 4.00 out of 5
(4.00)

Description

Power BI is a powerful suite of software services, apps, and connectors that turns your unrelated data into cohesive, visually immersive, and interactive insights. Whether your data resides in an Excel spreadsheet or a combination of cloud-based and on-premises hybrid data warehouses, Power BI empowers you to connect, visualize, and share data-driven insights with ease.

At Will Power Technologies, we recognize the ever-evolving nature of Power BI. Our curriculum is designed to cover all essential aspects of Power BI, in alignment with industry standards and certifications. Whether you opt for our in-person or online training, you will receive personalized attention and hands-on experience that will sharpen your Power BI skills and prepare you for real-world applications.

Key Highlights

Will Power Technologies offers a comprehensive Power BI training program that spans the full breadth of this powerful tool. Our courses are meticulously crafted to align with industry certifications, ensuring you gain the most in-demand skills in the field of Power BI. Through a blend of theoretical knowledge and practical exercises, you’ll be fully prepared to use Power BI for data visualization, data modeling, and business intelligence.

Comprehensive Power BI Fundamentals
Real-World Project Experience

Collaborative Learning Environment
Industry-Relevant Case Studies

Certification

It is designed to validate the knowledge, skills, and competencies of individuals in a specific area of study or professional field. The certification program is meticulously designed to ensure that candidates have acquired a comprehensive understanding of the subject matter. It encompasses both theoretical knowledge and practical application, allowing candidates to demonstrate their expertise in real-world scenarios.

Power BI Complete Course

Power BI Introduction
Data Visualization, Reporting
Business Intelligence (BI), Traditional BI, Self-Serviced BI
Cloud Based BI cloud service vs On Premise BI
Power BI Products
Power BI Desktop (Power Query - transformation, Power Pivot - modelling, Power View - reports)
Flow of Work in Power BI Desktop
Power BI Server, Power BI Service, Power BI Mobile
Flow of Work in Power BI / Power BI Architecture
A Brief History of Power BI

PBI Desktop Installation, PBI Desktop & Service Overview

Power BI Desktop Installation
Building Blocks of Power BI
Datasets, Visualizations, Reports, Dashboards, Tiles
Power BI Desktop User Interface
Fields Pane, Visualizations pane, Ribbon, Views, Pages Tab, Canvas
Overview of Power Query / Query Editor - Extract, Transform & Load Data
Connecting to Data Sources, Establish connection to the Excel source
Importing Data into Power BI or Query Editor
Transforming the Data using Power Query
Model the Data using Power Pivot – Relationship View
Creating New Measures and New Columns using DAX – Data View
Visualizing the Data using Power View and Power Maps – Report View
Saving and Publishing the Visuals or Reports
Logon to Power BI Service
View the Reports in PBI Service and Share the Reports

Reports View / Power View

Report View User Interface
Fields Pane, Visualizations pane, Ribbon, Views, Pages Tab, Canvas
Visual Interactions
Interaction Type (Filter, Highlight, None)
Visual Interactions Default Behaviour, Changing the Interaction
Bookmarks, Drill Through, Drilldown, Slicer, Hierarchy, Groupings

Filters in Power View

Filter Types
Visual Level Filters, Page Level Filters, Report Level Filters, Drill Through Filters
Filter Sub Types
Basic Filtering, Advanced Filtering, Top N, Relative Date Filtering
Numeric Field Filters, Text Field Filters, Date and Time Field Filters

Grouping, Binding & Sorting

Grouping and Binning Introduction
Using Grouping, Creating Groups on Text Columns
Using Binning, Creating Bins on Number Column and Date Columns
Sorting Data in Visuals
Changing the Sort Column, Changing the Sort Order
Sort using Column that is not used in the Visualization
Sort using the Sort by Column Button

Hierarchies and Drill-Down Reports

Hierarchy Introduction, Default Date Hierarchy
Creating Hierarchy, Creating Custom Date Hierarchy
Change Hierarchy Levels
Drill-Up and Drill-Down Reports
Data Actions, Drill Down, Drill Up, Show Next Level, Expand Next Level
Drilling Filters Other Visuals Option

Power BI Visualizations

Visualizing Data: Why Visualizations?
Visualization Types and Field Wells
Visuals for Filtering
Visualizing Categorical Data
Visualizing Trend Data
Visualizing KPI Data
Visualizing Tabular Data
Visualizing Geographical Data
Leveraging Power BI Custom Visuals

Visuals for Filtering

Slicer Visualization
When to use a Slicer
Create and format Slicer Visualization
Hierarchy Slicer (Custom Visualization)
When to use a Hierarchy Slicer
Create and format Hierarchy Slicer
Advantages of Hierarchy Slicer

Visualizing Categorical Data

Create and Format Bar and Column Charts
Create and Format Stacked Bar Chart and Stacked Column Chart
Create and Format Clustered Bar Chart and Clustered Column Chart
Create and Format 100% Stacked Bar Chart and 100% Stacked Column Chart
Create and Format Pie and Donut Charts
Create and Format the Tree Map Visual
Create and Format Scatter Charts

Visualizing Trend Data

Line and Area Charts
Create and Format Line Chart, Area Chart, Stacked Area Chart
Combo Charts
Create and Format Line and Stacked Column Chart, Line and Clustered Column Chart
Create and Format Ribbon Chart, Waterfall Chart, Funnel Chart

Visualizing KPI Data

Create and Format Gauge Visual, KPI Visual
Create and Format Card Visualization, Multi Row Card

Power Query

Introduction to Power Query – Extract, Transform & Load

Data Transformation, Benefits of Data Transformation
Shape or Transform Data using Power Query
Overview of Power Query / Query Editor, Query Editor User Interface
The Ribbon (Home, Transform, Add Column, View Tabs)
The Queries Pane, The Data View / Results Pane, The Query Settings Pane, Formula Bar
Advanced Editor – Complete ETL Code
Saving Your Work – Applying ETL Changes – Loading into Power Pivot Model
Power Query Conceptually

Datatypes and Filters in Power Query

Datatypes, Changing the Datatype of a Column
Filters in Power Query
Auto Filter / Basic Filtering
Filter a Column using Text Filters
Filter a Column using Number Filters
Filter a Column using Date Filters
Filter Multiple Columns

Inbuilt Column Transformations

Remove Columns / Remove Other Columns
Name / Rename a Column
Reorder Columns or Sort Columns
Add Column / Custom Column
Split Columns
Merge Columns
PIVOT, UNPIVOT Columns
Transpose Columns

In built Row Transformations

Header Row or Use First Row as Headers
Keep Top Rows, Keep Bottom Rows
Keep Range of Rows
Keep Duplicates, Keep Errors
Remove Top Rows, Remove Bottom Rows, Remove Alternative Rows
Remove Duplicates, Remove Blank Rows, Remove Errors
Group Rows / Group By

Combine Queries (Append Queries & Merge Queries) Append Queries / Union Queries

Append Queries
Append Queries as New
Append 2 or more files individually with different queries
Appending multiple files of same type from a folder using single query
Query Options
Copy Query, Paste Query
Delete Query, Rename Query
Enable Load, Include in report Refresh
Duplicate Query, Reference Query
Move to Group, Move Up, Move Down

Merge Queries / Join Queries

Merge Queries, Merge Queries as New
Default Types of Joins / Join Kinds / Merge Type
- Left Outer (all from first, matching from second)
- Right Outer (all from second, matching from first)
- Full Outer (all rows from both)
- Inner (only matching rows)
- Left Anti (rows only in first)
- Right Anti (rows only in second)
Cartesian Join or Cross Join

Power Pivot

Power BI Data Modelling – Relationship View

Data Modelling Introduction
Relationship, Need of Relationship
Relationship Types / Cardinality in General
One-to-One, One-to-Many (or Many-to-One), Many-to-Many
AutoDetect the relationship, Create a new relationship, Edit existing relationships
Make Relationship Active or Inactive
Delete a relationship
Cross filter direction (Single, Both), Assume Referential Integrity

Enhancing the Data Model - DAX

What is DAX, Calculated Column, Measures
DAX Table and Column Name Syntax
Creating Calculated Columns, Creating Measures
Implicit Vs Explicit Measures
Calculated Columns Vs Measures
DAX Syntax & Operators
DAX Operators
Types of Operators
- Arithmetic Operators
- Comparison Operators
- Text Concatenation Operator
- Logical Operators

DAX Functions Categories

Date and Time Functions
Logical Functions
Text Functions
Math & Statistical Functions
Filter Functions
Time Intelligence Functions

DAX Date & Time Functions

YEAR, MONTH, DAY
WEEKDAY, WEEKNUM
FORMAT (Text Function) → Month Name, Weekday Name
DATE, TODAY, NOW
HOUR, MINUTE, SECOND, TIME
DATEDIFF, CALENDAR
Creating Date Dimension Table

DAX Text Functions

LEN, CONCATENATE (&)
LEFT, RIGHT, MID
UPPER, LOWER
TRIM, SUBSTITUTE, BLANK

DAX Logical Functions

IF
TRUE, FALSE
NOT, OR, IN, AND
IFERROR
SWITCH

DAX Math and Statistical Functions

INT
ROUND, ROUNDUP, ROUNDDOWN
DIVIDE
EVEN, ODD
POWER, SIGN
SQRT, FACT
SUM, SUMX
MIN, MINX
MAX, MAXX
COUNT, COUNTX
AVERAGE, AVERAGEX
COUNTROWS, COUNTBLANK

DAX Filter Functions

CALCULATE
ALL
RELATED

DAX Time Intelligence Functions

Time Intelligence Introduction
TOTALMTD, TOTALQTD, TOTALYTD
PREVIOUSDAY, PREVIOUSMONTH, PREVIOUSQUARTER, PREVIOUSYEAR
NEXTDAY, NEXTMONTH, NEXTQUARTER, NEXTYEAR
SAMEPERIODLASTYEAR
YOY Growth
MOM Growth

Visualizing Tabular Data, Geographical Data

Create and Format Table Visual, Matrix Visualization
Create and Format Map Visual, Filled Map Visual, Arc GIS Maps Visual
Create and Format R Script Visual

POWER BI SERVICE

Power BI Service Introduction

Power BI Service Introduction, Power BI Cloud Architecture
Creating Power BI Service Account, SIGN IN to Power BI Service Account
Publishing Reports to the Power BI Service, Import / Getting the Report to PBI Service
My Workspace / App Workspaces Tabs
DATASETS, WORKBOOKS, REPORTS, DASHBOARDS
Working with Datasets, Creating Reports in Cloud using Published Datasets
Power BI Datasets Live Connection using Desktop
Working with Workbooks, Working with Reports, Sharing Reports

Dashboards Development

Creating Dashboards
Pin Visuals and Pin LIVE Report Pages to Dashboard
Advantages of Dashboards
Interacting with Dashboards
Adding Tiles to Dashboards
Web Content, Image, Text Box, Video
Formatting Dashboard
Sharing Dashboard

Data Gateways

Introduction to Data Gateways
How Data Gateways work
Connect to an on-premise Data Source by using a Data Gateway
Download Data Gateway
Installing a Data Gateway
Types of Gateways
On-premises Data Gateway, On-premises Data Gateway (personal mode)
Manage Data Gateway
Add and Remove Administrators
Add Data Source, Add or Remove Users to a Data Source
Refresh On-Premise Data
Configuring Automatic Refresh using Schedules

Collaboration in Power BI using App Workspace

Introduction to App Workspaces
Create an App Workspace
Add Members to App Workspace to Collaborate
App Workspace Access
Admin, Member, Contributor

Sharing Power BI Content using Apps and Content Packs

Introduction to App
Publish an App
Update a Published App
Manage Content in App
Include in App, Exclude in App
Sharing App
Entire Organization, Specific individuals or group
Unpublishing an App
Specific Groups, My Entire Organization
Selecting the Content / Items to Publish or Share

Row Level Security in Power BI

Introduction to Row Level Security
Row Level Security (RLS) with DAX
Manage Roles, Creating Roles, Testing Roles
Adding Members to Roles in Power BI Service
Dynamic Row Level Security
Creating Users Table and Adding to the Model
Capturing users using UserName() or UserPrincipalName() DAX Functions

SSAS Tabular Modal Cube

Introduction to SSAS Tabular
- Creating a Project
- Relationship and measures
- Measures and their usage
- Advantages of Tabular model
- Limitations
Tabular Model Basics
- Tabular – Development Server
- Workspace Server configuration
- SSAS Configuration management
- Project, Model – Properties
Tabular Model – Design
- Creating new model
- Importing data from different sources
- Create and Maintain relationship across data sources
- Creating measures and their usage
- Creating calculated columns
- Creating Hierarchies based on data sources
- Deployment
Deploy Tabular Model using SSMS
- Managing Server Properties
- Managing Cube properties
- Deploy the Cube

Power BI with AI Training Course Key Features

At Will Power Technologies, we provide a variety of training courses that cater to both beginners and experienced professionals. Our Power BI course is structured to offer comprehensive training, whether you're starting from scratch or looking to deepen your knowledge.

Career Counseling:We assist with resume writing, interview preparation, and job search strategies to ensure you are fully prepared to step into the job market.
Placement Assistance: With our extensive network of industry contacts, we help students find job opportunities after completing their training.
State-of-the-Art Lab Facilities: Gain practical experience with access to cutting-edge lab facilities where you can practice and refine your Power BI skills.
Flexible Online Learning Options: Learn at your own pace with our online courses, accessible anytime, anywhere.

Skills Covered

Will Power Technologies provides training courses that cater to both beginners and experienced developers. Our programs are designed to equip you with the necessary skills and knowledge to excel in the software industry.

Data Visualization: Master the art of creating visually appealing and informative reports and dashboards using Power BI’s robust visualization tools.
Data Modeling: Learn how to design and implement data models to organize and structure data for effective analysis and visualization.
Querying and Transforming Data: Develop expertise in importing, querying, cleaning, and transforming data from various sources for analysis and visualization in Power BI.
DAX (Data Analysis Expressions): Gain proficiency in using DAX functions and formulas for complex calculations, creating calculated columns and measures, and enhancing data analysis capabilities.

Pre Requisites

Our Power BI training is designed for individuals from any background. While familiarity with data analysis concepts, data visualization techniques, basic knowledge of databases and SQL, and experience with Excel are beneficial, no prior coding knowledge is required. All you need is a willingness to learn and adapt to the latest features and updates in the Power BI platform.

Any Degree: B.Tech, B.Sc., B.Com, BBA, etc.
All IT & Non-IT Branches: CSE, EEE, Civil, Mechanical, Biotechnology, etc.
No Prior Coding Knowledge Required: Open to all skill levels.
No CGPA Cut-Off: Career gaps are not a barrier to entry.

Course Information

Instructor: Vijay
Lessons: 40
Duration: 06 Weeks
Students : 150+
Course level: Beginners
Language: English/Telugu

FOLLOW US ON:

Recent Posts

Get in touch!

Courses Details