+91 8130 80 2001

+91 9267 97 4043

Placement

Join Now

The next level of your career starts here.







Estimated Time
6 Months

Pre REQUISITES
Students, Fresher's
Working Professional

Training Mode
Offline, Online

Full Fees
₹ 25,000/-₹ 36,000/-
You Save - ₹ 11,000/-

What you will learn

Introduction to Data

Learn how to use statistics and visuals to find and communicate insights. Develop Excel skills to manipulate, analyze, and visualize data in a spreadsheet. Build Excel models to analyze possible business outcomes.

VBA Macros for Report Automation

Learn VBA Macros to automate Excel, dynamic templates, send emails, automate web browsers, PDF form filling and more.

SQL for Data Analysis

Learn to use Structured Query Language (SQL) to extract and analyze data stored in databases.

Power BI for Data Visualization

Learn to apply design and visualization principles to create impactful data visualizations, build data dashboards, and tell stories with data.

Curriculum

Our leading edge curriculum covers fundamentals and more complex data and analytics concepts.

Advanced Excel

The focus of this advanced excel course is to equip the participants with all the knowledge, understanding, and practice they need to use MS Excel easily, effectively, and efficiently. In this course, we cover the entire range of topics, from the very basics to the advanced topics.

  • Introduction to Advanced Excel
  • Understanding cell references and range name
  • Data Selection and various selection techniques
  • Separate Discussion on Shortcut keys
  • Data/Report Formatting and tips and tricks
  • Working with simple formula and functions
  • Copy and paste in detailed discussion
  • Number formatting and custom number formatting advanced
  • Row and column Insert/Delete tips and tricks
  • Protection Workbook, Worksheet and Range/Cell
  • Flash fill, Data Shorting, Data filter tips and tricks
  • Find, Replace and Goto Special tips and tricks
  • Understanding the concept of a formula
  • Understanding the Mathematical operators & Comparative operators
  • Mixed Reference Style (Row Freeze & Column Freeze)
  • Text Functions: Concatenate, Concat, Dollar, Fixed, Left, Mid, Right, Len, Lower, Upper, Proper, Replace, Rept, Find, Search, Substitute, Trim, Trunc, Convert. Char, Code, Clean, TextJoin, Value, Number Value,
  • Logical Functions: IF, IFS, AND, OR, XOR, SWITCH, NOT, IFNA and IFERROR
  • Date and Time Functions: Date, Datevalue, Day, Day360, Minutes, Hours, Now, Today, Month, Year, Yearfrac, Time, Timevalue, Weekday, Weeknum, Workday, Workday,Intl, Networkdays, Networkdays.intl, Datedif, Eomonth, Edate, Datedif. Isoweeknum,
  • Lookup and reference Functions: Vlookup, Hlookup, Lookup, Index, Offset, Choose, Match, Row, Rows, Column, Columns, Transpose, Indirect, Hyperlink, Address, Areas.
  • Math & Trig Functions: ABS, Aggregate, Power, Product, Rand, Randbetween, Round, Rounddown, Roundup, Subtotal, Sum, Sumif, Sumifs, Sumproduct, Ceiling, Ceiling.Math, Even, Odd, Fact, Floor, Gcd, Int, Lcm, Mod, Mround, Quotient, Roman, Sqrt,
  • Statistical Functions: Average, AverageA, Averageif, Averageifs, Count, CountA, Countblank, Countif, Countifs, Max, Maxa, Maxifs, Median, Min, Mina, Minifs, Mode, Rank, Small, Large.
  • Information Functions: Cell, Error.Type, Info, Isblank, Iserr, Iserror, Iseven, Isformula, Islogical, Isna, Isnontext, Isnumber, Isodd, Isref, Istext, N, Na,
  • Database: Daverage, Dcount, Dcounta, Dget, Dmax, Dmin, Dproduct, Dsum,
  • Financial Functions : Pmt, Ppmt, Pv, Rate, Nper, Ipmt, Fv, Cumprinc, Cumipmt.
  • Discussion of Errors and handling of multiple errors like. #DIV/0! , #N/A, # REF, #NAME, #VALUE, # NULL, #NUM and ########Error.
  • Use of Name Manager: Creating, Editing, and Deleting of Names.
  • Magic With Array Formulas
  • Writing of the Complex formulas for improvement in formulas writing skills
  • Interview Question and Answerer Session
  • Doubts Session
  • Start With Pivot Table, Do the Multiple Field Setting in Pivot Table.
  • Organizing and analysing large volumes of data
  • Creating Groups, Insert additional Calculated Field in Pivot Table.
  • Perform the % calculation on the basis of multiple fields
  • Insert slicer in Pivot Table and Pivot charts.
  • Dynamic Dashboard
  • Data Modelling and relationship
  • Working with multiple Data Source like PowerQuery, PowerPivot, SQL Server, Notepade.
  • Detailed discussion on graphically presentation of Data by using Charts.
  • Presentation with different kind to Basic charts like Column Charts, Line Charts, Pie Charts, Bar Charts, Scatter Charts
  • Preparation of Advanced Level of Charts: Gnatt Chart, Bubble Chart, Speedo Meter Chart. Pareto Chart, Waterfall Chart
  • Introduction to Multiple switches and buttons: Like Form Control, Combo Box, Check Box, Spin Box, List Box and Option Box.
  • Tips and Tricks to enhance dashboard designing
  • Working on Dynamic Charts in Excel
  • Use of Sparkline to your Sheet, Interactive Sparklines
  • What is Format as Table
  • Differences between normal range and FT
  • Structural references in FT and how this feature enable you to write effective formulas
  • Illustrations, Header and Footer, Hyperlink, Textbox, Symbol, WordArt, Object Etc.
  • Printer Properties and Page Setup (Page, Margin, Header/Footer and Sheet) for Printing.
  • Inserting, Deleting, Moving, and linking the data in between the multiple sheets.
  • What is Conditional formatting & how to change the existing formatting using this feature.
  • Quick format technique to highlight Duplicate/Unique values
  • We will discuss more than 25 real time examples of Conditional formatting
  • Writing Complex Conditional Formatting rules using formulas
  • Text to column
  • Remove Duplicates
  • Consolidate
  • Data Validation
  • Scenario Manager
  • Goal Seek
  • Data Table and Forecast Sheet
  • Group/Ungroup and Subtotal.
  • Daily/Weekly/Monthly and Yearly Sales MIS Report
  • Daily/Weekly/Monthly and Yearly Collection MIS Report
  • MIS Report for Monthly Meeting/Review

