+65 8133 0642 / +65 9138 9813 info@xaltius.tech

Data Analysis with PowerBI

This is a beginner to intermediate course to understand the nuances of data storytelling along with visualizing using charts and dashboards on PowerBI.

What You’ll Learn

This dashboard in a day – Power BI course provides students with the knowledge and skills to work with and analyse data using Power BI. This workshop will allow participants to use Power BI Desktop to connect to various data sources, shape that data, and use that model to create reports. Through this Power BI workshop, students can learn that Power BI Desktop centralizes, simplifies, and streamlines what can otherwise be a scattered, disconnected, and arduous process of designing and creating business intelligence repositories and reports.

Please click the event link in the timetable for the respective price.

Course Plan

MODULE 1: INTRODUCTION TO BI SOLUTIONS
  • Introduction to business intelligence
  • Introduction to data analysis
  • Introduction to data visualization
  • Overview of self-service BI
  • Considerations of self-service BI
  • Microsoft tools for self-service BI
  • Labs
MODULE 2: INTRODUCTION TO POWERBI
  • Power BI
  • Power BI Service
  • Labs
MODULE 3: POWERBI DATA
  • Using Excel as a PowerBI data source
  • Using databases as a PowerBI data source
  • Power BI service
  • Labs
MODULE 4: SHAPING AND COMBINING DATA
  • Power BI desktop queries
  • Shaping data
  • Combining data
  • Labs
MODULE 5: MODELLING DATA
  • Relationships
  • DAX queries
  • Calculations and measures
  • Labs
MODULE 6: INTERACTIVE DATA VISUALIZATIONS
  • Creating Power BI reports
  • Labs

Timetable

June 27th, 2020Click here to register

Prerequisites

Basic knowledge of Excel and tables would be beneficial for this workshop.

About the Course

Data Storytelling & Visualization with PowerBI is a beginners to intermediate course in understanding how to use the tool to create amazing visualizations to explain data to managers, stakeholders and fellow peers.

Attendees will better understand how to:

  • Connect to, import, and transform data from a variety of sources
  • Define business rules and KPIs
  • Explore your data with powerful visualization tools
  • Build stunning reports
  • Share your dashboards with your team and/or the world

Relevant Courses

Data Literacy – Let the data journey begin!

Data Literacy Before embarking on the data journey, organizations need to be equipped with the right skills and be data literate. This course walks through that journey and empowers individuals with the skills required to get an organization ready. What You'll...

read more

Excel VBA for Beginners

In order to increase office productivity, we require to automate our business processes. In this training learn how VBA can be used to automate Excel tasks.

read more

Amazon Web Services and Introduction to DevOps

Cloud has become the go-to place today for storage, computation, security and many other services. The cloud is disrupting the analytics industry and taking over processes and applications by storm! This course helps you understand the fundamentals of AWS and DevOps Lifecycle.

read more