Rakesh Tech Solutions is one of the leading IT Institutions for Power Bi Class Room And Online Training which is located in Hyderabad with the objective of providing a Training services for various requirements in IT industry.
POWER BI COURSE CONTENT
1)Introduction to Power BI Desktop
Installing Power BI Desktop
First Power BI Desktop Dashboard
Loading the Source Data
Data Load Process
Navigator Window
Navigator Data Preview
Modifying Data.
2) Creating Power BI Desktop Dashboard (Class assignment-1) with Excel data
source.
a) Find out Sales per Country by Year?
b)Find out Delivery Charge by Model?
c) Labor Cost by Country?
d) Total Cost of Spare Parts?
e)How to add a slicer by make? And use it as a filter.
f) Organising the Dashboard and going through properties. Like Adding Pages, Renaming
Pages
Deleting Pages, Moving Pages, Duplicating Pages etc
Note: Work assignment -1 will be provided with different data source. On which
students should work on.
For eg:
Task-1
1)Add a new page or sheet
2)Load the sales excel data into power BI
3)Select the fields or drag I.e Sales Type , Sales Amount and country
4) Select the column chart.
Task-2
1) Add a new page or sheet
2) Load the sales excel data into power BI
3) Select fields Channel type, Department and Sales cost
4) Select diff visualizations and check the views
3) Discovering and Loading Data with Power BI Desktop (class assignment -2)
- Loading Data i.e Web Pages, CSV Files, Text Files, XML Files, Excel, Microsoft
Access Databases etc.
Note: Work assignment -2 will be given with a different datasource. For example:
Task-1:(pie chart)
1)Add a new page or sheet
2)Load the sales excel data into power BI
3)Select the fields Channel type, Customer country and Sales amount .
4)Select the pie chart from matrix. And notice the values in reports area.
5)Notice the fields in legend, Details and values. Which can even be interchanged.
Task-2:(Line chart)
1)Add a new page or sheet
2)Load the sales excel data into power BI
3)Select the line chart first and then select the fields i.e Sales date, sales amount.
4) power bi automatically creates a hierarchy i.e yearwise -quarterwise –monthwise
5)Add customer location or country field to legend.
Task-3:(Bar chart)
1)Add a new page or sheet
2)Load the sales excel data into power BI
3) Select the fields Item category and Sales cost . from fields pane and notice values in
reports area.
4)Change the visualization to bar chart and then clustered bar chart.
Task-4:(Area Chart)
1)Add a new page or sheet
2)Load the sales excel data into power BI
3) Select the Area chart first and then select the fields i.e Sales QTY, pay type and items
name.
4)Select the Area chart from matrix. And notice the values in reports area.
Task-5:(Scatter Chart)
1)Add a new page or sheet
2)Load the sales excel data into power BI
3) Select the Scatter chart and then select the fields i.e Department, Manager and Sales QTY.
4)Select the Area chart from matrix. And notice the values in reports area.
Note: Students should complete the assignment with the source data
provided and should send the PowerBIfile(pbix) to the mail id of tutor i.e
powerbitutor@gmail.com
Note : Work assignment task provided in course content only shows how
the tasks are going to be. Further work assignment tasks and class
assignments will not be showcased in course content. Only given to
students who have completed prior work assignments .
5) Transforming Datasets:
- Power BI Desktop Queries
Editing Data After a Data Load
Transforming Data Before Loading
The Power BI Desktop Query Editor
The Power BI Desktop Query Editor Ribbons
Dataset Shaping: I.e Renaming Columns, Reordering Columns, Removing
Columns ,Merging Columns, Removing Records, Removing Duplicate Records,
Sorting Data, Reversing the Row Order
Filtering Data: i.e Selecting Specifi c Values, Finding Elements in the Filter List,
Filtering Text Ranges, Filtering Numeric Ranges, Filtering Date and Time Ranges,
6) Data Cleansing
Changing Data Type, Detecting Data Types, Replacing Values, Transforming Column
Contents
Filling Down, Using the First Row As Headers.
7) Data Mashup
The Power BI Desktop View Ribbon
Extending Data
Duplicating Columns, Splitting Columns . Splitting Column by a Delimiter, Splitting
Columns by Number of Characters
Merging Columns
Custom Columns
Index Columns
Merging Data
Aggregating Data During a Merge Operation
Types of Join
Joining on Multiple Columns
Preparing Datasets for Joins
Changing the Data Structure i.e Unpivoting Tables, Pivoting Tables, Transposing
Rows and Columns.
Managing the Transformation Process
Managing Queries
8) Creating a Data Model
Data Modeling in the Power BI Desktop Environment
The Power BI Desktop Data View
Data Model or Query
Manipulating Tables, Manipulating Columns, Power BI Desktop Data Types,
Formatting Power BI Desktop Data, Preparing Data for Dashboards
Adding Hierarchies
Designing a Power BI Desktop Data Model
Data View and Relationship View
Relationship View Display Options
Creating Relationships Manually and automatically.
Advanced Relationship Options
9) Relational Databases: SQL Server
Automatically Loading Related Tables
Database Options
Analysis Services Cube Tools
Microsoft SQL Server Analysis Services Tabular Data Sources
Pinning a Data Source
Refreshing a Query
Refreshing All the Queries in a Power BI Desktop File
10) Data Analysis eXpressions (DAX)
Math Operators
Rounding Values
Calculating Across Tables
Using Functions in New Columns like Safe Division, Counting Reference Elements,
Statistical Functions, the IF( ) Function, Exception Indicators, Flagging Data,
Creating Custom Groups Using Multiple Nested IF() Statements, Multiline Formulas
etc
Basic Aggregations in Measures.
Cross-Table Measures
Filtering Data in Measures
Multiple Criteria in Filters.
The ALLEXCEPT() Function
Displaying Rank , Calculation Options etc
10) Analyzing Data over Time using DAX
Simple Date Calculations, Date and Time Formatting, Calculating the Age of Cars
Sold
Adding Time Intelligence to a Data Mode
Creating and Applying a Date Table
Applying Time Intelligence
Comparisons with Previous Time Periods
Rolling Aggregations over a Period of Time
Comparison with a Parallel Period in Time
11) Filtering Data
Visual-Level Filters
Filtering Different Data Types
Advanced Text Filters
Specifi c Visualization-Level Filters
Page-Level Filters
Report-Level Filters
Using the Filter Hierarchy
12) Using Slicers
Formatting Slicers
Using Charts As Slicers
Charts As Filters
13) Enhancing Dashboards
Adding Text Boxes to Annotate a Report
Modifying the Page Background Color
Custom Images
Adding Shapes
Organizing Visuals on the Page
Exporting Data from a Visualisation
14) Q&A in power BI
Sometimes the fastest way to get an answer from your data, is to ask a question
using natural language. For example, "what were total sales last year." Use
Q&A to explore your data using intuitive, natural language capabilities and
receive answers in the form of charts and graphs. Q&A is different from a
search engine -- Q&A only provides results about the data in Power BI.
15) PowerBI.com (power bi cloud server)
Publishing Reports to PowerBI.com
Using Power BI Desktop Files in PowerBI.com
Interacting with a Report on PowerBI.com
Creating PowerBI.com Dashboards
Sharing Dashboards
Creating New Reports in PowerBI.com
- Note : Work assignment task provided in course content only shows how
the tasks are going to be. Further work assignment tasks and class
assignments will not be showcased in course content. Only given to
students who have completed prior work assignments .