This intensive single day bootcamp will run through the analytical workflow -- from collecting, cleaning, analyzing and presenting insights from small and big data sets. We will introduce important tools used in this process such as Excel, SQL, and Tableau.
Goals:
Introduce concepts and practice using and managing data
Transform data for predictive analytics and business intelligence decision-making
Develop compelling visualizations that articulate the value of data assets
Takeaways
Learn about the value of data in everyday decision makingUnderstand the analytics workflow
Be introduced to tools for data analysis
Formulate research questions that can be informed with data
Clean and analyze data in Excel to improve decision making
Master shortcuts to streamline workflow in Excel
Learn advanced Excel tools to manage and explore data
Introduction: learn to write SQL to manage databases
Clean and prepare data for analysis in SQL
Learn Tableau to visualize the results of your analysis
Develop presentations that articulate key findings to a new audiences
Prereqs & Preparation
Who is this for? Professionals seeking advice on where to turn for new market research or leverage open data assets. Participants will be tasked with installing softwares on a laptop computer in advance of course instruction.
Excel:
SQLectron:
(Click Download GUI, then click the .exe file if you're on Windows or .dmg if you're on Mac)
Tableau:
School Notes:
For students enrolling in 12 week part time and immersive classes, it is not recommended that you book more than one class simultaneously.
Still have questions?
Ask the community
.