Power BI Basic Training Course

This course offers a complete, in-depth introduction to Microsoft Power BI tool by providing hands-on experience using Excel spreadsheets. During this course, users will be introduced to Power BI products and features essential to develop a BI solution.

Get Schedule

What is Included With The Microsoft Power BI Course

Small Class Size

Developed and Guided Learning Content

Certificate of Attendance

Highly Skilled Trainers

Our Price Beat Guarantee

Email Support

About This Course?

This course offers a complete, in-depth introduction to Microsoft Power BI tool by providing hands-on experience using Excel spreadsheets. During this course, users will be introduced to Power BI products and features essential to develop a BI solution. This course also bridges the gap between Excel and Power BI and lays the foundation for the advanced courses.

Prerequisite :

This course is suitable for people having an experience in Excel functions such as VLOOKUP. Prior knowledge of Power BI or any other reporting tool is not required. However, familiarization with business terminologies such as revenue and profit is a plus.

Who should take this course?

This course is suitable for Excel users who want to develop a fully interactive and visually appealing BI solution. This course is also suitable for SQL (or similar database) users who want to enhance their reporting by using state-of-the art BI tools.

Course Duration: 1 Day

Skill Level:  Basic

Add-ons:

  • Small Class size
  • Developed and Guided learning content
  • Completion certificate
  • Taught by Industry Pros
  • Free re-sit
  • Email support
  • Member card to participate in hackathon event

Training Cities:

  • Sydney, Melbourne, Brisbane, Canberra, Adelaide, Perth

Ticket Price:  

  • $385 incl GST

Early Bird Discount

Book and pay 1 month in advance to save 10%, Register and pay for 3 or more people at the same time to receive 25%+ disc.

Register now

Learning Experience

Throughout the training program, you will learn and practice a variety of skills such as data cleaning, data transformation, basic data visualization and dashboard sharing.

Start your learning journey with this basic training course and understand the extensive and powerful capabilities of Microsoft Power BI.

Course Outline

  1. Introduction To Business Intelligence
  2. Importance Of Business Intelligence In Organizations
  3. How Bi Insipres Efficient Decision Making
  4. Inefficient Business Processes
  5. Discover New Opportunities

