Share Description
In this course, you will :
-
Enjoy CLEAR and CONCISE step by step lessons from a best selling Udemy instructor
-
Learn to create POWERFUL reports and dashboards with Microsoft Power BI with a few clicks of the mouse
-
Gain valuable INSIGHT and INTELLIGENCE from your business and marketing data in a FRACTION of the time of traditional spreadsheets
-
PUBLISH reports and dashboards on the Internet and view using laptops, tablets or smartphones in minutes
-
Learn to create Data Models and use the DAX Formula language to develop POWERFUL calculations
-
Easily create a wide range of GRAPHS and VISUALISATIONS using drag and drop technologies
-
Use the Power BI Q & A feature to easily ask QUESTIONS of your data and provide new insight
Syllabus :
1. Sign Up for Power BI
- Signing up for PowerBI
- Load Data into the Power BI Service
- Practical Activity
2. The Power BI Desktop
- Introduction to PowerBI Desktop Section
- Overview of Power BI Desktop
3. Creating Reports in Power BI Desktop
- Create Reports in Power BI Desktop Section
- Creating Tables in Power BI
- Table Styles and Formatting
- Matrix Visualization
- Tables and Matrixes Practical Activity
- Answers to Tables and Matrixes Practical Activity
- Changing the Method of Aggregation
- Methods of Aggregation Challenge
- Methods of Aggregation Challenge Completed
- Cards and Multi Row Cards
- Cards, Matrix and Multi Row Card Challenge
- Answers to Cards Challenge
- Percentage Calculations
- Filtering Data - Using Slicers
- Filtering Data - Visual Filters
- Filtering Data - Page Filters
- Filtering Data - Drill Through Filter
- Practical Activity - Filters
- Practical Activity Filters Completed
4. Graphs and Visualizations
- Clustered Column Graphs
- Stacked and 100% Graphs
- Column Graph Challenge
- Column Graph Challenge Completed
- Graph Options
- Trend Analysis Graphs
- Area Graphs
- Ribbon Graphs
- Additional Graphs
- Scatterplots and Bubbleplots
- Decomposition Tree
5. Interactive Dashboards
- Creating Interactive Dashboards
- Challenge - Create an Interactive Report
- Completed Challenge - How to Create an Interactive Report
- Publishing Reports to the Power BI Service
- Pinning Visualizations to Dashboards
- Mobile Reports
- App Workspaces
- Publishing an App
- Using Themes in Power BI
- Using Custom Visualizations
6. DAX Formulas
- DAX Calculated Columns
- Date Functions
- Formatting Dates
- Date Master Tables
7. DAX Measures
- Introduction to DAX Measures
- DAX Measures Practical Activity
- DAX Measures Activity Completed
- The =Calculate Formula
8. Relationships
- Relationships Section
- Creating and Managing Relationships in Power BI
- Relationship Calculations
9. Power BI Query Editor
- Basic Transformations
- Aggregating Data
