Enterprise Analytics Course Syllabus
Module 1: Introduction to Information Science | Introduction to the Business & Buzzwords Industrial utility of information science Introduction to completely different Information Science Methods Essential Software program & Instruments Profession paths & progress in information science |
Module 2: Introduction to Excel | Introduction to Excel- Interface, Sorting & Filtering, Excel Reporting- Fundamental & Conditional Formatting Layouts, Printing and Securing Recordsdata |
Module 3: Introduction to Stats | Introduction to Statistics & It’s Purposes Intro: Inferential vs. descriptive statistics |
Module 4: Descriptive Stats Utilizing Excel Datasets | Categorical Variables Visualization Utilizing Excel Charts- FDT, Pie Charts, Bar Charts & Pareto Numerical Variables Visualization of Frequency & Absolute Frequency- Utilizing Histogram, Cross Desk & Scatter Plot Measure of Unfold ( Imply, Mode , Median) Measure of Variance( Skewness, SD, Variance, Vary, Coef. Of Variance, Bivariate Evaluation, Covariance & Correlation) |
Module 5: Inferential Stats Utilizing Excel Datasets | Introduction to Likelihood Permutation & Mixtures Normal Regular distribution Regular vs. Normal Regular distribution Confidence Intervals & Z-Rating Speculation Testing & It’s Varieties |
Module 6: Information Visualization Utilizing Tableau | Tableau vs Excel and PowerBI Exploratory and Explanatory Evaluation Getting began with Tableau Visualizing and Analyzing information with Tableau – I Visualizing and Analyzing Information with Tableau – II Numeric and String capabilities Logical and Date capabilities Histograms and parameters High N Parameters and Calculated Fields Dashboards – II and Filter Actions |
Introduction to Enterprise Intelligence and Energy BI Energy BI Desktop Interface Information Sources and Connectivity Energy Question Editor (Information Transformation) Information Modeling and Relationships DAX (Information Evaluation Expressions) Creating Reviews and Visualizations Dashboards and Interactive Reviews Publishing to Energy BI Service Sharing and Collaboration AI and Machine Studying Integration | |
Module 8: Database Design & RDBMS | Introduction to databases, DBMS, database system structure Information fashions (hierarchical, community, relational, object-oriented Information independence, schemas, cases Three-schema structure Entity-Relationship (ER) Modeling Entities, attributes, relationships Relational Database Mannequin: Relations, attributes, tuples, keys Integrity constraints (entity, referential) Relational algebra and calculus SQL (Information Definition Language, Information Manipulation Language, Information Management Language) Normalization (1NF, 2NF, 3NF, BCNF) Categorical – Categorical Evaluation Concurrency management (locking, timestamping) |
Enterprise Analytics Initiatives and Assignments
Main Initiatives
Buyer Lifetime Worth Calculation: The venture includes calculating the shopper lifetime worth utilizing SQL to know the income generated by a buyer over their lifetime.
Buyer Churn Prediction: This venture includes constructing a predictive mannequin utilizing SQL to establish clients who’re more likely to churn primarily based on their habits and transaction historical past.
Interactive Dashboard for E-Commerce Gross sales: The venture includes creating an interactive dashboard utilizing Tableau & SQL to research retail gross sales information, establish traits, and make data-driven selections.
Buyer Segmentation Dashboard: This venture includes making a buyer segmentation dashboard utilizing Tableau to establish buyer teams primarily based on demographics, habits, and buying patterns.
Film Suggestion System: The venture includes constructing a film advice system utilizing Python and its libraries akin to Pandas, NumPy, and Scikit-Study. The advice system will recommend films primarily based on consumer preferences and scores.
Sentiment Evaluation on Twitter Information: This venture includes analyzing Twitter information utilizing Python and its libraries akin to NLTK and TextBlob to carry out sentiment evaluation and perceive the general sentiment of a specific subject.
Visualizing COVID-19 Information: The venture includes visualizing COVID-19 information utilizing Python and its libraries akin to Matplotlib, Seaborn, and Plotly to know the affect of the pandemic on completely different nations and areas.
Visualizing Inventory Market Information: This venture includes visualizing inventory market information utilizing Python and its libraries akin to Pandas, Matplotlib, and Bokeh to know the traits and patterns in inventory costs over time.
Airbnb Information Evaluation: The venture includes performing exploratory information evaluation on Airbnb information to know the patterns within the pricing, availability, and high quality of Airbnb listings in several cities.
Bike Sharing Information Evaluation: This venture includes performing exploratory information evaluation on bike sharing information to know the utilization patterns of bikes in several cities and establish elements that affect bike utilization.
Home Value Prediction: The venture includes constructing a regression mannequin utilizing Python and its libraries akin to Scikit-Study to foretell the costs of homes primarily based on their options akin to location, measurement, and facilities.
Credit score Danger Prediction: This venture includes constructing a classification mannequin utilizing Python and its libraries akin to Scikit-Study to foretell the credit score danger of mortgage candidates primarily based on their credit score historical past and different elements.
Time Collection Forecasting for Gross sales Information: The venture includes constructing a time sequence forecasting mannequin utilizing superior machine studying algorithms akin to ARIMA and LSTM to foretell future gross sales traits and establish elements that affect gross sales.
Sentiment Evaluation on Product Critiques: The venture includes constructing a sentiment evaluation mannequin utilizing NLP strategies akin to Phrase Embeddings and Recurrent Neural Networks (RNN) to research product critiques and perceive the sentiment of consumers in direction of completely different merchandise.
Segmentation utilizing Deep Studying: This venture includes utilizing superior deep studying strategies akin to Totally Convolutional Networks (FCN) and U-Web to carry out picture segmentation and establish objects in pictures.
Machine Translation utilizing Transformers: This venture includes constructing a machine translation mannequin utilizing superior deep studying strategies akin to Transformers to translate textual content from one language to a different.
Case Research & Assignments:
- Healthcare Buyer Suggestions Evaluation
- Administration Groups Dashboard Creation
- Retail Retailer Gross sales Report Evaluation
- Software program Agency Worker Information Evaluation
- Industrial Information Units Classification & Comparability
- Charts & Graphs: Frequency Distribution Desk, Pie-charts, Pareto Diagram, Histogram, Scatter Plots, Heatmaps, Bar Graphs and lots of Extra.
- Affected person Illness Likelihood Evaluation Utilizing Healthcare Information
- Automobile Mannequin & Menu Merchandise Information Mixture & Configuration Likelihood Evaluation
- Manufacturing & Product Launch Information Classification & Evaluation
- Buyer Criticism Decision Evaluation Utilizing Regular Distribution Curves
- Product Score & Worker Productiveness Evaluation Usign Z-Rating
- New Product Want Evaluation Utilizing Speculation Testing
- Stock Administration & Buyer Segmentation Techniques Utilizing Vlook up & Hlook Lookup
- Gross sales Pattern & Staffing Plan Creation utilizing Pivot Tables
- Pricing Technique & Monetary Mannequin Creation Utilizing What if Evaluation
- Gross sales & Operations Dashboard Creation
- Healthcare & Development Reporting Automation Utilizing Macros
- Retail Gross sales Alternative Evaluation Utilizing PIVOT Charts
- Accounting Agency Assertion Evaluation Utilizing Sparklines & Waterfall Chart
- FMCG Advertising and marketing Spend to Gross sales Income Impression Evaluation Utilizing Regression Evaluation
- Transportation Pricing Mannequin Utilizing Regression Evaluation
Enterprise Analytics Placements
100% * Placement Help Devoted Placement Cell To Assist You Land Your Dream Job
Enterprise Analytics course charges
Grasp Program in Enterprise Analytics Charges: 30k-90k
Contact Data
Digiperform Company Workplace: C-30, Third Flooring, Sector-2, Close to Sec-15 Metro Station, Noida, Uttar Pradesh 201301, India
E mail: [email protected]
Telephone: +91-8527-611-500
Web site: www.digiperform.com