Description
Discover the power of data visualization and reporting as you learn how to use Power BI tools effectively. Our experienced instructors guide you step by step through the process, from importing data to creating dynamic dashboards. Learn how to transform data into valuable insights and develop the skills needed to make data-driven decisions.
Whether you're interested in the basics or advanced features of Power BI, our training courses are flexible and adapt to your needs. Take control of your data and improve your analytical skills with Multimedi's Power BI courses
About Power BI
Power BI is Microsoft's Business Intelligence solution in the Office 365 environment. This software helps users connect to different data sources and create reports with different images to show the data in a comprehensive way.
Audience
This course is for anyone who wants to use Power BI to create reports on any data source.
Methods
Classic training with individual guidance. Practical exercises make it possible for students to become familiar with the possibilities of the product. Each participant performs the exercises at their own workstation.
Contents
- Get Started with Microsoft Data Analytics
- Data Analytics and Microsoft
- Introduction
- Overview of Data Analysis
- Roles in Data Analysis
- Tasks of a Data Analyst
- Getting Started with Power BI
- Introduction to Power BI
- Using Power BI
- Building Blocks of Power BI
- The common flow of work in Power BI
- Get Data into Power BI
- Get data from various data sources
- Introduction to getting data
- Get data from flat files
- Get data from relational data sources
- Get data from NoSQL
- Get data from applications
- Get data from Analysis Services
- Optimize Performance
- Select a storage mode
- Fix performance issues
- Optimize query performance
- Query folding
- Resolve data errors
- Identify and resolve data import errors
- Cleaning, Transforming, and Loading Data
- Shaping the data
- Identify column headers and names
- Shaping Table Structure
- Unpivot and Pivot columns
- Enhance the Data Structure
- Apply user-friendly value replacements
- Evaluate and Change Column Data Types
- Combine Multiple Tables into a Single Table
- Use Advanced Editor to Modify M Code
- Profiling the Data
- Profiling Data and Examining Structures
- Designing a Data Model in Power BI
- Introduction to Data Modeling
- Joins and Relationships
- Star Schedules
- Working with Tables
- Configure Table and Column Properties
- Create a Dates Table
- Relationships and Cardinality
- Create Many-to-Many Relationships
- Modeling Challenges
- Combine Queries
- Dimensions and Hierarchies
- Introduction to Dimensions and Hierarchies
- Role-playing Dimensions
- Creating new Hierarchies
- Flatten out of a Parent-Child Hierarchy
- Create Measures using DAX in Power BI
- Introduction to DAX
- Measures
- Calculated Columns
- Columns vs. Measures
- DAX Content
- Understanding Context
- The CALCULATE () Function
- Advanced DAX
- Using Relationships Effectively
- Semi-additive Measures
- Time Intelligence
- Create Reports
- Design a Report
- Introduction
- Design a Report Layout
- Choosing Effective Visualizations
- Adding Visualizations to Reports
- Import a Custom Visual
- Add to R or Python Visual
- Format and Configure Visualizations
- Basic Interactions
- Configure Conditional Formatting
- Design Report Navigation
- Design for Accessibility
- Enhance the Report
- Apply Slicing, Filtering, and Sorting
- Performance Tuning Reports
- Commenting on Reports
- Advanced Interactions and Drill-Throughs
- Adding Buttons, Bookmarks, and Selections
- Key Performance Indicators
- Publish and Export Reports
- Create Dashboards
- Create a Dashboard
- Introduction to Dashboards
- Add a Dashboard Theme
- Mobile View Set
- Real-time Dashboards
- Create a Real-Time Dashboards
- Configure Data Alerts
- Pin a Live Report Page to a Dashboard
- Enhance a dashboard
- Explore Data by Asking Questions
- Configure Data Classification
- Row-level Security
- Security in Power BI
- Security overview in Power BI
- Static Method
- Dynamic Method
Certification
Participation certificate: At the end of the training, participants will receive a certificate that they have completed this course.