Data Analytics Training
12/10/2021 2024-06-22 15:01Data Analytics Training
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 final Cohort in 2024
Estimated Completion Time
3 Months
6 - 10hrs of study / week
Next cohort
Sep, 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.
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
Alex Paterno
Sales Data AnalystUche Okere
CRM SpecialistKatherine Onorato
Data AnalystSucceed 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
#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
#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
#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
#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.