Types Of Bi

  1. Managed Bi
  2. Partially Managed Bi
  3. Self-Service Bi
  • Getting Raw Data
  • Data Transformation
  • Data Modeling
  • Data Enrichment
  • Visualization
  • Sharing And Collaboration
  • Introduction To Power Bi
  • Comparison Of Traditional Bi Vs. Self-Service Bi
  1. Loss Of Valuable Time And Resources
  2. Data Explosion And Multiple Email Exchanges
  3. Working With Repetition And Outdated Data
  • How Does Power Bi Solve These Problems?
  1. Direct Connectivity Using Power Bi Data Connectors
  2. Automated Data Transformation
  3. Efficient Data Processing
  4. Instantaneous Updates And Permission Control
  5. Powerful Business Insights On The Run!

  • Power Bi Desktop
  • Power Bi Service
  • Power Bi Report Server
  • Power Bi Mobile
  • Power Bi Licensing Options
  1. Power Bi Free Vs. Power Bi Pro
  2. Power Bi Premium
  • Competitors Of Power Bi
  • Competitive Advantages Of Power Bi
  • Getting Started With Power Bi
  1. Setting Up Office365 Enterprise E3 Trial Account
  2. Signing Up For Power Bi Pro
  3. Downloading Power Bi Desktop
  • Exploring Power Bi Desktop Navigation
  • Ribbon Menu
  • Tab Menu
  • Visualizations And Fields Pane
  • Power Query Editor
  • Query Editor Ribbon Menu
  • Getting Data From Data Sources
  1. File
  2. Database
  3. Power Bi
  4. Azure
  5. Online Services
  6. Other
  7. Getting Data From Website
  8. Getting Data From Access Database
  9. Getting Data From Azure Database
  10. Getting Data From Sql Database Using Sql Statements
  • Getting Data From Excel
  • Selecting Queries Via Navigator
  • Removing Blank Rows From The Top
  • Using First Row As A Header
  • Removing Blank Columns And Choosing Relevant Columns
  • Renaming Column Names
  • Selecting The Right Data Types
  1. Number Data Types
  2. Date/ Time Data Types
  3. Text Data Type
  4. Boolean Data Type
  5. Changing Data Type
  6. Formatting The Data Type
  7. Data Categories
  8. Address/City/Continent/Country/Region
  9. Latitude/Longitude
  10. Place/Postal Code/State Or Province
  11. Web Url/Image Url
  12. Barcode
  13. Changing The Data Category
  • Data Cleaing
  1. Removing Errors
  2. Cleaning And Trimming The Text
  3. Correcting Spelling Mistakes
  • Data Wrangling
  1. Adding Year Column & Filtering Out Data Based On Condition
  2. Filling Down
  3. Splitting Column By A Delimiter
  4. Changing Case Of A Column
  5. Filtering Out Data Based On Product Line
  6. Removing Duplicates
  • Merge Query And Expanding Table
  • Exploring And Editing Applied Steps
  1. Renaming And Changing Property Of An Applied Step
  • Checking Repeatable Workflows
  • Exploring Code Behind Every Step & Advanced Editor
  • Understanding Data Modeling
  • Primary Keys (Or A Unique Identifier) And Foreign Keys
  • Deleting Relationships
  • Hiding Datasets And Fields
  • Creating New Relationships
  1. Pin & Drag
  2. Manage Relationships
  3. Editing Relationships
  • Cardinality And Cross Filter Direction
  • Why Is A Data Model More Efficient Than A Flattened Data Set?
  • What Is Dax?
  1. Defining Calculated Columns
  2. Defining A Calculated Measure
  • What Is Data Visualization?
  1. Canvas
  2. Visualization Panel
  3. Fields Panel
  • Creating A Default Visual (Table)
  1. Formatting A Table
  • Creating And Formatting A Column Chart
  • Line Chart
  • Pie Chart
  • Card Visual
  • Filled Map Visual
  • Bar Chart
  • Matrix
  • Treemap Visual
  • Bubble Map Visual
  • Getting Custom Visuals From The Store
  • Creating A Custom Visual: Sankey Chart
  • Creating A Custom Visual: Radar Chart
  • Understanding Visual Interaction
  • Visual Interaction States
  • Editing Visuals Interaction
  • Creating And Formatting A Slicer
  • Types Of Filters
  1. Visual Level Filter
  2. Page Level Filter
  3. Report Level Filter
  4. Drillthrough Filter
  • Editing Visual Level Filter
  • Adding New Visual Level Filter
  • Applying Page Level Filter
  • Applying Report Level Visual
  • Applying Top N Visual
  • Drillthrough Filters
  • Custom Visuals: Enlighten World Flag Slicer
  • Custom Visuals: Chiclet Slicer
  • Focus Mode
  • Export Data/Show Data
  • Spotlight
  • See Records
  • Exclude/Include Records
  • Page Options
  • Inserting Image And Text Box
  • Phone Layout
  • Help And File Options
  • Guided Learning
  • Documentation
  • Training Videos
  • Power Bi Blog Andcommunity
  • Community Gallery
  • Submit An Idea
  • Solution Templates
  • Workspace
  • Introduction To Samples
  • Getting The Sample Reports
  • Learning From Samples
  • Overview Of Q & A
  • Creating A Visual Using Q&A
  • Using Aggregations And Visuals
  • Some Other Examples Of Q & A
  • What Is Power Bi Service
  • Datasets
  • Reports
  1. Changing The Report View
  2. Editing The Existing Report
  3. Publishing Report To Web
  4. Generating A Qr Code For Report
  • Dashboards
  1. Pinning Visuals To Dashboard
  2. Navigation & Tools Of Dashboard
  3. Navigation & Tools Of Dashboard Explained
  4. Difference Between A Report And A Dashboard
  • Workbooks
  • Understanding The Navigation
  • Working With Filters
  • Export To Power Point
  • Getting Data Directly In Power Bi Service
  • Content Packs
  • Databases
  • Online Services
  • Files
  1. Converting Excel File To A Table
  2. Importing / Uploading Excel File In Power Bi Service
  • Data Source
  • Page
  1. Interactive Visuals
  2. Pinning Slicers
  3. Natural Language
  4. Adding Tiles And Creating Alerts On Card Tile
  5. Testing The Alert
  6. Pinning A Live Page
  • Customizing Dashboard For Mobile View
  1. Sharing Dashboard
  • Introduction To Quick Insights
  • Generating Quick Insights For Our Sales Report
  • Generating Quick Insights For A Visual
  • What Is Power Bi Publisher?
  • Downloading Power Bi Publisher For Excel And Enabling Power Bi Publisher For Excel
  • Pinning A Visual From Excel To Power Bi
  • Updating Visuals
  • Signing In To Power Bi Mobile
  • Working With Power Bi Mobile Dashboard
  • Annotating And Sharing A Visual
  • Working With Power Bi Mobile Reports

