DATA ANALYTICS - UNC-Chapel Hill Boot Camps
DATA ANALYTICSBOOT CAMPCurriculum OverviewOver the past decade, the explosion of data has transformed nearly every industry known to man.Whether it’s marketing, healthcare, government, or activism—the ability to translate data intoactionable insights has quickly become a highly in-demand skill by all. Data Analytics Boot Camp atUNC-Chapel Hill is a part-time, 24-week program that will empower students to gain the knowledgeand skills to conduct robust analytics on a host of real-world problems.The program is designed to fit into your life, whether you’re employed or attendingcollege full-time, with convenient weekend and evening sessions.The program is rigorous, fast-paced, and focused on the practical technical skills needed to solve dataproblems. Throughout the course, students gain proficiencies on numerous marketable technologies,including Excel, Python, JavaScript, SQL Databases, Tableau, and more. Plus, students leave with animpressive professional portfolio and the confidence to succeed in the data-driven economy.Data Analytics Boot Camp at UNC-Chapel Hill - Powered by Trilogy Education Services Inc.
Is This Program Right For You?Are you a creative, curious, and ambitious professional looking to join the datarevolution? If so--or if any of the following describes your situation--enrolling in ourData Analytics Boot Camp could be a smart career move:You are currently a professional working with data, but are looking to advanceyour career by building technical skills.You are a manager or professional in a business where data can be used to boostyour company’s bottom line.You have interests in visualizing social, consumer, or popular trends.You are looking to enter a new field in healthcare, government, or media and arelooking for a way to jump in.You are a full-time student, hungry to learn more and expand your skill set.Data Analytics Boot Camp at UNC-Chapel Hill - Powered by Trilogy Education Services Inc.1
The Skills You’ll GainYou will graduate with skills in Data Analytics and Visualization, including:*Advanced ExcelFront-End Web Visualization Pivot Tables HTML VBA Scripting CSS Bootstrap Dashboarding JavaScript Charting D3.js Geomapping with Leaflet.jsFundamental Statistics Modelling ForecastingPython ProgrammingBusiness Intelligence Software Tableau Python 3 NumPy Pandas Matplotlib API Interactions Big Data Analytics with Hadoop Social Media Mining Machine LearningAdvanced TopicsDatabases MySQL MongoDB* Note: These topics are subject to change based on local market demand and the input of hiring partners.Data Analytics Boot Camp at UNC-Chapel Hill - Powered by Trilogy Education Services Inc.2
BuildingOn The BasicsFor those first entering the field ofData Analytics, knowing where tostart can be a daunting task. That’swhy our curriculum is designedto provide you with a deepfoundation on the core technicalskills needed to succeed in thefield. Throughout the program,expect to learn brand new skillsand be challenged in completingdifficult real-world problems todemonstrate your new abilities. Bythe program’s end, you will havea strong professional portfolioshowcasing your work.Data Analytics Boot Camp at UNC-Chapel Hill - Powered by Trilogy Education Services Inc.3
Real Projects, Real JobsOur graduates will be qualified for many different roles, including:Data AnalystSystems EngineerData EngineerDatabase AdministratorData ScientistBig Data EngineerData JournalistBusiness Intelligence AnalystBusiness AnalystResearch AnalystSQL DeveloperSoftware EngineerData Analytics Boot Camp at UNC-Chapel Hill - Powered by Trilogy Education Services Inc.4
What You Will LearnBy the time you graduate, you can expect to be able to: Employ statistical analysis to model, predict, andforecast trends Expertly build VBA scripts in Excel to automatetedious manual processes Use advanced SQL and Mongo techniquesto combine multiple datasets into one soas to create even more impressive andcomprehensive databases Create basic interactive websites andapplications to show your work to the entireworld Work with and lead small-scale teams in orderto create applications and visual datasets Scrape information from web pages in orderto collect data from a wide variety of onlinesources Communicate and glean new business insightsusing enterprise-grade tools like Tableau Analyze social media trends on Twitter andFacebook using automated programs Work independently or in a group on complexdata-mining projects Understand the basics of troubleshooting andenhancing legacy codeUtilize real-world data sources to showcasesocial, financial, and political phenomenaCreate Python-based scripts to automate thecleanup, re-structuring, and rendering of large,heterogeneous datasetsInteract with RESTful APIs using PythonRequests and JSON parsing techniquesCreate in-depth graphs, charts, and tablesutilizing a wide-variety of data-drivenprogramming languages and librariesUse geographic data to create visually exciting,interactive, and informative mapsBuild custom interactive data visualizationsusing D3.js and other JavaScript librariesWrite SQL commands to perform Create, Read,Update, and Delete commandsData Analytics Boot Camp at UNC-Chapel Hill - Powered by Trilogy Education Services Inc.5
Course StructureOver the course of 24 weeks, you’ll attend informative lectures,participate in a variety of individual and team exercises, and workindependently in the classroom and at home. Homework assignmentsprovide an opportunity to apply what you’ve learned and build on it.The goal is to give you a comprehensive learning experience and trueinsight into a “day in the life” of a data professional.DISCUSSIONPROJECT WORKPORTFOLIO PROJECTSInstructor-led discussions cover theYou’ll work on timed in-classYour portfolio signals to employersbackground, history, and use newexercises and projects individuallythat you are ready for primetime!technologies or concepts.and in teams to put classroomYou’ll build a substantial portfolioteachings into practice.of projects that demonstrate yourabilities across a wide variety oftechnologies.Data Analytics Boot Camp at UNC-Chapel Hill - Powered by Trilogy Education Services Inc.6
We’re Here To HelpAs you move up the learning curve, you’re likely to have questions around some of the concepts coveredin class. We’re here to help—through in-person and virtual office hours, as well as a dedicated #slackchannel where you can get assistance from instructors, support staff and your fellow students. All workis done via Github, so you can create issues directly on your own projects for instructors to assist you ina truly asynchronous fashion. In addition to learning to code, you will have access to career services thatwill help you prepare for technical roles after graduation such as:Career Content and Practice SessionsOnline Career Events With Industry ProfessionalsDatabase of Customizable Tools and TemplatesSoft Skills Training Multiple Technical Resume Templates Github Best Practices Guidelines To Building A Portfolio Creating an Elevator Pitch Developing a BioOne-on-One Career CoachingData Analytics Boot Camp at UNC-Chapel Hill - Powered by Trilogy Education Services Inc.7
Building Your PortfolioIt’s a fact: companies care about what you can do, not what you say you can do. Forthat reason, our curriculum teaches you how to put what you’ve learned to work. Wecover real-world data projects, ranging from visualizing bike sharing data in New YorkCity to mapping worldwide earthquakes in real-time.Data Analytics Boot Camp at UNC-Chapel Hill - Powered by Trilogy Education Services Inc.8
Building Your PortfolioBank DesertsSocial economists have long noted a trend that in geographic areas with higher poverty rates, there is often a dearth of reputablebanks or financial services. The shortage leads to higher rates of financial victimization in these areas. But how could we showthis trend using data? In this activity, you’ll learn how to combine data from the US Census, Google Maps, and Google Places tovisualize the relationship between various socioeconomic factors and the number of banks in a given zip code.Skills NeededObjectives Python Matplotlib Pandas APIs Google Maps Google Places Utilize the Python Requests library to make hundreds of API calls to theUS Census and Google Maps datasets. Utilize the Python pandas library to organize the retrieved informationby zip code and socioeconomic factors. Build scatter plots to easily communicate the Banking DesertphenomenaEarthquake HistoryData isn’t just about finance and numbers. It can also be used for good as well. In this activity, you will create an interactivevisualization of historic earthquakes over time using Leaflet.js, a popular JavaScript geo-mapping library. Your final application willprovide a near-live feed of global earthquakes and their relative magnitudes.Skills NeededObjectives HTML Leaflet.js CSS APIs Javascript JSON Harness the power of APIs and JSON to gather earthquake data fromUSGS datasets Utilize Leaflet.js library to create visually compelling,animated maps Embed the created map onto a live web page using HTML and CSSWeb Scraping ApplicationSometimes, data is just out of reach. Whether it’s a social media website that is guarding its information, a government agencythat has poorly organized records, or a cookbook website filled with secret recipes -- data isn’t always accessible by externalapplications. This is where data scraping comes in. Utilizing Python libraries like Beautiful Soup, you will learn to convert datastraight from raw HTML into a queryable and storable form, opening up troves of data for your future applications.Skills NeededObjectives Python CSS Scrape your favorite social media website for otherwise inaccessible data Beautiful Soup MongoDB Parse through the retrieved information and store it into a MongoDB HTMLdatabase Create new representations of the data using HTML and CSSData Analytics Boot Camp at UNC-Chapel Hill - Powered by Trilogy Education Services Inc.9
Portfolio continued.Data Journalism and D3In this activity, you will be taking on the role of a data visualization specialist working for a major metropolitan newspaper. Your editorwants to run a series of feature stories about the health risks facing particular demographics in the United States. Using the latestinformation from two government databases and the D3 JavaScript library, you will be creating charts and interactive graphs for thisimportant news article.Skills NeededObjectives JavaScript and the D3 Library Collect data from two government databases HTML/CSS Store the data within a series of .CSV files Bootstrap Create fully interactive graphs that alter with button-clicks Microsoft Excel Place all of your information into a mobile-responsive webpageGame Studio AnalyticsCongratulations! You have landed a job as the Lead Analyst for an independent game company and for your first assignment youhave been given the difficult task of analyzing data and creating a report for their latest smash hit release. You will be using thePython Pandas Library and Jupyter Notebook to create demographic and financial reports.Skills NeededObjectives Python Jupyter Notebook Pandas Library Use Python and the Pandas library to create a report containing a vastamount of data Make the data viewable using Jupyter Notebook Find, analyze, and write up descriptions of observable trends in the dataPlotBot5Twitter bots are all the rage these days and, for this assignment, you will be creating an interactive Twitter bot of your very own.This Twitter bot will receive tweets via mentions and then perform “sentiment analysis” on the first Twitter account specified in themention. A plot of data will then be tweeted out from the PlotBot5 Twitter feed.Skills Needed Python VADER(SentimentAnalysis)Objectives Tweepy Create your own fully-interactive Twitter bot and to be run off of Heroku(Twitter) Perform sentiment analysis on Twitter accounts using VADER and Pandas Matplotlib HerokuTweepy Parse, store, and post to the web on callData Analytics Boot Camp at UNC-Chapel Hill - Powered by Trilogy Education Services Inc.10
Course Curriculum By ModuleModuleDescriptionModule 1:Excel Crash Course(Weeks 1-2)Module 2:Python Data Analytics(Weeks 3-9)Module 3:Databases(Weeks 10-12)Module 4:Web Visualization(Weeks 13-19)Module 5:Advanced Topics(Weeks 20-23)Module 6:Final Project(Week 24)What You’ll LearnLearn to do more with Microsoft Excel. Inthis module we’ll cover advanced topics likestatistical modeling, forecasting and prediction,pivot tables, and VBA scripting. You’ll even learnto model historic stock trends -- and hopefully,learn to beat the market!»»Microsoft Excel»»VBA Script»»Statistics ModelingGain a strong foothold in one of today’sfundamental programming languages. Inthe course of this module, you’ll gain deepproficiencies with core Python, data analytictools like NumPy, Pandas, Matplotlib, andspecific libraries for interacting with web datalike Requests, BeautifulSoup, and as»»Matplotlib»»Beautiful Soup»»TweepyDive deep into the most prolific databaselanguages: SQL and NoSQL. Work with MySQLand MongoDB to organize data into wellstructured and easily retrievable data ng visualizations is of little benefitwithout a way to communicate the message.In this module, you’ll be learning the coretechnologies of web development (HTML, CSS,and JavaScript) to create new, interactive datavisualizations that you can share with everyoneon the �LeafletBy program’s end, you’ll be immersed in newand in-demand topics like Tableau, Hadoop,and Machine Learning.»»Tableau»»Hadoop»»Machine LearningBring everything that you have learned inclass altogether to create an impressive datavisualization application with a small team. Getcreative and come up with something cool toshow off to the whole world!»»Dreaming up something fantasticand understanding the bounds ofreasonable and achievableData Analytics Boot Camp at UNC-Chapel Hill - Powered by Trilogy Education Services Inc.11
Data Analytics Boot Camp at UNC-Chapel Hill - Powered by Trilogy Education Services Inc. 8 Building Your Portfolio It’s a fact: companies care about what you can do, not what you say you can do. For that reason, our curriculum teaches you how to put what you’ve learned to work.
Rebecca J. Macy, PhD, MSW University of North Carolina at Chapel Hill, School of Social Work 325 Pittsboro Street, CB #3550 Chapel Hill, NC 27599 rjmacy@email.unc.edu . Professor, UNC at Chapel Hill, School of Social Work L. Richardson Preyer Distinguished Chair for Strengthening Families, UNC at Chapel Hill, School of Social Work .
For permission, contact DESTINY, UNC-Chapel Hill's Traveling Science Learning Program, CB# 7448, More-head Planetarium and Science Center Annex, UNC-Chapel Hill, Chapel Hill, NC 27599-7448." .
Welcome to UNC-Chapel Hill! The information presented in this document (the Clinical Psychology Program Handbook) has been prepared by faculty, staff, and students to help you as you progress through the UNC-Chapel Hill Clinical Psychology graduate program. Note: For the rest of this document, we'll use "UNC" to refer to "UNC-Chapel .
TODD M. JENSEN, MSW, LCSWA Curriculum Vitae University of North Carolina at Chapel Hill School of Social Work 325 Pittsboro Street, CB# 3550 Chapel Hill, NC 27599-3550 801-376-8410 toddm.jensen@gmail.com jensent@live.unc.edu EDUCATION 2017 (expected) PhD University of North Carolina at Chapel Hill, Chapel Hill, NC Field: Social Work
Google Analytics 101 UNC Webmasters, April 7, 2016 Rachell Underhill, Web & Information Manager, The Graduate School at UNC-CH. What will be covered today . If your site is part of sites.unc.edu or web.unc.edu, you might see two tracking codes: 1. Tracking code for entire network UA-5142490-28 (web.unc.edu)
School of Medicine, Gillings School of Global Public Health, UNC Medical Center, or other relevant UNC-CH affiliations (the search strategy is available at: https://go.unc.edu/UNC- . Marsico Lung Institute UNC Hussman School of Journalism and Media NC Translational and Clinical Sciences
6 DESTINY - UNC-CHAPEL HILL - CB# 7448, Morehead Planetarium and Science Center Annex - Chapel Hill, NC 27599-7448 - (919) 843-9036 - www.destiny.unc.edu Immunocompetent — B cells and T cells that are fully developed and armed to fight infection. These will recirculate from blood to lymph
Dorothy Cilenti, DrPH, MPH, MSW CURRENT ADDRESS UNC Gillings School of Global Public Health CB# 7445 University of North Carolina at Chapel Hill Chapel Hill, NC 27599-7445 (919) 843.5427; Fax: 966.0458 cilenti@email.unc.edu EDUCATION AND TRAINING Graduate 2009 DrPH, Health Policy and Management University of North Carolina at Chapel Hill
