What is Power BI?
Power BI is a suite of business analytics tools that deliver insights throughout your organization. Connect to hundreds of data sources, simplify data prep, and drive ad hoc analysis. Produce beautiful reports, then publish them for your organization to consume on the web and across mobile devices. Everyone can create personalized dashboards with a unique, 360-degree view of their business. And scale across the enterprise, with governance and security built-in.
Objectives:
At the end of this course the student must be capable on the following skillsets
• Connecting and Shaping data using Query Editor
• Creating a Data Model by connecting tables with BI relationship tools
• Creating DAX , Measures and Calculated Columns for Data Analytics
• Create Dynamic Dashboards using Power BI Visuals
Course Outline
Module 1: Meet Microsoft Power BI
• Setting up Power BI Properties
• The Power BI Interface and Workflow
• Helpful Resources
Module 2: Introduction on Query Editor
• Types of Data Connectors
• The Query Editor Interface
• Basic Table Transformations
Module 3: Data Shaping with Query Editor
• Text-Specific Tools
• Number-Specific Tools
• Date-Specific Tools
• Creating a Rolling Calendar
• Index and Conditional Columns
• Grouping and Aggregating Data
• Pivoting and Unpivoting Data
Module 4: Advanced Query Editor
• Merging Queries
• Appending Queries
• Appending Queries from a Folder
Module 5: Query Editor Configurations
• Data Source Settings
• Query Refresh Settings
• Additional Types and Categories
• Defining Heirarchies
• Importing Models from Excel Power Tools
Course Recap: Data Connection Best Practices
Course Work Exercise 1: Connecting & Shaping Data
Module 6: Introduction to Data Model
• What is a Data Model?
• Database Normalization
• Data Tables vs Lookup Tables
• Relationship vs Merge Tables
Module 7: Creating Table Relationships
• Star Schema
• Snowflakes Schema
• Managing and Editing Relationships
• Active vs Inactive Relationships
• Relationship Cardinality
Module 8: Connecting Multiple Tables
• Understanding Filter Flow
• Two Way Filter Flow
• Hiding Fields from Report View
Course Recap: Data Model Best Practices
Course Work Exercise 2: Creating a Data Model
Module 9: Meet Data Analysis Expressions (DAX)
• Introduction to Calculated Columns and Measures
• Adding Columns and Measures
• Implicit and Explicit Measures
• Filter Context Samples
• Step by Step Measure Calculation
Module 10: DAX Syntax and Operators
• Common DAX Functions and Categories
• Basic Date and Time Functions
• Basic Logical Functions
• Text Functions
Module 11: Advanced Data Analysis Expressions
• Joining Data with Related
• Math and Stats Functions
• COUNT Functions
• CALCULATED Function
• CALCULATE and ALL Function
• CALCULATE and FILTER Function
• Iterator X Functions
• DAX Time Intelligence Formulas
Course Recap: DAX Best Practices
Course Work Exercise 3: Adding Calculated Fields
Module 12: Introduction to Reports and Dashboards
• The Report View
• Adding Simple Objects
• Inserting Basic Charts and Visual
• Formatting Options
• Report Filtering Options
Module 13: Different Visuals in Power BI
• DEMO: Matrix Visuals
• DEMO: Date Slicers
• DEMO: Cards and KPI’s
• DEMO: Text Cards
• DEMO: Map Visuals
• DEMO: Tree Maps
• DEMO: Line and Area Charts
• DEMO: Trend-lines and Forecast
• DEMO: Gauge Charts
Module 14: Dashboard Configurations and Settings
• Editing Report Interactions
• Adding Drill-through Filter
• Adding Report Bookmark
• Adding What-if Parameter
• Managing and Viewing Role
• Preview: Custom Visual
• Preview: Publishing to Power BI Services
Course Recap: Data Visualization Best Practices
Course Work Exercise 4: Visualizing Data with Reports
Create a Complete Project using Power BI Tools