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.

The national values are presented in the Excel file “HAD_2011_Valeurs_Nationales”: — by homogeneous support group (GHPC); — by association Main Loading Mode x Associated Loading Mode; — by Main Loading Mode. The 2011 PMSI data is also available by GHPC (number of days) to assess the survey rate by GHPC. In addition, in order to enlighten you and guide you in the reading of the information, the document “HAD 2011 National Values Reading Guide” completes the Excel file. It presents: — the composition of the 2011 sample; — the methods for calculating national cost values based on the ENCC data relating to the 2011 activity of institutions: taking into account the geographical coefficient, deletion of certain sequences, setting operations, etc.; — instructions on the content of the different tabs of the Excel file.

Os resultados destes inquéritos incluem dados de quatro ondas de análise, realizadas entre março e dezembro, entre um painel de mais de 4.600 inquiridos, com idades compreendidas entre os 18 e os 79 anos. Foram questionados sobre a frequência de utilização dos modos de mobilidade diária (automóvel, transportes públicos, modos ativos, micromobilidade, motociclos ou ciclomotores). No ficheiro abaixo, os resultados das edições de 2022 e 2023 podem ser descarregados em formato Excel. You will find, by mode of transport, the distribution of the frequency of use, for Belgium and the three regions. Os resultados destes inquéritos incluem dados de quatro ondas de análise, realizadas entre março e dezembro, entre um painel de mais de 4.600 inquiridos, com idades compreendidas entre os 18 e os 79 anos. Foram questionados sobre a frequência de utilização dos modos de mobilidade diária (automóvel, transportes públicos, modos ativos, micromobilidade, motociclos ou ciclomotores). No ficheiro abaixo, os resultados das edições de 2022 e 2023 podem ser descarregados em formato Excel. You will find, by mode of transport, the distribution of the frequency of use, for Belgium and the three regions. Os resultados destes inquéritos incluem dados de quatro ondas de análise, realizadas entre março e dezembro, entre um painel de mais de 4.600 inquiridos, com idades compreendidas entre os 18 e os 79 anos. Foram questionados sobre a frequência de utilização dos modos de mobilidade diária (automóvel, transportes públicos, modos ativos, micromobilidade, motociclos ou ciclomotores). No ficheiro abaixo, os resultados das edições de 2022 e 2023 podem ser descarregados em formato Excel. You will find, by mode of transport, the distribution of the frequency of use, for Belgium and the three regions.

This excel file contains PMID or web link and the source for each GWAS summary statistics analyzed in this study. (XLSX)