Course Instractor: Naimul Islam

12+ years experience in big data analysis and informatics

DESCRIPTION

In the business world of Data Analysis and Business Intelligence, there are powerful tools that enable professionals to extract meaningful insights from vast amounts of data. Excel, Power BI, Power Pivot, and Power Query are four such tools that have revolutionized the way data is managed, analyzed and visualized.

This is an introductory level course for Business and Data Analytics. The objective of this training to offer understanding of Basic Analytics concepts, developing competencies on how to perform data analysis in Excel, and gain proficiency in data visualization and analysis using Power BI.

After finishing the training, you will have the expertise to implement business intelligence solutions to your organization using tools such as Excel or Power BI that will improve the current reporting system and add greater depth in the business decision making process.

OBJECTIVES:

• Understand Basic Analytics concepts
• Gain proficiency in data visualization and analysis using Power BI
• Learn how to perform data analysis in Excel

• You will gain an advanced level of understanding on the types of data, overview of Data analytics and its importance in decision-making.
• You will learn the analytics process: data collection, data cleaning, analysis, visualization, and interpretation
• You will learn how to use advanced Excel Statistical functions (VLOOKUP, SUMIFS, INDEX-MATCH, PivotTables and PivotCharts etc.)
• You will learn how to gather, transform, model and visualize data with Power BI
• You will learn how to use Excel and Power BI data solutions to your orginizations

Session 1: Introduction to Analytics.

Duration: 1 hour

• Overview of analytics and its importance in decision-making
• Introduction to basic analytics concepts: data types, variables, measures, etc.
• Understanding the analytics process: data collection, data cleaning, analysis, visualization, and interpretation

Session 2: Data Analysis in Excel

Duration: 2 hours

• Introduction to Excel for data analysis
• Data import and cleaning techniques in Excel
• Basic data manipulation and transformation using Excel functions (e.g., VLOOKUP, SUMIFS, INDEX-MATCH)
• Introduction to PivotTables and PivotCharts for data summarization and visualization

Session 3: Advanced Data Analysis in Excel

Duration: 2 hours

• Advanced data manipulation techniques: using array formulas, Power Query, and Power Pivot
• Performing statistical analysis in Excel: descriptive statistics, regression analysis, etc.
• Introduction to Excel macros for automating repetitive tasks

Session 4: Introduction to Power BI (3 hours)

Duration: 3 hours

• Overview of Power BI and its features
• Importing data into Power BI from different sources (Excel, databases, web, etc.)
• Creating relationships between data tables in Power BI
• Building basic visualizations (bar charts, line charts, pie charts, etc.) in Power BI
• Introduction to Power BI DAX (Data Analysis Expressions) for creating calculated columns and measures
• Publishing and sharing Power BI reports and dashboards

• Basic or Intermediate level understanding of Excel
• A basic understanding of Probability and statics would be advantageous

The training will be applicable for those who are:

• Exploring the career in Data Analytics
• Looking for bridging course to add to their current reporting skills
• Data enthusiastic
• Looking for a deep awareness of the field