Benefits of Data Analysis

• Ability to make faster, more informed business decisions, backed up by facts.
• Deeper understanding of customer requirements which, in turn, builds better business relationships.
• Increased awareness of risk, enabling the implementation of preventative measures.
• Improved flexibility and greater capability in order to react to change – both within the business and the market.
• Better insight into the financial performance of the business.
• Proven to reduce costs and therefore increase profit

Course Content

Introduction to Data Analytics

• Data Analytics Overview
• Importance of Data Analytics
• Types of DataAnalytics
• Descriptive Analytics
• Diagnostic Analytics
• Predictive Analytics
• Prescriptive Analytics
• Benefits of DataAnalytics
• Data Visualization for Decision Making
• Data Types, Measure Of central tendency, Measures of Dispersion
• Graphical Techniques, Skewness & Kurtosis, Box Plot
• Descriptive Stats
• Sampling Funnel, Sampling Variation, Central Limit Theorem, Confidence interval

Excel: Basics to Advanced

• Excel tutorial
• Text to Columns
• Concatenate
• The Concatenate Function
• The Right Function withConcatenation
• Absolute Cell References
• Data Validation
• Time and Date Calculations
• Conditional Formatting
• Exploring Styles and Clearing Formatting
• Using Conditional Formatting to Hide Cells
• Using the IFFunction
• Changing the “Value if false” Condition to Text
• Pivot Tables
• Creating a Pivot Table
• Specifying PivotTable Data
• Changing a PivotTablesCalculation
• Filtering and Sorting aPivotTable
• Creating a PivotChart
• Grouping Items
• Updating a PivotTable
• Formatting a PivotTable
• Using Slicers
• Charts
• Creating a Simple Chart
• Charting Non-Adjacent Cells
• Creating a Chart Using the ChartWizard
• Modifying Charts
• Moving an Embedded Chart
• Sizing an Embedded Chart
• Changing the Chart Type
• Chart Types
• Changing the Way Data isDisplayed
• Moving the Legend
• Resize Table
• Remove Duplicates
• Convert to Range
• Table Style Options
• Table Styles
• Cleaning Data with TextFunctions
• Removing Unwanted Characters fromText
• Extracting Data Values from Text
• Formatting Data with TextFunctions
• Date Formats
• Conditional Formatting
• Sorting
• Filtering
• Lookup Functions
• Pivoting

SQL

• Introduction to Oracle Database
• Retrieve Data using the SQL SELECT Statement
• Learn to Restrict and SortData
• Usage of Single-Row Functions to Customize Output
• Invoke Conversion Functions and Conditional Expressions
• Aggregate Data Using the Group Functions
• Display Data from Multiple Tables Using Joins
• Use Sub-Queries to SolveQueries
• The SET Operators
• Data Manipulation Statements
• Use of DDL Statements to Create and Manage Tables
• Other Schema Objects
• Control User Access
• Management of SchemaObjects
• Manage Objects with Data DictionaryViews
• Manipulate Large DataSets
• Data Management in Different TimeZones
• Retrieve Data UsingSub-queries
• Regular Expression Support

Power BI

• Module 1: Introduction to PowerBI
• Get Started with PowerBI
• Overview: Power BI concep
• Sign up for PowerBI
• Overview: Power BI datasources
• Connect to a SaaSsolution
• Upload a local CSV file
• Connect to Excel data that can be refreshed
• Connect to a sample
• Create a Report withVisualizations
• Explore the Power BIportal

Module 2: Viz and Tiles

• Overview: Visualizations
• Using visualizations
• Create a newreport
• Create and arrange visualizations
• Format a visualization
• Create chart visualizations
• Use text, map, and gauge visualizations and save a report
• Use a slicer to filtervisualizations
• Use text, map, and gauge visualizations and save a report
• Sort, copy, and pastevisualizations
• Download and use a custom visual from the gallery

Module 3: Reports andDashboards

• Modify and Print a Report
• Rename and delete reportpages
• Set visualization interactions
• Print a report page
• Send a report toPowerPoint
• Create a Dashboard
• Create and manage dashboards
• Pinareporttileto adashboard
• Pin a live report page to a dashboard
• Pin a tile from another dashboard
• Pin an Excel element to a dashboard
• Manage pinned elements inExcel
• Add a tile to adashboard
• Build a dashboard with QuickInsights
• Set a Featured (default)dashboard
• Ask Questions about YourData
• Ask a question with Power BI Q&A
• Tweak your dataset for Q&A
• EnableCortanaforPowerBI

Module 4: Publishing Workbooks and Workspace

• Share Data with Colleagues and Others
• Publish a report to theweb
• Manage published reports
• Share a dashboard
• Create an app workspace and add users
• Use an app workspace
• Publish an app
• Create a QR code to share a tile
• Embed a report in SharePoint Online

Module 5: Other Power BI Components and Table Relationship

• Use Power BI MobileApps
• Get Power BI for mobile
• View reports and dashboards in the iPad app
• Use workspaces in the mobileapp
• Sharing from Power BI Mobile
• Use Power BI Desktop
• Install and launch Power BI Desktop
• Get data
• Reduce data
• Transform data
• Relate tables
• Get Power BI Desktop data with the Power BI service
• Export a report from Power BI service to Desktop

Module 6: DAX functions

• New Dax functions
• Date and time functions
• Time intelligence functions
• Filter functions
• Information functions
• Logical functions
• Math & trigfunctions
• Parent and child functions
• Text functions

Python Basics

• The print statement
• Comments
• Python Data Structures & Data Types
• String Operations inPython
• Simple Input & Output
• Simple Output Formatting
• Deep copy
• Shallow copy
• Operators in python
• Introduction to Data Science/Analysis Tools for data Analysis
• Introduction to Advanced Excel
• Python programming Language
• SQL
• Data visualization using us pandas vi) Data set manipulation using python
• Data visualization using us pandas vi) Data set manipulation using python