GUIDE ME

Become a skilled data analyst. Join now to learn from a competent industry practitioner.

4.9 out of 5 based on 13253 votes
google4.2/5
Sulekha4.8/5
Urbonpro4.6/5
Just Dial4.3/5
Fb4.5/5

Course Duration

32 Hrs.

Live Project

2 Project

Certification Pass

Guaranteed

Training Format

Live Online /Self-Paced/Classroom

Watch Live Classes

Data Analytics & BI

Speciality

prof trained

300+

Professionals Trained
batch image

4+

Batches every month
country image

20+

Countries & Counting
corporate

100+

Corporate Served

  • No matter if you are from an IT background or not, our Data Analytics Training Institute offers a holistic approach to provide its training participants. So, what are you waiting for Simply enrol for the best data Analytics certification course and become a certified professional like never before.
  • Looking for the best Data Analytics training institute that can impart at the right price If so, your search ends here! Croma Campus offers the best Data Analytics training course that is industriously designed by our team of experts to help you improve your skills and make you proficient so that you can deploy them in your workplace, confidently.
    • Enterprises are using data in their business processes to make the right decisions.

      We impart real-life case studies and hands-on practice to let you gain a proper understanding of the concepts.

      Our Data Analytics training program will help you to kick-start an incredible career journey.

      Get an immersive understanding of the relative domain.

      Avail of suitable learning materials and the knowledge that will enhance the necessary skills.

Data Analyst Certification Training

About-Us-Course

  • Once you have mastered the fundamentals of Data analysis, you’ll learn more advanced concepts of R studio, Tableau, Spotfire, statistics, etc.
  • Our data analytics certification course may help you with a robust foundation of data analysis concepts. Here are a few of the major objectives of this course:
    • We offer an optimal distribution of theoretical and practical knowledge.

      Sharpen your data analysis skills and various data analytics terminologies.

      Familiarize yourself with open-source data analytics tools i.e., R Studio or Spotfire, etc.

      Know how to extract meaningful insights from the preferred data such as hidden patterns, market trends unknown correlations, and customer preferences.

      Our Data analytic placement training makes you an expert in Data Analytic concepts, principles.

  • Data Analyticss are one of the most in-demand and highly-payed professionals across the world. However, the salary of a Data Analytics varies depending on various factors such as work experience, location, size of the organization, job role, etc.
    • An experienced data Analytics can earn up to $45,280 to $99,542.

      Even a professional at the beginner level may earn $40,585 to $78,832.

      It is one of the most in-demand and high-paid professionals across the globe.

      The salary will grow as you gain experience, knowledge, and job role.

      The average salary of a Data Analytics is more than $ 65,000 per year in the USA.

  • If you want to avail the benefits of a lucrative career, you need to enroll in one of the leading Data Analytics certification training online.
  • Data Analysis has become a part of every organization. However, the huge demand and therefore the salary of Data Analyticss is significantly higher. Some of the job titles after successfully completing the Data Analytics training are data engineer, data scientist, data architect, database administrator, data Analytics, etc.
    • Popular job titles include data engineer, data architect, data scientist, database administrator, etc.

      MNCs and corporate giants are hiring data Analytics professionals across the globe.

      Our Live session is empowered with delivering the recordings of the live class, study material, projects, etc.

      You will work with leading IT giants in the marketplace and at a higher salary package.

  • It wouldn’t be wrong to say that data is increasingly popular, so the demand for a data Analytics professional. Data Analytics plays a crucial role in helping business operations by making effective business decisions.
    • Most of Top MNCs are getting into data analytics.

      There’s a shortage of skilled experts across the globe.

      Professionals are likely to bag huge salary packages and even work abroad.

      The demand for skilled professional is likely to rise in the future.

      Students will learn how to analyse and manage the data that could benefit the organization.

  • Our Data Analytics training practical training sessions such as the projects, webinars, & assignments will make you industry-ready, allowing you to grab a high-paying job at a top-notch company.
  • After the completion of your data Analytics course, here are some of the major job roles and responsibilities that you must need to perform at work.
    • Apply for advanced level training such as advanced analytics, R studio, Tableau, Spotfire, statistics, and much more.

      Implement basic R programming, Tableau programming and familiarize yourself with open-source data analytics tools.

      A pro should know all Data Analytics concepts and related skills.

      You must know about various data analytics terminologies like acquisition, manipulation, evaluation, experimentation, etc.

  • Upon data Analytics online training course completion, you will be bestowed with a training certificate that will assure your potential employers trust your skillset and knowledge. So, it will be a wise decision on your part to enroll in our Data Analytics training in India and successfully complete the training.
    • Establish yourself as a certified data Analytics expert right away.

      Major companies include Google, Intuit, Cisco Systems, Facebook, Apple, Capital, Maruti, etc.

      We provide an interview training session regarding job interviews

      Get yourself ready to face any challenges that come your way.

  • Our Data Analytics training program includes comprehensive knowledge of all the related Data Analytics tools and techniques to cater to the specific needs of the learners.
    • Get noticed by the potential recruiters, and get hired right away.

      Our experts also support you by providing interview tips.

      Increase your worth in today’s competitive landscape.

      As it is accepted worldwide, you can work abroad.

      Get sufficient knowledge to clear any certification exam successfully.

Why Should You Learn Data Analyst Training?

Request more information

By registering here, I agree to Croma Campus Terms & Conditions and Privacy Policy

Plenary for Data Analyst Certification Training

TrackWeek DaysWeekendsFast Track
Course Duration 40-45 Days 7 Weekends 8 Days
Hours 1 Hrs. Per Day 2 Hrs. Per Day 6+ Hrs. Per Day
Training ModeClassroom/OnlineClassroom/OnlineClassroom/Online
Want To Know More About

This Course

Program fees are indicative only* Know more

Program Core Credentials

user

Trainer Profiles

Industry Experts

trainer

Trained Students

10000+

industry

Success Ratio

100%

Corporate Training

For India & Abroad

abrord

Job Assistance

100%

BATCH TIMINGS

Data Analyst Certification Training Upcoming Batches

WEEKDAY

05-Dec-2022*

Take class during weekdays and utilize your weekend for practice.

Get regular training by Industry Experts.

Get Proper guidance on certifications.

Register for FREE demo before signing up.

10% OFF

FASTRACK

03-Jan-2023*

Running lack of time? Join Fastrack classes to speed up your career growth.

Materials and guidance on certifications

Register for FREE demo before signing up.

WEEKDAY

07-Dec-2022*

Take class during weekdays and utilize your weekend for practice.

Get regular training by Industry Experts.

Get Proper guidance on certifications.

Register for FREE demo before signing up.

10% OFF

WEEKDAY

05-Jan-2023

Take class during weekdays and utilize your weekend for practice.

Get regular training by Industry Experts.

Get Proper guidance on certifications.

Register for FREE demo before signing up.

10% OFF

WEEKEND

03-Dec-2022

More Suitable for working professionals who cannot join in weekdays

Get Intensive coaching in less time

Get Proper guidance on certifications.

Register for FREE demo before signing up.

10% OFF

WEEKEND

10-Dec-2022*

More Suitable for working professionals who cannot join in weekdays

Get Intensive coaching in less time

Get Proper guidance on certifications.

Register for FREE demo before signing up.

10% OFF

Timings Doesn't Suit You ?

We can set up a batch at your convenient time.

Batch Request

FOR QUERIES, FEEDBACK OR ASSISTANCE

Contact Croma Campus Learner Support

Best of support with us

Phone (For Voice Call)

+919711526942

WhatsApp (For Call & Chat)

+91-8287060032

CURRICULUM & PROJECTS

Data Analyst Certification Training

  • With our AZ-900 “Microsoft Azure fundamentals” certification Training you will learn foundational knowledge of cloud services and how those services are provided with Microsoft Azure. The exam is intended for candidates who are just beginning to work with cloud-based solutions and services or are new to Azure.
  • Things you will learn:
    • Python Statistics for Data Science

      Data Analytics Overview

      Statistics Essentials For Analytics

      SQL For Data Analytics

      Analytics with Excel

      Analytics with Tableau

      Data Analytics with Power BI

