👉 Registration for Summer cohort is now open! Live training starts in July 🎉

Data Analytics Training

This training prepares you towards the growing demand of Data science & analytics skills and technology. This is a 12 weeks intense project based hands-on live instructor led training program (8 weeks  3 – hours sessions & 4 weeks for final capstone projects ) with a weekly assignment & an internship opportunity for only qualified students which is based on performance. At the end of the program, Students will go from novice to understanding how to execute end to end analytics project using analytics framework and building holistic analytics solutions and models for any business domain. You will confidently be able to uncover actionable insights from any data no matter the business domain, communicate and deliver recommendations that drives business growth.

This training will prepare you to be job ready for a successful career or climb the job ladder in data analytics field. You will build solid foundation, explore various domains and learn best practices to execute and to end analytics project for various industries, develop analytics solutions, create actionable insights, tell data story and provide recommendations that drive business growth. 

Kindly note that by enrolling for this program, you will automatically gain free access to our community to continue learning & developing your skills with our weekly events and monthly hands-on master class hosted by analytics experts from various domains and industries.

Become a Certified Data Analytics Pro! Hone techniques in executing analytics projects using tools Excel, SQL, Python and Power BI. We provide qualified graduates with an optional internship opportunity both paid and unpaid to help them learn on the job with real datasets and robust data pipelines

  • Training Day:  Every Saturday
  • Training Time: 8:30am to 11:30 pst.
  • Mentorship Time: 30mins 1-on-1 weekly session
 
‼️ Registration is now open for Q3’24 Cohort 
 

Estimated Completion Time

3 Months

6 - 10hrs of study / week

Next cohort

July, 2024

Limited spots available.

Training Cost

$2,500

Pay in full or 3 Installments of $833/month

Data Analytics Course Outline

WEEK 1 - INTRODUCTION TO DATA SCIENCE & ANALYTICS

Learn how to use data, analytics & statistics uncover & communicate insights that solves real-world problems. Develop skills to manipulate, analyze, model, and visualize data using Excel, SQL, Power BI, Tableau, Python 

  • Introduction to data science and analytics
  • Data analytics for business
  • Different Analytics Domains
  • How data is used in different roles
  • Data Analytics frameworks & approach
  • Introduction to data analytics with Excel
  • Excel Basic
    • Navigating Excel UI
    • Excel Filtering & Sorting
    • Conditional Formatting
    • Data Cleaning & transformation
    • Data analysis functions
WEEK 2 - DATA ANALYSIS WITH EXCEL
  • Introduction to advanced excel
  • Business problems with data analytics
  • Business key terms you need to use related to data
  • Data types & Structures
  • Dimension & Measures
  • Business Metrics & KPIs
  • How to identify & create KPI metrics
  • Data analysis toolkit
  • Descriptive Statistics
  • Data visualization
  • Pivot table
  • Dashboard Development
  • Linear regression & correlation
  • Gap Analysis

>>>First Mini project (data cleaning, manipulation, analysis and dashboard development exercise with excel).

WEEK 3 - DATA ANALYSIS WITH SQL

Learn to use Structured Query Language (SQL) to extract and analyze data stored in databases.

  • Introduction to database, data warehouse & data lakes
  • Database terminologies
  • Types of database
  • Data Types & SQL concepts
  • Data Modeling
  • ER Diagram & Concepts
  • Databases Servers
  • ETL concepts
  • SQL Commands
    • DDL
    • DML
    • DCL
    • TCL
  • DML – Basic SQL Commands (Select, from, where……)
  • Create a relational database
  • Create multiple database tables
  • Load data into database
  • Validate data
  • Retrieve data using basic SQL

 

>>> Second project: Developing a relational database, building data model & ER Diagram, creating tables and loading data into the database tables using SQL Commands

WEEK 4 - DATA ANALYSIS WITH SQL - ADVANCED
  • Advanced SQL
  • SQL Aggregate Functions
  • SQL Joins
  • Subqueries
  • Data Cleaning & Manipulation with SQL
  • SQL windows Functions

 

>>>> Mini project 3: Writing SQL queries to answer business questions. Writing SQL queries to retrieve records, manipulate, aggregate and analyze data in a relational database management system.

 

WEEK 5 - DATA ANALYSIS WITH POWER BI

Learn to analyze, create KPI metrics, visualize principles to build impactful dashboards, tell data stories and uncover actionable insights with microsoft power BI.

  • Introduction to Power BI
  • Navigate Power BI UI
  • Dimensions & Measures
  • Data Types
  • ETL 
  • Power BI Development Framework
    • Query Editor
    • Data Modeling
    • Dax
    • Data Visualization
  • Dashboards & Reports
  • Sharing & Dustribution
WEEK 6 - DATA ANALYSIS WITH POWER BI - ADVANCED

