Power BI

Languages
English + Hindi
Batch Size
20-22
Duration
10 hours
Investment
$$$$$
Request Training Proposal

Course Contents

  • Microsoft Power BI transforms your company data into rich visuals that facilitate new ways of thinking about and organizing your data, so that you can focus on what is important to achieving your goals.
  • Upon completing this course, learners will have a basic understanding of the topics covered in the syllabus below, as well as the ability to utilize and implement the concepts on-the-job.

Who should attend? This course is intended for Business Managers, Report Developers, Analysts, Project Managers and Team Leads.

Lesson 1: Power BI

  1. What is Power BI?
  2. Examining Power BI Suite of Products
  3. Identifying Differences Between Products
  4. Understanding Power BI Updates

Lesson 2: Power BI Desktop

  1. Installing Power BI Desktop
  2. Exploring the Power BI Desktop Interface
  3. Utilizing File Types; PBIX vs PBIT
  4. Examining Data Sources
  5. Discussing Data Refresh
  6. Understanding Data Types

Lesson 3: Working With CSV, TXT and Excel Worksheets

  1. Importing, Transforming, and Loading Data
  2. Appending Operations
  3. Working with Folders and Files
  4. Using Pivot Tables

Lesson 4: Connecting to Databases

  1. Working with Relational Data
  2. Understanding Relationships
  3. Importing from SQL Server Analysis Services Multidimensional and Tabular

Lesson 5: Merging, Grouping, Summarizing, and Calculating Data

  1. Understanding the Issues with Merges
  2. Performing Merges
  3. Grouping Options
  4. Summarizing
  5. Calculating

Lesson 6: Reporting

  1. Creating Reports
  2. Utilizing the Matrix Visualization
  3. Utilizing the Map Visualization
  4. Utilizing the Card Visualization
  5. Utilizing the Chart Visualization
  6. Utilizing Slicers
  7. Publishing to Power BI Online

Lesson 7: Power BI Online

  1. Introduction to Power BI Online
  2. Importing Data
  3. Creating Reports
  4. Configuring Dashboards
  5. Sharing Reports and Dashboards
  6. Exploring Power BI Mobile

​N/A

Instructor Profile

instructor_image

Ritu is an expert in Microsoft Office & Power BI with core developmental skills in MS-Excel, MS-Access, VBA, Advanced Excel, RDBMS, and all other areas of data management. She has also written a book on Advance Excel 2016.

This course includes:

  • 100% Online Sessions
  • Instructor led
  • Customizable Syllabus
  • Customizable Schedule
  • Certificate of Completion
  • Training Recordings
  • Training Resources
  • Learner Assessment
Request Training Proposal

Related courses