Class Level:
All levels
Other Categories in Tech
Course Details
Price:
$3,950
8 seats
Start Date:
Mon, Dec 17, 9:00am - Dec 22, 5:00pm (6 sessions)
Location:
Downtown, Washington, D.C.
1133 15th St NW 8th Fl
Btwn L & M Streets NW
Washington, District of Columbia 20005 (Map)
1133 15th St NW 8th Fl
Btwn L & M Streets NW
Washington, District of Columbia 20005 (Map)
Important:
A computer will not be provided
Purchase Options
Age Requirements:
18 and older
Average Class Size:
20
What you'll learn in this data analyst training:
This is a part time course.
This course will teach you how to use large datasets to make critical decisions.
Unit 1: Exploring Data with Excel
Understanding the Value of Data
Understanding the Fundamentals of Databases and SQL
Exploring the Fundamentals of Tableau
This course will teach you how to use large datasets to make critical decisions.
Unit 1: Exploring Data with Excel
Understanding the Value of Data
- Explore the value of data.
- Work your way through the data analytics workflow.
- Unlock the power of Microsoft Excel to utilize its analytical tools — no matter your experience level.
- Learn best practices for collecting and cleaning data in Excel to ensure accurate analysis results.
- Manipulate real-world data sets using advanced nested logical functions (IF, OR, and AND).
- Clean large, unruly data sets by removing duplicate rows and performing text manipulations.
- Transform and rearrange columns and rows within spreadsheets to prepare data for analysis.
- Gain insight into data analysis by manipulating data formats.
- Use the VLOOKUP and HLOOKUP functions to manipulate data sets.
- Look up values in other tables using the functions INDEX and MATCH.
- Summarize data using pivot tables.
- Execute Excel aggregation commands (SUM, AVERAGE, COUNT, etc.) and their conditional variants (COUNTIF, COUNTBLANKS, etc.) to summarize data sets.
- Derive insights from data by highlighting cells based on conditionals.
- Use scatter plots, bar graphs, and histograms to visualize data.
- Explore color theory and how it applies to data visualization.
- Build your own data dashboard using industry best practices.
- Apply visual design principles to your dashboard to present your findings clearly.
- Understand the value of descriptive and inferential statistics.
- Learn to describe data and identify outliers using its mean, median, mode, range, and variance.
- Make predictions about larger populations using sample data.
- Learn best practices for describing analysis techniques.
- Communicate insights and implications for stakeholders.
- Deliver short, effective presentations sharing your findings.
- Provide context for your audience by identifying and presenting the salient statistics.
Understanding the Fundamentals of Databases and SQL
- Practice the fundamentals of Structured Query Language (SQL).
- Use database schema to design appropriate queries using SQL.
- Explore the differences between relational databases (tabular data storage) and document-based databases (key-value pairs).
- Collect data using standard SQL commands (Create, Update, Truncate, etc.).
- Filter data using advanced SQL commands (Where, Group By, Having, Order By, Limit).
- Obtain data by creating relationships between tables using Joins.
- Gather filtered data using SQL Boolean operators (AND and OR) and SQL conditional operators (=,!=,>,<,IN, and BETWEEN).
- Create relationships between tables and data points (including has_many and many_to_many) using Join tables.
- Write Boolean statements with SQL conditional operators (=,!=,>,<,IN, and BETWEEN) and null functions (“IS NULL,” “IS NOT NULL,” and “NVL”).
- Clean data using SQL mathematical functions (ABS, SIGN, MOD, etc.).
- Summarize data sets by employing aggregation commands (“Sum,” “Average,” “Count,” etc.).
- Determine data trends by applying aggregation methods.
- Use CASE statements to structure data and create new attributes.
- Combine multiple subqueries into one using “WITH AS.”
- Create a local database using data sets you bring into the classroom.
- Upload and export data using a local database.
Exploring the Fundamentals of Tableau
- Get hands-on, practical experience navigating the Tableau software interface.
- Connect your data to Tableau and identify the best ways to visualize and display your results.
- Use bubble graphs to visualize data.
- Display geocoded information for your data.
- Contextualize analysis results by creating Tableau dashboards.
- Incorporate charts and conditional formatting into your dashboard using supporting information specific to a particular data set.
- Understand the use of specific data analysis software.
- Apply all the tools and skills you’ve acquired in Excel, SQL, and Tableau to analyze a data set from start to finish.
- Identify strengths and areas for improvement in your analytical skills with feedback from peers, instructors, and guest panelists.
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.
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.
If you can't make it to a class/workshop, please email us at [email protected] at least 7 days before the scheduled event date. No refunds will be given after this timeframe.
Map
General Assembly
Downtown, Washington, D.C.
1133 15th St NW 8th Fl
Btwn L & M Streets NW
Washington, District of Columbia 20005 Downtown, Washington, D.C.
1133 15th St NW 8th Fl
Btwn L & M Streets NW
Washington, District of Columbia 20005
Start Dates (3)
| Start Date | Time | Teacher | # Sessions | Price |
|---|---|---|---|---|
|
|
6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | 19 | $3,950 |
|
This course consists of multiple sessions, view schedule for sessions.
|
||||
| Wed, Jan 16 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Mon, Jan 21 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Wed, Jan 23 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Mon, Jan 28 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Wed, Jan 30 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Mon, Feb 04 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Wed, Feb 06 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Mon, Feb 11 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Wed, Feb 13 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Wed, Feb 20 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Mon, Feb 25 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Wed, Feb 27 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Mon, Mar 04 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Wed, Mar 06 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Mon, Mar 11 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Wed, Mar 13 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Mon, Mar 18 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Wed, Mar 20 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
|
|
9:00am - 5:00pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | 6 | $3,950 |
|
This course consists of multiple sessions, view schedule for sessions.
|
||||
| Tue, Dec 18 | 9:00am - 5:00pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Wed, Dec 19 | 9:00am - 5:00pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Thu, Dec 20 | 9:00am - 5:00pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Fri, Dec 21 | 9:00am - 5:00pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Sat, Dec 22 | 9:00am - 5:00pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
|
|
6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | 20 | $3,950 |
|
This course consists of multiple sessions, view schedule for sessions.
|
||||
| Wed, Mar 20 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Mon, Mar 25 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Wed, Mar 27 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Mon, Apr 01 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Wed, Apr 03 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Mon, Apr 08 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Wed, Apr 10 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Mon, Apr 15 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Wed, Apr 17 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Mon, Apr 22 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Wed, Apr 24 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Mon, Apr 29 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Wed, May 01 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Mon, May 06 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Wed, May 08 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Mon, May 13 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Wed, May 15 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Mon, May 20 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Wed, May 22 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
Benefits of Booking Through CourseHorse
Booking is safe.
When you book with us your details are protected by a secure connection.
Lowest price guaranteed.
Classes on CourseHorse are never marked up.
Reviews of Classes at General Assembly
Similar Classes
Ch Gift Card
School: General Assembly
General Assembly is a pioneer in education and career transformation, specializing in today’s most in-demand skills. The leading source for training, staffing, and career transitions, we foster a flourishing community of professionals pursuing careers they love.
What began as a co-working space in...
Read more about General Assembly
This school has been carefully vetted by CourseHorse and is a verified DC educator.
Ready to take this class?
BOOK NOW
Taking this class for work? Get exclusive perks & discounts for free.
Choose a Gift Giving Option
Know someone who would like this class but not sure of their schedule? (We recommend this!)
Know their schedule better than your own? Book a date and time directly.
(This school does not support a scheduled gift delivery date so if you book the class, the recipient will be notified right away.)
One last thing!
Add a name to your account.
What name do you want displayed with your post?
What name do you want displayed with your post?