DATA SCIENCE & VISUALIZATION
NORTHWESTERNDATA SCIENCE& VISUALIZATIONBOOT 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 into actionableinsights has quickly become an in-demand skill. Northwestern Data Science & VisualizationBoot Camp is a part-time 24-week, non-credit certificate program that empowers students with theknowledge and skills to conduct robust analytics on a host of real-world problems.This program is designed to fit into your life, with convenient evening and weekend sessions tailored tothe needs of working professionals.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.Northwestern Data Science & Visualization Boot Camp - Powered by Trilogy Education Services
IS THIS PROGRAM RIGHT FOR YOU?Are you a creative, curious, and ambitious professional looking to join the data revolution? Ifso—or if any of the following describes you—enrolling in Northwestern’s Data Science& Visualization Boot Camp could be a smart career move:*You are currently a professional workingYou are a manager or professional in awith data, but want to advancebusiness where data can be used to boostyour career by building technical skills.your company’s bottom line.You have interests in visualizing social,consumer, or popular trends.You want to enter a new field inhealthcare, government, or media and arelooking for a way to change career paths.*No programming experience is required. It is recommended that applicants hold a bachelor’s degree orat least two years of experience in business, management, financial statistics, or a related field.Northwestern Data Science & Visualization Boot Camp - Powered by Trilogy Education Services1
THE SKILLS YOU’LL GAINYou will gain the practical technical skills in Data Science, including:*Advanced ExcelFront-End Web Visualization Pivot Tables HTML VBA Scripting CSS Bootstrap Dashboarding JavaScript Charting D3.js Geomapping with Leaflet.jsFundamental Statistics Modelling ForecastingBusiness Intelligence SoftwarePython Programming Tableau Python 3 NumPy Pandas Matplotlib API Interactions Big Data Analytics with Hadoop Social Media Mining Machine LearningAdvanced TopicsDatabases MySQL MongoDB ETL* Note: These topics are subject to change based on local market demand and the input of hiring partners.Northwestern Data Science & Visualization Boot Camp - Powered by Trilogy Education Services2
BUILDING ON THE BASICSFor those entering the field of Data Science, knowingwhere to start can be a daunting task. That’s why our curriculumis designed to provide you with a deep foundation of the coretechnical skills needed to succeed in the field. Throughout theprogram, expect to learn brand new skills and be challengedin completing difficult, real-world problems to demonstrateyour abilities. By the program’s end, you will have a strongprofessional portfolio showcasing your work.Northwestern Data Science & Visualization Boot Camp - Powered by Trilogy Education Services3
REAL PROJECTS, REAL JOBSOur graduates are qualified for many different entry-level technical roles, including:Data AnalystDatabase AdministratorData EngineerBig Data EngineerData ScientistBusiness Intelligence AnalystData JournalistResearch AnalystBusiness AnalystSoftware EngineerSQL DeveloperSystems EngineerNorthwestern Data Science & Visualization Boot Camp - Powered by Trilogy Education Services4
WHAT YOU WILL LEARNEmploy statistical analysis to model, predict, andforecast trendsWrite SQL commands to perform Create, Read,Update, and Delete commandsExpertly build VBA scripts in Excel to automatetedious manual processesUse advanced SQL and Mongo techniques to combinemultiple datasets into one to create moreimpressive and comprehensive databasesUtilize real-world data sources to showcase social,financial, and political phenomenaCreate basic interactive websites and applicationsto show your work to the entire worldCreate Python-based scripts to automate thecleanup, re-structuring, and rendering of large,heterogeneous datasetsWork with and lead small-scale teams in order tocreate applications and visual datasetsInteract with RESTful APIs using Python Requestsand JSON parsing techniquesScrape information from web pages in order tocollect data from a wide variety of online sourcesCreate in-depth graphs, charts, and tables utilizing awide variety of data-driven programming languagesand librariesCommunicate and glean new business insightsusing enterprise-grade tools like TableauUse ETL process (Extract, Transform, Load) totransform and consolidate data from multiple sourcesUse geographic data to create visually exciting,interactive, and informative mapsBuild custom interactive data visualizations usingD3.js and other JavaScript librariesAnalyze social media trends using automatedprogramsWork independently or in a group on complexdata-mining projectsUnderstand the basics of troubleshooting andenhancing legacy codeNorthwestern Data Science & Visualization Boot Camp - Powered by Trilogy Education Services5
COURSE STRUCTUREOver the course of 24 weeks, you’ll attend informative lectures,participate in a variety of individual and team exercises,and work independently in the classroom and athome. Homework assignments provide an opportunity to applywhat you’ve learned and build on it. The goal is to give you acomprehensive learning experience and true insight into a “dayin the life” of a data professional.DISCUSSIONPROJECT WORKPORTFOLIO PROJECTSInstructor-led discussions cover theYou’ll work on timed in-classYour portfolio signals to employers thatbackground, history, and use of newexercises and projects individuallyyou’re ready for primetime! You’ll buildtechnologies and concepts.and in teams to put classrooma substantial portfolio of projects thatteachings into practice.demonstrate your abilities across awide variety of technologies.Northwestern Data Science & Visualization Boot Camp - Powered by Trilogy Education Services6
WE’RE HERE TO HELPAs you move up the learning curve, you’ll likely have questionsabout many of the concepts covered in class. We’re here to help–through in-person and virtual office hours, as well as a dedicated#slack channel where you can get assistance from instructors,support staff, and your fellow students. All work is done via Github,so you can create issues directly on your own projects for instructorsto assist you in a truly asynchronous fashion. In addition to buildinga strong portfolio, you will benefit from a wide range of careerservices to position you for success as you work to advance in yourcurrent career or seek a new challenge.Career Content and Practice SessionsDatabase of Customizable Tools andTemplates Multiple Technical Resume Templates Github Best Practices Guidelines To Building A Portfolio Creating an Elevator Pitch Developing a BioOnline Career Events With IndustryProfessionalsSoft Skills TrainingOne-on-One Career CoachingNorthwestern Data Science & Visualization Boot Camp - Powered by Trilogy Education Services7
BUILDING YOUR PORTFOLIOIt’s a fact: companies care about what you can do, not what you say you can do. For thatreason, our curriculum teaches you how to put what you’ve learned to work. We coverreal-world data projects, ranging from visualizing bike sharing data in New York City tomapping worldwide earthquakes in real-time.Northwestern Data Science & Visualization Boot Camp - Powered by Trilogy Education Services8
BUILDING YOUR PORTFOLIOBank DesertsSocial economists have long noted atrend that in geographic areas withhigher poverty rates, there is often adearth of reputable banks or financialservices. The shortage leads to higherrates of financial victimization in theseareas. But how could we show thistrend using data? In this activity, you’lllearn how to combine data from the USCensus, Google Maps, and Google Placesto visualize the relationship betweenvarious socioeconomic factors and thenumber of banks in a given zip code.Earthquake HistoryData isn’t just about finance andnumbers. It can also be used for goodas well. In this activity, you will createan interactive visualization of historicearthquakes over time using Leaflet.js, apopular JavaScript geo-mapping library.Your final application will provide a nearlive feed of global earthquakes and theirrelative magnitudes.Skills Needed Python Google Maps Matplotlib Pandas Google Place APIsObjectives Skills Needed Sometimes, data is just out of reach.Whether it’s a social media website thatis guarding its information, a governmentagency that has poorly organized records,or a cookbook website filled with secretrecipes – data isn’t always accessibleby external applications. This is wheredata scraping comes in. Utilizing Pythonlibraries like Beautiful Soup, you will learnto convert data straight from raw HTML intoa queryable and storable form, opening uptroves of data for your future applications.HTML Javascript APIsCSS Leaflet.js JSONObjectives Web ScrapingApplicationUtilize the Python Requests library to make hundreds of API calls tothe US Census and Google Maps datasetsUtilize the Python pandas library to organize the retrieved informationby zip code and socioeconomic factorsBuild scatter plots to easily communicate the Banking DesertphenomenaHarness the power of APIs and JSON to gather earthquake data fromUSGS datasetsUtilize Leaflet.js library to create visually compelling,animated mapsEmbed the created map onto a live web page using HTML and CSSSkills Needed Python HTMLBeautiful Soup CSS MongoDBObjectives Scrape your favorite social media website for otherwiseinaccessible dataParse through the retrieved information and store it into aMongoDB databaseCreate new representations of the data using HTML and CSSNorthwestern Data Science & Visualization Boot Camp - Powered by Trilogy Education Services9
PORTFOLIO continued.Data Journalismand D3In this activity, you will be taking on therole of a data visualization specialistworking for a major metropolitannewspaper. Your editor wants torun a series of feature stories aboutthe health risks facing particulardemographics in the United States.Using the latest information from twogovernment databases and the D3JavaScript library, you will be creatingcharts and interactive graphs for thisimportant news article.Game StudioAnalyticsCongratulations! You have landed ajob as the Lead Analyst for anindependent game company and foryour first assignment you have beengiven the difficult task of analyzingdata and creating a report for theirlatest smash hit release. You willbe using the Python Pandas Libraryand Jupyter Notebook to createdemographic and financial reports.Classifying YelpReviewsA Nielsen report concluded that 82% ofvisitors to Yelp intended to make a purchase,so it’s no surprise that companies take onlinecustomer reviews and ratings seriously. Inthis section of the course, you’ll build anapplication that can analyze reviews, and tellyou through Natural Language Processingwhether it’s negative or positive. Thismeans you don’t have to have a human readevery review that gets posted and respondaccordingly. You can instead have a machineflag negative reviews for you so you cantrigger an action like outreach and more.Skills Needed JavaScript andthe D3 Library HTML/CSS Bootstrap Microsoft ExcelObjectives Collect data from two government databasesStore the data within a series of .CSV filesCreate fully interactive graphs that alter with button-clicksPlace all of your information into a mobile-responsive webpageSkills Needed Python Jupyter Pandas LibraryNotebookObjectives Use Python and the Pandas library to create a report containing a vastamount of dataMake the data viewable using Jupyter NotebookFind, analyze, and write up descriptions of observable trends in the dataSkills Needed PySpark Machine Learning Natural Language ProcessingObjectives Perform Natural Language Processing with PySpark-MLEstablish a big data processing pipeline to clean and process dataTrain and validate a Naive Bayes machine learning model that can makepredictions from customer reviewsNorthwestern Data Science & Visualization Boot Camp - Powered by Trilogy Education Services10
COURSE CURRICULUM BY MODULEModuleDescriptionModule 1:Excel Crash CourseModule 2:Python Data AnalyticsDatabasesModule 4:Web VisualizationModule 5:Advanced TopicsModule 6:Learn to do more with Microsoft Excel! In this module we’llcover advanced topics like statistical modeling, forecasting,and prediction; pivot tables, and VBA scripting. You will evenlearn to model historic stock trends–and hopefully, learn tobeat the market!»»Microsoft Excel»»VBA Script»»Statistics ModelingGain a strong foothold in one of today’s fundamentalprogramming languages. In the course of this module, you’llgain deep proficiencies with core Python, data analytic toolslike NumPy, Pandas, Matplotlib, and specific libraries forinteracting with web data like Requests and �»Pandas»»Matplotlib»»Beautiful »»ETL »»Leaflet»»Tableau»»Hadoop»»Machine Learning»»Dreaming upsomething fantasticand understanding thebounds of reasonableand achievableDive deep into the most prolific database languages: SQL andNoSQL. Work with MySQL and MongoDB to organize data intowell-structured and easily retrievable data formats. Work ona case study to combine data from different sources into onedatabase.Module 3:Final ProjectWhat You’ll LearnBuilding visualizations is of little benefit without away to communicate the message. In this module, you’llbe learning the core technologies of web development(HTML, CSS, and JavaScript) to create new,interactive data visualizations that you can sharewith everyone on the web!By program’s end, you’ll be immersed in new and in-demandtopics like Tableau, Hadoop, and Machine Learning.Bring everything that you have learned in classaltogether to create an impressive data-visualizationapplication with a small team! Get creative and come upwith something cool to show off to the whole world!Northwestern Data Science & Visualization Boot Camp - Powered by Trilogy Education Services11
Northwestern Data Science & Visualization Boot Camp - Powered by Trilogy Education Services 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.
2.1 Data Visualization Data visualization in the digital age has skyrocketed, but making sense of data has a long history and has frequently been discussed by scientists and statisticians. 2.1.1 History of Data Visualization In Michael Friendly's paper from 2009 [14], he gives a thorough description of the history of data visualization.
Types of Data Visualization Scientific Visualization – –Structural Data – Seismic, Medical, . Information Visualization –No inherent structure – News, stock market, top grossing movies, facebook connections Visual Analytics –Use visualization to understand and synthesize large amounts of multimodal data – File Size: 2MBPage Count: 28
discussing the challenges of big data visualization, and analyzing technology progress in big data visualization. In this study, authors first searched for papers that are related to data visualization and were published in recent years through the university library system. At this stage, authors mainly summarized traditional data visualization
The data source and visualization system have different data models. A database visualization tool must make a connection between the data source data model and the visualization data model. Some methods has been proposed and studied. For example, Lee [17] described a database management-database visualization integration, which
About Oracle Data Visualization Desktop 1-1 Get Started with Samples 1-2 2 Explore, Visualize, and Analyze Data Typical Workflow to Visualize Data 2-1 Create a Project and Add Data Sets 2-2 Build a Visualization by Adding Data from Data Panel 2-3 Different Methods to Add Data 2-3 Automatically Create Best Visualization 2-3 Add Data to the .
language express all the facts in the set of data, and only the facts in the data. Effectiveness A visualization is more effective than another visualization if the information conveyed by one visualization is more readily perceived than the information in the other visualization. Design Principles [Mackinlay 86]
This course teaches you the core principles and techniques of data visualization, so that you can turn HR data into appealing . history of data visualization and many examples, you will also learn about the science behind how we process visual information, why objectivity in data visualization is a myth, and .
Data Visualization Lead Jose Lopez Web Application Lead Kiefer Giang Data Visualization Abubakir Siedahmed Data Analysis Kennedy Nguyen Web Application Fredi Garcia Data Visualization John Grover Rodriguez Data Analysis Leo Shapiro Web Application Isaac Villalva . Dr. Navid Amin
