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

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