Details
- What is Power BI?
- Security and administration
- Customer case study
- Power BI in action
2 Explore Power BI
- Using BI as a consumer
- View content in Power BI service
- Explore with dashboards, reports, and apps in Power BI
- Collaborate and share in Power BI
- Find and view dashboards and reports
3 Get started building with Power BI
- Use Power BI
- Building blocks of Power BI
- Tour and use the Power BI service
4 Analyse data in Power BI
- Filter data with Power BI
- View your data
- Ask questions of your data
- Apply filters to reports
5 Get data
- Overview of Power BI Desktop
- Explore Power BI Desktop
- Connect to data sources
- Get data from Excel
- Transform data to include in a report
- Combine data from multiple sources
- Clean data to include in a report
6 Model Data
- Introduction to modelling your data
- How to manage your data relationships
- Create calculated columns
- Optimize data models
- Create calculated measures
- Create calculated tables
- Explore time-based data
- Introduction to visuals in Power BI
- Create and customize simple visualizations
- Create slicers
- Map visualizations
- Matrices and tables
- Create scatter, waterfall, and funnel charts
- Modify colours in charts and visuals
- Page layout and formatting
8 Explore Data
- Introduction to the Power BI service
- Quick insights in Power BI
- Create and configure a dashboard
- Ask questions of your data with natural language
- Create custom Q&A suggestions
- Share dashboards with your organization
- Display visuals and tiles in full screen
- Edit tile details and add widgets
- Get more space on your dashboard
9 Publish and Share
- Introduction to content packs, security, and groups
- Publish Power BI Desktop reports
- Print and export dashboards and reports
- Introducing Power BI Mobile
- Create workspaces in Power BI
- Build apps
- Use apps
- Integrate OneDrive for Business with Power BI
- Publish to web
10 Importing files from PDF & Power Query
- Importing a table & transforming Data
- Merging Queries
- Appending Queries
- Transposing Tables
- Unpivoting Tables
11 Importing Data from the Web
- Importing from simple HTML tables
- Using Web Table Inference Feature
- Creating Query Parameters
12 Advanced Data Models and Queries
- Using the Calendar
- Changing Data Sources – M Language
- Drop Down Filters
- Using Parameters
- Using Tooltips
- Introduction to DAX
- DAX calculation types
- DAX functions
- Using variables in DAX expressions
- Table relationships and DAX
- DAX tables and filtering
14 Microsoft PowerBI Mobile
- Overview
- Getting Started
- Explore
15 Added content:
Power Query Course Schedule
- Transforming Data
- Cleansing Data
- Connecting to Data Sources
Schedules
| No. of Days: | 3 |
| Total Hours: | 18 |
Sankin Computer Training offers MICT Accredited end using computer training on the Microsoft Office Suite (all levels) to individuals and corporate clients countrywide.
Established in 2003, Sankin Computer Training was born from an Internet Café, where the founder of the business recognised a need for education in the private and public sector. Having a background of computer training for Quest Personnel, our private company, Sankin Computer Training soon took root and has grown from strength to strength.
Sankin Computer Training is designed to offer short, intensive, personalized courses that effectively present new concepts and techniques through interactive training methods. Small focused groups allow for individual attention and the practical application of theory.
We Offer:
Personal training venue in Glenwood, Durban for up to 8 delegates in a boardroom styled air-conditioned office with secure parking on site.
Training at your premises – we are equipped with 15 laptops and ready to travel, saving your company logistical arrangements and costs. We have enjoyed training all over South Africa this way, in both major cities and in outlying areas.
Flexible calendar – we prize ourselves on arranging our training times and dates according to your company and delegate’s requirements. ...
Related Courses
