Business Analyst Master's Program

·      Various types of databases                       

·      Introduction to Structured Query Language        

·      Distinction between client server and file server databases                      

·      Understanding SQL Server Management Studio

·      SQL Table basics              

·      Data types and functions              

·      Transaction-SQL               

·      Authentication for Windows                    

·      Data control language                   

·      The identification of the keywords in T-SQL

·      Practical Exercise

·      Data Anomalies                 

·      Update Anomalies            

·      Insertion Anomalies                      

·      Deletion Anomalies                       

·      Types of Dependencies                 

·      Functional Dependency                

·      Fully functional dependency                    

·      Partial functional dependency                  

·      Transitive functional dependency             

·      Multi-valued functional dependency                    

·      Decomposition of tables               

·      Lossy decomposition                    

·      Lossless decomposition                 

·      What is Normalization?                 

·      First Normal Form             

·      Second Normal Form                    

·      Third Normal Form                       

·      Boyce-Codd Normal Form(BCNF)                      

·      Fourth Normal Form         

·      Practical Exercise

·      Entity-Relationship Model            

·      Entity and Entity Set                    

·      Attributes and types of Attributes            

·      Entity Sets             

·      Relationship Sets               

·      Degree of Relationship                 

·      Mapping Cardinalities, One-to-One, One-to-Many, Many-to-one, Many-to-many

·      Symbols used in E-R Notation

·      Practical Exercise

·      Introduction to relational databases                      

·      Fundamental concepts of relational rows, tables, and columns                

·      Several operators (such as logical and relational), constraints, domains, indexes, stored procedures, primary and foreign keys                       

·      Understanding group functions                

·      The unique key

·      Practical Exercise

·      Join            

·      Tables                    

·      Variables

·      Practical Exercise

·      SQL functions                   

·      Operators & queries                      

·      Table creation                    

·      Data retrieval from tables              

·      Combining rows from tables using inner, outer, cross, and self joins                   

·      Deploying operators such as ‘intersect,’ ‘except,’ ‘union,’           

·      Temporary table creation               

·      Set operator rules              

·      Table variables       

·      Practical Exercise

·      Understanding SQL functions                  

·      Scalar functions                 

·      Aggregate functions                      

·      Functions that can be used on different datasets, such as numbers, characters, strings, and dates

·      Inline SQL functions                    

·      General functions              

·      Duplicate functions

·      Practical Exercise  

·      Understanding SQL subqueries, their rules          

·      Statements and operators with which subqueries can be used                 

·      Using the set clause to modify subqueries

·      Understanding different types of subqueries, such as where, select, insert, update, delete, etc  

·      Methods to create and view subqueries

·      Practical Exercise  

·      Learning SQL views                     

·      Methods of creating, using, altering, renaming, dropping, and modifying views            

·      Understanding stored procedures and their key benefits 

·      Working with stored procedures               

·      Studying user-defined functions              

·      Error handling

·      Practical Exercise

·      User-defined functions                 

·      Types of UDFs, such as scalar                  

·      Inline table value               

·      Multi-statement table                    

·      Stored procedures and when to deploy them       

·      What is rank function?                  

·      Triggers, and when to execute triggers?   

·      Practical Exercise

·      SQL Server Management Studio              

·      Using pivot in MS Excel and MS SQL Server     

·      Differentiating between Char, Varchar, and NVarchar    

·      XL path, indexes and their creation                      

·      Records grouping, advantages, searching, sorting, modifying data                     

·      Clustered indexes creation            

·      Use of indexes to cover queries                

·      Common table expressions            

·      Index guidelines

·      Practical Exercise

·      Creating Transact-SQL queries                 

·      Querying multiple tables using joins                     

·      Implementing functions and aggregating data     

·      Modifying data                 

·      Determining the results of DDL statements on supplied tables and data            

·      Constructing DML statements using the output statement

·      Practical Exercise

·      Querying data using subqueries and APPLY       

·      Querying data using table expressions                  

·      Grouping and pivoting data using queries

·      Querying temporal data and non-relational data