SQL Server

This course gives you all the information you need to successfully start working with SQL databases and make use of the database in your applications. Learn to correctly structure your database, author efficient SQL statements, and clauses, and manage your SQL database for scalable growth.

  • Write common SQL commands including SELECT, FROM, and WHERE
  • Use logical operators like LIKE, AND, and OR
  • Write JOINs in SQL to combine data from multiple sources to answer more complex business questions
  • Understand different types of JOINs and when to use each type
  • Write common aggregations in SQL including COUNT, SUM, MIN, and MAX
  • Write CASE and DATE functions, as well as work with NULLs
  • Write subqueries to run multiple queries together
  • Learn the types of subquery placement and formatting
  • Use temp tables to access a table with more than one query
  • Learn and apply the basics of data cleaning strategies in SQL to normalize or create a column from existing data
  • Perform the appropriate data cleaning methodology based on goals for further analysis
  • Apply core window functions to tackle analysis tasks that require further targeting or segmentation
  • Use other window functions including RANK, NTILE, LAG, LEAD new functions along with partitions to complete complex tasks
  • Learn how and when to use advanced joins (e.g., self joins) to write queries that run quickly across giant datasets
  • Learn the high-level tradeoffs with queries, including performance and what you can do to optimize them
  • Apply basic and advanced query techniques to compile strategic recommendations from a large dataset
  • Organize data in a format suitable for relational databases
  • Get a grasp on database normal forms
  • Write common SQL commands with CREATE TABLE and ALTER TABLE
  • Use different data types to model real-world situations
  • Write common SQL commands with INSERT, UPDATE, and DELETE
  • Use SQL functions to manipulate numbers, strings, and dates
  • Implement business rules at the database level using SQL commands with CONSTRAINT, UNIQUE, PRIMARY KEY, and CHECK
  • Formalize the relations between tables using SQL FOREIGN KEY and its variations
  • Fix some slow SQL queries by introducing database indexes with the SQL command CREATE INDEX
  • Introspect SQL queries through the query planner with EXPLAIN and EXPLAIN ANALYZE
  • Assess whether a use-case is a good candidate for indexing

Power BI

Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards.
Creating Reports
Visualization
Real-time insights
Dashboarding
Business intelligence workflow

  • Difference between Business Analyst & a data analyst
  • Business Understanding & Data Understanding
  • Data Analysis & Data Visualization
  • Data Cleaning & Preparation & methods used with some examples
  • Tools for Data Analysis & Visualization
  • Some charts & best practice related to them
  • Some data connectors in Power BI (Excel/txt,csv)
  • Basic elements of power BI their differences & use
  • Ways of PBI desktop App installation & system requirements
  • PBI desktop App interface Explanation
  • Modeling Basics
  • Creating Relationships
  • Normalization-Denormalization
  • Dimension & Fact Tables
  • Relationships (Autodetect, Manual & Autodetection settings)
  • Cardinality
  • Active & Inactive Relationships
  • Some Basic Data Cleaning Operations
  • Data Transformation
  • Merge & Append Queries
  • Interview Questions related to query Editor
  • DAX Basics
  • Row & Filter Context
  • Measures & Calculated Columns
  • Some DAX Functions
  • Various Types of Filters
  • Various Types of Visualizations & Formatting Options
  • Story telling & Dashboarding
  • SQL server
  • Odata feed
  • Blank Query
  • MS Access
  • Real Time Data Streaming
  • Web
  • Pdf
  • Folder
  • OLE DB

6 Months

Video Recording

Live Session with industry experts

100% Placement Assistance

Career Scope

  • MIS Executive
  • MIS Analyst
  • Data Analyst
  • Business Analyst
  • Sales Planning
  • Sales Analyst
  • Finance Analyst
  • Market Research Analyst
  • Sales/Project Coordinator
  • Operation Executive
  • Process Associate & Etc...

All Our Programs Include

Instructor-led

Live interactive and classroom training will include the practical approach and assessments on regular basis.

Live Case Study

Case study using industry specific data helps you to get hands on with a good exposure.

Lifetime Placement Assistance

Lifetime Placement Assistance

24 X 7 Support

We will support If any concern is raised related to the training, assignments, projects, case studies & interview questions.

Download Syllabus

The next level of your career starts here.







Learn free on the App
Download the lessons and learn anytime, anywhere from the free courses available on our app

Scan this QR code on your camera app to download the app

OR

Learn free on the App
Download the lessons and learn anytime, anywhere from the free courses available on our app

Scan this QR code on your camera app to download the app

OR