Course Outline
- Types of Analytics
- Types of Variables
- Difference between business intelligence and business analytics
- Advanced-Data transformation through Power Query
- Transform numbers to get mastery in decision making
- Highlight key business parameters using advanced conditional formatting
- Advanced logical functions to for customized calculations
- Snapshot of Data without any visualization techniques
- Analyze data with pivot tables
- Design Dashboards in pivot tables
- Histogram and frequency distribution for quantitative variables
- Compare business Scenarios with What-if analysis
- Concept of Solver add-in for optimization techniques
- Descriptive statistics for variables
- Creating custom lists and Data validation
- Find the best market segment and target through multiple statistical techniques
- Find correlation and apply multiple regression for future predictions
- Hypothesis testing for inferential analysis