·      Constructing recursive table expressions to meet business requirements              

·      Using windowing functions to group                   

·      Rank the results of a query           

·      Practical Exercise

·      Creating database programmability objects by using T-SQL                   

·      Implementing error handling and transactions

·      Implementing transaction control in conjunction with error handling in stored procedures

·      Implementing data types and NULL

·      Practical Exercise

·      Designing and implementing relational database schema             

·      Designing and implementing indexes                   

·      Learning to compare between indexed and included columns                 

·      Implementing clustered index                   

·      Designing and deploying views                

·      Column store views

·      Practical Exercise  

·      Explaining foreign key constraints            

·      Using T-SQL statements               

·      Usage of Data Manipulation Language (DML)

·      Designing the components of stored procedures

·      Implementing input and output parameters          

·      Applying error handling                

·      Executing control logic in stored procedures        

·      Designing trigger logic, DDL triggers, etc

·      Practical Exercise

·      Applying transactions                   

·      Using the transaction behavior to identify DML statements                    

·      Learning about implicit and explicit transactions

·      Isolation levels management                     

·      Understanding concurrency and locking behavior

·      Using memory-optimized tables

·      Practical Exercise  

·      Accuracy of statistics                    

·      Formulating statistics maintenance tasks  

·      Dynamic management objects management         

·      Identifying missing indexes                      

·      Examining and troubleshooting query plans         

·      Consolidating the overlapping indexes                 

·      The performance management of database instances

·      SQL server performance monitoring

·      Practical Exercise

·      Correlated Subquery, Grouping Sets, Rollup, Cube

·      Implementing Correlated Subqueries                    

·      Using EXISTS with a Correlated subquery          

·      Using Union Query                       

·      Using Grouping Set Query                       

·      Using Rollup                     

·      Using CUBE to generate four grouping sets        

·      Perform a partial CUBE

·      Practical Exercise  

·      Entering Data

·      Learning to enter data

·      Filling of series and custom fill list

·      Editing and deleting fields

·      Practical Exercise

·      Learning about relative and absolute referencing

·      The concept of relative formulae

·      The issues in relative formulae

·      Creating of absolute

·      Mixed references

·      Various other formulae

·      Practical Exercise

·      Creating names range

·      Using names in new formula

·      Working with the name box

·      Selecting range

·      Names from a selection

·      Pasting names in formula

·      Selecting names & working with Name Manager

·      Practical Exercise

·      The various logical functions in Excel

·      The If function for calculating values and displaying text

·      Nested If functions

·      Vlookup and iferror functions

·      Practical Exercise

·      Learning about conditional formatting

·      The options for formatting cells

·      Various operations with icon sets

·      Data bars and color scales

·      Creating and modifying sparklines

·      Practical Exercise

·      Multi-level drop down validation

·      Restricting value from list only

·      Learning about error messages & cell drop down

·      Practical Exercise

·      Introduction to the various formulae in Excel like Sum

·      Sumif & sumifs

·      Count

·      Counta, countif and countblank

·      Networkdays

·      Networkdays International

·      Today & Now function

·      Trim (Eliminating undesirable spaces)

·      Concatenate (Consolidating columns)

·      Practical Exercise

·      Introduction to dynamic table in Excel

·      Data conversion

·      Table conversion

·      Tables for charts and VLOOKUP

·      Practical Exercise

·      Sorting in Excel

·      Various types of sorting including, alphabetical, numerical, row, multiple columns, working with paste special, hyperlinking and using subtotal

·      Practical Exercise

·      The concept of data filtering

·      Understanding compound filter and its creation

·      Removing of filter

·      Using custom filter and multiple value filters

·      Working with wildcards

·      Practical Exercise

·      Creation of Charts in Excel

·      Performing operations in embedded chart

·      Modifying, resizing

·      Dragging of chart

·      Practical Exercise

·      Introduction to the various types of charting techniques

·      Creating titles for charts, axes

·      Learning about data labels

·      Displaying data tables

·      Modifying axes

·      Displaying gridlines and inserting trendlines

·      Textbox insertion in a chart

