Prime Skill Academy

Next Class is now open for enrollees
Date : September 2, 2024
- Online training
-Face to Face
- One on One Session

DM to enroll!!!!

Be a professional data analyst

DM for more information

Enroll now!!!!

Enroll now!!!

Enrollment is now open

Last 3 Slot for tomorrow class
Class 18 : Monday August 19, 2024 to August 23, 2024
Morning Class : 8:00AM - 12:00PM
Night Class : 7:00PM - 11:00PM
Training Fee : 1000.00 PHP

Habol na po mga sir

Class 18 : Monday August 19, 2024 to August 23, 2024
Morning Class : 8:00AM - 12:00PM
Night Class : 7:00PM - 11:00PM
Training Fee : 1000.00 PHP

LAST 3 SLOT
Class 18 : Monday August 19, 2024 to August 23, 2024
Morning Class : 8:00AM - 12:00PM
Night Class : 7:00PM - 11:00PM
Training Fee : 1000.00 PHP

Class 18 : Monday August 19, 2024 to August 23, 2024
Morning Class : 8:00AM - 12:00PM
Night Class : 7:00PM - 11:00PM
Training Fee : 1000.00 PHP
Lesson 1: Getting Started
TOPIC A: An Introduction to Power BI
- What is Power BI?
- The Building Blocks of Power BI
- The Power BI Desktop Interface
- Important Information About Power BI Updates

TOPIC B: Working with Power BI Desktop Files
- Opening Files
- Saving Files
- Creating a New File
- Publishing to the Power BI Web App

TOPIC C: Connecting to Data Sources with Power BI Desktop
- Connecting to an Excel Workbook
- Connecting to an Access Database
- Viewing All Connection Options
- Creating a Manual Dataset
- Managing Data Sources

TOPIC D: Creating a Report with Visualizations
- Using the Visualizations Pane
- Using the Fields Pane
- Creating a Visualization
- Interacting with Visualizations
- Changing the Visualization Type
- Moving and Resizing Visualizations

TOPIC E: Doing More with Visualizations
- Formatting Visualizations
- Viewing Visualization Data
- Using Focus Mode and Spotlight
- Removing a Visualization

Lesson 2: Working with Data
TOPIC A: Transforming and Sanitizing Data
- Using Data View
- Cleaning Irregularly Formatted Data
- Managing Columns
- Sorting Table Data

TOPIC B: Using the Query Editor
- Opening the Query Editor
- The Query Editor Interface
- Using the Query Settings Pane
- Using Merge Queries
- Using Append Queries

TOPIC C: Data Modeling
- What is DAX?
- Creating a New Table
- Creating a New Calculated Column
- Creating a New Measure

TOPIC D: Managing Relationships
- Using the Relationships View
- Creating Relationships
- Editing Relationships
- Deleting Relationships
- Using the Manage Relationships Dialog

Lesson 3: Working with Reports and Visualizations
TOPIC A: Managing Report Pages
- Navigating Through Pages
- Showing and Hiding Pages
- Adding Pages
- Deleting Pages
- Renaming Pages
- Changing Page Order

TOPIC B: Changing Report View Options
- Setting Page View Options
- Customizing Your View
- Using Phone vs. Desktop Layout

TOPIC C: Working with Visualizations
- Understanding Drillthrough Options
- Changing Category and Summarization Options
- Arranging Visualizations
- Editing Interactions
- About Custom Visualizations

TOPIC D: Adding Static Objects to a Report
- Inserting Pictures
- Inserting Text Boxes
- Inserting Shapes
- Working with Static Objects

Lesson 4: A Closer Look at Visualizations

TOPIC A: Matrixes, Tables, and Charts
-Creating a Table
-Creating a Matrix
-Overview of Chart Types
-Creating Charts

TOPIC B: Maps
-Creating a Treemap
-Creating a Bubble Map
-Creating a Filled Map

TOPIC C: Cards, Gauges, and KPIs
-Creating a Card
-Creating a Gauge
-Creating a KPI

TOPIC D: Slicers
-Creating a Slicer
-Using Slicers
-Customizing Slicer Display
-Changing Slicer Mode
-Changing Slicer Orientation

Lesson 5: Introduction to the Power BI Web App

TOPIC A: Getting Started
-Opening the Power BI Web App
-The Web App Interface
-Web App Building Blocks
-Key Differences

TOPIC B: Connecting to Data Sources with the Power BI Web App
-Connecting to Local Data
-Connecting to Live Data
-Connecting to Content Packs
-Connecting to Samples

TOPIC C: Using Workspaces, Dashboards, and Reports
-Viewing and Managing Power BI Content
-Viewing a Workspace
-Viewing Dashboards and Reports
-Managing Reports

TOPIC D: Creating Custom Dashboards
-Creating a Dashboard
-Pinning Visualizations to a Dashboard
-Adding Custom Tiles
-Managing Dashboards

TOPIC E: Power BI Web App Features
-Using Insights
-Using Q & A
-Customizing Q & A Suggestions

• We also offer one on one session

Enroll now ! Be a certified expert!!

Enroll Now!!!

Class 10 : August 18, 2024
Morning : 9:00AM - 1:00 PM
Afternoon : 2:00PM - 6:00PM

* Also available in one on one tutorial

Microsoft Excel Day 2 : Advance Formulation VLookUp , XLookUp, Advance Pivoting