Know about the PowerBI architecture, components, features

 What is PowerBI?

Power BI is a business intelligence tool that is used as a data visualization tool. It can convert data from different sources into a visually interesting and interactive dashboard. 

The data information is reported in the form of graphs, charts and other multimedia formats.

For example, excel sheets that consist of information power BI will convert the information into visualized form such as graphics, charts.

Power BI is used for cloud based apps and the data are analysed and managed from different sources in a convenient way. Business Intelligence tool helps the businesses to take the right decision at the right time.

It is based on the windows desktop application also called Power BI desktop, it is also based on Saas app called Power BI services. The different versions of Power BI that are used in different platforms such as mobile apps, desktop, Saas, etc.

Architecture

Power BI Desktop

It is a free data visualization tool that you can install on Windows computers to provide reports and visualizations. Power BI supports different databases and systems to extract business data. It is an easy tool for the developers to transfer the data into clear visualized form. Power BI desktop also provides data warehouse capability including data preparation and data discovery. Reports of data can be prepared by this tool but sharing of data within the tool is not possible.

Power BI services 

Power BI is a cloud service platform that provides the user to create interactive dashboards and share the developed reports. Features of Power BI desktop are supported by Power BI service. 

• It is used to share dashboards and reports with other Power BI users

• Offers different workspaces

• Analyze data in excel

• It also used to share the reports securely in other systems via embed API

• Create reports and share dashboards of business intelligence to other users in the team.

With the Power BI services things cannot be achieved, it can be done with the support of Power BI desktop. 

• For adding rules in the row-level security 

• To create calculated columns 

• Foe advanced query editor

• Used in DAX and python support

• For data transformation and modeling 

Power BI gateway-You can utilize the Power BI on-premises entryway to keep your data new by interfacing with your on-premises data sources without the need to move the data information. It permits you to question huge datasets and advantages from the current ventures.

Power BI Mobile app- it is used in mobile applications in which you can access the data from anywhere you want. It is available for windows, IOS, and Android platforms.

 

Features of Power BI?

1. It accesses a large number of data from various sources. It offers the user to visualize, analyze large amounts of data that can’t be viewed in excel. Some of the necessary data sources available for Power BI as Excel, CSV, JSON, etc. 

2. It is used to provide interactive UI/UX features that allows it to be visually attractive and also allows the functionality easy and the features that offer you to copy all and formatting into visualizing form.

3. It is easy for exceptional excel integration and it helps to convert the insights of data into action to make data-driven business decisions.

4. It permits real-time stream analytics that allows to fetch data from different multiple sources to connect real time stream analytics so that it would be easy to take business decisions.

Components of Power BI

1. Power Query is known as a data conversion and collection of engines. It helps you to find, associate, combine and refine data sources to meet your analysis needs. It may be installed and included for Excel or can be utilized as a feature of the Power BI Desktop.

2. Power view that is used in sharepoint, sql server, etc. it displays the data in the visualized form, it brings data to life. Data visualization is done in the form of graphs, charts, etc.

3. Power map that offers you to map the data information instead of creating a huge size table. It creates 3-D data visualization in an effective manner. The visualization is based on longitude, latitude, or country, state, etc.

4. Power pivot used to data model that allows you to create data models, create calculations and provide relationships. The data modeling is developed  using data analysis expressions.

5. Power BI desktop is a development tool for Power BI desktop for Power Query, Power pivot, Power view. Everything can be created under Power BI desktop also it is easy to create BI and data analysis experience.

Manual Testing Training in Bangalore

Manual testing is known as a software testing process that executes test cases without the use of any tools. According to the end user’s point of view it executes the test cases manually. It checks the working condition of an application correctly and implements the complete software application effectively.

 Manual testing is the fundamental process that can correct both the visible and hidden defects of software applications accurately. Manual testing is very important for the all new developed software before automation  time and effort is essential for manual testing. It provides bug free software. Manual is an essential component for the testing in software development.

Although manual testing is required for the newly developed software. It checks the features of software working properly. It ensures that all are created and processed properly.

 Types of Manual testing

Manual testing keeps the software development error-free. There are various types to ensure error-free software development.

 1)   Black box testing:

It is the technique of testing software development without seeing internal code structure. Hence the developers don't want to know about the internal code structure. It ensures if the software matches its specification and requirements given by users. Black box testing ensures the inputs and output application without the consideration of internal structure.

 2)   White Box Testing

It  is exactly opposite of black-box testing. To perform manual testing internal structure, codebase knowledge is required, in this type it defines code visibility for the manual testers.

White box testing used to define the flow of input and output instead of focusing on the functional needs of the application. It is used to improve the software application design and usability that strengthens its security.

3)   Exploratory testing

Exploratory testing is a kind of Manual testing in which the testers don't want to create test cases in an advanced way. It is used to create out-of-box test cases and execute the test cases quickly.

The testers have the freedom and responsibility to introduce the continuous design and execution of testion features.

It helps the testers to escape from the predefined test cases and provides learning, investigation and discovery of the application in learning.

Difference between Manual andAutomation testing

Manual testing requires human action while automation testing requires machines. Manual testing is suitable for user interface and user experience.

Automation testing is suitable for stable systems that promote lesser bugs, it is mostly used for regression testing and performance testing. Testing tools like selenium and Jmeter are commonly used.

 Pros

●     Accurate

●     Provides human insight

●     Adaptable

●     Saves money

Cons

●     It provides heavy resources

●     It is not always suitable

●     Potential for errors

●     It is not reusable

How Manual testing is performed?

❖   It is necessary to understand the project requirement, understand the behavior of software, and what should be tested.

❖   Prepare test cases after the understanding of project requirements and should implement the test case in order to provide error-free software application.

❖   Report the bugs once the bugs are identified, again execute failed test cases to verify they pass.

Why Manual Testing?

Manual testing is based on human perspective, the usability and look,feel of the application can be implemented by humans.

Manual check consistently gives a more extensive point of view of the general application. As the human mind will forever be in an exploratory structure, rather than a coding system that executes similar advances each time. In this way, it will give more extensive inclusion for the system validationAnother situation where manual testing is required is the situation usability testing.

 We perform usability testing to assess how helpful, proficient, and easy to understand the item has ended up being for the end clients. For this appraisal, we require the most elevated manual mediation and can't depend on instruments to survey it for us. So to assess the item according to the end-client perspective, we decide on manual testing.