·      Creating a 2-axis chart

·      Creating combination chart

·      Practical Exercise

·      The concept of Pivot tables in Excel

·      Report filtering

·      Shell creation

·      Working with Pivot for calculations

·      Formatting of reports

·      Dynamic range assigning

·      The slicers and creating of slicers

·      Practical Exercise

·      Data and file security in Excel

·      Protecting row

·      Column, and cell

·      The different safeguarding techniques

·      Practical Exercise

·      Learning about VBA macros in Excel

·      Executing macros in Excel

·      The macro shortcuts

·      Applications

·      The concept of relative reference in macros

·      Practical Exercise

·      In-depth understanding of Visual Basic for Applications

·      The VBA Editor

·      Module insertion and deletion

·      Performing action with Sub and ending Sub if condition not met

·      Practical Exercise

·      Learning about the concepts of workbooks

·      Worksheets in Excel

·      Protection of macro codes

·      Range coding

·      Declaring a variable

·      The concept of Pivot Table in VBA

·      Introduction to arrays

·      User forms

·      Getting to know how to work with databases within Excel

·      Practical Exercise

·      Learning how the If condition works

·      Knowing how to apply it in various scenarios

·      Working with multiple Ifs in Macro

·      Practical Exercise

·      Understanding the concept of looping

·      Deploying looping in VBA Macros

·      Practical Exercise

·      Studying about debugging in VBA

·      The various steps of debugging like running

·      Breaking, resetting, understanding breakpoints and way to mark it

·      The code for debugging and code commenting

·      Practical Exercise

·      The concept of message box in VBA

·      Learning to create the message box

·      Various types of message boxes

·      The IF condition as related to message boxes

·      Practical Exercise

·      Mastering the various tasks and functions using VBA

·      Understanding data separation

·      Auto filtering

·      Formatting of report

·      Combining multiple sheets into one

·      Merging multiple files together

·      Practical Exercise

·      Introduction to powerful data visualization with Excel Dashboard

·      Important points to consider while designing the dashboards

·      Loading the data

·      Managing data

·      Linking the data to tables and charts

·      Creating Reports using dashboard features

·      Practical Exercise

·      Learning to create charts in Excel

·      The various charts available

·      The steps to successfully build a chart

·      Personalization of charts

·      Formatting and updating features

·      Various special charts for Excel dashboards

·      Understanding how to choose the right chart for the right data

·      Practical Exercise

·      Creation of Pivot Tables in Excel

·      Learning to change the Pivot Table layout

·      Generating Reports

·      The methodology of grouping and ungrouping of data

·      Practical Exercise

·      Learning to create Dashboards

·      The various rules to follow while creating Dashboards

·      Creation of dynamic dashboards

·      Knowing what is data layout

·      Introduction to thermometer chart and its creation

·      How to use alerts in the Dashboard setup

·      Practical Exercise

·      How to insert a Scroll bar to a data window?

·      Concept of Option buttons in a chart

·      Use of combo box drop-down

·      List box control Usage

·      How to use Checkbox Control?

·      Practical Exercise

·      Understanding data quality issues in Excel

·      Linking of data

·      Consolidating

·      Merging data

·      Working with dashboards for Excel Pivot Tables

·      Practical Exercise

·      Data Visualization

·      An introduction to visualization

·      Importance of Data Visualisation

·      Data visualization Domains

·      Using of Data Visualization

·      Data visualization tools

·      History of data visualization

·      Data visualization tool expectation

·      Tableau Competency

·      Reasons to choose Tableau

·      Positioning of Tableau

·      Tableau product line

·      File types in Tableau

·      Practical Exercise            

·      Installation of Tableau Desktop,

·      Architecture of Tableau,

·      Interface of Tableau

·      How to start with Tableau,

·      The ways to share

·      Export the work done in tableau.

·      Practical Exercise            

·      Desktop architecture

·      Data layer

·      Data connectors

·      Live connection

·      In-memory

·      Data Source Page

·      Workspace

·      Workbooks and Sheets

·      Visual Cues and Icons in Tableau

·      Connect to a File

