2
Dec 2019

Data Analytics Using Microsoft Power BI

Course Information

Start Date2 Dec 2019, Monday
End Date3 Dec 2019, Tuesday
Time9am to 5pm
Venue100 Orchard Road, Concorde Hotel Singapore 238840
Fee$990 (excluding GST) Inclusive of refreshments, lunch, and course materials
ContactRoshini | 6720 3333 | roshini@aventisglobal.com
Register Now
Get Group Quote
Download Directory

Course Schedule

2 & 3 Dec 2019 NEW

10 & 11 Mar 2020

18 & 19 Jun 2020

(Click on the dates above to register online)

INTRODUCTION

Power BI is a cloud-based business analytics tool that requires no capital expenditure or infrastructure support regardless of the size of the business. It aims to provide end-users with interactive visualisations and business intelligence capabilities with an easy-to-use interface to create reports and dashboards. Power BI is also capable of seamless integration with existing applications, extracting business intelligence rapidly and accurately, publishing reports securely, and its lack of memory and speed constraints. This 2-day course aims to help you understand key concepts of Power BI by analysing, visualising, and reporting data using the data analytics tool by Microsoft, Power BI. You will learn how to connect your data, import your data, author reports, publish reports, create dashboards, and share with other business users so that they are able to utilise the business intelligence gathered in dashboards on both the web and mobile application. This course also covers the latest tools to monitor your business growth and get immediate insights on any device.

Course Highlights

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

  • Perform Power BI desktop data transformation
  • Describe Power BI desktop modelling
  • Create a Power BI desktop visualisation
  • Implement the Power BI service
  • Describe how to connect to Excel data
  • Describe how to collaborate with Power BI data
  • Connect directly to data stores
  • Describe the Power BI mobile app
Target Audience
  • Business Analysts and Data Analysts
  • BI Professionals and SQL Professionals
  • Business Intelligence Developers
  • Individuals who fulfil the prerequisites and are keen in using Power BI for data visualisation
Prerequisite

Participants should have a basic knowledge of data warehouse schema topology and Microsoft Office applications, especially Excel. Participants are required to bring a laptop.

Course Outline
  • Introduction to Self-Service BI Solutions
    • Introduction to Business Intelligence
    • Introduction to Data Analysis
    • Introduction to Data Visualisation
    • Overview of Self-Service BI
    • Considerations for Self-Service BI
    • Microsoft Tools for Self-Service BI
  • Introducing Power BI
    • Power BI
    • The Power BI Service
  • Power BI Data
    • Using Excel as a Data Source for Power BI
    • The Power BI Data Model
    • Using Databases as a Data Source for Power BI
    • The Power BI Service

 

  • Shaping and Combining Data
    • Power BI Desktop Queries
    • Shaping Data
    • Combining Data

 

  • Modelling Data
    • Relationships
    • DAX Queries
    • Calculations and Measures

 

  • Interactive Data Visualisations
    • Creating Power BI Reports
    • Managing a Power BI Solution

 

  • Direct Connectivity
    • Cloud Data
    • Connecting to Analysis Services

 

  • Power BI Mobile
    • Power BI Mobile Apps
    • Using the Power BI Mobile App
    • Power BI Embedded
Data Analyst: Sahil

Sahil is a seasoned data analytics entrepreneur, trainer, consultant, and content creator. His expertise and experience include Data Analysis, Design, Implementation, Administration and Support of Business Intelligence, OLTP (Batch Processing, Online Processing), OLAP, ETL, Data warehousing, DBMS and Data Modeling using SQL Server 2012/2008R2 /2008/2005, Informatica, MSBI, and Pentaho.

To date, Sahil has trained over 500 professionals worldwide on Microsoft Power BI, Tableau, Pentaho, Microsoft Business Intelligence, SQL Server, and Informatica. Aside from training, he has also been a consultant for the past seven years and has consulted for numerous businesses in India, USA, Malaysia, and South Africa. His clientele includes RHB Bank and Provant Health Solutions.