This Certificate Program in Data Visualization is designed by D Square Consulting Services Pvt Ltd in partnership with CMS Jain (deemed-to-be-university) with the aim of advancing your career in Data Visualization. This program is for both beginners and experienced professionals who are keen to learn and advance their career in Data Visualization.
Program Start Date: 2nd September 2023
Program Registration Last Date: 30th August 2023
Duration: Total 157 hours (12 weeks) Weekends (Saturday and Sunday)
Learning mode: Offline/Online Premises/Classroom
PARTNERS WITH
ABOUT PROGRAM
This Certificate Program in Data Visualization is designed with the aim of advancing one’s career in Data Visualization. It will help you learn how to make sense of data by creating informative and engaging reports and dashboards. You will be using tools such as Tableau, Power BI, Google Analytics, Excel, and SQL Basic to generate visualizations. By the end of this course, you will have a clear-cut understanding of how to derive meaningful conclusions from data.
WHAT YOU'LL LEARN
Learn Data visualization principles
Communicating data driven findings
Learn the art of communicating business intelligence visually as opposed to intimidating tables or reams of data.
OUR MODULES
- Overview and Business Intelligence tools usage
- Pros & Cons of each tool
- Working Architecture of each tool
- Charts and Usage
- Requirements gathering for Reports
- Create different types of charts
- Visual Formatting Techniques
- Dashboards Building with Tool Features
- Logic Implementation by using different types of functions
- (Calculations)
- Publishing the reports
- Schedule the Refresh
- Access Management
- Share the reports with different peoples
- Working with Multiple Worksheets and workbooks
- Topic A: Use Links and External References
- Topic B: Use 3-D References
- Topic C: Consolidated Data
- Using Lookup Formulas and Formula Auditing
- Topic A: Use Lookup Functions
- Topic B: Trace Cells
- Topic C: Watch and Evaluate Formulas
- Sharing and Protecting Workbooks
- Topic A: Collaborate on Workbook
- Topic B: Protect Worksheets and Workbooks
- Automating Workbook Functionality
- Topic A: Apply Data Validation
- Topic B: Search for Invalid Data and Formulas with Errors
- Topic C: Work with Macros
- Creating Sparklines and Mapping Data
- Topic A: Create Sparklines
- Topic B: Map Data
- Forecasting Data
- Topic A: Determine Potential Outcomes Using Data Tables
- Topic B: Determine Potential Outcomes Using Scenarios
- Topic C: Use the Goal Seek Feature
- Topic D: Forecasting Data Trends
- Introduction to SQL
(What is SQL?, Purpose of SQL, Who should learn SQL?, What are the subsets of SQL?, Data Definition Language, Data Manipulation Language, Data Control Language, and SQL vs. NoSQL) - Introduction to Databases and RDMBS
(What is a Database?, Database Objects, Database Tables, Table Records, Types of Database Management Systems, Relational Database Management Systems, and SQL/Relational Databases vs. No SQL Databases) - Install a Database Engine
(Download MS SQL Server or Oracle or MySQL Database Engine, and Install. Launch SQL Server Management Studio, Select New Query, and launch SQL Query. Type SQL Commands and Execute.) - SQL Syntax
(Focus on SQL Syntax, SQL keywords, SQL is not case sensitive, SQL Comments, SQL Commands, and writing SQL Statements.) - SQL Data Types
(SQL Numeric data types, Date and Time data types, Character and String data types, Unicode character string data types, Binary data types, and Miscellaneous data types.) - SQL Operators
(SQL Arithmetic Operators, Comparison Operators, Logical Operators, and Bitwise Operators) - SQL Expressions
(SQL Boolean Expression, SQL Numeric Expression, and SQL Date Expression) - SQL Comments
(SQL Comments, Comments are used to explain sections of SQL statements, or to prevent the execution of SQL statements. Single-Line Comments, and Multi-line Comments) - SQL – Data Definition Language Commands and Operations
• (SQL Data Definition Language Commands, Create, Alter, Drop, Truncate, and Rename.
• Data Definition Language Operations, Create a Database, Use Database, Rename a Database, Drop Database, Create a Table, Rename Table, Add a Column to exiting Table, Add multiple columns to existing Table, Modify an existing column, Rename a Column, Drop a Column, Truncate a Table, and Drop a Table.) - SQL – Data Manipulation Language Commands and Operations
• (Data Manipulation Language Commands, SELECT, INSERT, UPDATE, and DELETE.
• Data Manipulation Language Operations, Retrieving data from a table, Inserting data into a table, Updating existing data into a table, and Deleting all records from a table.) - SQL – Data Control Language Commands
DCL includes commands such as GRANT and REVOKE which mainly deal with the rights, permissions, and other controls of the database system
 1.png)
