Discoveries

Estatus de las empreas en México

Impact

Definir el sector que requiere mayor atención en el país

Audience

Empresarios, emprendedores, gobierno

Data and advanced analytics

5 millones de datos de empresas

Discoveries

Análisis what if para el descubrimiento de datos

Impact

Impacta desde la parte estratégica de la compañía

Audience

Gerentes y coordinadores

Data and advanced analytics

What if

Discoveries

Information for Sec 1 posting

Impact

Allow parents to access to such information

Audience

For Parents/Students

Data and advanced analytics

Easy reference for School information in SG

Discoveries

Some of the discoveries from using this app include:
* Top 5 states by honey production (lb) and its value ($) — calculated automatically.
* Detailed breakdown by state.
* For each state — production, value, number of colonies, yield per colony, and price. Plus the change from the previous year.

Impact

Makes it clear at a glance which five states produced the most honey, by weight and by value, and how their contributions to the top five totals were shifting on a yearly basis, revealing the biggest effects on each change and delivering more analytics on demand for informed decision making.

Audience

Business and market analysts watching the development of the honey production sector. All who want to analyze the cumulative effect of sequentially introduced values in Qlik Sense — the app features a good example of an advanced Waterfall chart and is publicly available among AnyChart demo apps for QS.

Data and advanced analytics

The dataset is derived from publicly available reports on honey production in the United States, provided by the National Agricultural Statistics Service (NASS), the statistical branch of the U.S. Department of Agriculture (USDA).

Discoveries

Overall conclusion: Discussing public health involves a great amount of factors. As seen in this application many countries are affected by disease(s), food shortages, food overconsumption, alcohol consumption, mental state, water and sanitation and energy consumption. With this dashboard we hope to give more insight in problems evolving around public health over different countries and time periods. We can see for example that there are still a lot of cases of overweighted people but also cases of undernourishment, shifting this to the center of a balanced state would be the ultimate challenge but also a great goal to achieve in the future. Also the occurence of different diseases could be lowered. To our biggest surprise we saw that the amount of tuberculosis cases is overwhelmingly large. 

Impact

It made us realize that we must protect the world, our children and be careful with our beautiful earth!

Audience

For any person that is interested in the SDG goals.

Data and advanced analytics

We got strong insights of things we didnt know, like the effect of safe water supplies, or HIV, and Malaria but also that tubercolosis is on the rise. It made us aware of things we didnt know. But also think of the problem about alcohol consumption. We loved working it and Jesse and I learned a lot from this work.

Discoveries

Some of the discoveries from using this app include:
* Key demographics at different hierarchical levels: population size, rates of births, deaths, and natural increase.
* RNI for each state, division, and region compared to the national average.

Impact

Helps estimate and project population counts and shifts to draw conclusions and make decisions in respect of the current and future distribution of social and economic resources and activities at national, regional, divisional, and state levels.

Audience

Demographics analysts, researchers, and planners seeking to understand the size and change of populations. All who want to analyze hierarchical data structures in Qlik Sense — the app features a good example of a Sunburst chart and is publicly available among AnyChart demo apps for Qlik Sense.

Data and advanced analytics

The dataset is derived from Kaggle.com: “United States Energy, Census, and GDP 2010-2014.” It contains demographic data from the United States Census of 2010.

Discoveries

Some of the discoveries from using this app include:
* Timeline and details of each active dormitory facility development project across all institutions across the state of New York.
* Most and least expensive dormitory constructions statewide.

Impact

Delivers a visual overview of all projects' schedules, communicating how long a project should take, its current schedule status, and budget to support informed, time and cost-aware decisions on prioritization, re-allocation of resources, and other aspects of management.

Audience

Authorities delivering dormitory construction project management supervision and audit. All who need to create or understand project plans and schedules — the app features a good example of a Project Gantt chart in Qlik Sense and is publicly available among AnyChart demo apps for Qlik.

Data and advanced analytics

The dataset is derived from a report on active construction projects managed by Dormitory Authority State of New York (DASNY), which is publicly available online.

Discoveries

Some of the discoveries from using this app include:
* Key milestones in the food permit application process for all mobile vendors, including when it was requested, approved, and expires.
* Current application status and timeline for each vendor.

Impact

Makes it easy to understand which mobile vendors actually possess an official food permit from San Francisco city authorities, identifying violators endangering public health, as well as to plan timely inspections, renewals, and other procedures established by law.

Audience

Authorities overseeing mobile food safety and operations. People willing to know if a certain vendor has the required permit. All who want to analyze resource allocation in Qlik Sense — the app features a good example of a Resource Gantt chart and is publicly available among AnyChart demo apps for QS.

Data and advanced analytics

The dataset is derived from a report on mobile food facility permits, which is provided by the San Francisco Department of Public Works and publicly available online.

Discoveries

1. Afternoon is the preferred time of day for occasional members. Afternoon accounts for 47% of total trips per day. 2. The summer months are the most popular of the year for occasional members and they account for 52% of the annual period. 3. Following the introduction of electric bicycles, we noticed an increase of 59% in their use by occasional members during their first 3 months and a decrease of 30% of bicycles at the dock during this same period. 4. We noticed occasional members keep the bikes almost 3 times longer than the annual members. 5. In summer, trips for occasional cyclists are concentrated near the beaches, unlike the rest of the year.

Impact

The marketing recommendations we came to a conclusion are the following: 1. Offer flexible weekend subscriptions for occasional cyclists between 4 p.m. and 6 p.m. at the most popular stations: Streeter Dr & Grand Ave, Lake Shore Dr & Monroe St, Theater on the Lake and Lake Dr & North Blvd. 2. As the number of cyclists increases on Friday and last the entire weekend, the marketing team may offer discounts to speed up membership for occasional cyclists. 3. Make the dockside bicycle stations more accessible and available depending on the start and ending place of the journey. 4. Create a loyalty program in the form of bonuses / rewards for occasional rides who cycle for long kilometers. A smartwatch could be a great reward. 5. Send a newsletter via email every Thursday evening with the unusual places in the region, the latest discounts and news from Cyclistic. 6. Collect the body mass index in order to track trends.

Audience

The app is made for the marketing as well as the financial team of the company in order to make business decisions on the next months.

Data and advanced analytics

N/A

App with data under the link: https://drive.google.com/file/d/1gRIoiU6C_bqariyC3AiWkqkPM3PrY6w_/view?usp=sharingApp with data