Power BI – Business Intelligence for Beginners to Advance

Last updated 5/2024
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Language: English | Duration: 35h 22m | Size: 21.4 GB

The Complete and Comprehensive Course on Power BI : step by step with hands on demos with Power BI

What you’ll 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.
Learn to create powerful tables and matrix of reporting data.
Learn how to use Text Boxes, Shapes, Images, maps, and other visuals.
Learn how to turn data into insight and data into interactive visualizations to tell a story.
Learn how to use advanced features like Report page tooltips and Bookmarks.
Learn to use Custom Visualizations and Themes in Power BI.
Learn and develop data modeling skills.
Learn how to automate the cleansing of data.
Learn how to collaboration and sharing of content on Microsoft’s Powerful platform.
This hands on course will prepare you to start your data analytics career.
Learn Dashboard-in-a-day at your own pace at home or at your office.
Learn Power BI Best Practices, Tip and Tricks.

Requirements
Absolutely no experience is required. We will start from the basics and gradually build up your knowledge with clear and concise step by step instructions
No prior knowledge needed, covers Power BI end to end, while providing a wealth of practical tips for those that already know Power BI.
Power BI requires that you use a work or school email address to sign up. You can’t sign up using email addresses provided by consumer email services or telecommunication providers. This includes outlook, hotmail, gmail, yahoo and others.

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. #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 : AI Visuals – ChatGPT and Microsoft CoPilot AI Visuals – ChatGPT and Microsoft CoPilot (2min)Decomposition Tree Visual (15 min)Key Influencers Visual (16 min)Smart Narrative (12 min)Q&A Visual (17 min)Quick Measures with CoPilot (16 min)Column from Examples (15 min)New Calculation – Model Tab (25 min)Field Parameters (7 min)Bravo Tool (24 min)ChatGPT – Power BI CoPilot DAX Example (17 min)ChatGPT – Power BI CoPilot M Code Example (13 min)Section 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, Tips and Tricks 2Power BI : Best Practices, Tips and Tricks 3Power BI : Best Practices, Tips and Tricks 4Power BI : Best Practices, Tips and Tricks 5Dashboard-in-a-day : Download Material linkDashboard-in-a-day : IntroductionDashboard-in-a-day : Accessing DataDashboard-in-a-day : Data Preparation 0Dashboard-in-a-day : Data Preparation 1Dashboard-in-a-day : Data modeling and Exploration 0Dashboard-in-a-day : Data modeling and Exploration 1Dashboard-in-a-day : Data modeling and Exploration 2Dashboard-in-a-day : Data modeling and Exploration 3Dashboard-in-a-day : Data modeling and Exploration 4Dashboard-in-a-day : Data Visualizations 0Dashboard-in-a-day : Data Visualizations 1Dashboard-in-a-day : Publishing ReportDashboard-in-a-day : Creating Dashboards 0Dashboard-in-a-day : Creating Dashboards 1Dashboard-in-a-day : 6 ways to create Dashboards 0Dashboard-in-a-day : 6 ways to create Dashboards 1

---