get app

    Microsoft Power BI - Business Intelligence for Beginners

    BY
    Udemy

    Learn the fundamentals of Microsoft Power BI for business intelligence, business analytics, and data analysis.

    Brochure Enquire
    Mode

    Online

    Fees

    ₹ 3299

    Quick Facts

    particular details
    Medium of instructions English
    Mode of learning Self study
    Mode of Delivery Video and Text Based

    Course overview

    The Microsoft Power BI - Business Intelligence for Beginners certification course was designed by BizticsCom King - Passionate Data Expert in the business intelligence sector and is available on Udemy for participants who wish to develop dynamic dashboards and reports using Microsoft Power BI. The Microsoft Power BI - Business Intelligence for Beginners online course focuses on providing the knowledge and analytical expertise needed to create and deploy the same business intelligence tools used by professional data analysts and data scientists.

    Microsoft Power BI - Business Intelligence for Beginners online classes feature over 32 hours of intensive video learning tools, as well as 6 articles and 74 downloaded resources that learners can access at any time to obtain a theoretical reference of the topics presented. This course is broken down into 11 sections: business intelligence, data analysis, cleaning and shaping data, power BI visualizations, data modeling, DAX, BI services and dashboards, enterprise gateway, sharing, and collaboration. By the end of this course, participants will have learned how to extract knowledge from data as a business intelligence specialist, allowing them to easily analyze and visualize complex business challenges.

    The highlights

    • Certificate of completion
    • Self-paced course
    • English videos with multi-language subtitles
    • 32.5 hours of pre-recorded video content
    • 6 articles
    • 74 downloadable resources
    • Projects
    • 30-day money-back guarantee 
    • Unlimited access
    • Accessible on mobile devices and TV

    Program offerings

    • Certificate of completion
    • Self-paced course
    • English videos with multi-language subtitles
    • 32.5 hours of pre-recorded video content
    • 6 articles
    • 74 downloadable resources
    • Projects
    • Unlimited access
    • Accessible on mobile devices and tv

    Course and certificate fees

    Fees information
    ₹ 3,299
    certificate availability

    Yes

    certificate providing authority

    Udemy

    Who it is for

    Data analyst Data engineer

    What you will learn

    Knowledge of data visualization

    After completing the Microsoft Power BI - Business Intelligence for Beginners online certification, participants will be introduced to the features and core concepts of Microsoft Power BI for business intelligence. Participants will identify the techniques to utilize business intelligence tools to create dynamic reports and dashboards. Participants will learn about data operations such as data visualization, web analysis, and SQL analysis. Participants will also learn about MS Excel, DAX, XML, CSV, JSON, SQL servers, data modeling approaches and strategies, dataflows, and how to automate data cleaning.

    The syllabus

    Business intelligence - Course Introduction

    • Business Analysis - Course Introduction
    • Thank you for enrolling & How to get support

    What is Business Intelligence and why companies use it

    • What is Business Intelligence
    • Why use Business Intelligence
    • What answers Business Intelligence gives a business
    • Characteristics of Modern BI Tools
    • Factors to consider while buying business intelligence solution
    • Descriptive-Predictive-Prescriptive Analytics

    Introduction to Power BI

    • Power Bi Introduction - 0
    • Power Bi Introduction - 1
    • Power Bi Introduction - 2
    • Why Microsoft Power BI
    • Power BI Family
    • Power BI Desktop
    • Power BI Service 1
    • Power BI Service 2
    • IT Challenges 0
    • IT Challenges 1

    Data Analysis and Business Intelligence - Collect , Injest and Import Data

    • Download Data files first
    • Import data from CSV files
    • Import data from Excel files
    • Import data from Web 1
    • Import data from Web 2
    • Import Real-time Streaming Data
    • Download and Install SQL Server Express
    • Download and Install Sample Databases
    • Import data from SQL Server
    • Import data from OData feed REST-API
    • Import Data from Folder
    • Dataflows - Introduction
    • Dataflows - Create Gateway from Scratch
    • Dataflows - Create Entities from CSV file
    • Dataflows - Create Entities Using SQL Server

    Power Query : Prep, Clean and Shape Data

    • Download resources for this section.
    • Remove Rows
    • Remove Columns
    • Make first row as headers
    • How to create calculate columns
    • How to remove duplicates
    • Unpivot columns and split columns
    • Change Data type, Replace Values and Rearrange the columns
    • Append Queries
    • Merge Queries

    Power BI Visuals

    • Download resources for this section.
    • Visuals Intro
    • Visuals-Bar Charts
    • Visuals-Line Charts
    • Visuals-Pie Chart
    • Stacked bar Chart
    • Clustered Column Chart
    • Visuals-Area Chart and Analytics Tab Explained-0
    • Visuals-Area Chart and Analytics Tab Explained-1
    • Visuals-Combo Chart
    • Visuals-Scatter Chart
    • Visuals-Treemap Chart
    • Visuals-funnel Chart
    • Visuals-Card and Multi-Row Card
    • Visuals-Gauge Card
    • Visuals-KPIs
    • Visuals-Matrix
    • Visuals-Table
    • Visuals-Text boxes - Shapes - Images
    • Visuals-Slicers
    • Visuals-Maps
    • Custom Visuals - Word Cloud
    • Visualization interactions

    Data Modeling in Power BI

    • Our First Report-0
    • Our First Report-1
    • Our First Report-2
    • Our First Report-3
    • Publishing and Sharing your first report
    • Theme Download file
    • Modeling Basics-0
    • Modeling Basics-1
    • Modeling Basics-2
    • Modeling and Relationships-0
    • Modeling and Relationships-1
    • Other ways to create Relationship
    • Normalization - Denormalization-0
    • Normalization - Denormalization-1
    • OLTP vs OLAP
    • Star Schema vs Snowflake Schema-0
    • Star Schema vs Snowflake Schema-1

    Introduction to DAX using Power BI

    • DAX101 - Importing Data for Dax Learning
    • DAX101 - Resources for Dax Learning
    • DAX101 - What is Dax
    • DAX101 - Dax Data Types
    • DAX101 - Dax Operators and Syntax
    • DAX101 - M vs Dax
    • DAX101 - Create a Column
    • DAX101 - Rules to Create Measures
    • DAX101 - Calculated Columns vs Calculated Measures-0
    • DAX101 - Calculated Columns vs Calculated Measures-1
    • DAX101 - Sum()
    • DAX101 - AVERAGE()-MIN()-MAX()
    • DAX101 - SUMX()
    • DAX101 - DIVIDE()
    • DAX101 - COUNT()-COUNTROWS()
    • DAX101 - CALCULATE()-0
    • DAX101 - CALCULATE()-1
    • DAX101 - FILTER()
    • DAX101 - ALL()
    • DAX101 - Time Intelligence - Create Date Table in M (important)
    • DAX101 - Time Intelligence - Create Date Table in DAX-0
    • DAX101 - Time Intelligence - Create Date Table in DAX-1
    • DAX101 - Time Intelligence - SAMEPERIODLASTYEAR()
    • DAX101 - Time Intelligence - TOTALYTD()
    • DAX101 - Display Last Refresh Date
    • DAX101 - Time Intelligence - PREVIOUSMONTH()
    • DAX101 - Time Intelligence - DATEADD()
    • DAX101 - Quick Measures

    Hands-on Real-world Projects

    • Delicious Pizza Report-0
    • Delicious Pizza Report-1
    • Delicious Pizza Report-2
    • Abank Bank Report-0
    • Abank Bank Report-1
    • Abank Bank Report-2
    • Abank - Create phone layout
    • Financial Report-0
    • Financial Report-1
    • Financial Report-2
    • Financial Report-3
    • Financial Report-4
    • Financial Report-5 & Analytics tab explained
    • Personality and looks-0
    • Personality and looks-1
    • Personality and looks-2
    • Productivity Survey by Microsoft Office Team-0
    • Productivity Survey by Microsoft Office Team-1
    • Productivity Survey by Microsoft Office Team-2
    • Productivity Survey by Microsoft Office Team-3
    • Productivity Survey by Microsoft Office Team-4
    • Toughest Sport by Skills-0
    • Toughest Sport by Skills-1
    • Toughest Sport by Skills-2
    • Natural Disasters-0
    • Natural Disasters-1
    • Natural Disasters-2
    • Natural Disasters-3
    • Please watch this first
    • Adv - Procurement-Spend Analysis-0
    • Adv - Procurement-Spend Analysis-1
    • Adv - Procurement-Spend Analysis-2
    • Adv - Procurement-Spend Analysis-3
    • Adv - Procurement-Spend Analysis-4
    • Adv - Product Analysis-0
    • Adv - Product Analysis-1
    • Adv - Product Analysis-2
    • Adv - Product Analysis-3
    • Adv - Regional Analysis-0
    • Adv - Regional Analysis-1
    • Adv - Regional Analysis-2
    • Adv - Regional Analysis-3
    • Adv - Regional Analysis-4
    • Adv - IT-Tickets Analysis-0
    • Adv - IT-Tickets Analysis-1
    • Adv - IT-Tickets Analysis-2
    • Adv - IT-Tickets Analysis-3
    • Adv - IT-Tickets Analysis-4
    • Adv - Human Resources 1-0
    • Adv - Human Resources 1-1
    • Adv - Human Resources 1-2
    • Adv - Human Resources 1-3
    • Adv - Human Resources 2-0
    • Adv - Human Resources 2-1
    • Adv - Human Resources 2-2
    • Adv - Human Resources 3-0
    • Adv - Human Resources 3-1
    • Adv - Human Resources 3-2
    • Adv - Financial Report-0
    • Adv - Financial Report-1
    • Adv - Financial Report-2
    • Adv - Financial Report-3
    • Adv - Financial Report-4
    • Adv - Sales Report-0
    • Adv - Sales Report-1
    • Adv - Sales Report-2
    • Adv - Bank Report-0
    • Adv - Bank Report-1
    • Adv - Bank Report-2
    • Adv - Bank Report-3
    • Adv - Bank Report-4

    Personal - Enterprise Gatewaymin

    • On-Premises Gateway
    • Personal vs Enterprise Gateway
    • Install and Configure Personal Gateway
    • Install and Configure Enterprise Gateway
    • Manage SQL Server Data Source thru Enterprise Gateway

    Power BI Service and Dashboards

    • PowerBI Reports
    • PowerBI Workspaces
    • PowerBI Datasets
    • What are Dashboards
    • How to create Workspace and Publish Report
    • Create dashboards 6 different ways-0
    • Create dashboards 6 different ways-1
    • Favorite dashboards, reports, and apps in Power BI
    • Subscribe to a Report or Dashboard
    • Rename Workspace or Report or Dashboard
    • Display Reports or Dashboards in Full screen mode
    • Delete Reports or Dashboards
    • Dashboard Menus
    • Quick Insights
    • Setting up Alerts on Cards
    • Q-A in Power BI
    • Analyze in Excel
    • File and View Options
    • Printing Dashboard and Reports
    • Row level security
    • Access Reports Dashboards using Mobile Devices
    • Report page tooltip-0
    • Report page tooltip-1
    • Filter- Page-Report-Visualization level-0
    • Filter- Page-Report-Visualization level-1

    Row Level Security in Power BI

    • PATH Function
    • PATHCONTAINS Function
    • PATHITEM Function
    • PATHITEMREVERSE Function
    • PATHLENGTH Function
    • RLS - Static Row Level Security
    • RLS - Dynamic Row Level Security
    • RLS - Organizational Hierarchy 1
    • RLS - Organizational Hierarchy 2
    • RLS - Organizational Hierarchy 3

    Sharing and Collaboration in Power BI

    • Sharing and Collaboration
    • Sharing Dashboard
    • Sharing Workspaces
    • Sharing App
    • Publish To Web

    Bonus Lectures

    • Download Materials
    • Power BI : Best Practices, Tips and Tricks 0
    • Power BI : Best Practices, Tips and Tricks 1
    • Power BI : Best Practices, Tips and Tricks 2
    • Power BI : Best Practices, Tips and Tricks 3
    • Power BI : Best Practices, Tips and Tricks 4
    • Power BI : Best Practices, Tips and Tricks 5
    • Dashboard-in-a-day : Download Material link
    • Dashboard-in-a-day : Introduction
    • Dashboard-in-a-day : Accessing Data
    • Dashboard-in-a-day : Data Preparation 0
    • Dashboard-in-a-day : Data Preparation 1
    • Dashboard-in-a-day : Data modeling and Exploration 0
    • Dashboard-in-a-day : Data modeling and Exploration 1
    • Dashboard-in-a-day : Data modeling and Exploration 2
    • Dashboard-in-a-day : Data modeling and Exploration 3
    • Dashboard-in-a-day : Data modeling and Exploration 4
    • Dashboard-in-a-day : Data Visualizations 0
    • Dashboard-in-a-day : Data Visualizations 1
    • Dashboard-in-a-day : Publishing Report
    • Dashboard-in-a-day : Creating Dashboards 0
    • Dashboard-in-a-day : Creating Dashboards 1
    • Dashboard-in-a-day : 6 ways to create Dashboards 0
    • Dashboard-in-a-day : 6 ways to create Dashboards 1

    Final Words

    • Congratulations ! You made it

    Instructors

    Mr Bill Singh
    instructor
    Freelancer

    Trending Courses

    Digital Marketing Courses Fashion Design Courses Data Science Courses Interior Design Courses Graphic Designing Courses Cyber Security Courses Nursing Courses Tally Courses Data Analysis Courses Web Designing Courses Artificial Intelligence Courses Ethical Hacking Courses Free Digital Marketing Courses And certifications Free Artificial Intelligence Courses And Certifications Free Data Analysis Courses And Certifications Free Cyber Security Courses And Certifications Free Data Science Courses And Certifications Free Cloud Computing Courses And Certifications Free Python Courses And Certifications Free Fashion And Textiles Courses And Certifications Free Graphic Designing Courses And Certifications Free Web Designing Courses And Certifications

    Popular Courses

    General Management Courses Public Health Courses Teaching and Education Courses Financial Management Courses Web Development Courses Mathematics Courses Data Science Courses Cyber Security Courses Programming Courses Digital Marketing Courses Law Courses Leadership Courses Explore all courses

    Popular Platforms

    upGrad Courses Udemy Courses Edx Courses Swayam Courses Coursera Courses Futurelearn Courses Mindmajix Technologies Courses Vskills Courses IIT Kharagpur Courses Emeritus Courses IIT Kanpur Courses NPTEL Courses Explore all platforms

    Learn more about the Courses

    10 Reasons to Enrol Yourself in a Digital Marketing Course 8 Must-Have Skills for AWS Cloud Architects Planning to Upskill Yourself? Enrol for a Program in Data Science 25+ Tips for Improving Your Graphic Design Skills Top Universities in India Offering Cyber Security Courses 15+ Courses for Learning Data Mining How to Make a Career in the Field of Artificial Intelligence Top 10 Benefits Of Holding A Certification In Business Intelligence Which are the best certification courses for Photography in India A Beginner's Guide to Pursue Python Programming Want to Pursue a Career in Blockchain Technology? Here is all that you need to Know How Entrepreneurs Can Use Machine Learning to Make their Business Successful? The Scope of Artificial Intelligence in India Top 10 Online Courses for Travel Lovers 10 Best Certification Courses After Hospital and Healthcare Management
    Providers
    Close

    Download the Careers360 App on your Android phone

    Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

    Careers360 App
    150M+ Students
    30,000+ Colleges
    500+ Exams
    1500+ E-books