Practical 7: Introduction To Power BI

What is Power BI?

Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Your data may be an Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses. Power BI lets you easily connect to your data sources, visualize and discover what’s important, and share that with anyone or everyone you want.

Power BI is a business analytics service provided by Microsoft. It provides interactive visualizations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves, without having to depend on information technology staff or database administrators.

Power BI also gives you cloud-based BI services, known as “Power BI Services”, along with a desktop based interface, called “Power BI Desktop”. It offers data warehouse capabilities, including data preparation, data discovery and interactive dashboards. In March 2016, Microsoft released an additional service called Power BI Embedded on its Azure cloud platform which enables the user to analyze data easily, perform various ETL operations and deliver reports with Power BI.

Power BI gateways let you connect with SQL Server databases, Analytical Services, and many other data sources to your dashboard in Power BI and reporting portals, embed Power BI reports and dashboards to give you a unified experience.

Key features

Microsoft has added a number of data analytics features to Power BI since its inception and continues to do so. Some of the most important features include:
  • Artificial Intelligence — Users can access image recognition and text analytics in Power BI, create machine learning models using automated machine learning capabilities and integrate with Azure Machine Learning.
  • Hybrid deployment support — This feature provides built-in connectors that allow Power BI tools to connect with a number of different data sources from Microsoft, Salesforce and other vendors.
  • Quick Insights — This feature allows users to create subsets of data and automatically apply analytics to that information.
  • Common data model support — Power BI’s support for the common data model allows the use of a standardized and extensible collection of data schemas (entities, attributes, and relationships).
  • Cortana integration — This feature, which is especially popular on mobile devices, allows users to verbally query data using language and access results, using Cortana, Microsoft’s digital assistance.
  • Customization — This feature allows developers to change the appearance of default visualization and reporting tools and import new tools into the platform.
  • APIs for integration — This feature provides developers with sample code and application performance interfaces (APIs) for embedding the Power BI dashboard in other software products.
  • Self-service data prep — Using Power Query, business analysts can ingest, transform, integrate and enrich big data into the Power BI web service. Ingested data can be shared across multiple Power BI models, reports and dashboards.
  • Modeling view — This allows users to divide complex data models by subject area into separate diagrams, multi-select objects, and set common properties, view and modify properties in the properties pane, and set display folders for simpler consumption of complex data models.

Download and Install Power BI Desktop

Power BI Desktop is free software provided by Microsoft. You can visit the official website of Power BI so you can download the desktop application from the Microsoft Store.

Get started with Power BI

Import data to power BI


Import data to Power BI Dashboard from sample dataset

View Imported Data in tabular form

Previewing features of imported excel

Generate chart of Sales by category.


Thank you:)









Comments

Post a Comment

Popular posts from this blog

18IT100_Practical_Exam_Work

Image
Task-1: Dataset Description using Orange tool. What is need to be done to improve the accuracy of the classification result of the given dataset? Get the maximum classification accuracy possible by performing the following methods. -->Pre-processing o Encoding o Normalization o Missing value handling o Feature Selection Compare your accuracy with and without applying pre-processing steps. Perform the Classification and visualize accuracy before and after preprocessing in Orange/Python. What is Data Pre-processing? In any Machine Learning process, Data Preprocessing is that step in which the data gets transformed, or Encoded, to bring it to such a state that now the machine can easily parse it. In other words, the features of the data can now be easily interpreted by the algorithm. Encoding Encoding is the process of converting data from one form to another. While "encoding" can be used as a verb, it is often used as a noun, and refers to a specific type of encoded data Nor...
Read more

Practical:10 Getting started with Neo4j and Gephi Tool

Image
This blog contains two different tools , Neo4j and Gephi tool for data visualization in graphical form . Neo4j Neo4j delivers the lightning-fast read and write performance you need, while still protecting your data integrity. It is the only enterprise-strength graph database that combines native graph storage, scalable architecture optimized for speed, and ACID compliance to ensure the predictability of relationship-based queries. In simple words, Neo4j is the MySQL of the graph databases. It provides a graph database management system, a language to query the database, a.k.a CYPHER, and a visual interface with the neo4j browser. Advantages of Neo4j Following are the advantages of Neo4j. Flexible data model − Neo4j provides a flexible simple and yet powerful data model, which can be easily changed according to the applications and industries. Real-time insights − Neo4j provides results based on real-time data. High availability − Neo4j is highly available for large enterprise real-time...
Read more

Practical:6 Data-Preprocessing with orange Tool

Image
A guide to data preprocessing using Orange and how to use Python in Orange. This blog will help you understand how to perform Data pre-processing using Orange, use the Orange library in Python, and integrate Python Scripts in Orange. What is Data Preprocessing? When we talk about data, we usually think of some large datasets with a huge number of rows and columns. While that is a likely scenario, it is not always the case — data could be in so many different forms: Structured Tables, Images, Audio files, Videos, etc.. Machines don’t understand free text, image, or video data as it is, they understand 1s and 0s. So it probably won’t be good enough if we put on a slideshow of all our images and expect our machine learning model to get trained just by that! In any Machine Learning process, Data Preprocessing is that step in which the data gets transformed, or Encoded, to bring it to such a state that now the machine can easily parse it. In other words, the features of the data can now be ...
Read more