[Penang 2-Day] Powerful Data Analytics with Power BI for Beginner
Course Information
  • 20-Jul-2020
  • The Light Hotel, Prai
  • Jevanathan Dorsamy
  • English
  • RM 1190 RM 1090
    Until 15 Jul 2020
  • 9am - 5pm
The course covers the essential skills in Power BI, Extracting, Transforming and Loading data into the Data model and visualizing it with a rich set of Graphics, Charts, and Dashboards, these can be the shared with colleagues / peers or others with the Power BI Service and in many ways. Also covers Excel Data preparedness that can feed further to Power BI Desktop.

• At the end of this course Participants will be able to analyse data from different data sources and create their own datasets
• Participants will be able to comfortably work with the different tools of the Power BI universe and know how the different tools work together
• Participants will have the required knowledge to dive deeper into Power BI and find out more about its advanced features

The course is for individuals who are not IT professionals but need to easily create and publish reports with Power BI.
• People who never worked with Power BI and who want to understand how to use these tools
• Anyone who is interested in learning how to connect the different Power BI tools with each other
• People who want to understand how to create customized visuals with the Power BI Developer tool
• Anyone looking for a hands-on, project-based introduction to Microsoft Power BI Desktop
• Data analysts and Excel users hoping to develop advanced data modeling, dashboard design, and business intelligence skills
• Aspiring data professionals looking to master the #1 business intelligence tool on the market
• Students who want a comprehensive, engaging, and highly interactive approach to training
• Anyone looking to pursue a career in data analysis or business intelligence


Date: 20 - 21 July 2020 (Mon - Tue)
Time: 9.00am - 5.00pm
Venue: The Light Hotel, Prai


Early Bird Offer (before 1 July 2020) - RM 990
Special Offer (before 15 July 2020) - RM 1,090
Normal Fee - RM1,190

- Fee includes course Notes, Lunch, Refreshments/ Tea Breaks, Certificate of Completion & 6% Service Tax


- 15% overriding discount for SST2u Loyalty Card members


[01] Getting started
• Introducing Power BI
• A quick look at Power BI Desktop
• A quick look at the Power BI service
• Setting up Power BI Environment
o Installing Power BI Desktop
o Account setup for Power BI Services

[02] Power BI and Excel
• Introduction to using Excel data in Power BI
• Data Readiness in Excel
o Convert Text to Column Options in Excel
o Various Data pattern [ Word , pdf , Notepad ]
o PASTE As Options in Excel
o Cell Formatting , Table Formatting, Sorting & Filter
• Upload Excel data to Power BI

[03] Getting Data
• Available data sources in Power BI Desktop
• Connecting to data sources
• Get Data from Folder
o Handling multiple worksheets
• Get Data from CSV file

[04] Shaping and Transforming Data
• Introduction to the Query Editor
• Clean and transform your data with the Query Editor
• Cleaning irregularly formatted data
• Data categorization
• Relationship view
• Create and manage relationships in Power BI Desktop
• Common query tasks

[05] Modeling
• Introduction to modeling your data
• Optimizing data models
• Introduction to DAX [Calculation Types / Functions]
• Create calculated columns
• Create calculated measures
• Create calculated tables

[06] Visualizations
• Introduction to visuals in Power BI
• Create and customize simple visualizations
• Modify colors in charts and visuals
• Shapes, text boxes, and images
• Page layout and formatting
• Interactions among visualizations
• Visual hierarchies and drill-down
• Using custom visualizations

[07] Publishing and Sharing
• Introduction to the Power BI service
• Publish Power BI Desktop reports
• Create and configure a dashboard
• Share dashboards with your organization
• Quick insights in Power BI
• Ask questions of your data with natural language
• Create custom Q&A suggestions
• Create workspaces in Power BI
• Manually republish and refresh your data
• Print and export dashboards and reports
• Publish to web

[08] Power BI on Mobile Devices
• Understanding the mobile platform
• Dashboard / Report Visualization in Mobile screen



Jevanathan Dorsamy , Certified Project Manager and HRDF Certified Trainer, offering an extensive and versatile experience in various domain specializing in Software Development Life Cycle and Testing/Quality Assurance Methodologies.

He has been in Information Technology for more than 10 years. His extensive experience in Microsoft Products has paved the way for him to establish into training industry. He began with a Diploma In Information & Software Management (DISM - 2002) Microsoft’s Internet Solution Partner , Aptech Certified Computer Professionals (ACCP). Hecompleted his Degree of Bachelor of Sciences [Computer Science] at Periyar University, India. Subsequently, he obtained his Master of Sciences [Computer and Internet Applications] from the University Of Bedfordshire, United Kingdom.

In addition, he is certified in the following disciplines:
• ISEB/ISTQB Foundation Certificate In Software Testing
• Certificate in IT Infrastructure Library [ITIL] (V2)
• PRINCE2 [Foundation & Practitioner]

His training experience include:
• Conducted Microsoft Office Training [Excel, Word, Power Point, Access, Project, Publisher, Visio] for corporate and government candidates from various domain specifically Oil & Gas, Insurance, Production, IT Engineering
• Conducted Power BI with Excel on analyzing data
• Training for Agile Development & Testing for telecommunication domain
• Being an Continues Improvement Agent to implement Best Test Practice
• Training on Computer Networking for University / Institutions


Email: SSTcourse@gmail.com
General (03 - 8082 3357)
Teo (011 - 3178 9203)
Logesh (012 - 503 0346)
Siti (012 - 383 8603)
Han (019 - 323 0507)