Course Details
Course Outline
1 - Analyzing Data with Self-Service BI
Data Analysis and Visualization for Business IntelligenceSelf-Service BI with Microsoft Power BI
2 - Connecting to Data
Create Data ConnectionsModel Data with RelationshipsSave Power BI Files
3 - Performing Advanced Data Modeling and Shaping
Clean and Transform Data with the Query EditorShape Data with the Query EditorCombine and Manage Data Rows
4 - Visualizing Data with Power BI
Create Visualizations in Power BIChart Data in Power BI
5 - Enhancing Data Analysis
Enhance Analysis with Customized Visuals and PagesEnhance Analysis with Tooltips
6 - Modeling Data with Calculations
Create Calculations with Data Analysis Expressions (DAX)Create Calculated Measures and Conditional Columns
7 - Creating Interactive Visualizations
Create and Manage Data HierarchiesFilter and Slice ReportsCreate Dashboards in Power BI
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
Target Audience
This course is designed for professionals in a variety of job roles who are currently using desktop or web-based data-management tools such as Microsoft Excel or SQL Server reporting server to perform numerical or general data analysis. They are responsible for conducting data analysis and providing reports about their analysis, and are looking for alternative ways to analyze business data, visualize insights, and share those insights with peers across the enterprise. This includes capturing and reporting on data to peers, executives, and clients.
Prerequisites
Other Prerequisites
To ensure your success, you should have experience managing data with a spreadsheet program such as Microsoft Excel or Google Sheets. Optionally, having experience with other data analytics tools, such as Google Analytics™ or Customer Relationship Management (CRM) tools, as well as an understanding of database design concepts and basic programming constructs such as looping and branching, will help you get even more out of this course.