AN OVERVIEW OF POWER BI
- The Road-Map:
- Massaging Data
- Reporting & Analysis
- From Excel to Business Intelligence
- Why use Power BI
- PowerPivot and PowerQuery
- Size, Formulas, and Multiple Sources
WORKING WITH HR DATA SHEETS AND SOURCES USING POWERPIVOT
- Getting data from multiple
- Managing multiple data sets
- Creating and managing measures
- Inserting functions
- Designing KPIs
- Performing advanced conditional formatting
- Understanding and working with Data Models
- Creating and managing relationships between different data sources
- Using Diagram View and Data View
GET AND TRANSFORM DATA
- Connecting to CSV, Excel, Access, HTML, and other courses
- Loading and transforming data
- Managing columns and rows
- Restructuring HR fields by splitting, grouping, and replacing data
- Transforming data, pivoting and unpivoting
- Combining different data sets
- Perform special formatting such as trim, clean, proper, upper, and lower
- Perform basic statistics
- Transform Date and Time fields
- Design conditional columns
- Create custom columns to perform special calculations
- Perform special Extract techniques to data
- Load and close data transformation
- Combine and append data sets
POWER BI: RULES OF ENGAGEMENTS
- Data Transformation using Power BI
- Working with Models, Data, and Reports
- Understanding Visualizations
- Working with Buttons, Images, and Shapes
- Working with Custom Visuals
- Designing Dashboard Themes
POWER BI: CREATE & FORMAT INTERACTIVE VISUALIZING
- Select different visualization types
- Configure page layout and formatting
- Configure interactions between visuals
- Configure duplicate pages
- Handle categories that have no data
- Configure default summarization and data category of columns
- Position, align, and sort visuals
- Enable and integrate visuals
- Format measures
- Use bookmarks and themes for reports
POWER BI: CONFIGURE DASHBOARDS, REPORTS & APPS IN THE POWER BI SERVICE
- Add text and images
- Filter dashboards
- Customize the URL and titles
- Enable natural language queries
- Publishing, share, and collaborate your reports and Dashboards