Power BI Basic Training Schedule

Events Schedule:

Location: Level 11, 32 Walker Street, North Sydney , NSW 2060

Time: 9:00 Am to 5:00 PM

Training Dates: 

  • 13 February 2020
  • 26 February 2020
  • 10 March 2020
  • 1 April 2020
  • 17 April 2020
  • 28 April 2020
  • 12 May 2020
  • 02 June 2020
  • 24 June 2020

Register For Training in Sydney

Events Schedule :

Location: Level 12, 379 Collins Street, Melbourne , VIC 3000

Time: 09:00 AM to 5:00 PM

Training Dates: 

  • 18 February 2020
  • 04 March 2020
  • 20 March 2020
  • 09 April 2020
  • 27 April 2020
  • 20 May 2020
  • 11 June 2020
  • 26 June 2020

Register For Training in Melbourne

Event Schedule For Brisbane: 

Location: Level 6, 371 Queen Street, Brisbane , QLD 4000

Time: 09:00 AM to 05:00 PM

Training Dates: 

  • 17 Feb 2020
  • 26 Feb 2020
  • 28 Feb 2020
  • 11 March 2020
  • 3 April 2020
  • 22 April 2020
  • 11 May 2020
  • 1 June 2020
  • 23 June 2020

Register For Training in Brisbane

Events Schedule in Adelaide :

Location: 19 Young Street, Adelaide , SA 5000

Time: 09:00AM to 5:00 PM

Training Dates: 

  • 19 Feb 2020
  • 19 March 2020
  • 27 April 2020
  • 12 June 2020
  • 08 July 2020
  • 7 August 2020
  •  03 Sep 2020

Register For Training in Adelaide

Events Schedule: 

Location: Level 4, 54 Marcus Clarke Street, Canberra , ACT 2601

Time: 09:00 AM to 5:00 PM

Training Dates: 

  • 14 Feb 2020
  • 23 March 2020
  •  21 April 2020
  • 02 June 2020
  • 10 July 2020
  • 03 August 2020
  • 01 Sep 2020

Register Training in Canberra

Register For Sydney
Register For Melbourne
Register For Brisbane
Register For Adelaide
Register For Canberra

Why Power BI?

Business Intelligence Market

Worldwide Business Intelligence and Analytics market to grow to $22.8 billion in revenue in the next two years – Gartner

Jobs Opportunities

70 percent of the leading companies say that Analytics is integral to how they make decisions – IBM Survey

Career Growth

A Senior Business Intelligence Analyst can earn $89,000 in the United States – PayScale

Call Us: 041071609

Some of the companies that experienced Power BI Training With Our Trainers

1280px-Fujitsu-Logo.svg
schneider-electric-vector-logo
Department-of-Defence-Australian-Government
14cy-oil_search_reject
exxon-mobil-logo
C10000554
Previous
Next

Contact Us

Have Any Query? Feel Free to Contact Us



Contact Info

  • 38 Lucas Cct, Kellyville NSW 2155, Australia
  • 0410171609
  • info@amzconsulting.com.au
Facebook Linkedin

Public Training

What We Offer

We believe in catching up with the technological demands of industry by providing solution packs in the form of training.  We Offer Power Bi Training Courses In Sydney, Melbourne, Brisbane, Adelaide, Canberra, Perth And In-House Across Australia.

Close Menu
×
×

Cart