Microsoft Power BI - Business Intelligence for Beginners (Udemy.com)
Beginner Course on Power BI : Business Intelligence & Data/Business Analysis with Microsoft Power BI
Created by: BizticsCom King
Produced in 2021
What you will learn
- Learn to use the easiest Business Intelligence tool to create stunning reports and dashboards.
- learn how you can visualize that data in a meaningful way to revile insights into your business like never before.
- learn how, with Power BI, to connect to multiple sources of data like SQL Server, Excel, CSV, JSON, XML, Web and SQL Analysis Services etc....
- learn how to, with the power of basic DAX, create powerful calculations and comparisons across multiples tables of data.
- Learn how to create advanced DAX measures and calculated columns for complex calculations.
- Learn Dataflows (new CDM base, Azure Lake gen2), what it is and how to use and configure databases in it.
- Learn how to use charts using visuals like column, line, pie, combo, Scatter, Treemap, Funnel, Gauges and KPIs to name a few.
- Easily clean the messy data, model your data as per your requirement and format your report to make it look beautiful and professional.
Quality Score
Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/
Overall Score : 84 / 100
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 willprepare you to start your data analytics career andalso will prepare you toSuccessfully implement Power BI in your organization.
Absolutely no experience is required. 25+ hours ofHD videos of building 18interactiveBusiness IntelligenceReports 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 theknowledgeandconfidenceto 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 careerStable 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.#microsoft #powerbi #data #business #intelligence #analysisCourse Curriculum:
Section 1: Business intelligence -Introduction to Power BIBusiness Analysis - Course IntroductionThank you for enrolling - Must watchDashboard-in-a-day & Power BI Best Practices IntroductionPower Bi Introduction - 0Power Bi Introduction - 1Power Bi Introduction - 2Why Microsoft Power BIPower BI FamilyPower BI DesktopPower BI Service 1Power BI Service 2Descriptive-Predictive-Prescriptive AnalyticsIT Challenges 0IT Challenges 1How to take the quizzesSection 2: Data Analysis and Business Intelligence - Collect , Injest and Import DataDownload Data files firstImport data from CSV filesImport data from Excel filesImport data from Web 1Import data from Web 2Import Real-time Streaming DataDownload and Install SQL Server ExpressDownload and Install Sample DatabasesImport data from SQL ServerImport data from OData feed REST-APIImport Data from FolderDataflows - IntroductionDataflows - Create Gateway from ScratchDataflows - Create Entities from CSV fileDataflows - Create Entities Using SQL ServerSection 3: Prep, Clean and Shape DataDownload resources for this section.
Remove RowsRemove ColumnsMake first row as headersHow to create calculate columnsHow to remove duplicates, Unpivot columns and split columnsChange Data type, Replace Values and Rearrange the columnsAppend QueriesMerge QueriesSection 4: Power BI VisualsDownload resources for this section.
Visuals IntroVisuals-Bar ChartsVisuals-Line ChartsVisuals-Pie ChartStacked bar ChartClustered Column ChartVisuals-Area Chart and Analytics Tab Explained-0Visuals-Area Chart and Analytics Tab Explained-1Visuals-Combo ChartVisuals-Scatter ChartVisuals-Treemap ChartVisuals-funnel ChartVisuals-Card and Multi-Row CardVisuals-Gauge CardVisuals-KPIsVisuals-MatrixVisuals-TableVisuals-Text boxes - Shapes - ImagesVisuals-SlicersVisuals-MapsCustom Visuals - Word CloudVisualization interactionsSection 5: Data ModelingOur First Report-0Our First Report-1Our First Report-2Our First Report-3Publishing and Sharing your first reportTheme Download fileModeling Basics-0Modeling Basics-1Modeling Basics-2Modeling and Relationships-0Modeling and Relationships-1Other ways to create RelationshipNormalization - Denormalization-0Normalization - Denormalization-1OLTP vs OLAPStar Schema vs Snowflake Schema-0Star Schema vs Snowflake Schema-1Section 6: Introduction to DAXDAX101 - Importing Data for Dax LearningDAX101 - Resources for Dax LearningDAX101 - What is DaxDAX101 - Dax Data TypesDAX101 - Dax Operators and SyntaxDAX101 - M vs DaxDAX101 - Create a ColumnDAX101 - Rules to Create MeasuresDAX101 - Calculated Columns vs Calculated Measures-0DAX101 - Calculated Columns vs Calculated Measures-1DAX101 - Sum()DAX101 - AVERAGE()-MIN()-MAX()DAX101 - SUMX()DAX101 - DIVIDE()DAX101 - COUNT()-COUNTROWS()DAX101 - CALCULATE()-0DAX101 - CALCULATE()-1DAX101 - FILTER()DAX101 - ALL()DAX101 - Time Intelligence - Create Date Table in M (important)DAX101 - Time Intelligence - Create Date Table in DAX-0DAX101 - Time Intelligence - Create Date Table in DAX-1DAX101 - Time Intelligence - PREVIOUSMONTH()DAX101 - Time Intelligence - SAMEPERIODLASTYEAR()DAX101 - Time Intelligence - TOTALYTD()DAX101 - Display Last Refresh DateDAX101 - Time Intelligence - DATEADD()DAX101 - Quick MeasuresSection 7: Hands-on Real-world ProjectsDelicious PizzaAmerican BankFinancial ReportProductivity in 2017Personality Tough Sport by SkillNatural DisastersTerrorism in WorldProcurement-spend AnalysisProducts AnalysisRegional AnalysisIT Tickets AnalysisHuman Resources 1Human Resources 2Human Resources 3Financial Data ReportSales AnalysisBank ReportSection 8: Personal - Enterprise GatewayOn-Premises GatewayPersonal vs Enterprise GatewayInstall and Configure Personal GatewayInstall and Configure Enterprise GatewayManage SQL Server Data Source thru Enterprise GatewaySection 9: Power BI Service and DashboardsPowerBI ReportsPowerBI WorkspacesPowerBI DatasetsWhat are DashboardsHow to create Workspace and Publish ReportCreate dashboards 6 different ways-0Create dashboards 6 different ways-1Favorite dashboards, reports, and apps in Power BISubscribe to a Report or DashboardRename Workspace or Report or DashboardDisplay Reports or Dashboards in Full screen modeDelete Reports or DashboardsDashboard MenusQuick InsightsSetting up Alerts on CardsQ-A in Power BIAnalyze in ExcelFile and View OptionsPrinting Dashboard and ReportsRow level securityAccess Reports Dashboards using Mobile DevicesReport page tooltip-0Report page tooltip-1Filter- Page-Report-Visualization level-0Filter- Page-Report-Visualization level-1Section 10: Sharing and CollaborationSharing and CollaborationSharing DashboardSharing WorkspacesSharing AppPublish To WebSection 11: Bonus LecturesDownload MaterialsPower BI : Best Practices, Tips and Tricks 0Power BI : Best Practices, Tips and Tricks 1Power BI : Best Practices
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 willprepare you to start your data analytics career andalso will prepare you toSuccessfully implement Power BI in your organization.
Absolutely no experience is required. 25+ hours ofHD videos of building 18interactiveBusiness IntelligenceReports 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 theknowledgeandconfidenceto 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 careerStable 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.#microsoft #powerbi #data #business #intelligence #analysisCourse Curriculum:
Section 1: Business intelligence -Introduction to Power BIBusiness Analysis - Course IntroductionThank you for enrolling - Must watchDashboard-in-a-day & Power BI Best Practices IntroductionPower Bi Introduction - 0Power Bi Introduction - 1Power Bi Introduction - 2Why Microsoft Power BIPower BI FamilyPower BI DesktopPower BI Service 1Power BI Service 2Descriptive-Predictive-Prescriptive AnalyticsIT Challenges 0IT Challenges 1How to take the quizzesSection 2: Data Analysis and Business Intelligence - Collect , Injest and Import DataDownload Data files firstImport data from CSV filesImport data from Excel filesImport data from Web 1Import data from Web 2Import Real-time Streaming DataDownload and Install SQL Server ExpressDownload and Install Sample DatabasesImport data from SQL ServerImport data from OData feed REST-APIImport Data from FolderDataflows - IntroductionDataflows - Create Gateway from ScratchDataflows - Create Entities from CSV fileDataflows - Create Entities Using SQL ServerSection 3: Prep, Clean and Shape DataDownload resources for this section.
Remove RowsRemove ColumnsMake first row as headersHow to create calculate columnsHow to remove duplicates, Unpivot columns and split columnsChange Data type, Replace Values and Rearrange the columnsAppend QueriesMerge QueriesSection 4: Power BI VisualsDownload resources for this section.
Visuals IntroVisuals-Bar ChartsVisuals-Line ChartsVisuals-Pie ChartStacked bar ChartClustered Column ChartVisuals-Area Chart and Analytics Tab Explained-0Visuals-Area Chart and Analytics Tab Explained-1Visuals-Combo ChartVisuals-Scatter ChartVisuals-Treemap ChartVisuals-funnel ChartVisuals-Card and Multi-Row CardVisuals-Gauge CardVisuals-KPIsVisuals-MatrixVisuals-TableVisuals-Text boxes - Shapes - ImagesVisuals-SlicersVisuals-MapsCustom Visuals - Word CloudVisualization interactionsSection 5: Data ModelingOur First Report-0Our First Report-1Our First Report-2Our First Report-3Publishing and Sharing your first reportTheme Download fileModeling Basics-0Modeling Basics-1Modeling Basics-2Modeling and Relationships-0Modeling and Relationships-1Other ways to create RelationshipNormalization - Denormalization-0Normalization - Denormalization-1OLTP vs OLAPStar Schema vs Snowflake Schema-0Star Schema vs Snowflake Schema-1Section 6: Introduction to DAXDAX101 - Importing Data for Dax LearningDAX101 - Resources for Dax LearningDAX101 - What is DaxDAX101 - Dax Data TypesDAX101 - Dax Operators and SyntaxDAX101 - M vs DaxDAX101 - Create a ColumnDAX101 - Rules to Create MeasuresDAX101 - Calculated Columns vs Calculated Measures-0DAX101 - Calculated Columns vs Calculated Measures-1DAX101 - Sum()DAX101 - AVERAGE()-MIN()-MAX()DAX101 - SUMX()DAX101 - DIVIDE()DAX101 - COUNT()-COUNTROWS()DAX101 - CALCULATE()-0DAX101 - CALCULATE()-1DAX101 - FILTER()DAX101 - ALL()DAX101 - Time Intelligence - Create Date Table in M (important)DAX101 - Time Intelligence - Create Date Table in DAX-0DAX101 - Time Intelligence - Create Date Table in DAX-1DAX101 - Time Intelligence - PREVIOUSMONTH()DAX101 - Time Intelligence - SAMEPERIODLASTYEAR()DAX101 - Time Intelligence - TOTALYTD()DAX101 - Display Last Refresh DateDAX101 - Time Intelligence - DATEADD()DAX101 - Quick MeasuresSection 7: Hands-on Real-world ProjectsDelicious PizzaAmerican BankFinancial ReportProductivity in 2017Personality Tough Sport by SkillNatural DisastersTerrorism in WorldProcurement-spend AnalysisProducts AnalysisRegional AnalysisIT Tickets AnalysisHuman Resources 1Human Resources 2Human Resources 3Financial Data ReportSales AnalysisBank ReportSection 8: Personal - Enterprise GatewayOn-Premises GatewayPersonal vs Enterprise GatewayInstall and Configure Personal GatewayInstall and Configure Enterprise GatewayManage SQL Server Data Source thru Enterprise GatewaySection 9: Power BI Service and DashboardsPowerBI ReportsPowerBI WorkspacesPowerBI DatasetsWhat are DashboardsHow to create Workspace and Publish ReportCreate dashboards 6 different ways-0Create dashboards 6 different ways-1Favorite dashboards, reports, and apps in Power BISubscribe to a Report or DashboardRename Workspace or Report or DashboardDisplay Reports or Dashboards in Full screen modeDelete Reports or DashboardsDashboard MenusQuick InsightsSetting up Alerts on CardsQ-A in Power BIAnalyze in ExcelFile and View OptionsPrinting Dashboard and ReportsRow level securityAccess Reports Dashboards using Mobile DevicesReport page tooltip-0Report page tooltip-1Filter- Page-Report-Visualization level-0Filter- Page-Report-Visualization level-1Section 10: Sharing and CollaborationSharing and CollaborationSharing DashboardSharing WorkspacesSharing AppPublish To WebSection 11: Bonus LecturesDownload MaterialsPower BI : Best Practices, Tips and Tricks 0Power BI : Best Practices, Tips and Tricks 1Power BI : Best Practices
Instructor Details
- 4.2 Rating
294 Reviews
BizticsCom King
Hi,
My name is Bill Singh. Ihave 18 years of experience in ITmainly in Data or Big Data. Iam IBM, ITIL, Microsoft and Amazon Certified Professional. Ibeen working in Business Intelligence for many years now and also teaching live classes. I also got few opportunities to speak at Microsoft and LinkedIn in silicon valley campuses. Taught this course live to employees from Microsoft, GE, Facebook etc.. After having received such positive feedback from teaching this course live, I have created the digital version to extend this course to anyone wanting to learn.
More data analysis courses
Microsoft Power BI - Up & Running With Power BI Desktop (2021)
4.8 (312 Reviews)
Provider: Udemy
Time: 10.5h
$11.99
Python Data Analysis & Visualization Bootcamp (2021)
4.8 (309 Reviews)
- Provider: Udemy
- Time: 8h
$11.99
![Complete Introduction to Microsoft Power BI [2021 Edition]](/programming/data-analysis/images/468172_d1c0_11.jpg?v=1789153474)
Complete Introduction to Microsoft Power BI [2021 Edition] (2021)
4.7 (312 Reviews)
- Provider: Udemy
- Time: 6.5h
$11.99
![[Intermediate] Spatial Data Analysis with R, QGIS & More](/programming/data-analysis/images/1030486_58a1_2.jpg?v=1789153427)
[Intermediate] Spatial Data Analysis with R, QGIS & More (2021)
4.7 (170 Reviews)
- Provider: Udemy
- Time: 5h
$11.99
Reviews
- Video Duration:
31.5h - Price: 11.99 Track Price 11.99 Track Price
- Provider: Udemy
- Year:
2021 - Language:
English - Certificate:
Yes
30-Day Money-Back Guarantee
Udemy Coupon Price Tracker
