Power bi

Power bi

Power bi

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. 
Rakesh Tech Solutions Trainings  is started by a group of highly talented faculty in their respective courses  with Class Room And online support for students and Employees in world wide. 

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 .

Send Us A Message