This Bootcamp is for you if you want to pursue career growth by enhancing your Data Analytics and visualization skills for practical application in day-to-day work.
On Completion of This Course, You Will Walk Away With:
The practical skills to convey insights and uncertainty using effective visualization-based communication
Practical knowledge of how to write queries using the select statement and other SQL commands to retrieve information from a large set of data
Data Analytics skills using the Excel Analytics Toolpak
Actionable knowledge of building business models that’ll help companies make informed business decisions
Knowledge of business forecasting using historical data
Course Curriculum
Over the duration of this online short course, you will work through the following modules:
Week 1 – Saturday October 9, 2021 @ 7:00AM CDT,1:00PM WAT
SQL
Introduction to SQL
How to download & Instal SQL on your local computer
Creating Databases & Tables
How to import data into SQL Server from other sources
Parameter to look out for when writing queries
Week 2 – Saturday October 16, 2021 @ 7:00AM CDT, 1:00PM WAT
SQL
Joins in SQL
Subqueries
Other SQL Commands
Writing numerous qieries and exporting the data to another tool
Week 3- Saturday October 23, 2021 @ 7:00AM CDT, 1:00PM WAT
Pyhton
Introduction to Python
Varianbles & Data Types
Data Structures & Manipulations [Lists,turples,dictionaries]
Week 3- Sunday October 24, 2021 @ 10:00AM CDT, 4:00PM WAT
Python
Control Statement and Loops
Funtions & Packages
Nimpy & Pandas
Python project
Week 4- Saturday October 30, 2021 @ 7:00AM CDT, 1:00PM WAT
Tableau
Examine the purpose of data visualization and the use of tools such as Tableau
Explore the data visualization process and consider different types of data
Connecting to Data
Joins & Unions
Dimensions & Measures
The Show Me Panel
Week 5- Saturday November 6, 2021 @ 7:00AM CDT, 1:00PM WAT
Tableau
How to create calculated fields
How to build your stunning dashboard
Creating Data Stories with Tableau Visualization
Tableau project
Other study matertials will be provided for particiants.