Learn to analyze, create KPI metrics, visualize principles to build impactful dashboards, tell data stories and uncover actionable insights with microsoft power BI.

  • Advanced DAX functions
  • Building Data Model
  • Creating relationships from multiple tables
  • Time Intelligence
  • Enterprise Analytics Dashboard Development
  • Advanced Dashboard Customization & Design Concepts
  • Insights & Recommendations
  • Sharing & Distribution
  • Creating Executive summary Report to deliver insights
WEEK 7 - DATA ANALYSIS WITH TABLEAU

Learn to analyze, create KPI metrics, visualize principles to build impactful dashboards, tell data stories and uncover actionable insights with TABLEAU.

  • Introduction to tableau
  • Navigating Tableau UI
  • Data Connectors
  • Creating worksheets, dashboards and stories
  • Creating various charts and graphs
  • LOD Functions
  • Data Cleaning & Manipulation 
  • Time Intelligence
  •  Dashboard Development
  • Advanced Dashboard Customization & Design Concepts
  • Insights & Recommendations
  • Sharing & Distribution
WEEK 8 - DATA ANALYSIS WITH PYTHON

Learn to analyze, create KPI metrics, visualize principles to build impactful dashboards, tell data stories and uncover actionable insights with Python

  • Intro to python; data types, structures, objects
  • Python Libraries for data analysis
  • Importing Data
  • Data Validation
  • Pandas Dataframes
  • Data Manipulation 
  • Data Transformation 
  • Aggregating data using Pandas
  • Merging Data using Pandas 
  • Treating Missing Values
  • Identifying Outliers
  • Data Visualization
  • Exploratory Data Analysis
  • Feature Engineering
  • Time series Analysis
  • Correlation Analysis
  • Intro to Machine Learning
  • Supervised & Unsupervised learning
  • Building Machine Learning  Models
WEEK 9 MACHINE LEARNING
  • Building Regression Models
  • Building Classification Models
  • Statistical Testing Methods
  • Model Training
  • Model Evaluation
  • Model Deployment
  • Recap 
WEEK 10 - 12 FINAL CAPSTONE PROJECTS

Final capstone projects 

To become a certified data analytics professional, you are
required to execute a full data analytics end to end project from data collection to storytelling with little to no supervision.  You are required to work on your final capstone projects within these two weeks by selecting 2 options from these analytics domains;

  • Product Analytics
  • HR Analytics
  • Retail Analytics
  • Healthcare Analytics
  • Marketing Analytics
  • Financial Analytics

Flexible Payment Options

Ready to Enroll? Take advantage of our payment options

  • Leverage data & analytics to solve real-world problems
  • Derive actionable insights  to inform business decisions
  • Identify trends, patterns, outliers, and summarize data sets
  • Develop end to end analytics dashboard products & solutions
  • Develop and test hypotheses
  • Create KPI metrics & reports
  • Tell a data story that resonate with business stakeholders
  • Build data model and machine learning predictive models to forecast future outcomes.
  • Become job ready for any analytics role
  • Experienced instructors from top fortune 500 companies
  • Learn from the World’s Best  Industry Experts
  • Learn with Hands-on Exercises & Assignments
  • Live 1-on-1 weekly mentorship
  • 6 month access to video recordings
  • 24*7 learning Support
  • Resume Building & Mock Interview Prep
  • Exclusive access to Job Portal
  • Evening and weekend classes are available
  • Affordable pricing & Flexible payment
  • We work with you to build your portfolio
  • Any data enthusiast or students that is interested in learning how to go from data to insights
  • Professionals working with data in any industry
  • Aspiring Analytics consultants
  • Anyone who aspires to spearhead their career in Data Analytics.

Program Completion

Upon Completion of this course, you will:

  • Receive a Data Analytics Certificate of Completion.
  • Receive free resume revamp.
  • Receive free mock interview prep.
Copy of Tolu

Certificate of Completion

Ready to make to advance your skills in Tech?

Read student's success stories to help motivate you as you transition into Data Analytics field

The Folks at Data Techon know what they are doing. If you are looking for a quality instructor who can teach you practical data skills, Tobe and her team do a stellar job. Unlike other places, Tobe will go the distance and help build your resume and prep you for interview to make sure you land a job in the Data field if you put in the work. Topics we covered included Power BI, excel, SQL, and more. Overall the boot camp at Datatechon was a great experience and I highly recommend it to anyone who is looking to get into the Data science & analytics field.
1635099152708
Alex Paterno
Sales Data Analyst
The chief instructor Tobe is truly a knowledgeable, disciplined and patient Data Science & Analytics Coach because not every tutor would go all the way for their students. Responding to all concerns even outside schedules, presentation was really personable, assignments, projects deadlines were no jokes. In weeks I learned not only to use several industry tools but also to provide business insights, tech. stack and skills have moved from 0-Intermediate. The confidence is building up and here to stay. Thank you so much Data Techcon!
1588427992769-170x170
Uche Okere
CRM Specialist
I loved Data Techcon’s Data Analytics Program! Even though I fell a little behind on my assignments (my own fault) I went to the weekly class & re-watched the videos & I learned so much! I am getting my masters in Data Analytics and I learned so much more hands on, real world skills during this bootcamp. I used the skills I have learned in my Data Internship, without the bootcamp I would have been very lost on where to start when it comes to handling data. I recommend this bootcamp to anyone interested in learning Data Analytics!
1613077918528-170x170
Katherine Onorato
Data Analyst
5/5
5/5
5/5

