Programme Content
Understanding Analytics and its Role in the Organizations
Course Brief
Introduction and Background of Data Analytics
Knowledge Discovery Process
Project Details
Introduction to Case Methodology
Sensitivity Analysis, Enhancing Decision Process
Scenario Manager for Decision Makers
Data Table (one way and two way)
Goal Seek and its Applications
Business Focused Data Analytics through Excel
Data Validation
Data Referencing, Indexing and Charting
Optimization
Data Warehouse, OLAP and Pivot Table
Extraction, Transformation and Loading Process, Architecture
OLAP Operations and Simulation
Enterprise Reporting
Visual Analytics
Building Dashboards
Random Number Theory and Price Analytics
Monte Carlo Stimulation
Price Analytics
R-Programming - I
Introduction to R (part 1)
R-Programming - II
Introduction To R (part 2)
Analytical Techniques for Business Intelligence – I
Classification using Decision Trees and Naive Bayesian
Analytical Techniques for Business Intelligence – II
Association Rule Mining (unsupervised Learning)
Analytical Techniques for Business Intelligence – III
Clustering (unsupervised Learning)
Analytical Techniques for Business Intelligence – IV
Neural Networks (Supervised Learning)
Analytical Techniques for Business Intelligence – V
Content based Recommendations
Collaborative Recommendations and Applications (unsupervised Learning)
Analytical Techniques for Business Intelligence – VI
Web and Social Media Analytics
Analytical Techniques for Business Intelligence – VII
Genetic Algorithm and Fuzzy Logic
Big Data Analytics (Introduction)
Big Data
Hadoop
HDFS
MapReduce
Python
Introduction to Python
Analytics of Applications
Web Scrapping and Mining
Analytical Techniques for Business Intelligence – VIII
Text Analytics
Sentiment Analytics
Project Presentations
Project Presentations
15Hrs. Power BI Masterclass by Nulearn
Power BI Desktop Installation
Data Sources & Visual Types
Canvas, Visualizations and Fields
Power BI Visualizations
Bar Charts
Pie Charts
Doughnut Charts
Line Charts
Area Charts
Columns Charts
Cards
Combo Charts
Decomposition Tree
Funnel Charts
KPIs
Gauge Charts
Waterfall Charts
Maps
Matrix
Slicer Visual
Single & Multi Select, CTRL Options
Slicer Number, Text and Date Data
Slicer List and Slicer Dropdowns
Filters
Visual Filter, Page Filter, Report Filter
Advanced and TOP N Filters
DAX
Define DAX formulas and its applications
Create basic calculated columns and measures
Apply common DAX expressions such as FILTER, SUM
