Power BI
Power BI is a Microsoft’s cloud-based business intelligence technology which is
part of theOffice 365 suite- a cloud based suite of productivity applications like
other business intelligence tools. Power BI focuses to democratize the data analysis
procedure by analyzing and visualizing data in a self-service way. Power BI helps
business users to access and analyze the data in user-friendly formats such as dashboards,
reports and datasets.It is designed to help business userscan gain insights from
their data like other Technologies, Power BI is a hybrid of on-premises and cloud
components.The authoring is done in Excel 2013 on Windows desktops. Publishing is
through Office 365’s SharePoint —requiring the end-users to have only a Web browser
or a tablet device for native mobile apps.
Tableau
Tableau is Business Intelligence (BI) tool that can help you create beautiful and
visually-renders reports, charts, dashboardsand graphs using your data. These reports
are interactive and can easily be shared with anyone. This data visualization software
is extremely robust and easy to use that it has a drag and drop interface, so you
need not be a techie to use it.Tableau helps you visualize & analyze your big data
and it can be a great source in helping you solve your complex business problems.
Visual representation of data can be very helpful in finding solutions to a lot
of problem
SQL
SQL (Structured Query Language) is an interactive programming language for getting
information from a database. It can also update information in a database. SQL is
both an ANSI and an ISO standard many database products support SQL with proprietary
extensions to the standard language. SQL Queries take the form of a command language
that lets you select, insert, update, find out the location of data, and so on.
SQL is the standard language for Relation Database Management System. All RDBMS
like Oracle, Sybase, Informix, postgres and MySQL, MS Access, SQL Server use SQL
as standard database language.