This Bootcamp is for you if you want to pursue career growth by enhancing your Data Analytics and visualization skills for practical application in your 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
Week 1: SQL -Beginner & Intermediate
In this training, you’ll learn how to correctly structure your database, author efficient SQL statements, and clauses, and manage your SQL database for scalable growth. You’ll learn how to write select statements and query specific information
from the database.
- Introduction to SQL
- SQL Commands
- Creating Database & Tables
- Importing Data into MySQL from Other Sources
- Order By & Group By
Week 2: SQL Advanced
- Joins
- Subqueries
- Querying specific information from the database
- Exporting returned query
- SQL Project
Week 3: Data Visualization – PowerBI (2 Sessions, 6 Hours)
Data Visualization is nothing but the process of presenting information through visual rendering. You’ll be learning how to use PowerBI to tell a data story with charts, shapes and lines without using words. The tool will help you transfer data into actionable insights.
- Introduction to PowerBI
- Installing PowerBI
- Importing Data into PowerBI
- Building charts and graphs with real data
- Creating dashboards and exporting to your local computer
Week 4: Python (2 Sessions)
- Introduction to Python
- Variables & Data Types
- Data Structures & Manipulation [Lists, tuples,dictionaries]
- Control Statements and loops
- Functions & Packages
- Nimpy & Pandas
- Scikit – Learn Library
- Python Project
Course Features
- Lectures 6
- Quizzes 0
- Duration 30 hours
- Skill level All levels
- Language English
- Students 58
- Assessments Self