Before we start learning about Power BI we need to understand the need of it. To understand the business most of the organizations needs a tool that can help to understand their growth or customer behavior. So they have a huge amount of data to work with and data management is not the cup of tea of everyone. Lot of tools have emerged to solve the problem of data management these days. Power BI is the tool that every data analyst should know about. The ease provided by Power BI helps everyone to analyze and visualize the data. We are going to understand Power BI in following order :
- Facts about data
- Importance of Data Analysis
- Data Analysis use cases
- Different tools for Data Analysis
- What is Business Intelligence
- Introduction to Power BI
- Power BI Platforms
- Why Power BI
- Power BI Data Sources
- Getting Started with Power BI
- Power BI Installation
- Power BI Features
- Components of Power BI
- Power BI Architecture
- Basic Data Visualization with Power BI
- Power BI Advanced Visualization
- Every second 60,000search queries are performed on Google and 2 trillion searches per year.
- 1 billionpieces of content are shared via Facebook’s Open Graph every day.
- By 2025, the Data Science analytics sector in India is estimated to grow eightfold, reaching $16 billion.
- The US leads the data science market, requiring 190,000data scientists by next year.
Importance of Data Analysis
Data analysis refers to the technique used to analyze the data to enhance productivity and business gain. Data is being collected from different resources and is cleaned and analyzed to understand the pattern of it. Data Analysis is important for organizations to understand their daily, weekly, monthly, or yearly sales or productivity. Data could be too complex and large, so it should be represented in such a way that anyone can easily understand it. We need to perform data visualization to show data in form of graphs and charts.
Data Analysis Use Cases
- Google analytics is the best example,
- Also, Youtube analytics is also a great example of data analysis and visualization.
- News channels, social media, large or small organizations, everyone needs data analysis and visualization to show outcomes or to understand their business.
Tools for Data Analysis and Visualization
If you want to become a data analyst then you need to learn a tool like :
What is Business Intelligence ?
“BI is about providing the right data at the right time to the right people so that they can take the right decisions”
Business intelligence(BI) comprises the strategies and technologies used by enterprises for the data analysis of business information.
What is Power BI ?
Power BI is business analytics service build by Microsoft to perform data analysis on visualization. It is a data visualization and business intelligence user friendly tool which offers impressive drag and drop features and self-service capabilities. With the help of Power BI desktop we can easily build any graph like bar chart, histogram, pie charts, waterfall charts, funnel charts, etc.
Power BI Platforms
Power BI provides different platforms like :
Why Power BI ?
Power BI Data Sources
- Files – Excel, CSV, XML, JSON, PDF…
- Database – SQL, Access, Oracle, SAP HANA, IBM, Amazon…
- Power BI – Power BI datasets, Power BI dataflows, etc.
- Online Services – Salesforce, Azure, Google Analytics, Facebook, GitHub, etc.
- Others – Python, R, Web, Spark, HDFS, ODBC, etc.
Power BI Installation
- Step 1.Visit https://powerbi.microsoft.com/en-us/desktop/
- Step 2. Select Download free button and you will be redirected to Microsoft Store
- Step 3.Now click on install button
- Step 4.After Installation you can launch Power BI Desktop App
Power BI Features / Key terms / Building Blocks
A pictorial or graphical representation of data. Information is represented through graphs and charts.
Power BI popular charts listed below :
- Clustered Bar and Clustered Columns Chart
- Stacked Chart and Area Chart
- Pie Chart and Donut Chart
- Funnel Chart
- Waterfall Chart
- Ribbon Chart
- Cards and Multi-row Cards
- Scatter Plots
- Heat Map
- Line Plots
A dataset could be a collection of some information either structured or unstructured. Dataset is something that you connect Power BI with to perform data visualization.
Reports are collection of visualizations. It could be a one or more pages. It is arranged in such a way that suits your story best.
Dashboard is a collection of tiles (discussed below) that we use to tell the story of data. It is a single page interface.
Tile is a single visualization that we show on a dashboard or include in report. We can customize tiles and make them visually look more interactive.
Components of Power BI
Power Query : Used to search, access, and transform public or internal data sources.
Power Pivot : Used in data modeling taken from in-memory and perform analytics on it.
Power View : Used to represent data graphically.
Power Map : Used to visualize geo-spatial data and model it on map, i.e., geographical visualization.
Power BI Service : Enables the sharing of workbooks and data views.
Power BI Q & A : Natural Language Query, you can ask questions and it will return results immediately.
Power BI Data Catalog : It offers the capability to search and reuse queries
Power BI Data Management : Here, you get periodic data refreshers, expose tables and view data fields.
Power BI Architecture
Power BI architecture has three phases. These three phases are used to perform ETL (Extract, Transform, Load).
Data Integration : In first step we collect data from different sources and in different formats. Power BI extract that data and convert it into some standard format required for data analysis and visualization. After integrating data into Power BI, is stored in a common storage area known as staging area.
Data Processing : The data we provided to Power BI is raw data. So it requires data processing. Data processing or data cleaning are the operations where we transform the raw data and remove unwanted or missing or redundant values. Then we load this transformed data into the data warehouse.
Data Presentation : This is the final phase where data is being moved from data warehouse and loaded into Power BI service like Power BI desktop to create reports and dashboards. We then publish these reports on cloud premises to share these reports with other users.
Power BI Basic Data Visualization
- Data Analysis on IPL
- Creating basic charts like clustered bar chart, pie charts etc.
- Applying filters
- Making a report
Power BI Advanced Data Visualization
- Power BI load data using API Call
- Advanced Visualization like waterfall, funnel and ribbon charts
- Build report on COVID-19 Dataset