Module 1 

Python (Basic & Advanced)

Python Basic

Introduction to Python

• Overview of Python
  • Introduction of Python
  • Installation of python
  • Feature of python
  • History of python
  • Installing Python and code editor IDE
  • Introduction to the anaconda distribution platform
  • Introduction to Jupytrt Notebook and how to work on it
  • Introduction to google collaboratory
  • Running python programs using terminal
  • Variables
  • Data type
  • Working on Integers, Floats, Booleans in Python
  • Playing with Strings in Python
  • Working on Lists
    • Creating lists
    • List functions
    • List Methods
    • Nested Lists
  • Working on Tuples
    • Creating Tuple
    • Tuple Functions
    • Tuple Methods
  • Working on Sets
    • Creating Sets
    • Set Functions
    • Set Methods
    • Frozen Sets
  • Working on Dictionary
    • Creating Dictionaries
    • Dictionary Functions
    • Dictionary Methods
  • Operators
  • Arithmetic Operator
  • Relational operators
  • Assignment operators
  • Logical operators
  • Special operators
  • Bitwise Operators
  • Control Structures
    • Conditional Statements
    • IF STATEMENT
    • IF / ELSE Statement
    • IF/ElIF/ELSE Statement
    • Nested IF/ELSE Statements
  • Expressions and Statements
  • Indentations
  • Writing Comments
  • Iterations and Iterables
  • Loops
    • For Loop
    • While Loop
    • Range and xrange Functions
    • Break, Continue, and Pass
  • Python Functions
    • Introduction to Python function
    • Types of Python Functions
    • Built-in Python Functions
    • User-defined Python function
    • Defining function
    • Calling Function
    • Parameters and arguments
    • Positional Arguments
    • Default Arguments
    • Keyword Arguments
    • Arbitrary Arguments
    • Docstrings
    • Recursive Functions
    • Lamda Functions
  • Object Oriented Programming
    • Objects
    • Classes
    • Creating empty class
    • Creating class and defining attributes
    • Class methods and attributes
    • Constructors
    • Generators
    • Decorators
    • Instance and class variables
    • Inheritance
    • Polymorphism
  • File Handling
    • Reading and writing files
    • Opening and closing files
    • Deleting Testing and debugging Files
    • Errors and Exception Handling
  • Modules and Packages
    • Importing Modules
    • Creating and importing packages
    • Namespaces
  • Testing and Debugging
    • Debugging with print statement
    • Debugging with the debugger
    • Testing with unit Test module
  • Database connectivity

====================================================

Business Analytics Training with Tableau and PowerBI

Module 2

Basic Excel Course Syllabus Introduction to Computers

• Font formatting
• Number formatting
• Table formatting
• Conditional formatting
• Hide/ Unhide
• Sort/filter
• Paste special
• Find and select

Insert

• Illustrations
• Charts
• Tex

Basic Functions

• Sum/Average/Count/Max/Min
• Basic Text/date/time/lookup/information functions
• Name manager
• Formula Auditing

Data

• Import from web
• Import from text
• Text to columns
• Remove duplicates
• Grouping and ungrouping

Review

• Proofing
• Comments
• Protection

Views

• Typesofviews
• Zoom
• Windows

Developer

• Enable developer
• Using checkbox/option buttons

============================================

Module 3

Advanced Excel Course Syllabus

Excel 2007 & 2010,2013, 2016 Quick Overview

• Difference between Excel2003, 2007 and 2010, 2013, 2016
• Use of Excel, its boundaries & features

Basic Formula

• Formulae that Add/ Subtract/ Multiply/ Divide
• BODMAS / Formula Error Checking
• The Sum Function

Absolute Referencing

• Problems with Absolute /Relative Cell Referencing
• Creating Absolute /Mixed References

LOOKUP Functions

• The VLOOKUP/ HLOOKUP Functions

Pivot Tables

• Creating,Formatting Simple Pivot Tables
• Page Field in a Pivot Table
• Formatting a Pivot Table
• Creating/ Modifying a Pivot Chart

Logical Functions

• IFs and Nested IF Functions
• Using AND/OR/ NOT Functions

Statistical Functions

• Using The SUM IF / COUNT IF Functions
• Using The AVERAGE/COUNT/LARGER/SMALLER Functions

Pivot Tables–Advance

• Adding new calculated Fields/Items
• Changing the Summary Function
• Consolidate Pivot table

LOOKUP Functions–Advance

• MATCH with VLOOKUP Functions
• INDEX& MATCH Functions
• OFFSET/INDIRECT functions

Logical Functions–Advance

• If Loop and Nested IF Loop Functions
• Using IF/IS ERROR Functions

