Course Description
Data Analyst Course In Collaboration with IBM :
ExcelR and Tech Conglomerate IBM have collaborated to provide quality upskilling opportunities to students and tech professionals. The Data Analyst Course has been crafted to suit both, the market needs and for those who are interested in building their career in a tech domain that is not dominated by coding.
Get Certified through our world class Data Analyst Certification Course powered by IBM.
What does the course offer ?
The Data Analyst Course covers technologies like Excel, Advanced Excel, Tableau, SQL, Power BI, Basics of R & Python. Apart from the theory classes, there are hands-on assignments and projects that help you apply the concepts that are learnt by a student.
Road Map for Data 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
- 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
Contact Our Team of Experts
