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

Iconic Training Solutions Logo

Analyzing And Visualizing Data With Microsoft Power BI

Microsoft Power BI transforms your company data into rich visuals that facilitate new ways of thinking about and organizing your data, so that you can focus on what is important to achieving your goals.

by Iconic Training Solutions [Claim Listing ]
Centrilinc Logo

Enterprise Big Data Professional Certification

Enterprise Big Data Professional Certification course is offered by Centrilinc. User application software training has been one of our core business focus. Our application courses were developed, and are consistently updated to meet the current, and practical need of the local workforce.

by Centrilinc [Claim Listing ]
Mnosys Logo

Data Analysis And Interactive Dashboard Reporting

For those who are new to dashboards, it would be ideal to get an understanding of the dashboards first. In this chapter, you will get to know the definition of dashboard, how it got its name, how they became popular in IT, key metrics, benefits of dashboards, types of dashboards and more.

by Mnosys [Claim Listing ]
AA Knowledge Malaysia Sdn Bhd Logo

Big Data Analytics In Financial Fraud

Big Data Analytics in Financial Fraud course is offered by AA Knowledge Malaysia Sdn Bhd. We fill needs creatively and seek new ways of looking at old problems. By promoting learning, research, and education, we contribute to the advancement of education and training.

by AA Knowledge Malaysia Sdn Bhd [Claim Listing ]
Pahang Skills Development Centre Logo

Big Data Analytics

Big data analytics programs generally provide students with a comprehensive understanding of the tools, techniques, and technologies used to manage and analyze large and complex datasets.

by Pahang Skills Development Centre [Claim Listing ]

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