Power BI is a technology-driven business intelligence tool provided by Microsoft for analyzing and visualizing raw data to present actionable information. It combines business analytics, data visualization, and best practices that help an organization to make data-driven decisions. In February 2019, Gartner confirmed Microsoft as Leader in the "2019 Gartner Magic Quadrant for Analytics and Business Intelligence Platform" as a result of the capabilities of the Power BI platform.
Power BI
- Data Professionals
- Business Intelligence Professionals
- Develop reports
1. Introduction to Power BI
• Power BI
• Sample Data
• Power BI -Phases in Development
2. Connecting to Data Sources
• Data Source
• Connection Modes, Import, Direct Query, Mixed Mode, Connect Live
• Importing Data
3. Data Preparation with Power BI (Transformation)
• Splitting Columns
• Renaming Columns
• Adding Columns
• Removing Columns
• Changing Data Type
• Transformation Steps
- Renaming an applied step
- Viewing transformation step changes
- Adding a step between an applied step
- Reordering applied step
- Editing an existing step
- Deleting an applied step
4. Modelling the Data
• Relationships in Data Modeling, Identifying Key Columns in Power Query
- Primary Key
- Foreign Key, Identify schema type
- Star Schema
- Snow flaw Schema
5. Understanding Relationships in Power BI
• Creating Relationships in Power BI
• Creating Calculated Columns and Measures with DAX, Calculated Tables, Calculated Columns, Measures, Quick Measures, Time Intelligence
6. Reporting on the Data – Creating Visualization
• Building Basic Visualizations
• Visualization Interactivity Custom
7. Custom Visuals in Power BI
• Getting Custom Visuals from AppSource
• Removing Custom Visual
8. Publishing to Power BI Service
• Create workplace
• Adding user
• Assign Role to User
After completing this course, you will be able to:
1. Understand the basics of information design
2. Understand the how’s and why’s of data visualization
3. Know which charts, graphs and visualizations to use with which data
4. Know which data to choose for a given scenario
5. Understand the differences between visualizing numerical and non numerical data
6. Understand how to interpret graphs and charts
7. Know which tools and techniques to apply and when
8. Understand the application of Storytelling with Data
9. Understand how to create compelling dashboard and visualizations
10. Have a good understanding of various benefit of business intelligence