Course Description
PowerBi is a data visualization tool developed by Microsoft that collects vast data from various data sources and converts it to effective communication dashboards and analytical reports.
PowerBi is one of our top-listed cloud technology. We train you virtually in classes-based training with expert trainers on weekdays and weekends.
We can also consider PowerBi a handy tool with diverse versions for different platforms such as desktop, SaaS, and mobile PowerBi apps, providing software and business intelligence services.
Upon completing the PowerBi course, you will understand implementing set to tools and extract data from various disparate sources and modify as per your required
We also guide you to attend the official PowerBi exam conducted by Microsoft, grab your PowerBi certification, and chase your craving profession.
Features
| ✅Lifetime access | ✅Lifetime video access |
| ✅Real-time case studies | ✅The project integrated into the Curriculum |
| ✅24*7 Support from our team of administrators |
Course Content
1.Getting started
| 1 | Welcome to the Course |
| 2 | Understanding the Power BI Tools |
| 3 | Installing Power BI & Connecting to Data |
| 4 | The “Locale” used in the curriculum |
| 5 | Working with the query Editor |
| 6 | Working with the data model and creating a visulaization |
| 7 | Course outline |
2.Intro to Power BI Desktop
| 1 | Overview of workflow in power bi desktop |
| 2 | introduction to different views of data model |
| 3 | taking a closer look at the quesry editor interface |
| 4 | Required Poer BI Settings |
3.An introduction to query editor
- 1What is quesry Editor ?2About the attached data3Connecting Power BI Desktop to the data 4Editing Rows5Understanding Append Queries6Editing Columns7Replacing Values8Formatting Data 9Pivoting & Unpivoting Columns10Splitting Columns11Creating a new Group for the queries12Intro Star Schema13Dupicating & Referencing Queries14Entering Data Manually15Merging Queries16Creating an Index Column17Duplicating Column and extracting info18Creating Conditional Columns19Performing Basic Mathematical Operations20Inmproving Performance and Loading Data into Data Model21Module Summary
4.Data & Relationship View
| 1 | Module intro |
| 2 | Query Editor & the data model. Why are they different ? |
| 3 | Intro to relationships |
| 4 | Editing relationships |
| 5 | Concepts are cardinality |
| 6 | Croas Filter selection & Many to tmany relationship |
| 7 | Active properties |
| 8 | M-Language & DAX. How are they different? |
| 9 | DAX Basics |
| 10 | Categorizing Data |
5.Working in the report view to visualize our results
| 1 | Module intro |
| 2 | Report view interface |
| 3 | Creating visuals |
| 4 | Add tooltips and interactions/markings |
| 5 | Data color |
| 6 | Hierarchies & Drill down |
| 7 | Formatting charts & Sorting |
| 8 | Introduction to slicers |
| 9 | Tree maps & Tables |
| 10 | Types of filters |
| 11 | Multi-row cards |
| 12 | Combined visuals & waterfalls |
| 13 | Module summary |
6.Power Bi Service & Power BI Mobile
| 1 | Module Intro |
| 2 | Why Power Bi Service ? |
| 3 | Comparison Power BI Free & Premium |
| 4 | Logging into Power Bi Service |
| 5 | Interface overview |
| 6 | Importing data from Desktop to Service |
| 7 | Dataset menu |
| 8 | Working on reports |
| 9 | Dashboard overview |
| 10 | Workspace & Gateways |
| 11 | Installing Gateways – Personal & On-premise |
| 12 | Working alone or collaboating with colleagues |
| 13 | Collaborating in App Workspace |
| 14 | Sharing the results |
| 15 | Publishing the app |
| 16 | Content packs from online services |
| 17 | Power Bi Mobile Ovcerview |
| 18 | Excluding dataset from sharing |
| 19 | Module Summary |
7.Other data source
| 1 | JSON Data |
| 2 | Importing data from rest of the APIs |
| 3 | Setting up a SQL Server |
| 4 | Importing data from SQL Server |
8.Course Round up
FAQ’s
❓ Do you offer any discount/offer?
✅ Yes, offers keep changing from time to time. You can chat with us or call our training coordinator for more details.
❓ Is there any demo video which I can watch before enrolling to the course?
✅ Yes, we have provided a Demo video section on each course page so that you can get a glimpse into the course you want to enroll.
❓ How soon after signing up would I get access to the learning content?
✅ Yes, we will provide access to all the learning materials after the complete payment for the course.
Course Instructor