·      Connect to a Text File

·      Connect to MS Access

·      Connecting to RData files

·      Connect to a Server

·      Connecting to MS SQL Server Management Studio

·      Connecting to MySQL

·      Connecting to NoSQL Databases

·      Metadata Grid

·      Custom SQL

·      Data Blending

·      Practical Exercise            

·      Why filtering?

·      What is filtering?

·      How to apply “Filter”?

·      Practical Exercise            

·      Why sorting?

·      What is sorting?

·      How to apply sorting?

·      Practical Exercise            

·      What is a group?

·      How to create a group?

·      Editing an existing group

·      Creating Hierarchies

·      Practical Exercise            

·      Why are measure names and measure values required?

·      What are measure names and measure values?

·      Where do these fields come from?

·      Measures on an independent axis

·      Blended axes

·      Dual axis

·      Practical Exercise            

·      Using Formatting Pane to work with menu, fonts, alignments, settings, and copy-paste;

·      Formatting data using Labels and tooltips,

·      Edit axes and annotations,

·      K-means cluster analysis,

·      Trend and reference lines,

·      Visual analytics in Tableau,

·      Forecasting,

·      Confidence interval,

·      Reference lines, and bands.

·      Practical Exercise            

·      Working on coordinate points,

·      Plotting longitude and latitude,

·      Editing unrecognized locations,

·      Customizing geocoding,

·      Polygon maps,

·      WMS: web mapping services,

·      Working on the background image,

·      Including add image,

·      Plotting points on images and generating coordinates from them; map visualization,

·      Custom territories,

·      Map box,

·      WMS map; how to create map projects in Tableau,

·      Creating dual axes maps, and editing locations.

·      Practical Exercise            

·      What is a table calculation?

·      Running Total of Sales

·      Profitability as Percent of Total

·      Moving average

·      Where is it used?

·      Types of moving average

·      LOD expressions, including concept and syntax

·      Aggregation and replication with LOD expressions,

·      Nested LOD expressions

·      Practical Exercise            

·      Number functions

·      CEILING(number) and FLOOR(number)

·      MAX(number, number), MIN(number, number)

·      ABS(number)

·      String functions

·      Concatenation

·      Left() and Find() functions

·      Contains() function

·      Len() function

·      Logical Functions

·      CASE ,IIF() function

·      IF ELSE ,IF ELSEIF

·      Date functions

·      DATEDIFF()

·      DATEADD() function

·      DATENAME

·      Aggregate functions

·      Practical Exercise            

·      Creating parameters, parameters in calculations,

·      Using parameters with filters,

·      Column selection parameters,

·      Chart selection parameters,

·      parameters in the filter session,

·      parameters in calculated fields,

·      parameters in reference line, etc.

·      Practical Exercise            

·      Why use statistics?

·      Few terms in statistics

·      Why do we use inferential statistics?

·      Why do we use descriptive statistics?

·      What is the measure of central tendency here?

·      Five magic number summaries

·      Mean, Median, Mode

·      When to use which average?

·      Spread of data

·      Range

·      Interquartile range

·      Variance and standard deviation

·      Standard deviation

·      Box plot

·      Plotting box and whiskers plot in Tableau

·      Statistics tools in Tableau

·      Forecasting

·      Practical Exercise            

·      Pie chart

·      What is a pie chart?

·      When to use a pie chart?

·      How to read a pie chart?

·      Pros, Cons

·      Five tips for using pie charts

·      A critique’s view

·      An alternative for a pie chart

·      What can further add to the woes?

·      Treemaps, Pros, References

·      Heat Map

·      Why use heat maps?

·      How to create a heat map?

·      Highlight Table, Line Graph

·      Stacked Bar Chart,

·      Gantt chart, Scatter plot, Histogram

·      Word Cloud

·      Practical Exercise            

·      Waterfall charts

·      Where can waterfall charts be used?

·      Bump charts

·      Where to use a bump chart?

·      Bullet graph

·      Practical Exercise            

·      Why use a dashboard?

·      What is a dashboard?

·      Creating a dashboard

