This course is designed for those interested to learn the basics of Microsoft Power BI to create stunning reports and dashboards, develop data modeling skills, and become a highly proficient Power BI user even with no prior knowledge.
Read more.Instructor
My name is Bill Singh. IÂ have 18 years of experience in ITÂ mainly in Data or Big Data. IÂ am IBM, ITIL, Microsoft and Amazon Certified Professional.
Only want this course? Buy this course for $199 $29 and keep lifetime access.
Click here
About This Course
Do you want to build professional-quality Business Intelligence Reports from the ground up? Do you want to blend and transform raw data into beautiful Interactive Dashboards? Do you want to learn how to design and implement the same B.I. tools used by professional analysts and data scientists? Do you want to understand the Business Intelligence workflow from end-to-end?
Then Microsoft Power BI is the right tool for you and this comprehensive course will teach you everything you need to know to use Power BI. This hands-on course will prepare you to start your data analytics career and will also prepare you to successfully implement Power BI in your organization. This course includes 25+ hours of HD videos of building 18 interactive Business Intelligence Reports and Dashboards (real-world examples) from scratch to finish.Â
Power BI allows the everyday Excel user to become a Business Intelligence Analyst. Create stunning reports and dashboards, poignant data visuals, and design highly insightful DAX measures with Power BI. Microsoft’s Power BI landscape allows easy data clean-up and data modeling directly in the Power BI application, or the user has the choice to accomplish these same tasks in Excel.
By the time you complete this course, you’ll be a highly proficient Power BI user. You will have gained the knowledge and confidence to apply these same concepts to real-word to solve business problems or business requirements. You’ll be fully prepared to collect, clean, model and present data for any purpose. You will be using your skills as a Business Intelligence Professional to extract knowledge from data so you can analyze and visualize complex business problems and requirements with ease.
Who this course is for:
- Anyone looking to get a job and prepare to start data analytics career
- Entrepreneurs/CEO/founders looking to master the Data Analysis process
- Data scientists and students learning in the field of Data
- Business Analysts who want to advance their skillset and aspiring Business Analysts who are looking to enhance their skill sets in the field of Business Analysis
- Business Analysts in charge of automation efforts
- Anyone wanting to transition into a Business Analyst
Our Promise to You
By the end of this course, you will have learned Microsoft Power BI.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about the Microsoft Power BI.
Course Curriculum
| Section 1 - Business Intelligence - Introduction To Power BI | |||
| Business Analysis – Course Introduction | 00:00:00 | ||
| Dashboard-In-A-Day And Power BI Best Practices Introduction | 00:00:00 | ||
| Power BI Introduction | 00:00:00 | ||
| Power BI Introduction | 00:00:00 | ||
| Power BI Introduction | 00:00:00 | ||
| Why Microsoft Power BI | 00:00:00 | ||
| Power BI Family | 00:00:00 | ||
| Power BI Desktop | 00:00:00 | ||
| Power BI Service 1 | 00:00:00 | ||
| Power BI Service 2 | 00:00:00 | ||
| Descriptive-Predictive-Prescriptive Analytics | 00:00:00 | ||
| IT Challenges | 00:00:00 | ||
| Downloadable Materials | 00:00:00 | ||
| Section 2 - Data Analysis And Business Intelligence - Collect, Injest And Import Data | |||
| Import Data From CSV Files | 00:00:00 | ||
| Import Data From Excel Files | 00:00:00 | ||
| Import Data From Web 1 | 00:00:00 | ||
| Import Data From Web 2 | 00:00:00 | ||
| Import Real-Time Streaming Data | 00:00:00 | ||
| Import Data From SQL Server | 00:00:00 | ||
| Import Data From OData Feed REST-API | 00:00:00 | ||
| Import Data From Folder | 00:00:00 | ||
| Dataflows – Introduction | 00:00:00 | ||
| Dataflows – Create Gateway From Scratch | 00:00:00 | ||
| Dataflows – Create Entities From CSV File | 00:00:00 | ||
| Dataflows – Create Entities Using SQL Server | 00:00:00 | ||
| Section 3 - Prep, Clean And Shape Data | |||
| Remove Rows | 00:00:00 | ||
| Remove Columns | 00:00:00 | ||
| Make First Row As Headers | 00:00:00 | ||
| How To Create Calculate Columns | 00:00:00 | ||
| How To Remove Duplicates | 00:00:00 | ||
| Unpivot Columns And Split Columns | 00:00:00 | ||
| Change Data Type, Replace Values And Rearrange The Columns | 00:00:00 | ||
| Append Queries | 00:00:00 | ||
| Merge Queries | 00:00:00 | ||
| Section 4 - Power BI Visuals | |||
| Visuals Intro | 00:00:00 | ||
| Visuals-Bar Charts | 00:00:00 | ||
| Visuals-Line Charts | 00:00:00 | ||
| Visuals-Pie Chart | 00:00:00 | ||
| Stacked Bar Chart | 00:00:00 | ||
| Clustered Column Chart | 00:00:00 | ||
| Visuals-Area Chart And Analytics Tab Explained 0 | 00:00:00 | ||
| Visuals-Area Chart And Analytics Tab Explained 1 | 00:00:00 | ||
| Visuals-Combo Chart | 00:00:00 | ||
| Visuals-Scatter Chart | 00:00:00 | ||
| Visuals-Treemap Chart | 00:00:00 | ||
| Visuals-Funnel Chart | 00:00:00 | ||
| Visuals-Card And Multi-Row Card | 00:00:00 | ||
| Visuals-Gauge Card | 00:00:00 | ||
| Visuals-KPIs | 00:00:00 | ||
| Visuals-Matrix | 00:00:00 | ||
| Visuals-Table | 00:00:00 | ||
| Visuals-Text Boxes – Shapes – Images | 00:00:00 | ||
| Visuals-Slicers | 00:00:00 | ||
| Visuals-Maps | 00:00:00 | ||
| Custom Visuals – Word Cloud | 00:00:00 | ||
| Visualization Interactions | 00:00:00 | ||
| Section 5 - Data Modeling | |||
| Our First Report 0 | 00:00:00 | ||
| Our First Report 1 | 00:00:00 | ||
| Our First Report 2 | 00:00:00 | ||
| Our First Report 3 | 00:00:00 | ||
| Publishing And Sharing Your First Report | 00:00:00 | ||
| Modeling Basics 0 | 00:00:00 | ||
| Modeling Basics 1 | 00:00:00 | ||
| Modeling Basics 2 | 00:00:00 | ||
| Modeling And Relationships 0 | 00:00:00 | ||
| Modeling And Relationships 1 | 00:00:00 | ||
| Other Ways To Create Relationship | 00:00:00 | ||
| Normalization – Denormalization 0 | 00:00:00 | ||
| Normalization – Denormalization 1 | 00:00:00 | ||
| OLTP Versus OLAP | 00:00:00 | ||
| Star Schema Versus Snowflake Schema 0 | 00:00:00 | ||
| Star Schema Versus Snowflake Schema 1 | 00:00:00 | ||
| Section 6 - Introduction To DAX | |||
| DAX 101 – Importing Data For Dax Learning | 00:00:00 | ||
| DAX 101 – What Is Dax | 00:00:00 | ||
| DAX 101 – Dax Data Types | 00:00:00 | ||
| DAX 101 – Dax Operators And Syntax | 00:00:00 | ||
| DAX 101 – M Versus Dax | 00:00:00 | ||
| DAX 101 – Create A Column | 00:00:00 | ||
| DAX 101 – Rules To Create Measures | 00:00:00 | ||
| DAX 101 – Calculated Columns Versus Calculated Measures 0 | 00:00:00 | ||
| DAX 101 – Calculated Columns Versus Calculated Measures 1 | 00:00:00 | ||
| DAX 101 – Sum() | 00:00:00 | ||
| DAX 101 – AVERAGE()-MIN()-MAX() | 00:00:00 | ||
| DAX 101 – SUMX() | 00:00:00 | ||
| DAX 101 – DIVIDE() | 00:00:00 | ||
| DAX 101 – COUNT()-COUNTROWS() | 00:00:00 | ||
| DAX 101 – CALCULATE() 0 | 00:00:00 | ||
| DAX 101 – CALCULATE() 1 | 00:00:00 | ||
| DAX 101 – FILTER() | 00:00:00 | ||
| DAX 101 – ALL() | 00:00:00 | ||
| DAX 101 – Time Intelligence – Create Date Table In M | 00:00:00 | ||
| DAX 101 – Time Intelligence – Create Date Table In DAX 0 | 00:00:00 | ||
| DAX 101 – Time Intelligence – Create Date Table In DAX 1 | 00:00:00 | ||
| DAX 101 – Time Intelligence – PREVIOUSMONTH() | 00:00:00 | ||
| DAX 101 – Time Intelligence – SAMEPERIODLASTYEAR() | 00:00:00 | ||
| DAX 101 – Time Intelligence – TOTALYTD() | 00:00:00 | ||
| DAX 101 – Display Last Refresh Date | 00:00:00 | ||
| DAX 101 – Time Intelligence – DATEADD() | 00:00:00 | ||
| DAX 101 – Quick Measures | 00:00:00 | ||
| Section 7 - Hands-On Real-World Projects | |||
| Delicious Pizza Report 0 | 00:00:00 | ||
| Delicious Pizza Report 1 | 00:00:00 | ||
| Delicious Pizza Report 2 | 00:00:00 | ||
| Abank Bank Report 0 | 00:00:00 | ||
| Abank Bank Report 1 | 00:00:00 | ||
| Abank Bank Report 1 | 00:00:00 | ||
| Abank – Create Phone Layout | 00:00:00 | ||
| Financial Report 0 | 00:00:00 | ||
| Financial Report 1 | 00:00:00 | ||
| Financial Report 2 | 00:00:00 | ||
| Financial Report 3 | 00:00:00 | ||
| Financial Report 4 | 00:00:00 | ||
| Financial Report-5 And Analytics Tab Explained | 00:00:00 | ||
| Personality And Looks 0 | 00:00:00 | ||
| Personality And Looks 1 | 00:00:00 | ||
| Personality And Looks 2 | 00:00:00 | ||
| Productivity Survey By Microsoft Office Team 0 | 00:00:00 | ||
| Productivity Survey By Microsoft Office Team 1 | 00:00:00 | ||
| Productivity Survey By Microsoft Office Team 2 | 00:00:00 | ||
| Productivity Survey By Microsoft Office Team 3 | 00:00:00 | ||
| Productivity Survey By Microsoft Office Team 4 | 00:00:00 | ||
| Toughest Sport By Skills 0 | 00:00:00 | ||
| Toughest Sport By Skills 1 | 00:00:00 | ||
| Toughest Sport By Skills 2 | 00:00:00 | ||
| Natural Disasters 0 | 00:00:00 | ||
| Natural Disasters 1 | 00:00:00 | ||
| Natural Disasters 2 | 00:00:00 | ||
| Natural Disasters 3 | 00:00:00 | ||
| Please Watch This First | 00:00:00 | ||
| Adv – Procurement-Spend Analysis 0 | 00:00:00 | ||
| Adv – Procurement-Spend Analysis 1 | 00:00:00 | ||
| Adv – Procurement-Spend Analysis 2 | 00:00:00 | ||
| Adv – Procurement-Spend Analysis 3 | 00:00:00 | ||
| Adv – Procurement-Spend Analysis 4 | 00:00:00 | ||
| Adv – Product Analysis 0 | 00:00:00 | ||
| Adv – Product Analysis 1 | 00:00:00 | ||
| Adv – Product Analysis 2 | 00:00:00 | ||
| Adv – Regional Analysis 0 | 00:00:00 | ||
| Adv – Regional Analysis 1 | 00:00:00 | ||
| Adv – Regional Analysis 2 | 00:00:00 | ||
| Adv – Regional Analysis 3 | 00:00:00 | ||
| Adv – Regional Analysis 4 | 00:00:00 | ||
| Adv – IT-Tickets Analysis 0 | 00:00:00 | ||
| Adv – IT-Tickets Analysis 1 | 00:00:00 | ||
| Adv – IT-Tickets Analysis 2 | 00:00:00 | ||
| Adv – IT-Tickets Analysis 3 | 00:00:00 | ||
| Adv – IT-Tickets Analysis 4 | 00:00:00 | ||
| Adv – Human Resources 1-0 | 00:00:00 | ||
| Adv – Human Resources 1-1 | 00:00:00 | ||
| Adv – Human Resources 1-2 | 00:00:00 | ||
| Adv – Human Resources 1-3 | 00:00:00 | ||
| Adv – Human Resources 2-0 | 00:00:00 | ||
| Adv – Human Resources 2-1 | 00:00:00 | ||
| Adv – Human Resources 2-2 | 00:00:00 | ||
| Adv – Human Resources 3-0 | 00:00:00 | ||
| Adv – Human Resources 3-1 | 00:00:00 | ||
| Adv – Human Resources 3-2 | 00:00:00 | ||
| Adv – Financial Report 0 | 00:00:00 | ||
| Adv – Financial Report 1 | 00:00:00 | ||
| Adv – Financial Report 2 | 00:00:00 | ||
| Adv – Financial Report 3 | 00:00:00 | ||
| Adv – Financial Report 4 | 00:00:00 | ||
| Adv – Sales Report 0 | 00:00:00 | ||
| Adv – Sales Report 1 | 00:00:00 | ||
| Adv – Sales Report 2 | 00:00:00 | ||
| Adv – Bank Report 0 | 00:00:00 | ||
| Adv – Bank Report 1 | 00:00:00 | ||
| Adv – Bank Report 2 | 00:00:00 | ||
| Adv – Bank Report 3 | 00:00:00 | ||
| Adv – Bank Report 4 | 00:00:00 | ||
| Section 8 - Personal - Enterprise Gateway | |||
| On-Premises Gateway | 00:00:00 | ||
| Personal Versus Enterprise Gateway | 00:00:00 | ||
| Install And Configure Personal Gateway | 00:00:00 | ||
| Install And Configure Enterprise Gateway | 00:00:00 | ||
| Manage SQL Server Data Source Thru Enterprise Gateway | 00:00:00 | ||
| Section 9 - Power BI Service And Dashboards | |||
| Power BI Reports | 00:00:00 | ||
| Power BI Workspaces | 00:00:00 | ||
| Power BI Datasets | 00:00:00 | ||
| What Are Dashboards | 00:00:00 | ||
| How To Create Workspace And Publish Report | 00:00:00 | ||
| Create Dashboards 6 Different Ways 0 | 00:00:00 | ||
| Create Dashboards 6 Different Ways 1 | 00:00:00 | ||
| Favorite Dashboards, Reports, And Apps In Power BI | 00:00:00 | ||
| Subscribe To A Report Or Dashboard | 00:00:00 | ||
| Rename Workspace Or Report Or Dashboard | 00:00:00 | ||
| Display Reports Or Dashboards In Full Screen Mode | 00:00:00 | ||
| Delete Reports Or Dashboards | 00:00:00 | ||
| Dashboard Menus | 00:00:00 | ||
| Quick Insights | 00:00:00 | ||
| Setting Up Alerts On Cards | 00:00:00 | ||
| Q-A In Power BI | 00:00:00 | ||
| Analyze In Excel | 00:00:00 | ||
| File And View Options | 00:00:00 | ||
| Printing Dashboard And Reports | 00:00:00 | ||
| Row Level Security | 00:00:00 | ||
| Access Reports Dashboards Using Mobile Devices | 00:00:00 | ||
| Report Page Tooltip 0 | 00:00:00 | ||
| Report Page Tooltip 1 | 00:00:00 | ||
| Filter- Page-Report-Visualization Level 0 | 00:00:00 | ||
| Filter- Page-Report-Visualization Level 1 | 00:00:00 | ||
| Section 10 - Sharing And Collaboration | |||
| Sharing And Collaboration | 00:00:00 | ||
| Sharing Dashboard | 00:00:00 | ||
| Sharing Workspaces | 00:00:00 | ||
| Sharing App | 00:00:00 | ||
| Publish To Web | 00:00:00 | ||
| Section 11 - Bonus Lectures | |||
| Power BI: Best Practices, Tips And Tricks 0 | 00:00:00 | ||
| Power BI: Best Practices, Tips And Tricks 1 | 00:00:00 | ||
| Power BI: Best Practices, Tips And Tricks 2 | 00:00:00 | ||
| Power BI: Best Practices, Tips And Tricks 3 | 00:00:00 | ||
| Power BI: Best Practices, Tips And Tricks 4 | 00:00:00 | ||
| Power BI: Best Practices, Tips And Tricks 5 | 00:00:00 | ||
| Dashboard-In-A-Day: Introduction | 00:00:00 | ||
| Dashboard-In-A-Day: Accessing Data | 00:00:00 | ||
| Dashboard-In-A-Day: Data Preparation 0 | 00:00:00 | ||
| Dashboard-In-A-Day: Data Preparation 1 | 00:00:00 | ||
| Dashboard-In-A-Day: Data Modeling And Exploration 0 | 00:00:00 | ||
| Dashboard-In-A-Day: Data Modeling And Exploration 1 | 00:00:00 | ||
| Dashboard-In-A-Day: Data Modeling And Exploration 2 | 00:00:00 | ||
| Dashboard-In-A-Day: Data Modeling And Exploration 3 | 00:00:00 | ||
| Dashboard-In-A-Day: Data Modeling And Exploration 4 | 00:00:00 | ||
| Dashboard-In-A-day: Data Visualizations 0 | 00:00:00 | ||
| Dashboard-In-A-day: Data Visualizations 1 | 00:00:00 | ||
| Dashboard-In-A-Day: Publishing Report | 00:00:00 | ||
| Dashboard-In-A-Day: Creating Dashboards 0 | 00:00:00 | ||
| Dashboard-In-A-Day: Creating Dashboards 1 | 00:00:00 | ||
| Dashboard-In-A-Day: 6 Ways To Create Dashboards 0 | 00:00:00 | ||
| Dashboard-In-A-Day: 6 Ways To Create Dashboards 1 | 00:00:00 | ||
Course Review
5.0
1 RatingsRelated Courses
Great Course
I had a great time learning Microsoft Power BI with this detailed course.