Are you an individual who wants to join a public class?  CLICK HERE.
Are you a company representative who needs a proposal?  Please email [email protected]

MS PowerBI for Beginners

This course is designed to equip you with the knowledge and skills needed to harness the power of Power BI for data visualization, analysis, and reporting. From the basics of navigating the Power BI interface to data modeling techniques, the training will guide you in getting to know Power BI tools and features.

Objectives

• Navigate and setup Power BI to cultivate a deep understanding of Power BI's capabilities, empowering participants to harness its features effectively for data visualization and analysis tasks.
  
• Instill proficiency in designing and customizing a diverse array of visual elements, including charts, graphs, and interactive components, to convey data trends with clarity and precision.
  
• Define and implement data modeling concepts, including table relationships and key identifiers, to construct efficient and scalable data models

Training Methodologies

• Incorporate ample opportunities for hands-on practice with Power BI, allowing participants to apply theoretical concepts to real-world scenarios.
  
• Provide multiple opportunities for applying the topics they learned per chapter.
  
• Encourage participants to explore additional resources, such as online forums, community groups, and advanced training modules, to deepen their understanding.
  

1. The PowerBI Interface

• Setting Up PowerBI for First Time Use
• Understanding the PowerBI Interface

2. Using Power BI for Data Visualization

• Adding Simple Objects to the Power BI Canvas
• Basic Charts and Formatting Options
• Modifying Format of Visuals
  • Changing Colors of Elements
  • Editing Title
  • Editing and Modifying Values
  • Modifying for Mobile View
• Report Filtering Options
  • Using Basic Filter
  • Advanced Filter and Top N Filter
• Basic Matrix Visuals
• Modifying Tooltips
• Using Slicers
• Modifying Interaction of Visuals
• Basic Card Visual
• Publishing Reports

3. Connecting Data using Power Query

• Using the Query Editor
• Adding Conditional Columns
• Performing Text-Related Modifications
• Math Formulas in Power Query
• Using Power Query’s Date Tools
• Importing Data Using Folder Approach
• Managing Data Source Settings
• Formatting Data

4. Data Modeling using Table Relationships

• Introduction to Table Relationships
• Understanding Primary and Foreign Keys
• Creating Relationships between Data Sources
• Editing Table Relationships

Join a public class