Business Intelligence Tool - Assignment
13 Pages1930 Words137 Views
Added on 2021-04-07
Business Intelligence Tool - Assignment
Added on 2021-04-07
ShareRelated Documents
I.Design a business intelligence tool,application or interface that can performa specific task to support problem-solvingor decision-making at an advance levelIn this section, I will use Tableau to conduct data analysis. Tableau is a powerful and fastestgrowing data visualization tool used in the Business Intelligence Industry. It helps to simplifyraw data in a format that is easy to understand. Tableau helps create data that can be understoodby professionals at any level in the organization. It also allows non-technical users to createcustom dashboards.The Dashboard created in this section was conducted with Tableau Public. Tableau Public,created by a software company in Seattle, enables interactive data visualization and focuses onbusiness intelligence. The product connects to relational databases, cubes and cloud databases.Tableau Public allows the creation of many types of graphs that can be combined in dashboardsand distributed on the internet. Currently used in all areas, Tableau Public has imposed by theeasy access not requiring programming skills. Among the advantages of using Tableau Public wecan mention:Speed – is the most important strength of Tableau Public. It is able to analyses millionsof rows and provide an answer in few seconds, enabling decision making in real time.Ease of use – based on the drag and drop option. Most of times, the graphics are createdby importing an Excel file. Engaging and interactive Dashboards – enables creation ofsmart charts and graphs.Direct connection to databases (Google Analytics, MySQL, Microsoft PowerPivot,Oracle, SAP, Windows Azure Marketplace Data Market, Excel, etc.)Easy sharing – can be easily distributed on internet and mobile devices.Popular Tool of Business IntelligenceBefore I go into data analysis, what is the dataset?According to Wikipedia, “A dataset (or data set) is a collection of data, usually presented intabular form. Each column represents a particular variable. Each row corresponds to a givenmember of the dataset in question. It lists values for each of the variables, such as height andweight of an object. Each value is known as a datum. The dataset may comprise data for one ormore members, corresponding to the number of rows. Nontabular datasets can take the form ofmarked up strings of characters, such as an XML file.”Content of dataset: The Olympic Games have been expanding every year which can be seen bythe records of the nation’s participating. This international sporting event where thousands ofathletes from various countries compete in various sports every four years, has experiencedenough growth in which we can begin to ask questions on the evolution of the Olympics basedon gender participation or their performance and results based on basic biological information.
Linktodownloadthedataset:https://www.wisdomaxis.com/technology/software/tableau/sample-data/with name file is“Olympic Athletes.xlsx”This file includes data of medalists at the Winter and Summer Olympics, including Olympic years: 2000, 2002, 2004, 2006, 2010, 2012.Figure 9. DatasetThe data fields in the table:Athlete: This field lists all athletes' names.Age: This field lists the number of athletes' ages in the year they won the medal.Country: This field represents the athletes' hometown (Nationality).Year: This school indicates the year athletes won a medal.Closing Ceremony Date: This school tells you how long an Olympic season is to take place.Sport: This school indicates the sport in which the medalist has participated.Gold Medals: This school shows the number of gold medals an athlete has won.Silver Medals: This school shows the number of silvers medals an athlete has won.Bronze: This school shows the number of bronze medals the athlete has earned.Total Medals: This field shows the total number of medals an athlete has earned.To analyze the data, I will open Tableau, I will go to the data source interface and do the following operations:Tableau has two ways to load data. One is real-time connection to obtain query results from datasources; the other is data extraction, which extracts data to the Tableau data engine formanagement.
Figure 10. Data SourceThen, I will plot the total number of medals won in each sport over the games.To plot a data analysis chart, I will drag the Sport field to Columns, drag the Totals Medals field to Rows with the default math Sum.Next, I will drag the Year field to Rows, in the down arrow select Discrete, the data will be separated by year.
Figure 11. The chart of the total medals won in each sport across gamesIn 2000, the sport with the most medals awarded was crazy (190), followed by swimming (185).In 2012, the sport with the most medals was swimming (195), followed by athletics (192).As can be seen with the Summer Olympics, the sport with the most medals awarded isswimming, athletics, sailing and soccer. Over the years, although the number of sports hasdiversified, there is still a lot of emphasis on traditional sports. To encourage the athletic spirit ofathletes, the organizers and athletes need to cooperate to encourage, call for more investment andenthusiastic participation of athletes in many sports. has not been focused.With the Winter Olympics, we can increase the number of athletes by building ice rinks, artificial skiing or sending athletes abroad.Sports with many medal winners also need to be strengthened and developed. For example, withathletics that need regular maintenance and upgrading of the track, swimming needs to becleaned to change clean water, it is necessary to prevent fan enthusiasts, ...
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Business Intelligence and Reporting for Enterpriseslg...
|9
|1188
|22
A Critical Evaluation of the Big Data Approach to Drug Misuse Data Analyticslg...
|6
|1296
|13
Creating Dillard's Christmas Dashboard using Tableau Softwarelg...
|13
|2116
|53
BACKGROUND A dataset is data collection, which most usuallylg...
|1
|418
|222
Uses of Pivot Tableslg...
|4
|699
|192
Business Information Systems Task 2022lg...
|7
|1078
|12