Chart Data Techniques

• The Chart Wizard
• Chart Types
• Adding Title/Legends/ Labels
• Printing Charts
• Adding Data to a Chart
• Formatting/Renaming/Deleting Data Series
• Changing the Order of Data Series

Date / Time Functions

• Using The Today
• Now& Date Functions
• Using The Dated if/ Network days/Eomonth Functions
• Using The Week num Functions
• Using The Edate/Network days.Intl/Weekdays.Intl Functions

Text Functions Using

• The Mid/Search/Left/Right Functions
• Using The Trim/Clean/Upper/Lower Functions
• Using The Substitute/Text Functions
• Using The Trim/Clean/Proper/Dollar Function

Validations

• Input Messages/Error Alerts/Drop-Down Lists
• Conditional Formatting

Advanced Filters

• Extracting Records with Advanced Filter
• Using Formula sin Criteria

Advanced Sorting

• Sorting by Top to Bottom/Left to Right
• Creating/Deleting Custom List
• Sort by using Custom List

Hyper/Data Linking

• Hyper linking data,within sheet/workbook
• Linking& Updating links between workbooks &application

Math & Trigonometry Functions

• Using SUM PRODUCT Functions
• Using FLOOR/CEILING/MROUND/MOD/QUOTIENT Functions

Summarizing Data

• Creating Subtotals/Nested Subtotals
• SUBTOTALS Formula

Outlining

• Creating/Working with an Automatic/Manual Outline
• Grouping/Un grouping

Consolidation

• Consolidating Data with Identical/Different Layout

Using Auditing Tools

• Displaying/Removing Dependent& Precedent Arrows
• Evaluate Formula–StepIN/ StepOut

Custom Views

• Creating Custom Views
• Displaying Custom Views
• Deleting Custom Views

Sharing and Protecting Workbooks

• Sharing Workbooks&Tracking Changes
• Protecting sheets/workbooks/Files

Importing & Exporting Data

• Importing Data from Database/ TextFiles/Web
• Exporting Data
• Changing External Data Range

====================================================

Module 4

SQL

 Introduction of SQL

SQL Statements

• DDL
• DML
• DQL
• DCL

SQL CONSTRINTS

• UNIQUE
• PRIMARY KEY
• NULL
• NOT NULL
• CHECK
• DEFAULT
• FOREIGN KEY

SQL OPERTORS

• AND
• OR
• LIKE
• IN
• BETWEEN
• IS

SQL FUNCTIONS

• MIN()
• MAX()
• COUNT()
• SUM()
• AVG()
• LENGTH()
• REVERSE()
• REPLACE()
• INSTR()
• SUBSTR()
• TRIM()
• ROUND()
• ABS()
• SQRT()
• MOD()

SQL CLAUSE

• WHERE
• GROUP BY
• ORDER BY
• HAVING

SUB QUERIS

JOINS

• inner join
• outer join
• left join
• right join

====================================================

Module 5

TABLEAU

Understanding Data

• What is data Where to find data
• Foundations for building Data Visualizations

Creating Your First visualization

• Getting started with Tableau Software Using Data file formats
• Connecting your Data to Tableau
• Creating basic charts(line,bar charts,Tree maps) Using the Show me panel

Tableau Calculations

• Overview of SUM, AVR, and Aggregate features
• Creating custom calculations and fields
• Applying new data calculations to your visualization

Formatting

• Visualizations
• Formatting Tools and Menus
• Formatting specific parts of the view
• Editing and Formatting Axes

Manipulating Data in Tableau

• Cleaning- up the data with the Data Interpreter Structuring your data
• Sorting and filtering Tableau data
• Pivoting Tableau data

Advanced Visualization Tools

• Using Filters
•  Using the Detail panel Using the Size panels Customizing filters
• Using and Customizing tooltips Formatting your data with colors

Creating Dashboards & Stories

• Using Storytelling
• Creating your first dashboard and Story Design for different displays
• Adding interactivity to your Dashboard

Distributing & Publishing Your Visualization

• Tableau file types
• Publishing toTableau
• Online Sharing your visualization Printing and exporting

====================================================

Module 6

POWER BI

Power BI Introduction

• Data Visualization,Reporting
• Business Intelligence(BI),Traditional BI,Self-Serviced BI
• Cloud Based BI,On Premise BI
• Power BI Products
• Power BI Desktop(Power Query,Power Pivot,Power View)
• Flow of Working PowerBI Desktop
• PowerBI Report Server,PowerBI Service,PowerBI Mobile Flowof Working PowerBI/PowerBI Architecture
• A Brief History of PowerBI
• Data Transformation,Benefits of Data Transformation
• Shape or Transform Data using Power Query

