
By TED Integrated
Analyzing & Visualizing Data using Power BI



By TED Integrated
![]() |
![]() |
![]() |
![]() |
Analyzing & Visualizing Data using Power BI
Training Category:
Information Technology
Target Audience:
This course is for participants whose job responsibilities include creating Excel reports, clean & analyze data as well as conducting analytics and data science.
Duration:
2 Days
![]() |
Request for Quotation |
![]() |
+603-2386-7788 |
![]() |
[email protected] |
- Language: English
- PowerPoint Presentation
- Workshop
- Reading Materials
- Computer Lab Work
- Lecture
- Certificate of Participation
Course Introduction ›
This course is taught to publish those reports to the Power BI service, create dashboards, and share to business users so that they can consume the dashboards through the web and their mobile devices. Microsoft Power Query is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery, access and collaboration. With Power Query, non-technical Excel users can access large corporate and Internet-based databases to conduct analysis and produce reports.
Power Query is an add-in program for Excel 2010 and Excel 2013. Its features are also integrated into Excel 2016.
Course Objectives ›
After completing this Power BI course, participants should be able to:
- Import Data from several of the data source.
- Structure unstructured data (Data Cleansing)
- Prepare data for analyzing and visualizing.
- Perform Power BI desktop data transformation.
- Describe Power BI desktop modelling.
- Create a Power BI desktop visualization.
- Describe how to connect to Excel data.
- Describe how to collaborate with Power BI data.
Prerequisites ›
Excel Introduction or Intermediate Level. Previous experience with database concepts is helpful but not required. Basic exposure to programming constructs (such as looping and branching).
Course Outline ›
Module 1: Introduction to Power Query
- Installing Power Query
- Creating a Simple Query
- Editing a Simple Query
Module 2: Common Data Import Sources
- Working with CSV files
- working with Text Files
- Working with Excel Files
- Working with other file types
Module 3: Working with Data from the Web
- Scraping Data from Web Pages
- Calling a Web Service
- Finding Data Using a Power Query Online Search
Module 4: Working with Folders and Multiple Files
- Working from Data from the Windows File System
- Combining Data from Multiple Files
Module 5: Filtering and Sorting Rows
- Using Auto-Filter
- Using Number, Text and Date Filters
- Filtering Rows by Range
- Removing Duplicate Values
- Filtering out Rows with Errors
- Sorting
Module 6: Changing Values in a Table
- Replacing Values
- Text Transformations
- Number Transformations
- Date/Time Transformations
- Replacing Missing Values
Module 7: Table Transformations
- Unpivoting Columns to Rows
- Transposing a Table
- Creating Custom Columns
Module 1: Introducing Power BI
Module 2: Sharing the dashboard
- Inviting a user to see a dashboard
- Inviting users outside your organization
- Creating a group workspace in Power BI
- Turning on sharing with Microsoft OneDrive for Business
- Viewing reports and dashboards on mobile devices
Module 3: Using Power BI Desktop
- Connecting to a database
- Loading from multiple sources
- Using Query Editor
- Hiding or removing tables
- Handling seasonality and sorting months
Module 4: Improving Power BI reports
- Choosing the right visualizations
- Choosing between standard visuals
- Using custom visualizations
- First steps with custom visualizations
- Improving reports by using custom visualizations
- Identifying conditions when custom visualizations are required
- Using DAX in data models
- Creating high-density reports
Module 5: Power BI and Excel
- Excel and Power BI
- Import an Excel table into Power BI
- Import Excel files with data models and Power View sheets
- Connect OneDrive for Business to Power BI
- Excel data in Power BI summary
Contact us now ›
|
|
![]() |
![]() |
Related Courses ›
- Fundamentals of Power BI Desktop
- Integrating Microsoft® Excel Power Query Technology
- Introduction to Power Business Intelligence with Excel 2010
- Business Intelligence with Microsoft® Excel 2010 & PowerPivot - Level 2
- Microsoft® Excel for Intermediate/Advance User
- More other Information Technology related courses