Report not found

There was a problem finding this report.
Job Board Analysis - Technical Skill Frequency
August 29, 2017 · Refreshed about 1 year ago

Collaborators

Run History
SELECT 'Python' AS skill, job_type AS "Role", COUNT(python)/COUNT(*)::float AS rate FROM modeanalytics.jobs_data WHERE job_type IN ('Data Analyst','Data Scientist','Data Engineer') GROUP BY 1,2 UNION ALL SELECT 'R' AS skill, job_type, COUNT(r_lang)/COUNT(*)::float AS rate FROM modeanalytics.jobs_data WHERE job_type IN ('Data Analyst','Data Scientist','Data Engineer') GROUP BY 1,2 UNION ALL SELECT 'Excel' AS skill, job_type, COUNT(excel)/COUNT(*)::float AS rate FROM modeanalytics.jobs_data WHERE job_type IN ('Data Analyst','Data Scientist','Data Engineer') GROUP BY 1,2 UNION ALL SELECT 'SAS' AS skill, job_type, COUNT(sas)/COUNT(*)::float AS rate FROM modeanalytics.jobs_data WHERE job_type IN ('Data Analyst','Data Scientist','Data Engineer') GROUP BY 1,2 UNION ALL SELECT 'MATLAB' AS skill, job_type, COUNT(matlab)/COUNT(*)::float AS rate FROM modeanalytics.jobs_data WHERE job_type IN ('Data Analyst','Data Scientist','Data Engineer') GROUP BY 1,2 UNION ALL SELECT 'SPSS' AS skill, job_type, COUNT(spss)/COUNT(*)::float AS rate FROM modeanalytics.jobs_data WHERE job_type IN ('Data Analyst','Data Scientist','Data Engineer') GROUP BY 1,2 UNION ALL SELECT 'Stata' AS skill, job_type, COUNT(stata)/COUNT(*)::float AS rate FROM modeanalytics.jobs_data WHERE job_type IN ('Data Analyst','Data Scientist','Data Engineer') GROUP BY 1,2
SELECT 'Python' AS skill, job_type AS "Role", COUNT(python)/COUNT(*)::float AS rate FROM modeanalytics.jobs_data WHERE job_type IN ('Data Analyst','Data Scientist','Data Engineer') GROUP BY 1,2 UNION ALL SELECT 'R' AS skill, job_type, COUNT(r_lang)/COUNT(*)::float AS rate FROM modeanalytics.jobs_data WHERE job_type IN ('Data Analyst','Data Scientist','Data Engineer') GROUP BY 1,2 UNION ALL SELECT 'Excel' AS skill, job_type, COUNT(excel)/COUNT(*)::float AS rate FROM modeanalytics.jobs_data WHERE job_type IN ('Data Analyst','Data Scientist','Data Engineer') GROUP BY 1,2 UNION ALL SELECT 'SAS' AS skill, job_type, COUNT(sas)/COUNT(*)::float AS rate FROM modeanalytics.jobs_data WHERE job_type IN ('Data Analyst','Data Scientist','Data Engineer') GROUP BY 1,2 UNION ALL SELECT 'MATLAB' AS skill, job_type, COUNT(matlab)/COUNT(*)::float AS rate FROM modeanalytics.jobs_data WHERE job_type IN ('Data Analyst','Data Scientist','Data Engineer') GROUP BY 1,2 UNION ALL SELECT 'SPSS' AS skill, job_type, COUNT(spss)/COUNT(*)::float AS rate FROM modeanalytics.jobs_data WHERE job_type IN ('Data Analyst','Data Scientist','Data Engineer') GROUP BY 1,2 UNION ALL SELECT 'Stata' AS skill, job_type, COUNT(stata)/COUNT(*)::float AS rate FROM modeanalytics.jobs_data WHERE job_type IN ('Data Analyst','Data Scientist','Data Engineer') GROUP BY 1,2
<link rel="stylesheet" href="https://mode.github.io/alamode/alamode.min.css"> <script src="https://mode.github.io/alamode/alamode.min.js"></script> <div class="mode-header embed-hidden"> <h1>{{ title }}</h1> <p>{{ description }}</p> </div> <div class="mode-grid container"> <div class="row" data-row-height="medium"> <div class="col-md-12"> <mode-chart id="chart_38815c9c0f9a" dataset="dataset" options="chart_options"></mode-chart> </div> </div> </div> <script> alamode.resizeChartHeight( { chart: "chart_38815c9c0f9a", height: 425 } ) </script>
{{ dataSourceName(params.queryId) }}

The dataset is too large to view in browser

Export

Looks like something went wrong with your query.

{{ DS.queryRuns[params.queryId].errorMessage }}
This query was cancelled