Get full course syllabus in your inbox

  • Introduction To Python:
    • Installation and Working with Python

      Understanding Python variables

      Python basic Operators

      Understanding the Python blocks.

  • Introduction To Variables:
    • Variables, expression condition and function

      Global and Local Variables in Python

      Packing and Unpacking Arguments

      Type Casting in Python

      Byte objects vs. string in Python

      Variable Scope

  • Python Data Type:
    • Declaring and usingNumeric data types

      Using stringdata type and string operations

      Understanding Non-numeric data types

      Understanding the concept of Casting and Boolean.

      Strings

      List

      Tuples

      Dictionary

      Sets

  • Introduction Keywords and Identifiers and Operators
    • Python Keyword and Identifiers

      Python Comments, Multiline Comments.

      Python Indentation

      Understating the concepts of Operators

  • Data Structure
    • List

      • What is List.
        • List Creation
          • List Length
            • List Append
              • List Insert
                • List Remove
                  • List Append & Extend using “+” and Keyword
                    • List Delete
                      • List related Keyword in Python
                        • List Revers
                          • List Sorting
                            • List having Multiple Reference
                              • String Split to create a List
                                • List Indexing
                                  • List Slicing
                                    • List count and Looping
                                      • List Comprehension and Nested Comprehension
                                    • Sets, Tuples and Looping Programming
                                      • Sets

                                        • What is Set
                                          • Set Creation
                                            • Add element to a Set
                                              • Remove elements from a Set
                                                • PythonSet Operations
                                                  • Frozen Sets

                                                    Tuple

                                                    • What is Tuple
                                                      • Tuple Creation
                                                        • Accessing Elements in Tuple
                                                          • Changinga Tuple
                                                            • TupleDeletion
                                                              • Tuple Count
                                                                • Tuple Index
                                                                  • TupleMembership
                                                                    • TupleBuilt in Function (Length, Sort)

                                                                      Control Flow

                                                                      • Loops
                                                                        • Loops and Control Statements (Continue, Break and Pass).
                                                                          • Looping techniques in Python
                                                                            • How to use Range function in Loop
                                                                              • Programs for printing Patterns in Python
                                                                                • How to use if and else with Loop
                                                                                  • Use of Switch Function in Loop
                                                                                    • Elegant way of Python Iteration
                                                                                      • Generator in Python
                                                                                        • How to use nested IF and Else in Python
                                                                                          • How to use nested Loop in Python
                                                                                            • Use If and Else in for and While Loop
                                                                                              • Examples of Looping with Break and Continue Statements
                                                                                                • How to use IN or NOTkeywordin Python Loop.
                                                                                              • Exception and File Handling, Module, Function and Packages
                                                                                                • Python Exception Handling

                                                                                                  • Python Errors and Built-in-Exceptions
                                                                                                    • Exception handing Try, Except and Finally
                                                                                                      • Catching Exceptions in Python
                                                                                                        • Catching Specific Exception in Python
                                                                                                          • Raising Exception
                                                                                                            • Try and Finally

                                                                                                              Python File Handling

                                                                                                              • Opening a File
                                                                                                                • Python File Modes
                                                                                                                  • Closing File
                                                                                                                    • Writing to a File
                                                                                                                      • Reading from a File
                                                                                                                        • Renaming and Deleting Files in Python
                                                                                                                          • Python Directory and File Management
                                                                                                                            • List Directories and Files
                                                                                                                              • Making New Directory
                                                                                                                                • Changing Directory

                                                                                                                                  Python Function, Modules and Packages

                                                                                                                                  • Python Syntax
                                                                                                                                    • Function Call
                                                                                                                                      • Return Statement
                                                                                                                                        • Write an Empty Function in Python –pass statement.
                                                                                                                                          • Lamda/ Anonymous Function
                                                                                                                                            • *argsand **kwargs
                                                                                                                                              • Help function in Python
                                                                                                                                                • Scope and Life Time of Variable in Python Function
                                                                                                                                                  • Nested Loop in Python Function
                                                                                                                                                    • Recursive Function and Its Advantage and Disadvantage
                                                                                                                                                      • Organizing python codes using functions
                                                                                                                                                        • Organizing python projects into modules
                                                                                                                                                          • Importing own module as well as external modules
                                                                                                                                                            • Understanding Packages
                                                                                                                                                              • Programming using functions, modules & external packages
                                                                                                                                                                • Map, Filter and Reduce function with Lambda Function
                                                                                                                                                                  • More example of Python Function
                                                                                                                                                                • Data Automation (Excel, SQL, PDF etc)
                                                                                                                                                                  • Python Object Oriented Programming—Oops

                                                                                                                                                                    • Concept of Class, Object and Instances
                                                                                                                                                                      • Constructor, Class attributes and Destructors
                                                                                                                                                                        • Real time use of class in live projects
                                                                                                                                                                          • Inheritance, Overlapping and Overloading operators
                                                                                                                                                                            • Adding and retrieving dynamic attributes of classes
                                                                                                                                                                              • Programming using Oops support

                                                                                                                                                                                Python Database Interaction

                                                                                                                                                                                • SQL Database connection using
                                                                                                                                                                                  • Creating and searching tables
                                                                                                                                                                                    • Reading and Storing configinformation on database
                                                                                                                                                                                      • Programming using database connections

                                                                                                                                                                                        Reading an excel

                                                                                                                                                                                        • Reading an excel file usingPython
                                                                                                                                                                                          • Writing toan excel sheet using Python
                                                                                                                                                                                            • Python| Reading an excel file
                                                                                                                                                                                              • Python | Writing an excel file
                                                                                                                                                                                                • Adjusting Rows and Column using Python
                                                                                                                                                                                                  • ArithmeticOperation in Excel file.
                                                                                                                                                                                                    • Plotting Pie Charts
                                                                                                                                                                                                      • Plotting Area Charts
                                                                                                                                                                                                        • Plotting Bar or Column Charts using Python.
                                                                                                                                                                                                          • Plotting Doughnut Chartslusing Python.
                                                                                                                                                                                                            • Consolidationof Excel File using Python
                                                                                                                                                                                                              • Split of Excel File Using Python.
                                                                                                                                                                                                                • Play with Workbook, Sheets and Cells in Excel using Python
                                                                                                                                                                                                                  • Creating and Removing Sheets
                                                                                                                                                                                                                    • Formatting the Excel File Data
                                                                                                                                                                                                                      • More example of Python Function

                                                                                                                                                                                                                        Working with PDF and MS Word using Python

                                                                                                                                                                                                                        • Extracting Text from PDFs
                                                                                                                                                                                                                          • Creating PDFs
                                                                                                                                                                                                                            • Copy Pages
                                                                                                                                                                                                                              • Split PDF
                                                                                                                                                                                                                                • Combining pages from many PDFs
                                                                                                                                                                                                                                  • Rotating PDF’s Pages

                                                                                                                                                                                                                                    Complete Understanding of OS Module of Python

                                                                                                                                                                                                                                    • Check Dirs. (exist or not)
                                                                                                                                                                                                                                      • How to split path and extension
                                                                                                                                                                                                                                        • How to get user profile detail
                                                                                                                                                                                                                                          • Get the path of Desktop, Documents, Downloads etc.
                                                                                                                                                                                                                                            • Handle the File System Organization using OS
                                                                                                                                                                                                                                              • How to get any files and folder’s details using OS
                                                                                                                                                                                                                                            • Data Analysis & Visualization
                                                                                                                                                                                                                                              • Pandas

                                                                                                                                                                                                                                                • Read data from Excel File using Pandas More Plotting, Date Time Indexing and writing to files
                                                                                                                                                                                                                                                  • How to get record specific records Using Pandas Adding & Resetting Columns, Mapping with function
                                                                                                                                                                                                                                                    • Using the Excel File class to read multiple sheets More Mapping, Filling Nonvalue’s
                                                                                                                                                                                                                                                      • Exploring the Data Plotting, Correlations, and Histograms
                                                                                                                                                                                                                                                        • Getting statistical information about the data Analysis Concepts, Handle the None Values
                                                                                                                                                                                                                                                          • Reading files with no header and skipping records Cumulative Sums and Value Counts, Ranking etc
                                                                                                                                                                                                                                                            • Reading a subset of columns Data Maintenance, Adding/Removing Cols and Rows
                                                                                                                                                                                                                                                              • Applying formulas on the columns Basic Grouping, Concepts of Aggregate Function
                                                                                                                                                                                                                                                                • Complete Understanding of Pivot Table Data Slicing using iLocand Locproperty (Setting Indices)
                                                                                                                                                                                                                                                                  • Under sting the Properties of Pivot Table in Pandas Advanced Reading CSVs/HTML, Binning, Categorical Data
                                                                                                                                                                                                                                                                    • Exporting the results to Excel Joins:
                                                                                                                                                                                                                                                                      • Python | Pandas Data Frame Inner Join
                                                                                                                                                                                                                                                                        • Under sting the properties of Data Frame Left Join (Left Outer Join)
                                                                                                                                                                                                                                                                          • Indexing and Selecting Data with Pandas Right Join (Right Outer Join)
                                                                                                                                                                                                                                                                            • Pandas | Merging, Joining and Concatenating Full Join (Full Outer Join)
                                                                                                                                                                                                                                                                              • Pandas | Find Missing Data and Fill and Drop NA Appending DataFrameand Data
                                                                                                                                                                                                                                                                                • Pandas | How to Group Data How to apply Lambda / Function on Data Frame
                                                                                                                                                                                                                                                                                  • Other Very Useful concepts of Pandas in Python Data Time Property in Pandas (More and More)

                                                                                                                                                                                                                                                                                    NumPy

                                                                                                                                                                                                                                                                                    • Introduction to NumPy: Numerical Python
                                                                                                                                                                                                                                                                                      • Importing NumPy and Its Properties
                                                                                                                                                                                                                                                                                        • NumPy Arrays
                                                                                                                                                                                                                                                                                          • Creating an Array from a CSV
                                                                                                                                                                                                                                                                                            • Operations an Array from aCSV
                                                                                                                                                                                                                                                                                              • Operations with NumPy Arrays
                                                                                                                                                                                                                                                                                                • Two-Dimensional Array
                                                                                                                                                                                                                                                                                                  • Selecting Elements from 1-D Array
                                                                                                                                                                                                                                                                                                    • Selecting Elements from 2-D Array
                                                                                                                                                                                                                                                                                                      • Logical Operation with Arrays
                                                                                                                                                                                                                                                                                                        • Indexing NumPy elements using conditionals
                                                                                                                                                                                                                                                                                                          • NumPy’sMean and Axis
                                                                                                                                                                                                                                                                                                            • NumPy’sMode, Median and Sum Function
                                                                                                                                                                                                                                                                                                              • NumPy’sSort Function and More

                                                                                                                                                                                                                                                                                                                MatPlotLib

                                                                                                                                                                                                                                                                                                                • Bar Chart using Python MatPlotLib
                                                                                                                                                                                                                                                                                                                  • Column Chart using Python MatPlotLib
                                                                                                                                                                                                                                                                                                                    • Pie Chart using Python MatPlotLib
                                                                                                                                                                                                                                                                                                                      • Area Chart using Python MatPlotLib
                                                                                                                                                                                                                                                                                                                        • Scatter Plot Chart using Python MatPlotLib
                                                                                                                                                                                                                                                                                                                          • Play with Charts Properties Using MatPlotLib
                                                                                                                                                                                                                                                                                                                            • Export the Chart as Image
                                                                                                                                                                                                                                                                                                                              • Understanding plt. subplots () notation
                                                                                                                                                                                                                                                                                                                                • Legend Alignment of Chart using MatPlotLib
                                                                                                                                                                                                                                                                                                                                  • Create Charts as Image
                                                                                                                                                                                                                                                                                                                                    • Other Useful Properties of Charts.
                                                                                                                                                                                                                                                                                                                                      • Complete Understanding of Histograms
                                                                                                                                                                                                                                                                                                                                        • Plotting Different Charts, Labels, and Labels Alignment etc.

                                                                                                                                                                                                                                                                                                                                          Introduction to Seaborn

                                                                                                                                                                                                                                                                                                                                          • Introduction to Seaborn
                                                                                                                                                                                                                                                                                                                                            • Making a scatter plot with lists
                                                                                                                                                                                                                                                                                                                                              • Making a count plot with a list
                                                                                                                                                                                                                                                                                                                                                • Using Pandas with seaborn
                                                                                                                                                                                                                                                                                                                                                  • Tidy vs Untidy data
                                                                                                                                                                                                                                                                                                                                                    • Making a count plot with a Dataframe
                                                                                                                                                                                                                                                                                                                                                      • Adding a third variable with hue
                                                                                                                                                                                                                                                                                                                                                        • Hue and scattera plots
                                                                                                                                                                                                                                                                                                                                                          • Hue and count plots

                                                                                                                                                                                                                                                                                                                                                            Visualizing Two Quantitative Variables

                                                                                                                                                                                                                                                                                                                                                            • Introduction to relational plots and subplots
                                                                                                                                                                                                                                                                                                                                                              • Creating subplots with col and row
                                                                                                                                                                                                                                                                                                                                                                • Customizing scatters plots
                                                                                                                                                                                                                                                                                                                                                                  • Changing the size of scatter plot points
                                                                                                                                                                                                                                                                                                                                                                    • Changing the style of scatter plot points
                                                                                                                                                                                                                                                                                                                                                                      • Introduction to line plots
                                                                                                                                                                                                                                                                                                                                                                        • Interpreting line plots
                                                                                                                                                                                                                                                                                                                                                                          • Visualizing standard deviation with line plots
                                                                                                                                                                                                                                                                                                                                                                            • Plotting subgroups in line plots

                                                                                                                                                                                                                                                                                                                                                                              Visualizing a Categorical and a Quantitative Variable

                                                                                                                                                                                                                                                                                                                                                                              • Current plots and bar plots
                                                                                                                                                                                                                                                                                                                                                                                • Count plots
                                                                                                                                                                                                                                                                                                                                                                                  • Bar plot with percentages
                                                                                                                                                                                                                                                                                                                                                                                    • Customizing bar plots
                                                                                                                                                                                                                                                                                                                                                                                      • Box plots
                                                                                                                                                                                                                                                                                                                                                                                        • Create and interpret a box plot
                                                                                                                                                                                                                                                                                                                                                                                          • Omitting outliers
                                                                                                                                                                                                                                                                                                                                                                                            • Adjusting the whiskers
                                                                                                                                                                                                                                                                                                                                                                                              • Point plots
                                                                                                                                                                                                                                                                                                                                                                                                • Customizing points plots
                                                                                                                                                                                                                                                                                                                                                                                                  • Point plot with subgroups

                                                                                                                                                                                                                                                                                                                                                                                                    Customizing Seaborn Plots

                                                                                                                                                                                                                                                                                                                                                                                                    • Changing plot style and colour
                                                                                                                                                                                                                                                                                                                                                                                                      • Changing style and palette
                                                                                                                                                                                                                                                                                                                                                                                                        • Changing the scale
                                                                                                                                                                                                                                                                                                                                                                                                          • Using a custom palette
                                                                                                                                                                                                                                                                                                                                                                                                            • Adding titles and labels: Part 1
                                                                                                                                                                                                                                                                                                                                                                                                              • Face Grids vs. Axes Subplots
                                                                                                                                                                                                                                                                                                                                                                                                                • Adding a title to a face Grid object
                                                                                                                                                                                                                                                                                                                                                                                                                  • Adding title and labels: Part 2
                                                                                                                                                                                                                                                                                                                                                                                                                    • Adding a title and axis labels
                                                                                                                                                                                                                                                                                                                                                                                                                      • Rotating x-tics labels
                                                                                                                                                                                                                                                                                                                                                                                                                        • Putting it all together
                                                                                                                                                                                                                                                                                                                                                                                                                          • Box plot with subgroups
                                                                                                                                                                                                                                                                                                                                                                                                                            • Bar plot with subgroups and subplots
                                                                                                                                                                                                                                                                                                                                                                                                                          Get full course syllabus in your inbox

                                                                                                                                                                                                                                                                                                                                                                                                                          • Introduction to Data Analytics Overview
                                                                                                                                                                                                                                                                                                                                                                                                                            • Dealing with Different Types of Data

                                                                                                                                                                                                                                                                                                                                                                                                                              Data Visualization for Decision making

                                                                                                                                                                                                                                                                                                                                                                                                                              Data Science, Data Analytics, and Machine Learning

                                                                                                                                                                                                                                                                                                                                                                                                                              Data Science Methodology

                                                                                                                                                                                                                                                                                                                                                                                                                              Data Analytics in Different Sectors

                                                                                                                                                                                                                                                                                                                                                                                                                              Analytics Framework and Latest trends

                                                                                                                                                                                                                                                                                                                                                                                                                          Get full course syllabus in your inbox

                                                                                                                                                                                                                                                                                                                                                                                                                          • Introduction to Statistics for Analytics
                                                                                                                                                                                                                                                                                                                                                                                                                            • Sample or Population Data

                                                                                                                                                                                                                                                                                                                                                                                                                              The Fundamentals of Descriptive Statistics

                                                                                                                                                                                                                                                                                                                                                                                                                              Measures of Central Tendency, Asymmetry, and Variability

                                                                                                                                                                                                                                                                                                                                                                                                                              Practical Example: Descriptive Statistics

                                                                                                                                                                                                                                                                                                                                                                                                                          • Distributions
                                                                                                                                                                                                                                                                                                                                                                                                                            • Estimators and Estimates

                                                                                                                                                                                                                                                                                                                                                                                                                              Confidence Intervals: Advanced Topics

                                                                                                                                                                                                                                                                                                                                                                                                                              Practical Example: Inferential Statistics

                                                                                                                                                                                                                                                                                                                                                                                                                          • Hypothesis Testing
                                                                                                                                                                                                                                                                                                                                                                                                                            • Introduction

                                                                                                                                                                                                                                                                                                                                                                                                                              Hypothesis Testing: Let’s Start Testing!

                                                                                                                                                                                                                                                                                                                                                                                                                              Practical Example: Hypothesis Testing

                                                                                                                                                                                                                                                                                                                                                                                                                          • The Fundamentals of Regression Analysis
                                                                                                                                                                                                                                                                                                                                                                                                                            • Subtleties of Regression Analysis

                                                                                                                                                                                                                                                                                                                                                                                                                              Assumptions for Linear Regression Analysis

                                                                                                                                                                                                                                                                                                                                                                                                                              Dealing with Categorical Data

                                                                                                                                                                                                                                                                                                                                                                                                                              Practical Example: Regression Analysis

                                                                                                                                                                                                                                                                                                                                                                                                                          Get full course syllabus in your inbox

                                                                                                                                                                                                                                                                                                                                                                                                                          • Introduction
                                                                                                                                                                                                                                                                                                                                                                                                                            • Overview of Oracle Database 11g and related products

                                                                                                                                                                                                                                                                                                                                                                                                                              Overview of relational database management concepts and terminologies

                                                                                                                                                                                                                                                                                                                                                                                                                              Introduction to SQL and its development environments

                                                                                                                                                                                                                                                                                                                                                                                                                              The HR schema and the tables used in this course

                                                                                                                                                                                                                                                                                                                                                                                                                              Oracle Database documentation and additional resources

                                                                                                                                                                                                                                                                                                                                                                                                                          • Retrieve Data using the SQL SELECT Statement
                                                                                                                                                                                                                                                                                                                                                                                                                            • List the capabilities of SQL SELECT statements

                                                                                                                                                                                                                                                                                                                                                                                                                              Generate a report of data from the output of a basic SELECT statement

                                                                                                                                                                                                                                                                                                                                                                                                                              Use arithmetic expressions and NULL values in the SELECT statement

                                                                                                                                                                                                                                                                                                                                                                                                                              Invoke Column aliases

                                                                                                                                                                                                                                                                                                                                                                                                                              Concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword

                                                                                                                                                                                                                                                                                                                                                                                                                              Display the table structure using the DESCRIBE command

                                                                                                                                                                                                                                                                                                                                                                                                                          • Usage of Single-Row Functions to Customize Output
                                                                                                                                                                                                                                                                                                                                                                                                                            • List the differences between single row and multiple row functions

                                                                                                                                                                                                                                                                                                                                                                                                                              Manipulate strings using character functions

                                                                                                                                                                                                                                                                                                                                                                                                                              Manipulate numbers with the ROUND, TRUNC, and MOD functions

                                                                                                                                                                                                                                                                                                                                                                                                                              Perform arithmetic with date data

                                                                                                                                                                                                                                                                                                                                                                                                                              Manipulate dates with the DATE functions

                                                                                                                                                                                                                                                                                                                                                                                                                          • Conversion Functions and Conditional Expressions
                                                                                                                                                                                                                                                                                                                                                                                                                            • Describe implicit and explicit data type conversion

                                                                                                                                                                                                                                                                                                                                                                                                                              Describe the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions

                                                                                                                                                                                                                                                                                                                                                                                                                              Nesting multiple functions

                                                                                                                                                                                                                                                                                                                                                                                                                              Apply the NVL, NULLIF, and COALESCE functions to data

                                                                                                                                                                                                                                                                                                                                                                                                                              Usage of conditional IF THEN ELSE logic in a SELECT statement

                                                                                                                                                                                                                                                                                                                                                                                                                          • Aggregated Data Using the Group Functions
                                                                                                                                                                                                                                                                                                                                                                                                                            • Usage of the aggregation functions in SELECT statements to produce meaningful reports

                                                                                                                                                                                                                                                                                                                                                                                                                              Describe the AVG, SUM, MIN, and MAX function

                                                                                                                                                                                                                                                                                                                                                                                                                              How to handle Null Values in a group function

                                                                                                                                                                                                                                                                                                                                                                                                                              Divide the data in groups by using the GROUP BY clause

                                                                                                                                                                                                                                                                                                                                                                                                                              Exclude groups of date by using the HAVING clause

                                                                                                                                                                                                                                                                                                                                                                                                                          • Display Data from Multiple Tables
                                                                                                                                                                                                                                                                                                                                                                                                                            • Write SELECT statements to access data from more than one table

                                                                                                                                                                                                                                                                                                                                                                                                                              Join Tables Using SQL:1999 Syntax

                                                                                                                                                                                                                                                                                                                                                                                                                              View data that does not meet a join condition by using outer joins

                                                                                                                                                                                                                                                                                                                                                                                                                              Join a table to itself by using a self join

                                                                                                                                                                                                                                                                                                                                                                                                                              Create Cross Joins

                                                                                                                                                                                                                                                                                                                                                                                                                          • Usage of Sub-queries to Solve Queries
                                                                                                                                                                                                                                                                                                                                                                                                                            • Use a Sub-query to Solve a Problem

                                                                                                                                                                                                                                                                                                                                                                                                                              Single-Row Sub-queries

                                                                                                                                                                                                                                                                                                                                                                                                                              Group Functions in a Sub-query

                                                                                                                                                                                                                                                                                                                                                                                                                              Multiple-Row Sub-queries

                                                                                                                                                                                                                                                                                                                                                                                                                              Use the ANY and ALL Operator in Multiple-Row Sub-queries

                                                                                                                                                                                                                                                                                                                                                                                                                              Use the EXISTS Operator

                                                                                                                                                                                                                                                                                                                                                                                                                          • SET Operators
                                                                                                                                                                                                                                                                                                                                                                                                                            • Describe the SET operators

                                                                                                                                                                                                                                                                                                                                                                                                                              Use a SET operator to combine multiple queries into a single query

                                                                                                                                                                                                                                                                                                                                                                                                                              Describe the UNION, UNION ALL, INTERSECT, and MINUS Operators

                                                                                                                                                                                                                                                                                                                                                                                                                              Use the ORDER BY Clause in Set Operations

                                                                                                                                                                                                                                                                                                                                                                                                                          • Data Manipulation
                                                                                                                                                                                                                                                                                                                                                                                                                            • Add New Rows to a Table

                                                                                                                                                                                                                                                                                                                                                                                                                              Change the Data in a Table

                                                                                                                                                                                                                                                                                                                                                                                                                              Use the DELETE and TRUNCATE Statements

                                                                                                                                                                                                                                                                                                                                                                                                                              How to save and discard changes with the COMMIT and ROLLBACK statements

                                                                                                                                                                                                                                                                                                                                                                                                                              Implement Read Consistency

                                                                                                                                                                                                                                                                                                                                                                                                                              Describe the FOR UPDATE Clause

                                                                                                                                                                                                                                                                                                                                                                                                                          Get full course syllabus in your inbox

                                                                                                                                                                                                                                                                                                                                                                                                                          • Ms Excel Basic
                                                                                                                                                                                                                                                                                                                                                                                                                            • Creation of Excel Sheet Data

                                                                                                                                                                                                                                                                                                                                                                                                                              Range Name, Format Painter

                                                                                                                                                                                                                                                                                                                                                                                                                              Conditional Formatting, Wrap Text, Merge & Centre

                                                                                                                                                                                                                                                                                                                                                                                                                              Sort, Filter, Advance Filter

                                                                                                                                                                                                                                                                                                                                                                                                                              Different type of Chart Creations

                                                                                                                                                                                                                                                                                                                                                                                                                              Auditing, (Trace Precedents, Trace Dependents)Print Area

                                                                                                                                                                                                                                                                                                                                                                                                                              Data Validations, Consolidate, Subtotal

                                                                                                                                                                                                                                                                                                                                                                                                                              What if Analysis (Data Table, Goal Seek, Scenario)

                                                                                                                                                                                                                                                                                                                                                                                                                              Solver, Freeze Panes

                                                                                                                                                                                                                                                                                                                                                                                                                              Various Simple Functions in Excel(Sum, Average, Max, Min)

                                                                                                                                                                                                                                                                                                                                                                                                                              Real Life Assignment work

                                                                                                                                                                                                                                                                                                                                                                                                                          • Ms Excel Advance
                                                                                                                                                                                                                                                                                                                                                                                                                            • Advance Data Sorting

                                                                                                                                                                                                                                                                                                                                                                                                                              Multi-level sorting

                                                                                                                                                                                                                                                                                                                                                                                                                              Restoring data to original order after performing sorting

                                                                                                                                                                                                                                                                                                                                                                                                                              Sort by icons

                                                                                                                                                                                                                                                                                                                                                                                                                              Sort by colours

                                                                                                                                                                                                                                                                                                                                                                                                                              Lookup Functions

                                                                                                                                                                                                                                                                                                                                                                                                                              • Lookup
                                                                                                                                                                                                                                                                                                                                                                                                                              • VLookup
                                                                                                                                                                                                                                                                                                                                                                                                                              • HLookup

                                                                                                                                                                                                                                                                                                                                                                                                                              Subtotal, Multi-Level Subtotal

                                                                                                                                                                                                                                                                                                                                                                                                                              Grouping Features

                                                                                                                                                                                                                                                                                                                                                                                                                              • Column Wise
                                                                                                                                                                                                                                                                                                                                                                                                                              • Row Wise

                                                                                                                                                                                                                                                                                                                                                                                                                              Consolidation With Several Worksheets

                                                                                                                                                                                                                                                                                                                                                                                                                              Filter

                                                                                                                                                                                                                                                                                                                                                                                                                              • Auto Filter
                                                                                                                                                                                                                                                                                                                                                                                                                              • Advance Filter

                                                                                                                                                                                                                                                                                                                                                                                                                              Printing of Raw & Column Heading on Each Page

                                                                                                                                                                                                                                                                                                                                                                                                                              Workbook Protection and Worksheet Protection

                                                                                                                                                                                                                                                                                                                                                                                                                              Specified Range Protection in Worksheet

                                                                                                                                                                                                                                                                                                                                                                                                                              Excel Data Analysis

                                                                                                                                                                                                                                                                                                                                                                                                                              • Goal Seek
                                                                                                                                                                                                                                                                                                                                                                                                                              • Scenario Manager

                                                                                                                                                                                                                                                                                                                                                                                                                              Data Table

                                                                                                                                                                                                                                                                                                                                                                                                                              • Advance use of Data Tables in Excel
                                                                                                                                                                                                                                                                                                                                                                                                                              • Reporting and Information Representation

                                                                                                                                                                                                                                                                                                                                                                                                                              Pivot Table

                                                                                                                                                                                                                                                                                                                                                                                                                              • Pivot Chat
                                                                                                                                                                                                                                                                                                                                                                                                                              • Slicer with Pivot Table & Chart

                                                                                                                                                                                                                                                                                                                                                                                                                              Generating MIS Report In Excel

                                                                                                                                                                                                                                                                                                                                                                                                                              • Advance Functions of Excel
                                                                                                                                                                                                                                                                                                                                                                                                                              • Math & Trig Functions

                                                                                                                                                                                                                                                                                                                                                                                                                              Text Functions

                                                                                                                                                                                                                                                                                                                                                                                                                              Lookup & Reference Function

                                                                                                                                                                                                                                                                                                                                                                                                                              Logical Functions & Date and Time Functions

                                                                                                                                                                                                                                                                                                                                                                                                                              Database Functions

                                                                                                                                                                                                                                                                                                                                                                                                                              Statistical Functions

                                                                                                                                                                                                                                                                                                                                                                                                                              Financial Functions

                                                                                                                                                                                                                                                                                                                                                                                                                              Functions for Calculation Depreciation

                                                                                                                                                                                                                                                                                                                                                                                                                          • MIS Reporting & Dash Board
                                                                                                                                                                                                                                                                                                                                                                                                                            • Dashboard Background

                                                                                                                                                                                                                                                                                                                                                                                                                              Dashboard Elements

                                                                                                                                                                                                                                                                                                                                                                                                                              Interactive Dashboards

                                                                                                                                                                                                                                                                                                                                                                                                                              Type of Reporting In India

                                                                                                                                                                                                                                                                                                                                                                                                                              • Reporting Analyst
                                                                                                                                                                                                                                                                                                                                                                                                                              • Indian Print Media Reporting

                                                                                                                                                                                                                                                                                                                                                                                                                              Audit Report

                                                                                                                                                                                                                                                                                                                                                                                                                              Accounting MIS Reports

                                                                                                                                                                                                                                                                                                                                                                                                                              HR Mis Reports

                                                                                                                                                                                                                                                                                                                                                                                                                              MIS Report Preparation Supplier, Exporter

                                                                                                                                                                                                                                                                                                                                                                                                                              Data Analysis

                                                                                                                                                                                                                                                                                                                                                                                                                              • Costing Budgeting Mis Reporting
                                                                                                                                                                                                                                                                                                                                                                                                                              • MIS Report For Manufacturing Company
                                                                                                                                                                                                                                                                                                                                                                                                                              • MIS Reporting For Store And Billing

                                                                                                                                                                                                                                                                                                                                                                                                                              Product Performance Report

                                                                                                                                                                                                                                                                                                                                                                                                                              Member Performance Report

                                                                                                                                                                                                                                                                                                                                                                                                                              Customer-Wise Sales Report

                                                                                                                                                                                                                                                                                                                                                                                                                              Collections Report

                                                                                                                                                                                                                                                                                                                                                                                                                              Channel Stock Report

                                                                                                                                                                                                                                                                                                                                                                                                                              Prospect Analysis Report

                                                                                                                                                                                                                                                                                                                                                                                                                              Calling Reports

                                                                                                                                                                                                                                                                                                                                                                                                                              Expenses Report

                                                                                                                                                                                                                                                                                                                                                                                                                              Stock Controller MIS Reporting

                                                                                                                                                                                                                                                                                                                                                                                                                              Inventory Statement

                                                                                                                                                                                                                                                                                                                                                                                                                              Payroll Report

                                                                                                                                                                                                                                                                                                                                                                                                                              Salary Slip

                                                                                                                                                                                                                                                                                                                                                                                                                              Loan Assumption Sheet

                                                                                                                                                                                                                                                                                                                                                                                                                              Invoice Creation

                                                                                                                                                                                                                                                                                                                                                                                                                          Get full course syllabus in your inbox

                                                                                                                                                                                                                                                                                                                                                                                                                          • Introduction to Tableau2018
                                                                                                                                                                                                                                                                                                                                                                                                                            • What is Tableau

                                                                                                                                                                                                                                                                                                                                                                                                                              Features of Tableau

                                                                                                                                                                                                                                                                                                                                                                                                                              Top Chart Types in Tableau

                                                                                                                                                                                                                                                                                                                                                                                                                              Introduction to the various File Types

                                                                                                                                                                                                                                                                                                                                                                                                                              Quick Introduction to the User Interface in Tableau

                                                                                                                                                                                                                                                                                                                                                                                                                              How to Create Data Visualization Using Tableau feature “Show Me”

                                                                                                                                                                                                                                                                                                                                                                                                                              Reorder & Remove Visualization Fields

                                                                                                                                                                                                                                                                                                                                                                                                                              How to Sort & Filter Data

                                                                                                                                                                                                                                                                                                                                                                                                                              How to Create a Calculated Field

                                                                                                                                                                                                                                                                                                                                                                                                                              How to Perform Operations using Cross-Tab

                                                                                                                                                                                                                                                                                                                                                                                                                              Working with Workbook Data & Worksheets

                                                                                                                                                                                                                                                                                                                                                                                                                              How to Create a Packaged Workbook

                                                                                                                                                                                                                                                                                                                                                                                                                          • Tableau Architecture & User Interface
                                                                                                                                                                                                                                                                                                                                                                                                                            • Architecture of Tableau

                                                                                                                                                                                                                                                                                                                                                                                                                              Installation of Tableau Desktop

                                                                                                                                                                                                                                                                                                                                                                                                                              The interface of Tableau (Layout, Toolbars, Data Pane, Analytics Pane etc.)

                                                                                                                                                                                                                                                                                                                                                                                                                              How to Start with Tableau

                                                                                                                                                                                                                                                                                                                                                                                                                          • Data Preparation
                                                                                                                                                                                                                                                                                                                                                                                                                            • Connecting to Different Data Sources

                                                                                                                                                                                                                                                                                                                                                                                                                              Excel

                                                                                                                                                                                                                                                                                                                                                                                                                              CSV

                                                                                                                                                                                                                                                                                                                                                                                                                              Microsoft Access

                                                                                                                                                                                                                                                                                                                                                                                                                              SQL server

                                                                                                                                                                                                                                                                                                                                                                                                                              Google Sheets

                                                                                                                                                                                                                                                                                                                                                                                                                              Live vs. Extract Connection

                                                                                                                                                                                                                                                                                                                                                                                                                              Creating Extract

                                                                                                                                                                                                                                                                                                                                                                                                                              Refreshing Extract

                                                                                                                                                                                                                                                                                                                                                                                                                              Incremental Extract

                                                                                                                                                                                                                                                                                                                                                                                                                              Refreshing Live

                                                                                                                                                                                                                                                                                                                                                                                                                              Data Source Editor

                                                                                                                                                                                                                                                                                                                                                                                                                              Managing Metadata and Extracts

                                                                                                                                                                                                                                                                                                                                                                                                                              Pivoting & Splitting

                                                                                                                                                                                                                                                                                                                                                                                                                              Data Interpreter : Clean dirty data

                                                                                                                                                                                                                                                                                                                                                                                                                              TWB vs. TWBX

                                                                                                                                                                                                                                                                                                                                                                                                                          • Data Visualization Principles
                                                                                                                                                                                                                                                                                                                                                                                                                            • What is Data Visualization

                                                                                                                                                                                                                                                                                                                                                                                                                              Why Visualization came into the picture

                                                                                                                                                                                                                                                                                                                                                                                                                              Importance of Visualizing Data

                                                                                                                                                                                                                                                                                                                                                                                                                              Poor Visualizations versus Perfect Visualizations

                                                                                                                                                                                                                                                                                                                                                                                                                              Principles of Visualizations

                                                                                                                                                                                                                                                                                                                                                                                                                              Tufte’s Graphical Integrity Rule

                                                                                                                                                                                                                                                                                                                                                                                                                              Tufte’s Principles for Analytical Design

                                                                                                                                                                                                                                                                                                                                                                                                                              Visual Rhetoric

                                                                                                                                                                                                                                                                                                                                                                                                                              Goal of Data Visualization

                                                                                                                                                                                                                                                                                                                                                                                                                              Data Interpretation

                                                                                                                                                                                                                                                                                                                                                                                                                              Pivot Tables

                                                                                                                                                                                                                                                                                                                                                                                                                              Split Tables

                                                                                                                                                                                                                                                                                                                                                                                                                              Responsive Tool Tips

                                                                                                                                                                                                                                                                                                                                                                                                                              Radial & Lasso Selection

                                                                                                                                                                                                                                                                                                                                                                                                                              Right Click Filtering

                                                                                                                                                                                                                                                                                                                                                                                                                              Creating Calculated Fields

                                                                                                                                                                                                                                                                                                                                                                                                                              Logical functions

                                                                                                                                                                                                                                                                                                                                                                                                                              Case-if functions

                                                                                                                                                                                                                                                                                                                                                                                                                              ZN function

                                                                                                                                                                                                                                                                                                                                                                                                                              Else-if function

                                                                                                                                                                                                                                                                                                                                                                                                                              Ad-Hoc Calculations

                                                                                                                                                                                                                                                                                                                                                                                                                              Manipulating Text-Left and Right Functions

                                                                                                                                                                                                                                                                                                                                                                                                                          • Basic Data Visualization
                                                                                                                                                                                                                                                                                                                                                                                                                            • Pivot Table & Heat Map

                                                                                                                                                                                                                                                                                                                                                                                                                              Highlight Table

                                                                                                                                                                                                                                                                                                                                                                                                                              Bar Charts

                                                                                                                                                                                                                                                                                                                                                                                                                              Line Charts

                                                                                                                                                                                                                                                                                                                                                                                                                              Pie Chart

                                                                                                                                                                                                                                                                                                                                                                                                                              Scatter Plot

                                                                                                                                                                                                                                                                                                                                                                                                                              Word Cloud

                                                                                                                                                                                                                                                                                                                                                                                                                              Tree Map

                                                                                                                                                                                                                                                                                                                                                                                                                              Blended Axis

                                                                                                                                                                                                                                                                                                                                                                                                                              Dual Axis

                                                                                                                                                                                                                                                                                                                                                                                                                          • Managing Your Data
                                                                                                                                                                                                                                                                                                                                                                                                                            • Filters

                                                                                                                                                                                                                                                                                                                                                                                                                              Types of Filters

                                                                                                                                                                                                                                                                                                                                                                                                                              Dimension Filters

                                                                                                                                                                                                                                                                                                                                                                                                                              Measure Filters

                                                                                                                                                                                                                                                                                                                                                                                                                              Condition based Filters

                                                                                                                                                                                                                                                                                                                                                                                                                              Advanced filters using wildcards

                                                                                                                                                                                                                                                                                                                                                                                                                              Top & Bottom N Filtering

                                                                                                                                                                                                                                                                                                                                                                                                                              Filtering order of operations

                                                                                                                                                                                                                                                                                                                                                                                                                              Extract Filter

                                                                                                                                                                                                                                                                                                                                                                                                                              Data Source Filter

                                                                                                                                                                                                                                                                                                                                                                                                                              Context Filter

                                                                                                                                                                                                                                                                                                                                                                                                                              Other Filters etc

                                                                                                                                                                                                                                                                                                                                                                                                                              Sorting

                                                                                                                                                                                                                                                                                                                                                                                                                              Calculations - String, Basic, Date & Logic

                                                                                                                                                                                                                                                                                                                                                                                                                              Parameters

                                                                                                                                                                                                                                                                                                                                                                                                                              Working with Dates

                                                                                                                                                                                                                                                                                                                                                                                                                              Table Calculation

                                                                                                                                                                                                                                                                                                                                                                                                                              Discrete vs Continuous measures

                                                                                                                                                                                                                                                                                                                                                                                                                              Grouping Data

                                                                                                                                                                                                                                                                                                                                                                                                                              Groups

                                                                                                                                                                                                                                                                                                                                                                                                                              Sets

                                                                                                                                                                                                                                                                                                                                                                                                                              Hierarchies

                                                                                                                                                                                                                                                                                                                                                                                                                              Bins

                                                                                                                                                                                                                                                                                                                                                                                                                              Combined Fields

                                                                                                                                                                                                                                                                                                                                                                                                                          • Formatting
                                                                                                                                                                                                                                                                                                                                                                                                                            • Size

                                                                                                                                                                                                                                                                                                                                                                                                                              Updating Axis

                                                                                                                                                                                                                                                                                                                                                                                                                              Colors

                                                                                                                                                                                                                                                                                                                                                                                                                              Borders

                                                                                                                                                                                                                                                                                                                                                                                                                              Transparency

                                                                                                                                                                                                                                                                                                                                                                                                                              Chart Lines

                                                                                                                                                                                                                                                                                                                                                                                                                              Trend Line

                                                                                                                                                                                                                                                                                                                                                                                                                              Forecasting

                                                                                                                                                                                                                                                                                                                                                                                                                              Reference Line

                                                                                                                                                                                                                                                                                                                                                                                                                              Mark Labels

                                                                                                                                                                                                                                                                                                                                                                                                                              Annotations

                                                                                                                                                                                                                                                                                                                                                                                                                          • Dashboard Design
                                                                                                                                                                                                                                                                                                                                                                                                                            • Canvas Selection & Adjusting Sizes

                                                                                                                                                                                                                                                                                                                                                                                                                              Tiled Objects

                                                                                                                                                                                                                                                                                                                                                                                                                              Floating Objects

                                                                                                                                                                                                                                                                                                                                                                                                                              Pixel Perfect Alignment

                                                                                                                                                                                                                                                                                                                                                                                                                              Summary Box

                                                                                                                                                                                                                                                                                                                                                                                                                              Chart Titles & Captions

                                                                                                                                                                                                                                                                                                                                                                                                                              Adding Images & Text

                                                                                                                                                                                                                                                                                                                                                                                                                              Adding Background Color

                                                                                                                                                                                                                                                                                                                                                                                                                              Adding Shading

                                                                                                                                                                                                                                                                                                                                                                                                                              Adding Separator Lines

                                                                                                                                                                                                                                                                                                                                                                                                                              Dynamic Chart Titles

                                                                                                                                                                                                                                                                                                                                                                                                                              Information Icons

                                                                                                                                                                                                                                                                                                                                                                                                                              Creating a Story

                                                                                                                                                                                                                                                                                                                                                                                                                          • Advanced Data Preparation
                                                                                                                                                                                                                                                                                                                                                                                                                            • Join

                                                                                                                                                                                                                                                                                                                                                                                                                              Inner

                                                                                                                                                                                                                                                                                                                                                                                                                              Left

                                                                                                                                                                                                                                                                                                                                                                                                                              Right

                                                                                                                                                                                                                                                                                                                                                                                                                              Full

                                                                                                                                                                                                                                                                                                                                                                                                                              Complex Joins

                                                                                                                                                                                                                                                                                                                                                                                                                              Union

                                                                                                                                                                                                                                                                                                                                                                                                                              Data Blending & when it is required

                                                                                                                                                                                                                                                                                                                                                                                                                          • Advance Data Visualization
                                                                                                                                                                                                                                                                                                                                                                                                                            • Bar Chart

                                                                                                                                                                                                                                                                                                                                                                                                                              Stack Bar Chart

                                                                                                                                                                                                                                                                                                                                                                                                                              Bar in Bar Chart

                                                                                                                                                                                                                                                                                                                                                                                                                              Combo Chart

                                                                                                                                                                                                                                                                                                                                                                                                                              Line Chart

                                                                                                                                                                                                                                                                                                                                                                                                                              Single Axis

                                                                                                                                                                                                                                                                                                                                                                                                                              Blended Axis

                                                                                                                                                                                                                                                                                                                                                                                                                              Dual Axis

                                                                                                                                                                                                                                                                                                                                                                                                                              Dual Axis Chart

                                                                                                                                                                                                                                                                                                                                                                                                                              Line

                                                                                                                                                                                                                                                                                                                                                                                                                              Bar

                                                                                                                                                                                                                                                                                                                                                                                                                              Lollipop Chart

                                                                                                                                                                                                                                                                                                                                                                                                                              Donut

                                                                                                                                                                                                                                                                                                                                                                                                                              Pareto Chart

                                                                                                                                                                                                                                                                                                                                                                                                                              Motion Charts

                                                                                                                                                                                                                                                                                                                                                                                                                              Other Advanced Charts

                                                                                                                                                                                                                                                                                                                                                                                                                          • Advanced Filtering & Actions
                                                                                                                                                                                                                                                                                                                                                                                                                            • Action Filters

                                                                                                                                                                                                                                                                                                                                                                                                                              Action Jumps

                                                                                                                                                                                                                                                                                                                                                                                                                          • Sharing Your Dashboards
                                                                                                                                                                                                                                                                                                                                                                                                                            • Publishing to PDF

                                                                                                                                                                                                                                                                                                                                                                                                                              Exporting to Pivot Tables and Images

                                                                                                                                                                                                                                                                                                                                                                                                                              Exporting Packaged Workbooks

                                                                                                                                                                                                                                                                                                                                                                                                                              Publishing to Tableau Server

                                                                                                                                                                                                                                                                                                                                                                                                                          Get full course syllabus in your inbox

                                                                                                                                                                                                                                                                                                                                                                                                                          • Introduction to Power BI
                                                                                                                                                                                                                                                                                                                                                                                                                            • Overview of BI concepts

                                                                                                                                                                                                                                                                                                                                                                                                                              Why we need BI

                                                                                                                                                                                                                                                                                                                                                                                                                              Introduction to SSBI

                                                                                                                                                                                                                                                                                                                                                                                                                              SSBI Tools

                                                                                                                                                                                                                                                                                                                                                                                                                              Why Power BI

                                                                                                                                                                                                                                                                                                                                                                                                                              What is Power BI

                                                                                                                                                                                                                                                                                                                                                                                                                              Building Blocks of Power BI

                                                                                                                                                                                                                                                                                                                                                                                                                              Getting started with Power BI Desktop

                                                                                                                                                                                                                                                                                                                                                                                                                              Get Power BI Tools

                                                                                                                                                                                                                                                                                                                                                                                                                              Introduction to Tools and Terminology

                                                                                                                                                                                                                                                                                                                                                                                                                              Dashboard in Minutes

                                                                                                                                                                                                                                                                                                                                                                                                                              Refreshing Power BI Service Data

                                                                                                                                                                                                                                                                                                                                                                                                                              Interacting with your Dashboards

                                                                                                                                                                                                                                                                                                                                                                                                                              Sharing Dashboards and Reports

                                                                                                                                                                                                                                                                                                                                                                                                                          • Power BI Desktop
                                                                                                                                                                                                                                                                                                                                                                                                                            • Power BI Desktop

                                                                                                                                                                                                                                                                                                                                                                                                                              Extracting data from various sources

                                                                                                                                                                                                                                                                                                                                                                                                                              Workspaces in Power BI

                                                                                                                                                                                                                                                                                                                                                                                                                              Data Transformation

                                                                                                                                                                                                                                                                                                                                                                                                                              Measures and Calculated Columns

                                                                                                                                                                                                                                                                                                                                                                                                                              Query Editor

                                                                                                                                                                                                                                                                                                                                                                                                                          • Modelling with Power BI
                                                                                                                                                                                                                                                                                                                                                                                                                            • Introduction to Modelling

                                                                                                                                                                                                                                                                                                                                                                                                                              Modelling Data

                                                                                                                                                                                                                                                                                                                                                                                                                              Manage Data Relationship

                                                                                                                                                                                                                                                                                                                                                                                                                              Optimize Data Models

                                                                                                                                                                                                                                                                                                                                                                                                                              Cardinality and Cross Filtering

                                                                                                                                                                                                                                                                                                                                                                                                                              Default Summarization & Sort by

                                                                                                                                                                                                                                                                                                                                                                                                                              Creating Calculated Columns

                                                                                                                                                                                                                                                                                                                                                                                                                              Creating Measures & Quick Measures

                                                                                                                                                                                                                                                                                                                                                                                                                          • Data Analysis Expressions (DAX)
                                                                                                                                                                                                                                                                                                                                                                                                                            • What is DAX

                                                                                                                                                                                                                                                                                                                                                                                                                              Data Types in DAX

                                                                                                                                                                                                                                                                                                                                                                                                                              Calculation Types

                                                                                                                                                                                                                                                                                                                                                                                                                              Syntax, Functions, Context Options

                                                                                                                                                                                                                                                                                                                                                                                                                              DAX Functions

                                                                                                                                                                                                                                                                                                                                                                                                                              Date and Time

                                                                                                                                                                                                                                                                                                                                                                                                                              Time Intelligence

                                                                                                                                                                                                                                                                                                                                                                                                                              Information

                                                                                                                                                                                                                                                                                                                                                                                                                              Logical

                                                                                                                                                                                                                                                                                                                                                                                                                              Mathematical

                                                                                                                                                                                                                                                                                                                                                                                                                              Statistical

                                                                                                                                                                                                                                                                                                                                                                                                                              Text and Aggregate

                                                                                                                                                                                                                                                                                                                                                                                                                              Measures in DAX

                                                                                                                                                                                                                                                                                                                                                                                                                              ROW Context and Filter Context in DAX

                                                                                                                                                                                                                                                                                                                                                                                                                              Operators in DAX - Real-time Usage

                                                                                                                                                                                                                                                                                                                                                                                                                              Quick Measures in DAX - Auto validations

                                                                                                                                                                                                                                                                                                                                                                                                                              Power Pivot x Velocity & Vertipaq Store

                                                                                                                                                                                                                                                                                                                                                                                                                              In-Memory Processing: DAX Performance

                                                                                                                                                                                                                                                                                                                                                                                                                          • Modelling with Power BI
                                                                                                                                                                                                                                                                                                                                                                                                                            • Introduction to Modelling

                                                                                                                                                                                                                                                                                                                                                                                                                              Optimize Data Models

                                                                                                                                                                                                                                                                                                                                                                                                                              Setup and Manage Relationships

                                                                                                                                                                                                                                                                                                                                                                                                                              Cardinality and Cross Filtering

                                                                                                                                                                                                                                                                                                                                                                                                                              Default Summarization & Sort by

                                                                                                                                                                                                                                                                                                                                                                                                                              Creating Calculated Columns

                                                                                                                                                                                                                                                                                                                                                                                                                              Creating Measures & Quick Measures

                                                                                                                                                                                                                                                                                                                                                                                                                          • Power BI Desktop Visualisations
                                                                                                                                                                                                                                                                                                                                                                                                                            • How to use Visual in Power BI

                                                                                                                                                                                                                                                                                                                                                                                                                              What Are Custom Visuals

                                                                                                                                                                                                                                                                                                                                                                                                                              Creating Visualisations and Colour Formatting

                                                                                                                                                                                                                                                                                                                                                                                                                              Setting Sort Order

                                                                                                                                                                                                                                                                                                                                                                                                                              Scatter & Bubble Charts & Play Axis

                                                                                                                                                                                                                                                                                                                                                                                                                              Tooltips and Slicers, Timeline Slicers & Sync Slicers

                                                                                                                                                                                                                                                                                                                                                                                                                              Cross Filtering and Highlighting

                                                                                                                                                                                                                                                                                                                                                                                                                              Visual, Page and Report Level Filters

                                                                                                                                                                                                                                                                                                                                                                                                                              Drill Down/Up

                                                                                                                                                                                                                                                                                                                                                                                                                              Hierarchies and Reference/Constant Lines

                                                                                                                                                                                                                                                                                                                                                                                                                              Tables, Matrices & Conditional Formatting

                                                                                                                                                                                                                                                                                                                                                                                                                              KPI's, Cards & Gauges

                                                                                                                                                                                                                                                                                                                                                                                                                              Map Visualizations

                                                                                                                                                                                                                                                                                                                                                                                                                              Custom Visuals

                                                                                                                                                                                                                                                                                                                                                                                                                              Managing and Arranging

                                                                                                                                                                                                                                                                                                                                                                                                                              Drill through and Custom Report Themes

                                                                                                                                                                                                                                                                                                                                                                                                                              Grouping and Binning and Selection Pane, Bookmarks & Buttons

                                                                                                                                                                                                                                                                                                                                                                                                                              Data Binding and Power BI Report Server

                                                                                                                                                                                                                                                                                                                                                                                                                          • Introduction to Power BI Q&A and Data Insights
                                                                                                                                                                                                                                                                                                                                                                                                                            • Why Dashboard and Dashboard vs Reports

                                                                                                                                                                                                                                                                                                                                                                                                                              Creating Dashboards

                                                                                                                                                                                                                                                                                                                                                                                                                              Configuring a Dashboard: Dashboard Tiles, Pinning Tiles

                                                                                                                                                                                                                                                                                                                                                                                                                              Quick Insights in Power BI

                                                                                                                                                                                                                                                                                                                                                                                                                              Power BI embedded and REST API

                                                                                                                                                                                                                                                                                                                                                                                                                          • Direct Connectivity
                                                                                                                                                                                                                                                                                                                                                                                                                            • Custom Data Gateways

                                                                                                                                                                                                                                                                                                                                                                                                                              Exploring live connections to data with Power BI

                                                                                                                                                                                                                                                                                                                                                                                                                              Connecting directly to SQL Azure, HD Spark, and SQL Server Analysis Services/ My SQL

                                                                                                                                                                                                                                                                                                                                                                                                                              Introduction to Power BI Development API

                                                                                                                                                                                                                                                                                                                                                                                                                              Excel with Power BI: Connect Excel to Power BI, Power BI Publisher for Excel

                                                                                                                                                                                                                                                                                                                                                                                                                              Content packs

                                                                                                                                                                                                                                                                                                                                                                                                                              Update content packs

                                                                                                                                                                                                                                                                                                                                                                                                                          • BI and Azure ML Integrating Power
                                                                                                                                                                                                                                                                                                                                                                                                                            • Extracting data out of Azure SQL using R

                                                                                                                                                                                                                                                                                                                                                                                                                              Using R, call the Azure ML web service and send it the un-scored data

                                                                                                                                                                                                                                                                                                                                                                                                                              Writing the output of the Azure ML model back into SQL

                                                                                                                                                                                                                                                                                                                                                                                                                              read scored data into Power BI using R

                                                                                                                                                                                                                                                                                                                                                                                                                              Publishing the Power BI file to the Power BI service

                                                                                                                                                                                                                                                                                                                                                                                                                              Scheduling a refresh of the data using the Personal Gateway

                                                                                                                                                                                                                                                                                                                                                                                                                          • Publishing and Sharing
                                                                                                                                                                                                                                                                                                                                                                                                                            • Introduction and Sharing Options Overview

                                                                                                                                                                                                                                                                                                                                                                                                                              Publish from Power BI Desktop and Publish to Web

                                                                                                                                                                                                                                                                                                                                                                                                                              Share Dashboard with Power BI Service

                                                                                                                                                                                                                                                                                                                                                                                                                              Workspaces and Apps (Power BI Pro) and Content Packs (Power BI Pro)

                                                                                                                                                                                                                                                                                                                                                                                                                              Print or Save as PDF and Row Level Security (Power BI Pro)

                                                                                                                                                                                                                                                                                                                                                                                                                              Export Data from a Visualization and Publishing for Mobile Apps

                                                                                                                                                                                                                                                                                                                                                                                                                          • Refreshing Datasets
                                                                                                                                                                                                                                                                                                                                                                                                                            • Understanding Data Refresh

                                                                                                                                                                                                                                                                                                                                                                                                                              Personal Gateway (Power BI Pro and 64-bit Windows)

                                                                                                                                                                                                                                                                                                                                                                                                                              Replacing a Dataset and Troubleshooting Refreshing

                                                                                                                                                                                                                                                                                                                                                                                                                          Get full course syllabus in your inbox

                                                                                                                                                                                                                                                                                                                                                                                                                          + More Lessons

                                                                                                                                                                                                                                                                                                                                                                                                                          Need Customized curriculum?

                                                                                                                                                                                                                                                                                                                                                                                                                          Mock Interviews

                                                                                                                                                                                                                                                                                                                                                                                                                          Prepare & Practice for real-life job interviews by joining the Mock Interviews drive at Croma Campus and learn to perform with confidence with our expert team.Not sure of Interview environments? Don’t worry, our team will familiarize you and help you in giving your best shot even under heavy pressures.Our Mock Interviews are conducted by trailblazing industry-experts having years of experience and they will surely help you to improve your chances of getting hired in real.
                                                                                                                                                                                                                                                                                                                                                                                                                          How Croma Campus Mock Interview Works?

                                                                                                                                                                                                                                                                                                                                                                                                                          Projects

                                                                                                                                                                                                                                                                                                                                                                                                                          Validate your skills and knowledge by working on industry-based projects that includes significant real-time use cases.Gain hands-on expertize in Top IT skills and become industry-ready after completing our project works and assessments.Our projects are perfectly aligned with the modules given in the curriculum and they are picked up based on latest industry standards. Add some meaningful project works in your resume, get noticed by top industries and start earning huge salary lumps right away.
                                                                                                                                                                                                                                                                                                                                                                                                                          Request more informations

                                                                                                                                                                                                                                                                                                                                                                                                                          Phone (For Voice Call):

                                                                                                                                                                                                                                                                                                                                                                                                                          +91-971 152 6942

                                                                                                                                                                                                                                                                                                                                                                                                                          WhatsApp (For Call & Chat):

                                                                                                                                                                                                                                                                                                                                                                                                                          +918287060032

                                                                                                                                                                                                                                                                                                                                                                                                                          self assessment

                                                                                                                                                                                                                                                                                                                                                                                                                          Learn, Grow & Test your skill with Online Assessment Exam to achieve your Certification Goals

                                                                                                                                                                                                                                                                                                                                                                                                                          laptop

                                                                                                                                                                                                                                                                                                                                                                                                                          FAQ's

                                                                                                                                                                                                                                                                                                                                                                                                                          Professionals or fresher’s who are willing to making a career in Data Analytics can do this course.

                                                                                                                                                                                                                                                                                                                                                                                                                          Well, with our training, participants can enhance their career as Data Analyst.

                                                                                                                                                                                                                                                                                                                                                                                                                          We, at Croma Campus, have a dedicated team of instructors with nearly a decade of relevant teaching experience.

                                                                                                                                                                                                                                                                                                                                                                                                                          We will train you accordingly, allowing you to get attractive job offers at the time of an interview.

                                                                                                                                                                                                                                                                                                                                                                                                                          We, at Croma Campus, don't ask for any requisites.

                                                                                                                                                                                                                                                                                                                                                                                                                          Career Assistancecareer assistance
                                                                                                                                                                                                                                                                                                                                                                                                                          • - Build an Impressive Resume
                                                                                                                                                                                                                                                                                                                                                                                                                          • - Get Tips from Trainer to Clear Interviews
                                                                                                                                                                                                                                                                                                                                                                                                                          • - Attend Mock-Up Interviews with Experts
                                                                                                                                                                                                                                                                                                                                                                                                                          • - Get Interviews & Get Hired
                                                                                                                                                                                                                                                                                                                                                                                                                          Are you satisfied with our Training Curriculum?

                                                                                                                                                                                                                                                                                                                                                                                                                          If yes, Register today and get impeccable Learning Solutions!

                                                                                                                                                                                                                                                                                                                                                                                                                          man

                                                                                                                                                                                                                                                                                                                                                                                                                          Training Features

                                                                                                                                                                                                                                                                                                                                                                                                                          instructore

                                                                                                                                                                                                                                                                                                                                                                                                                          Instructor-led Sessions

                                                                                                                                                                                                                                                                                                                                                                                                                          The most traditional way to learn with increased visibility,monitoring and control over learners with ease to learn at any time from internet-connected devices.

                                                                                                                                                                                                                                                                                                                                                                                                                          real life

                                                                                                                                                                                                                                                                                                                                                                                                                          Real-life Case Studies

                                                                                                                                                                                                                                                                                                                                                                                                                          Case studies based on top industry frameworks help you to relate your learning with real-time based industry solutions.

                                                                                                                                                                                                                                                                                                                                                                                                                          assigment

                                                                                                                                                                                                                                                                                                                                                                                                                          Assignment

                                                                                                                                                                                                                                                                                                                                                                                                                          Adding the scope of improvement and fostering the analytical abilities and skills through the perfect piece of academic work.

                                                                                                                                                                                                                                                                                                                                                                                                                          life time access

                                                                                                                                                                                                                                                                                                                                                                                                                          Lifetime Access

                                                                                                                                                                                                                                                                                                                                                                                                                          Get Unlimited access of the course throughout the life providing the freedom to learn at your own pace.

                                                                                                                                                                                                                                                                                                                                                                                                                          expert

                                                                                                                                                                                                                                                                                                                                                                                                                          24 x 7 Expert Support

                                                                                                                                                                                                                                                                                                                                                                                                                          With no limits to learn and in-depth vision from all-time available support to resolve all your queries related to the course.

                                                                                                                                                                                                                                                                                                                                                                                                                          certification

                                                                                                                                                                                                                                                                                                                                                                                                                          Certification

                                                                                                                                                                                                                                                                                                                                                                                                                          Each certification associated with the program is affiliated with the top universities providing edge to gain epitome in the course.

                                                                                                                                                                                                                                                                                                                                                                                                                          Training Certification

                                                                                                                                                                                                                                                                                                                                                                                                                          Earn your certificate

                                                                                                                                                                                                                                                                                                                                                                                                                          Your certificate and skills are vital to the extent of jump-starting your career and giving you a chance to compete in a global space.

                                                                                                                                                                                                                                                                                                                                                                                                                          Share your achievement

                                                                                                                                                                                                                                                                                                                                                                                                                          Talk about it on Linkedin, Twitter, Facebook, boost your resume or frame it- tell your friend and colleagues about it.

                                                                                                                                                                                                                                                                                                                                                                                                                          Video Reviews

                                                                                                                                                                                                                                                                                                                                                                                                                          Testimonials & Reviews

                                                                                                                                                                                                                                                                                                                                                                                                                          ×

                                                                                                                                                                                                                                                                                                                                                                                                                          For Voice Call

                                                                                                                                                                                                                                                                                                                                                                                                                          +91-971 152 6942

                                                                                                                                                                                                                                                                                                                                                                                                                          For Whatsapp Call & Chat

                                                                                                                                                                                                                                                                                                                                                                                                                          +91-8287060032
                                                                                                                                                                                                                                                                                                                                                                                                                          1
                                                                                                                                                                                                                                                                                                                                                                                                                          -->