Microsoft Power BI (Basic to Intermediate)
Data Analytics
Course Overview
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, and 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. In addition, scale across the enterprise, with governance and security built-in.
Duration: 2 days / 16 hours
Delivery Method: Classroom-based, Virtual Instructor Led Training
TARGET AUDIENCE
Data Analyst, Sales, Human Resource, Admin Executives
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: CONNECTING TO DATA USING POWER BI DESKTOP
· Setting up Power BI Properties
· The Power BI Interface and Workflow
· Types of Data Connectors
· The Query Editor Interface
· Basic Table Transformations
MODULE 2: DATA SHAPING WITH QUERY EDITOR
· Text-Specific Tools
· Number-Specific Tools
· Date-Specific Tools
· Index and Conditional Columns
· Grouping and Aggregating Data
· Merging Queries
· Appending Queries
· Appending Queries from a Folder
MODULE 3: QUERY EDITOR CONFIGURATIONS
· Data Source Settings
· Query Refresh Settings
· Additional Types and Categories
· Defining Hierarchies
· Column Quality and Profile
MODULE 4: INTRODUCTION TO DATA MODEL
· What is a Data Model?
· Database Normalization
· Data Tables vs Lookup Tables
· Relationship vs Merge Tables
MODULE 5: CREATING TABLE RELATIONSHIPS
· Star Schema
· Snowflakes Schema
· Managing and Editing Relationships
· Active vs Inactive Relationships
· Relationship Cardinality
· Connecting Multiple Tables
· Understanding Filter Flow
· Hiding Fields from Report View
MODULE 6: MEET DATA ANALYSIS EXPRESSIONS (DAX)
· Introduction to Calculated Columns and Measures
· Adding Columns and Measures
· Implicit and Explicit Measures
· Using Quick Measures
· Filter Context Samples
MODULE 7: DAX SYNTAX AND OPERATORS
· Common DAX Functions and Categories
· Basic Date and Time Functions
· Basic Logical Functions
· Text Functions
MODULE 8: ADVANCED-DATA ANALYSIS EXPRESSIONS
· Joining Data with Related
· CALCULATED Function
· CALCULATE and ALL Function
· CALCULATE and FILTER Function
· Iterator X Functions
MODULE 9: INTRODUCTION TO REPORTS AND DASHBOARDS
· The Report View
· Inserting Basic Charts and Visual
· Formatting Options
· Report Filtering Options
· Matrix Visuals
· Bar and Column Chart
· Text and Date Slicers
· Cards
· Map Visuals
· Line and Area Charts
· Pie and Donut Chart
MODULE 10: PERFORM REPORT ANALYSIS
· Explore statistical summary.
· Use the Analyze feature.
· Smart Narratives
· Explore Q and A Visuals
· Forecast and Trendlines
REGISTER NOW
