Course Description
Why Business Analyst Course With ExcelR ?
Companies across the globe have taken the approach of analysing tons of data that they generate as a part of their business. The analysis helps these companies obtain valuable insights that take the profitability to great heights.
Being one of the pioneers of upskilling learners in the Data Analytics field, ExcelR has come up with a curriculum that matches the market requirement with great precision. Alongside the curriculum, ExcelR is known for its hallmark service.
There is a dedicated assignments team, that helps students solve their queries.
Road Map for Business Analyst Course :
.png/process_lp%20(1)__1100x209.png)
Course Curriculum
- Business Statistics
- Excel: Basics to Advanced
- MySQL
- Tableau
- Power BI
- SAS
- R Basics
- Python Basics
- Agile
- Descriptive Statistics
- Data Types, Measure Of central tendency, Measures of Dispersion
- Graphical Techniques, Skewness & Kurtosis, Box Plot
- Probability and Normal Distribution
- Random Variable, Probability, Probility Distribution, Normal Distribution, SND, Expected Value
- Inferential Statistics
- Sampling Funnel, Sampling Variation, Central Limit Theorem, Confidence interval
- Introduction to Hypothesis Testing
- Hypothesis Testing (2 proportion test, 2 t sample t test)
- Anova and Chisquare
- Data cleaning and Insights
- Data Cleaning(Invalid cells,Blanks,Outliers,Null values)
- Imputation Techniques(Mean and Median)
- Scatter Diagram
- Correlation Analysis
- Intorduction to Excel:Quantum of Excel and Basics
- Workbook,Types of workbooks and their uses(XLSX,XLS,CSV,XLSM and XLSB)
- Common uses of Excel
- Cell,Row,Column,Range/Array,Name box
- Formatting of cells(Wrap Text,Number,Text,Cell formatting ,commenting,etc)
- Ribbon,Formula bar,Status bar
- Basic operators(+,-,/,*,%,>,<,>=,<=,( ),{ },[ ],&,' ', "" "",!)
- Intorduction to Functions:Commonly used Excel Functions
- What is syntax,arguments(Optional,Mandatory)Navigations using keyboard,shortcuts
- Sum,Average,Max,Min,Product
- CountBlank,CountA,CountIF,If,Now,Today
- Cut,Copy,Paste,Paste Special
- Anchoring data:Referencing,Named ranges and its uses
- Absolute,Relative,Mixed referencing
- Name Manager,Named ranges,Creating Tables
- Create functions using named ranges AND/OR referencing
- Referring data from different tables:Various types of Lookup,Nested IF
- Lookup,Vlookup,Nested Vlookup,Hlookup,Index,Index with Match function
- If,If with combination of AND/OR(multiple ways to get the output),IFERROR
- Referring data from different tables:Advanced functions
- RANK,RAND,RANDBETWEEN,INDIRECT with ADDRESS & MATCH,OFFSET
- Data Handling:Data cleaning,Data type identification,Data restrictions
- LEN,LEFT,RIGHT,MID,CONCATENATE,CONCAT,FIND,SUBSTITUTE,TEXT,TRIM
- SECOND,MINUTE,HOUR,DAY,WEEK,MONTH,QUARTER,YEAR,WORKDAYINTL
- ISNUMBER,ISNA,ISNONTEXT,ISEVEN,ISODD,ISFORMULA,ISERROR
- Data validation,Depended drop down,Protecting cell,Array,range,sheet,Workbook
- Data Handling:Formatting and Filtering
- Conditional formatting(Icon sets/Highlighted color sets/Data bars/custom formatting),Sort,Advanced Sort,Filtering
- Data Summerization:Advanced functions,Charts
- Sum,Average,Max,Min with IF and IF'S,CountIF'S
- Various types of Charts
- Data Summerization:Pivots,Preparing the Dashboard
- Pivot table,Slicers,Pivot charts,Calculated field,Calculated item, ADD/REMOVE/CHANGE data into the pivot table,Refreshing pivot data
- Dashboard creation
- Power query,power pivot
- Cleaning data,extracting data from multiple sources
- Transforming data,imputation techniques.Getting data from CSV files,databases,workbooks,webpages
- Power query,power pivot,Use case discussion:Data Preparation,Project Summarization
- Consolidating data from multiple sources,merging data from different workbooks/worksheets,relationships.
- Use Data handling steps taught in the previous session,Use Data summarization techniques,Populate output in Excel,Combining multiple functions
- Intro to Automation:Macros(Recorded /VBA)
- How VBA works,Record a sample macro(Recording macros,Absolute mode,relative mode,different methods of executing macros)
- VBA
- If constructs,Select construct,User defined functions,input box, message box,procedures,automatic macros, methods to cleanup the codes
- Introduction to Databases, Software Installation
- Introduction to RDBMS,Explain RDBMS through normalization,Different types of RDBMS
- Types of SQL Commands; Data Types in SQL
- DDL,DML,DQL,DCL,TCL,Datatypes:int,float,char,varchar,date,date&time,UTC
- DDL and DML and TCL commands
- DDL:Create,Drop,Rename,Alter,Truncate,DML:Insert,Update,Delete,TCL:Commit,rollback,savepoint
- Database Constraints
- Domain Constraint,Key Constraint,Referential Integrity Constraint,Primary key,Foreign Key
- Operators in SQL
- AND,OR,WHERE,IN,NOT IN,BETWEEN,EXIST,NULL
- Grouping operations
- Select query,Order by,Group by,Having Classes,Aggregating functions
- Ranking functions,Analytical functions
- Rank,Dense rank,row number,percentile rank,lead and lag functions
- Joining Tables
- Inner,Left,Right,Cross,Self Joins,Full outer join, Interview Scenarios
- Views,Triggers
- Simple views,Complex views,Different types of triggers
- Introduction to subqueries, different types of subqueries
- Explaintion of subqueries with interview scenarios
- Indexing,Sequence Objects
- B.Tree Index,Hash Index,Unique index,Advantage of Index,Creation of Sequence on primary key column
- Stored procedures
- Parameters in stored procedures,Exception handling in stored procedures
- Intro to Tableau Tool
- What is Data,Types of Data(Structured,Unstructured,Semi Structured),Visualization Basics,Different Visualization tools,Popularity of the Tools, Licencing Cost,Different Products of Tableau,Installation (Student ID), Connecting to Static Files,MySQL
- Data Pane Window
- Live Vs Extract,Data Source Window,Navigating to Work Sheet,Data Pane,Analytics Pane,Dimensions,Measures,Auto Generated Fields,Data Visualization Window Explanation,Data Source Window Operations
- Groups,Sets,Parameters
- Hierarchy(In-Built Hierarchy,Manual),Grouping ,Sets,Parameter With Filters and Parameter With Sets,Usage of Meausre Names and Measure Values
- Filters in Tableau
- Dual Axis,Blended Axis,Dimension Filters,Measure Filters(Record Level Filters,Summary Level Filters),Date Filters,Cascading Filters,Context filters,Data Source Filters,Extract Filters,
- Calculated Fields
- Quick Table Calculations,Introduction to Calculated Fields,String Calculated Fields,Number Calculated Fields,Date Calculated Fields,Logical Calculated Fields,ZN Function
- Data Blending and Joins
- Mixing Up of All Calculated Fields,Conditional Formatting in Tableau, Data Blending,Data Joins,Unions,Relationships,Basic Charts and Use Cases, Introduction to Show Me,Development of In-Built Charts Part1,
- Charts in Tableau
- Development of In-Built Charts Part2,Customized Graphs(Donut, Waterfall,Bump,Barometer,Butterfly,Gauge meter,Basic Funnel, Advanced Funnel,Word Cloud,Gantt Bar),Animated Chart
- Reference Lines,Bands,Distributions
- Arbitary Formatting,Explaination of Marks Card,Reference Lines, Reference Bands,Reference Distribution
- LOD's, Intro to Dashboard,Story
- Forecasting,Introduction to Dashboard,Story Board Interfaces,LOD's(Fixed,Include,Exclude)
- Creating a Dashboard
- Creating of a Basic Dashboard With Both Tiled,Floating Layouts, Explaination of Objects in the Dashboard Interface,Action Filters on Dashboards
- Creating a Advanced Dashboard
- Advanced Level Dashboard(Drill Down Dashboards),Designing of Basic Story Board
- Tableau Public Server
- Publishing Dashboards on Tableau Public Server,Exposure to the Websites Which Consists of Real Time Data,Interview Cracking Resources,Introduction to Tableau Certification
- "Introduction to R,Installation of Rstudio,Data Types in R
- Data types(Numeric,Char,Logical,Complex,Vector,List,Matrix,Factor,Array,Dataframe),Relational operators,Logical operators
- Decision making statements,Loops,Functions
- If,Ifelse,For loop,While loop,Repeat,Functions
- Built in Functions in R,Joins,dplyr and ggplot2
- Merging dataframes,Analyzing Iris Dataset using apply functions,dplyr package(Filter,Sel,Arrange),Data visualization using ggplot2,Scatterplot,Histogram,Boxplot
- Anaconda Installation,Introduction to python,Data types,Opearators
- Variables,data types(integer,Boolean,Float,List,tuple,string),Opearators in python
- Data types Contd,Slicing the data,Inbuilt functions in python
- Dictionaries,Sequence methods,Concatenate,Repetition,len,min,max functions,Index position,Addition and deletion of elements,Reverse,Sorting
- Sets,Set Theory,Regular Expressions,Decision making statements
- Sets,re module(findall,search,split,match),if,elifGetting input from user,Identity Operators
- Loops,Functions,Lambda functions,Modules
- For,While loops,Functions,Lambda functions,Math module,Calender module,Date & time module
- Pandas,Numpy,Matplotlib,Seaborn
- Data frame creation using different methods,Using Pandas anlysis on Universities,Salary data sets,Visualization using Matplotlib and Seaborn,Numpy introduction
- Power BI Introduction
- Introduction to Power BI Desktop
- Getting data (Excel and RDBMS, Web, SharePoint)
- Naming for Q&A
- Direct Query vs Import data
- Modelling with Power BI
- Introduction to Modelling
- Set up and Manager relationships
- Cardinality and cross filtering
- Creating hierarchy in the model
- Default summarization and sort by
- Creating calculated columns
- Creating measures and quick measures
- Power BI Desktop Visualizations
- Creating visuals
- Colour and conditional formatting
- Setting sort order
- Scatter and bubble charts and play axis
- Tool tips
- Slicers, timeline Slicers and sync Slicers
- Cross filtering and highlighting
- Visual, Page and Report level filters
- Drill down/up
- Hierarchies
- Constant Lines
- Tables, Matrix and Table conditional formatting
- KPI’s, Cards and Gauges
- Map Visualizations
- Custom visuals
- DAX Expressions
- Introduction to Dax (how to write Dax and basic functions in Power BI)
- Important Dax used in Power BI along with its applications
- Introduction to Dax (how to write Dax and basic functions in Power BI)
- how to create calculated columns and measures in Power BI and difference in its application
- Scenarios with Questions on Dax & explanation
- Creating date dimension in Power BI using calendar functions and its importance
- Publishing and Sharing
- Sharing options
- Publish from Power BI Desktop
- Publish reports to Web
- Sharing reports and Dashboards
- Workspaces
- Apps
- Printing, PDF’s and exports
- Row level Security
- Exporting data from Visualizations Refreshing Datasets
- Understanding data refresh
- Gateways
- Introduction to Agile
- Project Definition
- Difference Between Traditional & Agile Project Mgmt.
- Agile Manifesto and Principles
- Agile Methodology
- Agile Principles
- Agile Frameworks and Terminology
- Agile Methodologies
- Scrum
- XP
- Agile Analysis and Design
- Product Roadmap
- Product Backlog
- Story Maps
- Agile Modeling
- Wireframes
- Charting
- Personas
- Planning and Monitoring
- Iteration and Release Planning
- Progressive Elaboration
- Time Boxing
- Cumulative Flow Diagram
- Kanban Boards
- WIP Limits
- Burn Charts
- Retrospectives
- Innovation Games
- Agile Metrics and Estimations
- Relative Sizing
- Story Points
- Wideband Delphi Technique
- Planning Poker
- Affinity Diagram
- Ideal time
- Velocity
- Cycle Time
- EVM
- Escaped Defects
- Quality
- Frequent Verification and Validation
- Test Driven Development
- Definition of Done
- Continues Integration
- Feedback Techniques
- Incremental Delivery
- Continuous Improvement
- Value Based Prioritization
- Customer Valued Prioritization
- Compliance
- Relative Prioritization
- Value Stream Mapping
- Minimum Marketable Feature
- Risk Management
- Risk Adjusted backlog
- Risk Burn down charts
- Risk based spike
- Agile Communications
- Team Space
- Information Radiator
- Agile Tooling
- Daily Stand-ups
- Osmotic Communication
Contact Our Team of Experts
