In this course, you’ll learn the technical skills, strategic thinking, and communication skills hiring managers are looking for in job candidates. You’ll bring all of your learning together in two capstone projects focused on a realistic data analytics
scenario, ending up with a portfolio that you can show to future employers.
What You Will Learn
Framing Structured Thinking
All data analysis starts with a question. But how do you ask the right question so that the
end result of the analysis isn’t some trash bin-bound dusty printout, but rather a tangible
business strategy that is adopted by executives? Structured thinking is the foundation of
robust business analysis that can be used to identify the macro and micro value drivers
of any business problem, regardless of industry.
In this module of the course, you'll learn to think in a structured manner and break down
problems into bite-sized chunks, which can be tested via hypothesis trees. This will guide
your analysis and prevent you from analyzing data for the sake of analysis.
Analyzing Business Problems
A key skill that analysts should have is the ability to structure their efforts
around a central theme and present it to an executive with tangible business
insight. In this module, you’ll be introduced to common financial concepts as
well as the basics of economics. You’ll also review fundamental business
statistics concepts, such as descriptive statistics, correlations, simple and
multivariate regression, and confidence intervals. You will apply your
problem-solving and analytical skills to real-life data sets to derive business
insights.
Communicating Your Analysis
Data analysts also need to be adept at presenting the results of their analysis to
the appropriate stakeholders. This is a key, high-demand skill that separates
effective business-oriented data analysts from the rest. You’ll learn the different
forms of presentation, and how to best prepare your presentations based on your
audience and goal. More importantly, you’ll learn to convert your analysis into a
tangible or strategic insight that the business you’re working for can capitalize on.
This module covers best practices for presenting to both technical and
non-technical audiences, ranging from front-line employees to executives. When
you master the art of effective storytelling through visuals, executives won’t just
adopt your analysis—they’ll promote adoption and grow the business based on
those key insights.
Connecting Data Using SQL
You’ve been asked to analyze an extensive set of data so you can answer the
burning question your executive has. However, in order to do this you need data,
and you’ll have to source this yourself! Say hello to data connectivity.
As a business-oriented data analyst, it is expected that you will pull data from
databases yourself and write the structured queries to extract the information you
need. SQL is the default language used to interact with a traditional Relational
Management Database (RMDB). In this module, you’ll develop a high-level
understanding of what databases are, learn about the databases that you can use
in your work, and learn how to communicate with databases. You’ll be asked to
consolidate what you learn in this module with the skills you’ve developed
throughout the rest of the course to complete a mini-project that will focus on
extracting data from a database via SQL, analyzing it, and creating a presentation
of your business insights.
Pre-requisites
Previous work experience or training in Business Analysis
Schedule
This is a 12-week long intensive course delivered virtually.
Potential job opportunities after this Course
Data Analyst, Data Scientist, Business Intelligence Analyst, Marketing Analyst, Data Analytics Consultant