Data Analytics With Excel & Power BI​

DATA ANALYTICS FUNDAMENTALS

• Introduction to Data Science
• Principles of Data Modeling
• Data Science Techniques & Applications
• Data Extraction Methods
• Data Analysis Tools
• Data Visualization in Power BI
• Data Cleansing in Excel

DATA ANALYSIS TOOLS & TECHNIQUES

• Data Protection & Compliance
• Extract Data from Multiple Sources
• Data Science Techniques
• Application of Data Science Techniques to Excel Data
• Advantages & Disadvantages of Business Intelligence Tools like Power BI
• Creation of Data Structures for Data Science
• Statistical Analysis in Excel & Power BI

Data Visualization for Business Insights

• Create Dashboards in Power BI
• Generate Business Insights from published and shared Dashboards
• Present Business Reports & Insights to Target Audience

PowerBI Bar, Line, Column & Donut Charts

This WSQ Funded Data Analytics With Excel & Power BI course in Singapore teaches you how to get started into Data Analysis, use Statistical techniques in Excel, create Pivot Table Reports, and Visualize Data with Power BI Dashboards easily.

This course provides essential knowledge and skills relating to data analytics concepts, statistical analysis, data set preparation, data set summarization and data visualization successfully.

You will gain expertise in analyzing production data and chart future course of action confidently with these sophisticated Data Analytics Tools

Our objective is to train you to  be able to perform the following Data Analytics Tasks well:

• Understand the key concepts of data analytics in business
• Understand and apply key statistical analysis concepts
• Import data into a spreadsheet and prepare it for analysis using data cleansing and filtering techniques
• Summarize data sets using Pivot tables and Pivot charts.
• Understand and apply Data Visualization Techniques & Tools
• Create and Share Interactive Reports & Dashboards with the Best Data Visualization Tool – Power BI

HIGHLY Recommended for People who want to Upgrade themselves & Move to the Next Level

Prerequisites: Basic knowledge of PC skills, Microsoft Excel, and Windows and an open mind, interested in exploring and learning new things. Prior knowledge of Power BI is not required.

Certification: Successful trainees will receive the WSQ Certificate of Attainment for Data Analytics from SSG. Students must pass 120 minutes of written and practical assessment at the end of the Data Analytics training course to qualify for the Grants & Certification.

Learners’ Profile:

1. Any learner with a basic proficiency in reading, writing, and understanding English, basic knowledge of Excel can pick up the Data Analytics Skills with Power BI
2. We look for participants with Secondary education as a per-requisite
3. Participants should have completed the Basic PC Skills training, Basic Excel Training and be familiar with Windows operating system.

Course Duration:  2 full days

Course Timings: 8.45 am – 5.45 pm

Target Audience: For beginners in Data Analytics, or even complete newbies to Power BI.

You will learn the initial steps in understanding and analyzing data, using statistical analysis, importing large datasets from Excel, Websites or Databases, shaping data with formulas & functions, aggregate it with Excel Pivot Tables, create Frequency Distributions and finally create Dashboards to visualize it with amazing charts in Power BI.