In the beginning, the case was just data for a company that did not indicate any useful information that would help decision-makers. In this case, I had to ask questions that could help extract and explore information that would help decision-makers improve and evaluate performance. But before that, I did some operations in the data to help me to analyze it accurately: 1- Understand the data. 2- Clean the data “By power query”. 3- insert some calculation and columns like “COGS” cost of goods sold by power query. 4- Modeling the data and adding some measures and other columns to help me in analysis. Then I asked these questions: To Enhance Customer Loyalty What is the most used ship mode by our customer? Who are our top 5 customers in terms of sales and order frequency? To monitor our strength and weak points Which segment of clients generates the most sales? Which city has the most sales value? Which state generates the most sales value? Performance measurement What are the top performing product categories in terms of sales and profit? What is the most profitable product that we sell? What is the lowest profitable product that we sell? Customer Experience On Average how long does it take the orders to reach our clients? Based on each Shipping Mode

Then started extracting her summaries and answers from the pivot tables and designing the data graphics in a dashboard for easy communication and reading of the information as well. And after completing these operations, I made some calculations related to the KPI to calculate the extent to which sales officials achieved and the extent to which they achieved the target.

Abstract

This dataset was generated from a set of Excel spreadsheets from an Information and Communication Technology Services (ICTS) administrative database on student applications to the University of Cape Town (UCT). This database contains information on applications to UCT between the January 2006 and December 2014. In the original form received by DataFirst the data were ill suited to research purposes. This dataset represents an attempt at cleaning and organizing these data into a more tractable format. To ensure data confidentiality direct identifiers have been removed from the data and the data is only made available to accredited researchers through DataFirst's Secure Data Service.

The dataset was separated into the following data files:

1. Application level information: the "finest" unit of analysis. Individuals may have multiple applications. Uniquely identified by an application ID variable. There are a total of 1,714,669 applications on record.
2. Individual level information: individuals may have multiple applications. Each individual is uniquely identified by an individual ID variable. Each individual is associated with information on "key subjects" from a separate data file also contained in the database. These key subjects are all separate variables in the individual level data file. There are a total of 285,005 individuals on record.
3. Secondary Education Information: individuals can also be associated with row entries for each subject. This data file does not have a unique identifier. Instead, each row entry represents a specific secondary school subject for a specific individual. These subjects are quite specific and the data allows the user to distinguish between, for example, higher grade accounting and standard grade accounting. It also allows the user to identify the educational authority issuing the qualification e.g. Cambridge Internal Examinations (CIE) versus National Senior Certificate (NSC).
4. Tertiary Education Information: the smallest of the four data files. There are multiple entries for each individual in this dataset. Each row entry contains information on the year, institution and transcript information and can be associated with individuals.

Analysis unit

Applications, individuals

Kind of data

Administrative records [adm]

Mode of data collection

Other [oth]

Cleaning operations

The data files were made available to DataFirst as a group of Excel spreadsheet documents from an SQL database managed by the University of Cape Town's Information and Communication Technology Services . The process of combining these original data files to create a research-ready dataset is summarised in a document entitled "Notes on preparing the UCT Student Application Data 2006-2014" accompanying the data.

Title: Data on undergraduate students' creativity under HyFlex flipped classroom modeDescription: This dataset contains the quantitative data collected for a study investigating the effect of the HyFlex flipped classroom on students' creativity and gender differences.Methodology: Data were collected through a paper-based questionnaire in China between 28th April 2025 and 6th June 2025. The instrument measured students' creativity by using the CPSS.Data Contents: The dataset consists of one Excel file. It includes 301 rows (each representing one anonymous respondent) and 21 columns (each representing a variable). Key variables include ParticipantID, Group, Gender, and Time. Total_Raw (total score of orignal data), Total_100 (The percentage score generated by the formula)Data Processing: The raw data were cleaned by removing incomplete responses and calculating composite scores for scales as described in the first sheet of Excel (README).Usage Notes: A comprehensive codebook (README) is provided within this dataset, which defines all variables, values, and scoring procedures.Note for Peer Review: This dataset is under restricted access for the purpose of double-blind peer review. It will be made fully public upon acceptance of the associated manuscript.