Power BI - Business Intelligence for Beginners to Advance
Course Description
Learn to create stunning Dashboards and Reports using Microsoft's free Business Intelligence / Analytics tool, Power BI.
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 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 (Beginner to Intermediate) course will prepare you to start your data analytics career and also will prepare you to Successfully implement Power BI in your organization. Absolutely no experience is required. 25+ hours of HD videos of building 18 interactive Business Intelligence Reports and Dashboards (real-world examples) from scratch to finish. Files for Start and Finished projects also included to challenge you so you can learn by immediately applying what you're learning . You will have gained the knowledge and confidence to apply these same concepts to real-word to solve the Business problems or Business requirements.
By the time you complete this course, You'll be a highly proficient Power BI user. 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/Requirements with ease.
Why should you consider a career as a Business Data Analyst?
-
Salary. A Business Data Analyst is a well-paid career
-
Stable Career. As most corporations gathering more and more data. There will never be shortage of Jobs for Business Data Analyst.
-
Advancement in Career : Since you will be building different reports for different departments. You will never be bored and always be valued. Which will bring you more opportunities in your career. Business Data Analyst get very visibility in corporations. Whole management depends on them.
Course Curriculum
- 1 Course Introduction
- 2 Data Visualization & Its Importance
- 3 Types Of Data & Levels of measurement
- 4 Describing Visuals for Qualitative & Quantitative Data
- 5 Know the right chart
- 6 Power BI Overview Interface & Importing Of Data
- 7 Understanding Superstore Data
- 8 Bar Charts
- 9 Column Charts
- 10 Line & Area Charts
- 11 Combo & Ribbon Charts
- 12 Waterfall & Funnel Charts
- 13 Scatter Charts
- 14 Pie & Donut Charts
- 1 Tree Map
- 2 Basic Maps, Filled Map & Azure Map
- 3 Shape Map, ArGIS Map along with tips to build right map
- 4 Gauge Charts
- 5 Cards, Multi-row card & KPI
- 6 Slicers
- 7 Tables & Matrix
- 8 Other Visuals in Power BI Key Influencer & Decomposition tree
- 9 Other Visuals in Power BI Metrics), Card, Power Apps
- 10 Introduction to Data Model
- 11 Designing data model for superstore data-1
- 12 Designing data model for superstore data-2
- 13 Data Model Building in Power BI
- 14 Study about Relationships in Power BI-1
- 15 Study about Relationships in Power BI-2
- 1 Adding Calendar Table to data model
- 2 Additional relationship tools in Power BI
- 3 Overview of Power Query Editor
- 4 Using Append & Workbook method-to combine Excel Worksheets-1
- 5 Using Append & Workbook method-to combine Excel Worksheets-2
- 6 Using Append & Workbook method-to combine Excel Worksheets-1
- 7 Combining un-clean Excel Workbooks using a folder
- 8 Merge Queries
- 9 Data Source & Refresh Settings
- 10 Setup to enable Python scripts in Power BI
- 11 Line Chart using Python script
- 12 Simple Visuals using Python script
- 13 Advanced Visuals using Python script
- 1 Setup to enable R script in Power BI
- 2 Custom Visuals using R script
- 3 Limitations to R & Python scripts in Power BI
- 4 Different Custom Visuals in Power BI
- 5 Bookmarks
- 6 Drill Through
- 7 Buttons,shapes, images & Sync Slicers
- 8 Edit Interaction feature
- 9 Group, Include & Exclude feature
- 10 Customized Tooltip feature
- 11 Useful DAX Scenario's
- 12 Superstore Analysis Dashboard-1
- 13 Superstore Analysis Dashboard-2
- 14 Superstore Analysis Dashboard-3
- 15 Superstore Analysis Dashboard-4
- 16 Overview of Power BI Service