+91 72087 69880 info@landdedutech.com

Data analysis is important in business to understand problems facing an organisation, and to explore data in meaningful ways. Data in itself is merely facts and figures. Data analysis organises, interprets, structures and presents the data into useful information that provides context for the data. This context can then be used by decision-makers to take action with the aim of enhancing productivity and business gain.
Data analysis is an internal organisational function performed by Data Analysts that is more than merely presenting numbers and figures to management. It requires a much more in-depth approach to recording, analysing and dissecting data, and presenting the findings in an easily-digestible format.
With a data analysis course, you’ll be able to provide a company with decision-making insight into the following key areas:
• Predict customer trends and behaviours
• Analyse, interpret and deliver data in meaningful ways
• Increase business productivity
• Drive effective decision-making

Data Analysis and MIS course consists of following four modules:

Module: 1 Advanced Excel: Continuing to learn and hone your skill set is crucial to advance your career. Advanced Excel training focuses on a number of critical skills that can be utilized and valued in almost any position in a company. The more proficient at Excel you become, the more quickly you will be able to navigate the system.
Module: 2 Power BI: Microsoft Power BI (business intelligence)is a powerful analytics tool that helps companies of all sizes analyze data and share insights. With this technology, enterprises can monitor their business more closely and get instant answers with rich dashboards available for every device.
Module: 3 SQL Server: When you use SQL for data analysis, you will use it (most probably) for simple tasks: aggregating data, joining datasets, using simple statistical and mathematical methods. But you will be able to do these more efficiently and on much larger data sets than before.
Module: 4 MIS Reporting: MIS and data analysis is an essential and basic need of any business organization required to perform their functions efficiently and effectively. … Acompany’s business operations and performance improve by analyzing these records. MIS reports reduce the decision-making time as well as downtime for actionable items.

Module:1 Advanced Excel

• Overview of Excel
• What If Analysis
• Goal Seek
• Scenario Analysis
• Data Tables (PMT Function)
• Solver Tool

• Logical Functions

• If Function
• How to Fix Errors -iferror
• Nested If
• Complex if and or functions

• Data Validation

• Number, Date & Time Validation
• Text and List Validation
• Custom validation based on formula for a
o cell
• Dynamic Dropdown List Creation using Data Validation – Dependency List

• Lookup Functions

• Vlookup / Hlookup
• Index and Match
• Creating smooth User Interface Using Lookup
• Nested Vlookup
• Reverse Lookup using Choose Function
• Worksheet linking using Indirect

 PIVOT Tables

• Creating Simple Pivot Tables
• Basic and Advanced Value Field Setting
• Classic Pivot table
• Grouping based on numbers and Dates
• Calculated Field & Calculated Items

• Arrays Functions

• What are the Array Formulas,
• Use of the Array Formulas?
• Basic Examples of Arrays
(Using ctrl+shift+enter).
• Array with if, Len and mid functions
formulas.
• Array with Lookup functions.
• Advanced Use of formulas with Array.

• CHARTS and slicers

  • Various Charts i.e. Bar Charts / Pie Charts / Line Charts
  • Using SLICERS, Filter data with Slicers
  • Manage Primary and Secondary Axis

• Power Queries
• Power Pivot
• Dashboard

Module: 2 Power BI

• Explore what Power BI can do for you
• What can I do with Power BI service as a consumer?
• View content in Power BI service
• Explore with dashboards, reports, and apps in Power BI
• Collaborate and share in Power BI
• Find and view dashboards and reports

• Get started building with Power BI

• Introduction
• Use Power BI
• Building blocks of Power BI
• Tour and use the Power BI service

• Use visuals in Power BI

• Introduction to visuals in Power BI
• Create and customize simple visualizations
• Create slicers, Map visualizations
• Matrices and tables, Create scatter, waterfall, and funnel charts
• Modify colors in charts and visuals ,Page layout and formatting

• Get data with Power BI Desktop

• Overview of Power BI Desktop
• Connect to data source
• Transform data to include in a report
• Combine data from multiple sources
• Clean data to include in a report

• Model data in Power BI

• Introduction to modeling your data
• How to manage your data relationships
• Create calculated columns
• Optimize data models
• Create measures
• Create calculated tables
• Explore time-based data

• Build apps , Use apps
• Integrate OneDrive for Business with Power BI
• Publish to web

• Introduction to DAX

• Introduction to DAX
• DAX calculation types
• DAX functions
• Using variables in DAX expressions
• Table relationships and DAX
• DAX tables and filtering

Module: 3 SQL Server

• Introduction to Databases and Basic SQL
• Welcome to SQL
• Introduction to Databases
• How to Create a Database Instance on Cloud
• Relational Database Concepts

• Basic SQL

• CREATE Table Statement
• SELECT Statement
• COUNT, DISTINCT, LIMIT
• INSERT Statement
• UPDATE and DELETE Statements

• String Patterns, Ranges, Sorting, and Grouping

• Interactive Charts Examples (Dynamic Charts)
• Creating Bullet Chart in Excel

• Advanced Excel Charts for Dashboards

• Roll Over Effect in Excel Charts
(Advanced Concept)

• VBA Toolkit for Dashboards (VBA Macro Examples)

• Call Center Performance Dashboard in Excel
• Creating a Sales Pipeline Management Dashboard in Excel
• Creating a Pivot table Dashboard with Slicers in Excel (in 15 minutes)

• Explore data in Power BI

• Introduction to the Power BI service
• Quick insights in Power BI
• Create and configure a dashboard
• Ask questions of your data with
natural language
• Create custom Q&A suggestions
• Share dashboards with your organization
• Display visuals and tiles in full screen
• Edit tile details and add widgets,
Get more space on your dashboard

• Publish and share in Power BI

• Introduction to content packs, security,
and groups
• Publish Power BI Desktop reports
• Print and export dashboards and reports
• Introducing Power BI Mobile
• Create workspaces in Power BI

• Using String Patterns, Ranges
• Sorting Result Sets
• Grouping Result Sets

• Functions, Sub-Queries, Multiple Tables

• Built-in Database Functions.
• Date and Time Built-in Functions.
• Sub-Queries and Nested Selects
• Working with Multiple Tables

Module: 4 MIS Reporting

• Using Camera Tool For Excel Dashboards
• Excel Tables in Dashboards
• Using Custom Number Formatting
• Using Symbols in Excel Dashboards

• Conditional Formatting for Dashboard (How to Use + Advanced Examples)

• Using Sparklines in Excel Dashboards (In-cell charts / miniature charts)
• Getting the data ready for Excel Dashboards
• Useful Excel Dashboard Formulas
• Excel Interactive Controls (Scrollbar,
Spin Button, Checkbox, Combobox)

• Introduction to Excel Charting

• Creating the Right Excel Chart