Power BI for Excel Users
Details
Overview
The main purpose of the course is to review the essential skills needed to take data from Excel into Power BI then transform and shape the data, model the data, create reports, then publish the reports on the Power BI cloud service.
Targeted Audience
The course is individuals who are not IT professionals but need to easily create and publish reports with Power BI.
Prerequisites
Before attending this course, students should have experience creating worksheets in Excel. Familiarity with Pivot Tables is a plus, but is not required.
Outline
Getting started
Introducing Power BI
Using Power BI
A quick look at Power BI Desktop
A quick look at the Power BI service
Power BI and Excel
Introduction to using Excel data in Power BI
Upload Excel data to Power BI
Import Power View and Power Pivot to Power BI
Getting Data
Overview of Power BI Desktop
Getting started with Power BI Desktop
Connect to data sources in Power BI Desktop
More advanced data sources and transformation
Shaping and Transforming Data
Introduction to the Query Editor
Clean and transform your data with the Query Editor
Cleaning irregularly formatted data
Modeling
Introduction to modeling your data
How to manage your data relationships
Create calculated columns
Optimizing data models
Create calculated measures
Create calculated tables
Explore your time-based data
Introduction to DAX
DAX calculation types
DAX functions
Visualizations
Introduction to visuals in Power BI
Create and customize simple visualizations
Modify colors in charts and visuals
Shapes, text boxes, and images
Page layout and formatting
Group interactions among visualizations
Visual hierarchies and drill-down
Using custom visualizations
R integration in Power BI Desktop
Publishing and Sharing
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
Install and configure a personal gateway
Introduction to content packs, security, and groups
Publish Power BI Desktop reports
Print and export dashboards and reports
Manually republish and refresh your data
Create groups in Power BI
Schedules
| Thu, Fri, Sat | 10:00 AM — 04:00 PM |
| No. of Days: | 3 |
About Us
McTimothy Associates Consulting LLC is a Professional Management consulting, Human Capital Management, and Business Training company, incorporated in Nigeria with the Corporate Affairs Commission (CAC). Our Corporate office is centrally located at Gbagada Estate Phase 2 Estate, connecting easily to both Lagos Island and Lagos Mainland. We are enabling business greatness in Africa through cutting-edge modern management practices of Business transformation, Strategy, Change management and Innovation, Leadership, Restructuring and Turnaround management, and Training solutions.
Our Philosophy is an enduring commitment to enabling businesses and the professional greatness of our clients every day. Both organizations and individual employees who have attended our indoor and outdoor management development training programs have benefited tremendously in a number of ways. We also maintain relevant accreditations/partnerships with:
- Institute of Management Consultants (IMC).
- Institute of Professional Recruitment Consultants (IPRC), Nigeria
- Association of Professional Recruitment Consultant (APRC) UK
- Nigeria Institute of Training and Development (NITAD),
- Centre for Management Development (CMD), ...
Related Courses
