1 - Analyzing Data with Self-Service BI
Topic A: Data Analysis and Visualization for Business IntelligenceTopic B: Self-Service BI with Microsoft Power BI
2 - Connecting to Data Sources
Topic A: Create Data ConnectionsTopic B: Configure and Manage Data RelationshipsTopic C: Save Files in Power BI
3 - Performing Data Cleaning, Profiling, and Shaping
Topic A: Clean, Transform, and Load Data with the Query EditorTopic B: Profile Data with the Query EditorTopic C: Shape Data with the Query EditorTopic D: Combine and Manage Data Rows
4 - Visualizing Data with Power BI
Topic A: Create Visualizations in Power BITopic B: Chart Data in Power BI
5 - Enhancing Data Analysis
Topic A: Customize Visuals and PagesTopic B: Incorporate Tooltips
6 - Modeling Data with Calculations
Topic A: Create Calculations with Data Analysis Expressions (DAX)Topic B: Create Calculated Measures and Conditional Columns
7 - Creating Interactive Visualizations
Topic A: Create and Manage Data HierarchiesTopic B: Filter and Slice ReportsTopic C: Create Dashboards
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
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 services to perform numerical or general data analysis. They are responsible for connecting to cloud-based data sources, as well as shaping and combining data for the purpose of analysis. They are also 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.
To ensure your success in this course you should have experience managing data with a spreadsheet program such as Microsoft® Excel®, which you could obtain by taking the following Logical Operations courses.
Microsoft® Excel® for Office 365™ (Desktop or Online): Part 1 or Microsoft® Office Excel® 2019: Part 1
Microsoft® Excel® for Office 365™ (Desktop or Online): Part 2 or Microsoft® Office Excel® 2019: Part 2
Optionally, having experience with other data analytics tools, such as Google Analytics™ or Customer Relationship Management (CRM) systems such as Salesforce®, 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. The following courses are helpful but not required:
Google Analytics™: Foundation (Second Edition)
Database Design: A Modern Approach
Microsoft® Excel for Office 365™: Data Analysis with Power Pivot or Microsoft® Office Excel® 2019: Data Analysis with Power Pivot
Data Analysis and Visualization with Microsoft® Excel®