·      Opening a dashboard sheet

·      Adding views to the Dashboard

·      Adding interactivity to the dashboard

·      Adding an object to the dashboard

·      Remove a view or an object from the dashboard

·      Organizing a dashboard

·      Dashboard actions

·      Filter action

·      Creating stories, including the intro of story points

·      Creating as well as updating the story points,

·      Adding catchy visuals in stories,

·      Adding annotations with descriptions

·      Dashboards and stories: what is dashboard?,

·      Highlight actions,

·      URL actions, and filter actions,

·      Selecting and clearing values,

·      Best practices to create dashboards,

·      Dashboard examples;

·      Using Tableau workspace and Tableau interface;

·      Learning about Tableau joins,

·      Types of joins

·      Tableau field types,

·      Saving as well as publishing data source,

·      Live vs extract connection, and various file types.

·      Practical Exercise            

·      Installation, Concept and Pricing

·      Raw Data Sets Explained - The Dirty Super Store

·      Loading your Data - Menu Explained

·      Cleaning Step - Interface Explained

·      Renaming Fields, Keep Only, Exclude, Data Types

·      Branches, Multiple Outputs, Outputting your Results - CSV, Hyper,

·      Remapping a File to a New Location

·      Data Interpreter and NotePad Plus

·      Filtering Numbers and Strings

·      Grouping and Replacing

·      Ungrouping

·      Cleaning Text - Spaces, Letters, Numbers, Punct, REPLACE

·      Automatic and Custom Splitting

·      Replace with Null

·      Using Aggregates

·      Unpivotting

·      Introduction to Unions

·      Wildcard Unions

·      Join Types Explained and PDF Download

·      Single Join Example and your First Connection

·      Single Join - More Examples and Rebuilding Joins

·      Multi-Joins and Troubleshooting

·      If functions, IsNull, Not Null, IfNull, AND/OR

·      Rounding Decimal Places, Integer Function, Absolute

·      Left, Right, Mid and Concatenate

·      Find and Replace

·      Date Functions - Year, Month, Day, Now, Today

·      Practical Exercise

·      Defining Agile values and principles,

·      Contrasting Waterfall

·      Agile product development philosophies,

·      Confronting the challenges of adopting Agile,

·      Creating a cross–functional team.

·      Embracing Agile

·      Defining the core Agile Framework,

·      Core Agile team, artifacts

·      ceremonies,

·      Adapting traditional business process to Agile,

·      Applying core Agile Values,

·      Leveraging checks and balances      

·      Defining the Core Agile Artifacts

·      Creating the Product Backlog,

·      Implementing the Sprint Backlog,

·      Defining the Definition of Done,

·      Developing potentially shippable product increment       

·      Refining the Product Backlog,

·      Holding the Sprint Planning meeting,

·      Hosting the Daily Agile,

·      Leading Sprint Reviews,

·      Facilitating successful Sprint Retrospectives         

·      Iterating the Product Backlog

·      Developing the Product Vision,

·      Building the Product Backlog,

·      Continuously refining the Product Backlog,

·      Turning ideas into action,

·      Applying the DOVE framework

·      Comparing iterative and incremental delivery,

·      Decomposing Epics into features and stories,

·      Releasing products with Minimal Marketable Features,

·      Planning a product delivery roadmap

·      Defining user personas

·      Creating realistic user Personas,

·      Visualizing scope through story maps,

·      Linking user personas to use cases

·      Writing users stories with the Connextra format,

·      Evolving product requirements,

·      Applying INVEST

·      SMART frameworks to focus user stories,

·      Developing products with progressive elaboration,

·      Breaking user stories into tasks,

·      Defining appropriate acceptance criteria.

·      Sizing user stories,

·      Estimating effort

·      Business value level through relative measurement,

·      Comparing and contrasting affinity

·      Planning poker estimation techniques       

·      Ranking product backlog item priority at the release,

·      Product and project level,

·      Utilizing moscow

·      Other prioritization techniques,

·      Applying the Pareto principle to product planning,

·      Identifying high–priority items for sprint planning