Analyzing And Visualizing Data With Microsoft Power BI
Analyzing And Visualizing Data With Microsoft Power BI
Course Duration: 2 DaysIntroduction
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.
Prerequisites
Basic knowledge of essential and user of Microsoft Power BI
Course Objectives
Upon completing this course, participants will have a basic understanding of the topics below, as well as an ability to utlize and implement the concepts learnt.- Power BI
- Power BI Desktop
- Working with CSV, TXT and Excel Worksheets
- Connecting to Databases
- Merging, grouping, summarizing and calculating data
- Reporting
- Power BI Online
Key Content
Lesson 1: Course Overview
Lesson 2: Power BI
- What is Power BI?
- Examining Power BI Suite of Products
- Identifying differences between products
- Understanding Power BI updates
Lesson 3: Power BI Desktop
- Installing Power BI Desktop
- Exploring the Power BI Desktop interface
- Utilizing file types: PBIX vs PBIT
- Examining data sources
- Discussing data refresh
- Understanding data types
Lesson 4: Working with CSV, TXT and Excel Worksheets
- Importing, transforming and loading data
- Appending operations
- Working with folders and files
- Using Pivot Tables
Lesson 5: Connecting to Databases
- Working with relational data
- Understanding relationships
- Importing from SQL server analysis services multidimensional and tabular
Lesson 6: Merging, Grouping, Summarizing and Calculating Data
- Understanding the issues with merges
- Performing merges
- Grouping options
- Summarizing
- Calculating
Lesson 7: Reporting
- Creating reports
- Utilizing matrix visualization
- Utilizing map visualization
- Utlizing card visualization
- Utlizing chart visualization
- Utilzing slicers
- Publishing to Power BI online
Lesson 8: Power BI Online
- Introduction to Power BI ONline
- Importing data
- Creating reports
- Configuring dashboards
- Sharing reports and dashboards
Target Audience
This course is intended for business managers, report developers, analysts, project managers and team leads.Inquiry - Analyzing And Visualizing Data With Microsoft Power BI