Microsoft Office Course: Bridging Big Data Analytics using Excel & Power BI

Course Description

In today’s corporate environment, fact-based data plays a big part in shaping key business decisions. We have seen reports, spreadsheets, and slide decks jostle for space in our email inboxes. Hence, it is demanding for our attention as part of our decision-making process. Are you feeling swamped by the huge volume of reports to be analysed before writing proposals to your bosses? Our 2-days ‘Bridging Big Data Analytics using Excel & Power BI course, which is accredited by SkillsFuture Singapore (SSG), can help you streamline your data analysis process.

How A Power BI Course Will Help?

Taking a Power BI course allows you to combine unrelated sources of data into interactive insights. You can transform endless rows and columns of numbers and words into colourful and visually appealing graphics. Eventually, you get to make your data narratives more impactful to the reader. In addition, you can set up alerts for yourself when data changes at the backend. Besides, you can set up automated reports to yourself via email at regular time intervals. This is to keep you notified of the latest data trends. Hence, you can stay abreast of changes and amend your presentations accordingly.

You can also share your data sources with anyone who needs access to them. For instance, you and your team open up the Power BI service interface on the browser or mobile device at the same time. All are able to work on the same dashboards and reports simultaneously. The updates can be refreshed automatically to ensure that you are constantly working on the latest data inputs.

This Power BI course also helps you remove any fear that tinkering on your end will affect original datasets and shared content. Eventually, you can have peace of mind knowing that you can switch the view of content or revert to the original default data easily. This is possible even after you filter, slice or export the data at your disposal on your browser.

Who Should Join This Power BI Course?
This course is for those who want to gain more knowledge about how to use Power BI tools and create customised visual reports. Moreover, BI and reporting professionals, data analysts, and professionals in Singapore working with data in any sector will also benefit from this power BI training course.

Course Objectives

At the end of this power BI course, you will be able to:

  • Recognize key terminology, phases, concepts and benefits of data analytics
  • Import, shape and clean up data set before analysis
  • Execute advanced summarization techniques with pivot tables
  • Set up Power BI Desktop
  • Create data visualizations to build and share reports
  • Build and share dashboards in Power BI Service

Course Outline

Overview of Big Data Analytics
  • Common terminologies
  • Key concepts and benefits
  • Main phases of data analytics
Importing and Shaping Data Set
  • Importing data
  • Eliminating duplicate records
  • Cleaning up data
  • Setting up tables
  • Filtering with slicers
Advanced Summarization using PivotTable
  • Changing method of aggregation
  • Displaying multiple aggregation
  • Displaying values using built-in calculations
  • Applying frequency analysis
  • Filtering with report filter, slicer and timeline
Setting Up in Power BI Desktop
  • Connecting to data sources
  • Establishing the data model
  • Clean and transform data
Creating Data Visualisations
  • Understanding reports and dashboards
  • Setting up common visualisations
  • Applying conditional formatting
Building and Sharing Reports
  • Setting up reports
  • Adding calculations and measures
  • Adding interactivity features
  • Creating summary charts
  • Publishing report to Power BI Service
  • Sharing report
Building Dashboards in Power BI Service
  • Creating and configure a dashboard
  • Sharing a dashboard
  • Setting password in Access
  • Compacting and repairing a database

Related Courses

Introduction to Microsoft Excel Power Query, Data Model, Power Pivot & DAX

This 1-day course is a top choice for individuals seeking comprehensive skills in managing extensive databases, providing training in powerful tools like Power Query, Data Model, Power Pivot, and DAX for advanced data modeling and business intelligence.

Course Duration:
1 Day (9.00am – 5.00pm)

View course details here

Visual Basic for Applications in Microsoft Excel – Fundamental

The ‘Visual Basic for Applications in Microsoft Excel – Fundamental’ course focuses on practical VBA programming skills to unlock spreadsheet potential, enhancing productivity through task automation and simplification, such as copying data between sheets or performing statistical functions across multiple sheets, addressing repetitive or intricate tasks effectively.

Course Duration:
1 Day (9.00am – 5.00pm)

View course details here

Bridging Big Data Analytics using Excel & Power BI

Course Duration:

2 Days (9.00am – 5.00pm)

Course Fee Details:

$981.00 (incl. of 9% GST)

Course Code: ASKBB8

Course Schedule

Course NameCourse CodeVenueJuly 2024August 2024September 2024October 2024November 2024December 2024
Bridging Big Data Analytics using Excel & Power BIASKBB8Hotel15-16-23-24-11-12-

Nett Course Fee