Analysing & Visualising Data With Power Bi

by PM Resources Claim Listing

Transform, analyse and visualise data with Microsoft Power BI Desktop: hands-on demos, projects and 1-on-1 Power BI support. By the end of the Adventure Works project, not only will you have developed an entire business intelligence (BI) tool from the ground up using Power BI.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

PM Resources Logo

img Duration

2 Days

Course Details

Transform, analyse and visualise data with Microsoft Power BI Desktop: hands-on demos, projects and 1-on-1 Power BI support.

By the end of the Adventure Works project, not only will you have developed an entire business intelligence (BI) tool from the ground up using Power BI, but you will have gained the knowledge and confidence to apply these same concepts to your own Power BI projects.

 

Course Objective:

  • Build professional-quality business intelligence reports from the ground up
  • Blend and transform raw data into beautiful interactive dashboards
  • Design and implement the same BI tools used by professional analysts and data scientists
  • Showcase your skills with two full-scale course projects (with step-by-step solutions)
  • Understand the business intelligence workflow from end-to-end
  • Learn from a best-selling instructor and professional BI developer

 

Course Outline:

  • Module 1: Connect Ad Transform The Raw Data
  • Introduction to the Power BI Query Editor
  • Types of Power BI Data Connectors
  • Basic Table Transformations
  • Text, Number and Date Tools
  • Index and Conditional Columns
  • Grouping and Aggregating Data
  • Pivoting and Unpivoting
  • Modifying, Merging and Appending Queries
  • Connecting to Folders
  • Defining Hierarchies and Categories
  • Query Editing and Power BI Best Practices
  • Module 2: Build A Relational Data Model
  • Introduction to Database Normalisation
  • Data ("Fact") Tables vs. Lookup ("Dimension") Tables
  • Creating Power BI Table Relationships
  • "Star" vs. "Snowflake" Schemas
  • Active vs. Inactive Relationships
  • Relationship Cardinality
  • Connecting Multiple Data Tables
  • Filtering and Cross-Filtering
  • Hiding Fields from the Power BI Report View
  • Data Modeling and Power BI best Practices
  • Data
  • Module 3: Add Calculated Fields With Data Analysis Expressions (DAX)
  • Introduction to DAX
  • Calculated Columns vs. Measures
  • Row Context vs. Filter Context in Power BI
  • DAX Syntax and Operators
  • Common Power BI Functions
  • Basic Date and Time Formulas
  • Logical and Conditional Statements
  • Text, Math and Stats Functions
  • Joining Data with Related
  • Calculate, All And Filter Functions
  • DAX Iterators (SUMX, AVERAGEX)
  • Time Intelligence Formulas
  • DAX and Power BI Best Practices
  • Module 4: Design Interactive Power Bi Reports
  • Introduction to the Power BI Report View
  • Adding Basic Charts to Power BI Reports
  • Formatting and Filtering Options
  • Matrix Visuals
  • Slicers and Timelines
  • Cards and KPIs
  • Power BI Map Visuals (Basic, Fill, ArcGIS)
  • Treemaps, Lines, Areas and Gauges
  • Editing Report interactions
  • Adding Drillthrough Filters
  • Linking to Report Bookmarks
  • Using "What-If" Parameters
  • Managing and Viewing Roles
  • Preview: Publishing to Power BI Service
  • Power BI Data Viz Best Practices

 

Who Should Attend:

  • Anyone looking for a hands-on, projectbased 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 in 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

 

Prerequisite:

  • Microsoft Power BI Desktop (free download)
  • This course is designed for PC/Windows users (currently not available for Mac)
  • Experience with Excel Power Query, Power Pivot & DAX is a plus, but not required
  • Note: This is Part 1 of a 2-Part Microsoft Power BI series:
  • Up and Running with Power BI Desktop
  • Publishing to Power BI Service
  • Don't forget to complete PART 2 to learn Power BI Service and take your Power BI skills to the cloud!
  • Kuala Lumpur Branch

    Suite 7-5 Level 7 Wisma UOA II 21, Kuala Lumpur

Check out more Power BI courses in Malaysia

SENTRAL College Penang Logo

Mastering Power BI (A Comprehensive Guide for Data Analyst)

Discuss the various methods and best practices that are in line with business and technical requirements for modelling, visualizing, and analysing data. Explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups.

by SENTRAL College Penang [Claim Listing ]
AC Interactive Solutions Sdn Bhd (ACIS) Logo

Power BI (Analysing And Visualizing Data)

Power BI (Analysing and Visualizing Data) training is offered by AC Interactive Solutions Sdn Bhd (ACIS). Our passionate team of expert trainers is qualified and highly experienced in countless training fields.

by AC Interactive Solutions Sdn Bhd (ACIS) [Claim Listing ]
Tertiary Courses Malaysia Logo

Basic Microsoft Power BI Training

Microsoft Power BI is a suite of interactive data visualisation business analytics tools that deliver insights throughout your organization. You can use Power BI to connect to hundreds of data sources, simplify data prep, and drive ad hoc analysis.

by Tertiary Courses Malaysia [Claim Listing ]
  • Price
  • Start Date
  • Duration
Akademi Suria Logo

Data Analytics And Visualization

Data Analytics and Visualization course is offered by Akademi Suria. At the heart of Akademi Suria is our dedicated team of highly experienced trainers and staff members. They bring a wealth of knowledge and expertise to our training programs.

by Akademi Suria [Claim Listing ]
Instep Learning Asia Sdn Bhd Logo

Power BI Workshop

Power BI workshop is offered by Instep Learning Asia Sdn Bhd. As a registered training provider with PSMB, there is quality assured in every course designed by our training specialists.

by Instep Learning Asia Sdn Bhd [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy