Microsoft Power BI
What is Microsoft Power BI?
Microsoft power BI is a business intelligence tool .it is a most popular BI tool Microsoft power BI is a software which can be used for visualizing the Data in the other words, it is an interactive reporting platform to analyze data to analyze business reports and many more .so it's basically works with data to use it effectively .to get any answer within a short span of time and also it is a cloud platform as well.
When to use it?
When it is time to work with massive amount of data especially with different type of data we must go through Microsoft power BI in fact when it comes to the question of security of data then power BI is a best option for any data .we can work with data from all types of platform for example from Microsoft excel ,from SQL server ,API and web page as well .not only that even if you want to shape or clean your data power BI is a best option using power query.
Where to use it?
If we need to optimize or model our data in that case When the data will come to power BI we can do modeling of that particular data by our choice. Microsoft power Bi is being used in many section nowadays including data formatting ,data shaping .microsoft power BI can works on report and dashboard ,we clean data in power BI we can model our data in any format in power BI .it is very very easy and very simple to learn when you have to create a data form or chart from EXCEL ,CSB,PDF SQL,ORACLE,WEB on that time we can use microsoft power BI and if we want share the data with someone we can use power BI service account so this entire process is automated.
Reflection
From this talk we have learnt so many things including data visualization , ICEP ,visual design ,chart type & design practices and all about Microsoft power BI .Use of microsoft power BI in different sectors . data formatting based on Microsoft power Bi .Designing data by microsoft power BI .
Trends of Data Analytics in Different Sectors
Education
- Prediction of Academic Future and Career
Data analytics-driven education program help organizations and mentors obtain a deeper understanding of a student's academic development, as well as an assessment of the student's strengths and weaknesses. Based on the performance statistics gathered by data analytics, it may be effectively used to identify students who are at risk of failing and then guide them down a route that will lead to academic achievement.
- Identifying the Most Effective Educational Practices
Data analytics may be effectively used to monitor and visualize each student's educational and behavioral patterns. Instructors can examine and use the data gathered to determine the behavior and working process of the institution's most successful students. The data is evaluated to identify the most effective educational approaches, and then the remaining students are encouraged to study in a similar manner in order to achieve maximum academic performance.
Group 3 members
Team Members:
- Khaled Mahmud Sujon A20EC4082 (Leader) – Industrial Talk 7
- Tahia Khan A20EC3030 – Finding data and data visualization
- Nick Glenn Lin Zhen Ming B20EC3012 - Discussion of the data findings and organizing the content
- Ahmad Darwish Danial bin Ahmad Nazrun A21EC0005 - Trends of Data Analytics in Different Sectors
Banking
- Sales and marketing significantly boosted
Banks commonly have data on where to target specific demographics (such as those who use mobile apps or shop at specific businesses), and they can use predictive analytics to identify when marketing initiatives are most productive. Banks usually have data on where to target specific demographics (such as those who use mobile apps or shop at specific businesses), and they can use predictive analytics to identify when marketing initiatives are most effective.
- Improved security
Banks use the big data analytics to develop a profile of typical customer behavior, allowing them to spot and highlight odd conduct that could indicate their account has been hacked. A sequence of large-ticket purchases, for example, could trigger an alert or even lock down an account until the bank can confirm that the person made the purchases.
Reflection
Data analytics improve our daily life in many aspects. In the upcoming future, more data will be generated. With data, a lot of things could be done. Data which holds the information about something are crucial for development of different sectors. By using data analytics methods, the data can be analyzed and used to improve every domain. Improved domains lead to a brighter human future. Every sector will be able to operate better using the new improved data. This will also lead to more new job opportunities especially in computer science sectors. We need to be prepared for the upcoming future as it will change dramatically driven by the data analytics.
Introduction to data visualization
Introduction
In the year 2020, many lives were shaken by the impact of viral covid-19 virus. It has changed the entire world, and no one can live as how they used to. How has the virus affected the lives of people in the United States? How many people survived this virus? Here are some visualizations created using Microsoft Power BI that will answer these questions. The data has been cleaned and only usable variables are kept for the fitness of the story.
Figure 1:before transforming
Figure 2: after transforming
Results for Data Visualization
According to the descriptive analytics shown, the state New York has the highest number of deaths (above 25k) while Alaska has the least (around 100). This may be due to the lack of covid-19 awareness and hospitality that has caused so many deaths. Figure 3: Death by state
The amount of people who tested are quite high according to the prescriptive analytics, which says a lot about how many people are ill and have thought they had the virus. Only 9 million people were infected from about 142 million people. Figure 4: infected and tested
From the 9 million people who were infected in this prescriptive analytics, 200k people have faced death. This may be due to the lack of services in the hospital as there were a lot of cases and the virus spread very quickly. Figure 5: Infected and deaths
The state with the highest ratio of unemployment citizens belongs to Alaska according to this predictive analytic. Due to the pandemic, many lives were affected, and Alaska was not ready economically ready to deal the pandemic like other states. Figure 6: Unemployed by state
Conclusion
In conclusion, many states were prepared and have handled the pandemic well with proper hospitality and resources. However, many states have lost a big number of citizens and have a lot of infected citizens, so they were not ready to handle a pandemic. Maybe in the future this will help them know that they always must be ready to take on a global pandemic so that less people are affected.