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

Educ8 Technology Logo

Big Data

Big Data is a word processing program designed for everyday use. Having the basic skills to use this program is a minimum requirement for new hires in most businesses.

by Educ8 Technology [Claim Listing ]
SIRIM Academy Logo

Big Data Analytics

In today’s digital economy, data can be found everywhere. But how much of these data are actually useful and valuable? Predictive analytics help organizations derives values from data by utilizing different tools and techniques.

by SIRIM Academy [Claim Listing ]
Mnosys Logo

Power BI Fundamental

In this course, we help you get started with this powerful toolset. It begins by covering the web-based Power BI service, explaining how to import data, create visualizations, and arrange those visualizations into reports.

by Mnosys [Claim Listing ]
Training Valley Logo

Data Analysis And Dashboard Reporting In Excel

Data Analysis and Dashboard Reporting in Excel course is offered by Training Valley. Leave your employees in our hands and we will return them completely equipped with enriched skill set, fresher attitude, world-class knowledge and impressive competency.

by Training Valley [Claim Listing ]
GKK Consultants Sdn Bhd Logo

Power BI

Gain a comprehensive understanding of Power BI and how to use it to create and share interactive data visualizations and dashboards along with advanced features and techniques, such as data profiling, fuzzy matching, and Python scripting.

by GKK Consultants Sdn Bhd [Claim Listing ]

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