Succeed with Data Techcon Courses

Frequently asked questions

How to register online?

Enrolling for any Data Techcon class is easy. Select the program you would like to enroll for and select enroll now to get started.

What payment methods do you accept?

We accept payment via paypal account, debit card or credit card. If you are considering order payment methods, kindly send us an email.

How do you process my information?

Your data will be kept private and secure on our database. No illegal use without prior notice.

How long do I have access to the training videos?

All students will have one year access to all training course materials; videos, documents and slide decks. Certificate-holders will be invited to join a private LinkedIn group of all past Data Techcon alumni’s .

Do I need to have tech background to enroll?

You do not need to have tech background, degree or experience to enroll. Our program are curated to help everyone hone in demand skills in data science and analytics.

Will I receive certificate of completion?

Yes, a certificate of completion will be issued to all students that successfully complete the program and turn in their final capstone projects.

Who teaches the course?

Experienced instructors from top fortune 500 companies like Google, Pepsico, USAA, Molina. They combine in-depth hands on experience as data science and analytics experts with a passion for promoting data literacy to the next generation of talent.

Why are data analytics skills relevant today?

With the surge in data and its correlated fields, the job of a Data Scientist has become the most sought after job. Data Science is predicted to grow over the next decade. It is a staggering fact that over 90% of the data in the world was generated in just 2 years.

More and more industries are becoming data hungry and they need data to hold specialized data scientists who can craft products for the customers. About 11.5 Million jobs will be created by 2026 according to U.S. Bureau of Labor Statistics.

According to Forbes, to prepare students for the jobs in 2030, “Inject data analytics training into students’ course of study to help students master the use of data generated by AI”.  Learning data analytics can help you advance in your current profession or explore a growing field. Accelerate Change, transform business and Prepare for the Next Disruption. 

How do I contact support?

You can contact our help center or any contact method (phone call or email: info@datatechcon.com to get help. 

What happens at the end of the program

Once a program has finished, you will be invited to provide receive  detailed email from our support team on resume revamping, interview prepping guide and job search support. Also,  you will be invited to provide feedback on your course experience.

How can I get a discount?

Learners can get a discount based on referral. If you were referred by someone, be sure to state that when you reach out to us prior to enrolling

How many cohort do you offer annually?

We offer four cohorts annually. Our cohorts are run on a quarterly basis and enrollments for each cohort start a month prior to the cohort start date.

What roles can I apply for after the program

Upon program completion, you are qualified to apply for any intermediate data science and analytics roles within any domain like marketing analytics, HR analytics, Financial data analytics, product data analytics, sales analytics, product analytics, healthcare data analytics………

What type of support is provided during the program

During the program, all students receive continuous weekly 1-on-1 mentorship support and guidance from lead instructors to help make sure students are getting the best out of their educational investments

Steps to Success

Roadmap to a Successful Data Science & Analytics Career

Hone New Skills
start-here-timeline-photo-01

#1 Accelerate your skills

Learning new skills gives you more opportunity to stay competitive in the job market. With new skills, you can confidently apply for any data analytics role. However, goal setting is a crucial step in learning new skills. After enrolling for the program, you should set your career transition goal to help track your progress. Then, you can collaborate and interact with your instructor and fellow classmates.

Milestones Creation
start-here-timeline-photo-02

#2 Create weekly milestones

The roadmap to achieving any goal starts with breaking the goal into milestones. After creating your weekly tasks, you need to dedicate time and effort to achieve your goal.

Self-discipline
start-here-timeline-photo-03

#3 Self-discipline & responsibility

Who says that having to be more self-disciplined is a disadvantage? It is true that studying requires more time-management skills, because you will spend a lot of time on your own without someone physically close to keep you focused on daily practice.

Start Learning
start-here-timeline-photo-04

#Fortune 500 Industry Instructors

It’s time to put your plans into action by choosing from our instructor-led training programs or self-paced online courses. Our courses are curated by analytics professionals who work in fortune 500 companies and have both technical skills and business acumen that help businesses drive growth. Ready to start learning? Click on any of the buttons below to enroll.