Microsoft Office Course: Bridging Big Data Analytics using Excel & Power BI
Nett Course Fee
$981.00
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.
Prerequisites
To enrol in this course, you should possess the following:
- (≥ 16 years old); or
- 1 year working experience
You must have attended Excel Advanced course or has been using Excel for the past three years continuously, with working knowledge on Excel formulas and functions, manage data sets and Pivot Tables.
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 Name | Course Code | Venue | January 2025 | February 2025 | March 2025 | April 2025 | May 2025 | June 2025 |
---|---|---|---|---|---|---|---|---|
Bridging Big Data Analytics using Excel & Power BI | ASKBB8 | Hotel | 13-14 | - | 24-25 | - | 07-08 | - |