Course Overview
This Professional Certificate Program in Business Analytics is for those who are looking to pursue a Business Analysis career. Understand business analysis techniques, get hands-on experience, and for experienced analysts looking to learn the latest tools and frameworks used by Agile teams. Case studies in this course add a real-world perspective.Best-in-class content by leading faculty and industry leaders. Imparting skills and knowledge on smart data analysis helps you get noticed by top hiring companies.
Advantage
This Professional Certificate from Handson has a comprehensive course curriculum covering Statistics, key Programming Languages and more – with a great detail via our interactive learning model so that you are comfortable with any kinds of questions asked in job-interview. Upon successfully completing this course, you will be able to fast track your career in the field of interest and it will help you to kick start into an exciting profession in Business Analytics.
What you'll learn
- Introduction to Data Science
- Python Language
- Statistical Analysis Software
- SQL
- Advance Excel
- Data Visualization
Statistical Analysis Software
- Components of the Statistical Analysis Software
- Data-Driven Tasks
- Turning Data into Information
- Introducing to Statistical Analysis Software Programs
- Running Statistical Analysis Software Programs
- Mastering Fundamental Concepts
- Diagnosing and Correcting Syntax Errors
- Data Libraries
- Getting Started with the PRINT Procedure
- Sequencing and Grouping Observations
- Identifying Observations
- Special WHERE Statement Operators
- Customizing Report Appearance
- Formatting Data Values
- Creating HTML Reports
- Reading Raw Data Files: Column Input
- Reading Raw Data Files: Formatted Input
- Examining Data Errors
- Assigning Variable Attributes
- Changing Variable Attributes
- Reading Excel Spreadsheets
- Reading Data Sets and Creating Variables
- Conditional Processing
- Dropping and Keeping Variables
- Reading Excel Spreadsheets Containing Date Fields
- Concatenating Data Sets
- Merging Data Sets
- Combining Data Sets : Additional Features
- Introduction to Summary Reports
- Basic Summary Reports
- The Report Procedure
- The Tabulate Procedure
- Producing Bar and pie Chart
- Enhancing output
- Producing Plots
- Overview
- Review
- Review of DATA Step Processing
- Review of Displaying Data Sets
- Working with Existing Data Sets
- Outputting Multiple Observations
- Writing to Multiple Data Sets
- Selecting Variables and Observations
- Writing to an External File
- Creating an Accumulating Total variable
- Accumulating Totals for a Group of Data
- Reading Delimited Raw Data Files
- Controlling When a Record Loads
- Reading Hierarchical Raw data Files
- Introduction
- Manipulating Character values
- Manipulating Numeric values
- Manipulating Numeric values based on Dates
- Converting variable Type
- Using the PUT Statemen
- Using the DEBUG Option
- Do Loop Processing
- Array Processing
- Using Arrays
- Match-merging Two or more Data Sets
- Simple Joins Using the SQL Procedure
- Mastering Fundamental Concepts
- Diagnosing and Correcting Syntax Errors
Advanced Statistical Analysis Software
- What is SQL?
- What is the SQL Procedure?
- Terminology
- Comparing PROC SQL with the DATA step
- Note about the Example Table
- Overview of the select Statement
- Selecting Columns in a Table
- Creating New Columns
- Sorting Data
- Retrieving rows that satisfy a Condition
- Summarizing Data
- Grouping Data
- Filtering Grouped Data
- Introduction
- Selecting Data from More Than One Table by Using joins
- Using Subqueries to Select Data
- When to Use Joins and Subqueries
- Combining Queries with Set Operators
- Introduction
- Creating Tables
- Inserting Rows into Tables
- >Updating Data Values in a Table
- Deleting Rows
- Altering Columns
- Creating an Index
- Deleting a Table
- Using SQL Procedure Tables in Statistical Analysis Software
- Creating and Using Integrity Constraints in a Table
- Introduction
- Using Proc SQL Options to Create and Debug Quires
- Improving Query Performance
- Accessing System Information Using DICTIONARY Tables
- Using Proc SQL with the Macro Facility
- Formatting PROC SQL output Using the Report Procedure
- Accessing a DBMS
- Overview
- Computing a Weighted Average
- Comparing Tables
- Overlaying Missing Data Values
- Computing Percentages within Subtotals
- Counting Duplicate Rows in a Table
- Expanding Hierarchical Data in a Table
- Summarizing Data in Multiple Columns
- Creating a Summary Report
- Creating a Customized Sort Order
- Conditionally Updating a Table
- Updating a Table with Values from Another Table
- Creating and Using Macro Variables
- Macro Overview
- Macro Variables
- Scope of Macro variables
- Defining Macros
- Inserting Comments in Macros
- Macros with Arguments
- Conditional Macros
- Macros Repeating PROC Execution
- Macro Language
- Macro Processor
Python
- Introduction to Python
- Python Syntax rules
- Comments
- Variables
- Data Types
- Numbers
- Casting
- Strings
- Booleans
- Operators
- Lists
- Tuples
- Sets
- Dictionaries
- If...Else
- While Loops
- For Loops
- Functions
- Lambda
- Arrays
- Classes Objects
- Inheritance
- Iterators
- Scope
- Modules
- Dates
- Mathematics for Python
- JSON
- RegEx
- PIP
- Try...Except
- User Input
- String Formatting
- File Handling
- Read Files
- Write/Create Files
- Delete Files
- NumPy
- Pandas
- SciPy
- Getting Started
- Mean Median Mode
- Standard Deviation
- Percentile
- Data Distribution
- Normal Data Distribution
- Scatter Plot
- Linear Regression
- Polynomial Regression
- Multiple Regression
- Scale
- Train/Test
- Decision Tree
SQL
PowerBI(self-paced)
- Introduction To Microsoft Power BI - Learning Outcomes
- Introduction To Power BI
- Getting Started With Power BI Pro
- Working With Various Data Sources
- Improve Power BI Reports
- Optimize Power BI Reports
- Enriching Visualization
- Introduction To Microsoft Power BI - Lesson Summary
- Working With Power BI - Learning Outcomes
- Working With Data - Advanced Techniques
- Power BI Service - The Online Version Of Power BI
- Publish Reports
- The Various Power BI Components And How To Install Power BI
- Working With Power BI - Lesson Summary
Advanced Excel(Self-paced)
- Introduction to MS Excel, Quick review on MS Excel Options, Ribbon, Sheets and
- Difference between Excel 2003, 2007, 2010 and 2013
- Saving Excel File as PDF, CSV and Older versions
- Using Excel Shortcuts with Full List of Shortcuts
- Copy, Cut, Paste, Hide, Unhide, and Link the Data in Rows, Columns and Sheet
- Using Paste Special Options
- Formatting Cells, Rows, Columns and Sheets
- Protecting & Un protecting Cells, Rows, Columns and Sheets with or without Password
- Page Layout and Printer Properties
- Inserting Pictures and other objects in Worksheets
- Lookup and Reference Functions: VLOOKUP, HLOOKUP, INDEX, ADDRESS, MATCH, OFFSET,TRANSPOSE etc
- Logical Function: IF / ELSE, AND, OR, NOT, TRUE, NESTED IF/ELSE etc
- Database Functions: DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR,DVARP etc
- Date and Time Functions: DATE, DATEVALUE, DAY, DAY360, SECOND, MINUTES, HOURS,NOW, TODAY, MONTH, YEAR, YEARFRAC, TIME, WEEKDAY, WORKDAY etc
- Information Functions: CELL, ERROR.TYPE, INFO, ISBLANK, ISERR, ISERROR, ISEVEN,ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF, ISTEXT, TYPE etc
- Math and Trigonometry Functions: RAND, ROUND, CEILING, FLOOR, INT, LCM, MOD,EVEN, SUMIF, SUMIFS etc
- Statistical Functions: AVEDEV, AVERAGE, AVERAGEA, AVERAGEIF, COUNT, COUNTA,COUNTBLANK, COUNTIF, FORECAST, MAX, MAXA, MIN, MINA, STDEVA etc.
- Text Functions: LEFT, RIGHT, TEXT, TRIM, MID, LOWER, UPPER, PROPER, REPLACE, REPT, FIND, SEARCH, SUBSTITUTE, TRIM, TRUNC, CONVERT, CONCATENATE, DOLLAR etc
- Using Conditional Formatting
- Using Conditional Formatting with Multiple Cell Rules
- Using Color Scales and Icon Sets in Conditional Formatting
- Creating New Rules and Managing Existing Rules
- Sorting Data A-Z and Z-A
- Using Filters to Sort Data
- Advance Filtering Options Pivot Tables
- Creating Pivot Tables
- Using Pivot Table Options
- Changing and Updating Data Range
- Formatting Pivot Table and Making Dynamic Pivot Tables
- Creating Pivot Charts
- Types of Pivot Charts and Their Usage
- Formatting Pivot Charts and Making Dynamic Pivot Charts
- Introduction to VBA Macros
- Editing, Writing VBA Code and Saving as Macro or Add-In
- Adding Add-Ins in Exce
- Introduction of VBA Macros
- Recordings Macro
- Working with VBA Editor
- VBA Programming Concept
- VBA Syntax and Semantics
- Working with VBA Editor
- Variable Type and Declaration
- Repeating Actions with a Loops
- Procedures and Events
- Functions
- User Forms and GUI
- Sort and Filter, PivotTables and Pivot charts with VBA Macros
- ODBC Connectivity to SQL Database and Query Handling
- File Handling
Any one of the optional modules
Admission Process
Please call to admission counselor for course fees, registration fees, EMI fecilities,registration form and other formalities. Contact to admission counselor
+91-9831765780
+91-9830247087
Who can join?
Any graduate with knowledge of basic computing.
Requirment
1.Personal computer/laptop with webcam and microphone
2.Stable internet connections
Payment details
Bank Details:
KLMS HANDS-ON SYSTEMS PRIVET LIMITED
Account Number: 19700200000420
IFSC Code: BARB0SALTLA (5th letter is numeric zero)
UPI Payment: 9432257052@okbizaxis
This Course Include:
- Live Instructor-Led Course
- Project and Case Studies
- Certificate of completion
- Learn from Experts
- Placement Assistance
- Assistance for Global Certification
