17
Sep 2020

Data Analytics Using Microsoft Power BI (Live Stream)

Course Information

Start Date17 Sep 2020, Thursday
End Date18 Sep 2020, Friday
Time9.30am to 4.30pm
VenueOnline Live Stream via Zoom
Fee$900 (excluding GST)
ContactRoshini | 6720 3333 | training.aventis@gmail.com
Register Now
Get Group Quote
LIVE Stream

Course Schedule

10 & 11 Dec 2020

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.