Joshua K. Profile

MENJELAJAH

5.0

(1 ulasan)

Anda kini mengikuti

Ralat mengikuti pengguna.

Pengguna ini tidak membenarkan pengguna untuk mengikuti mereka.

Anda telah mengikuti pengguna ini.

Pelan keahlian anda hanya membenarkan 0 mengikuti. Naik taraf di sini.

Berjaya menyahikut

Ralat tidak mengikuti pengguna.

Anda berjaya mengesyorkan

Ralat mengesyorkan pengguna.

Sesuatu telah berlaku. Sila segar semula halaman dan cuba lagi.

E-mel berjaya disahkan.

$30 USD / jam

ottawa,

canada

$30 USD / jam

Sekarang jam 3:34 PG di sini

Menyertai November 28, 2013

0 Syor

Joshua K.

@joshuajkitz

5.0

(1 ulasan)

2.6

$30 USD / jam

ottawa,

canada

$30 USD / jam

100%

Pekerjaan Disiapkan

100%

Mengikut Bajet

100%

Tepat Pada Masa

N/A

Kadar Upah Semula

Business Intelligence & Analytics

Experience and Background ■ I have a Masters in Spatial Analysis and have worked extensively in data analysis and visual analytics. ■ I have created interactive reports and visualizations with tools such as Tableau, Klipfolio, Qlik, Arcadia Data, Zoomdata, and many more. ■ I have worked with all major GIS packages. ■ I have created databases and worked extensively with MySQL, Postgres, and Microsoft SQL Server. ■ I also have a knack for technical and creative writing.

Lihat semua Research Analysts dalam Canada

Hubungi Joshua K. tentang pekerjaan anda

Log masuk untuk membincangkan sebarang butiran melalui sembang.

Portfolio

While I do all kinds of SQL work, I find Alteryx is exceptional at combining, manipulating and transforming data. Particularly when the data is stored in many different locations.

Alteryx is also more visually interesting to look at then a screenshot of some SQL code I wrote.

Alteryx Data Preparation

Klipfolio: a work in progress dashboard on search enging rankings. This is from custom built Klips.
Klipfolio excels at connecting to web based data, and displaying it in dashboards.

Klipfolio: SEO Rankings

Airbnb data collected by Airdna used to create a report to on Airbnb's impact on Hotels. Airbnb data was stored in PostgreSQL database, hotel locations were added in a custom SQL query, and PostGIS allowed the selection of airbnb locations within 1km of a hotel.

Data is visualized using Tableau.

An article featuring this interactive visual is available here http://blog.airdna.co/lodging-reit-airbnb-disruption/

Tableau + PostGIS

Alteryx Data Preparation

Klipfolio: SEO Rankings

Tableau + PostGIS

Ulasan

Perubahan disimpan

Menunjukkan 1 - 1 daripada 1 ulasan

Tapis ulasan mengikut:

5.0

$198.54 USD

Project for joshuajkitz

Joshua provided great work. I would definitely hire again for my Klipfolio needs.

+1 lagi

Bryan M.

@ripesyrup1

•

7 tahun yang lalu

Pengalaman

Cineplex Entertainment LP

Mei 2011 - Jul 2013 (2 tahun, 2 bulan)

■ Built interactive Tableau dashboards to user specifications using custom SQL data connections. Provided business insights gained from interfaces. ■ Created a SCENE email Campaign database and analysed of promotional offers ■ Performed UAT and data validation of new corporate datasources, cubes, and models ■ Collaborated on Analytical and GIS Models including: Micro Attendance Forecast, Market Potential, and Potential Theatre sites ■ Lead summer interns.