Transcription
ONLINEDATA ANALYSISAND VISUALIZATIONBOOT CAMPCURRICULUM OVERVIEWCompanies today have access to more data than ever before. The problem? Finding employees whocan turn that data into actionable insights that improve processes and drive company growth. The DataAnalysis and Visualization Boot Camp at Texas McCombs is the solution.This intensive 24-week online program is fast-paced and focused on the technical skills needed to solvereal-world data problems. Throughout the course, you will gain proficiency in numerous in-demandtechnologies, including Excel, Python, JavaScript, SQL Databases, Tableau, Machine Learning, and more.This program is designed to give you the flexibility you need to balance your work-life schedule byproviding you with the structure and support you need to be successful in achieving your career pat TexasMcCombs- Poweredby zationBootCampat TexasMcCombs- Poweredby TrilogyEducationServices,1
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 ourprogram could be a smart career move:You are currently a professional working with data but are looking to advance yourcareer 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 Financial Services, IT & Services, HealthCare, Government, Research, or Media and are looking for a way to jump in.You are a full-time student, hungry to learn more and expand your skill set.You need the flexibility of at-home study.You have a bachelor’s degree or at least two years of experience in business,management, finance, statistics, or a related field.The Data Analysis and Visualization Boot Camp at Texas McCombs - Powered by Trilogy Education Services, LLC1
About the Online Data Analysis andVisualization Boot CampThe Data Analysis and Visualization Boot Camp at Texas McCombs is a part-timeprogram taking place over the course of 24 weeks. You will learn the same skills andtechnologies as those covered in the classroom program, but with extra emphasis onproject-based instruction, with the goal of creating a compelling portfolio of relevantproject work by the end of the program.The total program commitment time is 25-30 hours per week, including onlinesessions, homework, group projects, and self-study. You are supported in this journeyby your dedicated cohort of staff, which includes Instructors, Teaching Assistants,Tutors, Student Success Teams, and Career Coaches. You’ll also benefit from peer-topeer assistance through the program.The Data Analysis and Visualization Boot Camp at Texas McCombs - Powered by Trilogy Education Services, LLC2
Advance your SkillsThroughout the program, you will gain experience with a host of tools required for rolesin Data Analysis and Visualization including:Intermediate ExcelFront-End Web Visualization Pivot Tables HTML VBA Scripting CSS Bootstrap Dashboarding JavaScript Charting Geomapping with JavaScript librariesFundamental Statistics Modeling ForecastingPython ProgrammingBusiness Intelligence Software Tableau Python 3 NumPy PandasAdvanced Topics Matplotlib R API Interactions Big Data Analytics with Hadoop Web Scraping Amazon Web Services Machine LearningDatabases Postgres/pgAdmin MongoDB Extract-Transform-Load (ETL)* Note: These topics are subject to change based on local market demand and the input of our hiring partners.The Data Analysis and Visualization Boot Camp at Texas McCombs - Powered by Trilogy Education Services, LLC3
Building On The BasicsFor those entering the field of data analysis and visualization, knowing where to startcan be a daunting task. That’s why our curriculum is designed to provide you with a deepfoundation on the core technical skills needed to succeed in the field. Throughout theprogram, expect to learn brand new skills and be challenged in completing difficult realworld problems to demonstrate your new abilities. By the program’s end, you will have astrong professional portfolio showcasing your work.The Data Analysis and Visualization Boot Camp at Texas McCombs - Powered by Trilogy Education Services, LLC4
Real Projects, Real JobsThose who complete the online data boot camp are then qualified for many different roles, including:Data AnalystData EngineerData Scientist (Entry Level)Data JournalistBusiness AnalystSQL DeveloperData ArchitectDatabase Administrator (Entry Level)Big Data Engineer (Entry Level)Business Intelligence AnalystResearch AnalystSoftware Engineer (Entry Level)Computational ScientistThe Data Analysis and Visualization Boot Camp at Texas McCombs - Powered by Trilogy Education Services, LLC5
What You Will LearnThe online data analysis and visualization boot camp is designed to teach you to:Employ statistical analysis to model, predict, andWrite SQL commands to perform Create, Read,forecast trendsUpdate, and Delete operationsExpertly build VBA scripts in Excel to automateUse advanced SQL and Mongo techniques totedious manual processesUtilize real-world data sources to showcase social,financial, and political phenomenacombine multiple datasets into one to create an evenmore comprehensive databaseCreate basic interactive websites and applications toshow your work to the entire worldCreate Python-based scripts to automate thecleanup, re-structuring, and rendering of large,Create web applications and visualize datasetsheterogeneous datasetsthrough a variety of chartsInteract with RESTful APIs using Python Requests andScrape information from web pages in order toJSON parsing techniquescollect data from a wide variety of online sourcesCreate in-depth graphs, charts, and tables utilizing aCommunicate and glean new business insights usingwide-variety of data-driven programming languagesand librariesUse geographic data to create visually exciting,interactive, and informative mapsBuild custom interactive data visualizations usingJavaScript librariesenterprise-grade tools like TableauWork in a collaborate group on a complex datamining projectUnderstand the basics of troubleshooting andenhancing legacy codeThe Data Analysis and Visualization Boot Camp at Texas McCombs - Powered by Trilogy Education Services, LLC6
OnlineCourseStructureOver the course of 24-weeks, youwill progress through a unique,blended experience of weekly, flexiblecontent and live online classes ledby instructors in the field. Onlinemodules allow you to work at yourown pace on real-world data problemsand learn from wherever you are.You will come together with peersand a dedicated instructional teamin a highly-interactive live videoenvironment to build upon these skills.These live online classes are designedto give you the support of industryprofessionals while working throughinteresting challenges and receivingreal-time feedback.Projects cover real-world dataexamples, ranging from visualizingbike sharing data in New York City tomapping worldwide earthquakes inreal-time.The Data Analysis and Visualization Boot Camp at Texas McCombs - Powered by Trilogy Education Services, LLC7
Building Your PortfolioEarthquake 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 CSS Javascript Leaflet.js APIs JSONHarness the power of APIs and JSON to gatherearthquake data from USGS datasets Utilize Leaflet.js library to create visuallycompelling, animated maps Embed the created map onto a live web page usingHTML 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 Beautiful Soup HTML CSS MongoDBScrape your favorite social media website forotherwise inaccessible data Parse through the retrieved information and storeit into a MongoDB database Create new representations of the data usingHTML and CSSThe Data Analysis and Visualization Boot Camp at Texas McCombs - Powered by Trilogy Education Services, LLC8
Portfolio continued.PyCitySchoolsData is often used to drive action. In this activity, you will analyze a school district’s standardized test results over time usingPython and one of its most popular analysis libraries, Pandas. Their final application will showcase trends in school performancethroughout the district.Skills NeededObjectives Python Pandas Jupyter Notebook Git/GitHubClean and organize your data programmaticallyusing Python and Pandas Analyze your new data set through aggregationtechniques and find patterns and trends worthshowcasing Display your data live using a trending dataanalysis tool, Jupyter NotebooksThe Data Analysis and Visualization Boot Camp at Texas McCombs - Powered by Trilogy Education Services, LLC9
Course Curriculum By ModuleModuleDescriptionWhat You’ll LearnModule 1:Excel Crash CourseLearn to do more with Microsoft Excel. In thismodule, we’ll cover advanced topics like statisticalmodeling, forecasting and prediction, pivot tables,and VBA scripting. You’ll even learn to model historicstock trends — and hopefully, learn to beat themarket!»Microsoft Excel»VBA Script»Statistics ModelingModule 2:Python Data AnalyticsGain a strong foothold in one of today’s fundamentalprogramming languages. In this module, you’ll gaindeep proficiencies with core Python, data analyticstools like NumPy, Pandas, Matplotlib, and specificlibraries for interacting with web data like Requests,and Beautiful ib»Beautiful g visualizations is of little benefit without away to communicate the message. In this module,you’ll be learning the core technologies of webdevelopment (HTML, CSS, and JavaScript) to createnew, interactive data visualizations that you can sharewith everyone on the web.»HTML»CSS»JavaScript»LeafletModule 5:Advanced TopicsIn this module, you’ll be immersed in new and indemand topics like Tableau, Hadoop, and MachineLearning.»Tableau»Hadoop»Machine LearningModule 6:Final Group ProjectBring everything that you have learned in classtogether to create an impressive data-visualizationapplication with a small team. Get creative andcome up with something impressive to show off toemployers and managers.»Dreaming upsomething fantasticand understanding thebounds of reasonable andachievableModule 3:DatabasesModule 4:Web VisualizationDive deep into the most prolific database languages:SQL and NoSQL. Work with Postgres/pgAdmin andMongoDB to organize data into well-structured andeasily retrievable data formats.The Data Analysis and Visualization Boot Camp at Texas McCombs - Powered by Trilogy Education Services, LLC10
The Data Analysis and Visualization Boot Camp at Texas McCombs - Powered by Trilogy Education Services, LLC 2 The Data Analysis and Visualization Boot Camp at Texas McCombs is a pa