Power Query

• Overview of Power Query/Query Editor, Query Editor User Interface The
• Ribbon(Home,Transform, Add Column,View Tabs)
• The Queries Pane,The Data View/Results Pane,The Query Settings Pane,Formula Bar
• Saving the Work
• Datatypes,Changing the Data type of a Column Filter in Power Query
• Auto Filter/Basic Filtering
• Filter a Column using Text Filters
• Filter a Column using Number Filters
• Filter a Column using Date Filters
• Filter Multiple Columns
• Remove Columns/Remove Other Columns
• Name/Rename a Column
• Reorder Columns or Sort Columns
• Add Column/Custom Column Split
• Columns
• Merge Columns
• PIVOT,UNPIVOT Columns
• Transpose Columns
• Header Row or Use First Row as Headers
• Keep Top Rows,Keep Bottom Rows Keep
• Range of Rows
• Keep Duplicates,Keep Errors
• Remove Top Rows, Remove Bottom Rows,Remove Alternative Rows
• Remove Duplicates,Remove Blank Rows,Remove Errors
• Group Rows/Group By

Visualizations

• • Visualizing Data,Why Visualizations
  • Visualization types,Create and Format Bar and Column Charts
  • Create and Format Stacked Bar Chart Stacked Column Chart Create
  • and Format Clustered Bar Chart,Clustered Column Chart
  • Create and Format 100% Stacked Bar Chart,100% Stacked Column Chart Createand
  • Format Pie and Donut Charts
  • Create and Format Scatter Charts
  • Create and Format Table Visual,Matrix Visualization
  • Line and Area Charts
  • Create and Format Line Chart,Area Chart,Stacked Area Chart
  • Combo Charts
  • Create and Format Line and Stacked Column Chart,Line and Clustered Column Chart
  • Create and Format Ribbon Chart,Waterfall Chart,Funnel Chart

PowerBI Service

• PowerBI Service Introduction,PowerBI Cloud Architecture
• Creating PowerBI Service Account, SIGN IN to PowerBI Service Account
• Publishing Reports to the PowerBI service,Import/Getting the Report to PBI Service My
• Workspace/App Workspaces Tabs
• DATASETS,WORKBOOKS,REPORTS,DASHBOARDS
• Working with Datasets,Creating Reports in Cloud using Published Datasets

Creating Dashboards

• P in Visuals and Pin LIVE Report Pages to Dashboard
• Advantages of Dashboards
• Interacting with Dashboards
• Formatting Dashboard
• Sharing Dashboard

====================================================

Project: Project will be given as per latest topic.

Have a great career ahead…!!

Once you master your chosen program at Yess Infotech, you’ll walk away with a valuable certification!

 

• Why Choose Yess InfoTech?
  Yess InfoTech offers a comprehensive approach to IT education and career development. Here’s why you should choose them:Optimal Learning Environment
  Study Room: A dedicated space for focused learning.
  Computer Equipped Lab: Hands-on practice with the latest technology.Expert Guidance
  Experienced Trainers: Industry professionals sharing real-world knowledge.
  Career Coach Sandip Sir: 8+ years of MNC experience providing valuable career guidance.
  Personality Development Trainer: Enhancing soft skills essential for professional success.Comprehensive Support
  Dedicated Placement Team: Assisting with job search and interview preparation.
  Placement Record of 12 LPA: Demonstrating successful career outcomes.
  Notes Availability: Additional resources for effective learning.
  Recorded Sessions on Trechto App: Flexibility to review lessons at your convenience.
  In essence, Yess InfoTech provides a holistic learning experience that equips students with the necessary technical skills, soft skills, and career support to excel in the IT industry.By combining a conducive learning environment, expert faculty, and a strong focus on career development, Yess InfoTech sets itself apart as a preferred choice for aspiring IT professionals.

  Would you like to know more about a specific aspect of Yess InfoTech?

Trainer is having 15 year experience in Business Analytics with 10  years in Business Analytics . It has been 15 years now that he has been working extensively in the top level Software company. He is having different kind of certifications in DA. He also have done corporate sessions and seminars both in India and abroad. Recently he was engaged by Yess InfoTech for sessions and professional motivator for working processionals to achieve their day to day targets.

All trainers at our organization are currently working on the technologies in reputed organization. The curriculum is not just some theory or  some PPTs. We have all practical sessions and that to we ask our student to implement the same in the session only. We provide notes for the same. We use simple easy language and the contents are well absorbed by the candidates. The always give assignment. Also that the faculties are industry experienced so we give real time projects and practice. We also provide recorded sessions but that will be costing differently. Also we provide result oriented training.