Power Bi Bootcamp ( Zero To Hero) - Just 5 Hours

Power BI Bootcamp ( Zero to Hero) - Just 5 Hours

What you'll learn

Understand all the concepts of Power BI ( Scratch to advanced )

Skyrocket your data analysis in Just 5 hours

Confident & Proficient in building any Power BI reports and dashboards

Confident to tackle any scenario based project and build an interactive dashboard as per the client's requirement

Build interactive, intuitive & effective Power BI reports and dashboards confidently

Become a "Power BI Pro" and a "Data Rockstar"

Requirements

No prior experience required

Willingness to learn irrespective of your tech background

Description

Learn data visualization through Microsoft Power BI and create opportunities for you or key decision-makers to discover data patterns such as customer purchase behavior, sales trends, or production bottlenecks.You'll learn all of the features in Power BI that allow you to explore, experiment with, fix, prepare, and present data easily, quickly, and beautifully.Use Microsoft Power BI to Analyze and Visualize Data So You Can Respond AccordinglyConnect Power BI to a Variety of DatasetsDrill Down and Up in Your Visualization and Calculate DataVisualize Data in the Form of Various Charts, Plots, and MapsConvert Raw Data Into Compelling Data Visualizations Using Microsoft Power BIEach section provides exercises that will challenge you so you can learn by immediately applying what you're learning.Content is updated as new versions of Power BI are released. You can always return to the course to further hone your skills, while you stay ahead of the competition.Contents and OverviewThis course begins with Power BI basics. You will navigate the software, connect it to a data file, and export a worksheet, so even beginners will feel completely at ease.To be able to find trends in your data and make accurate forecasts, you'll learn how to work with hierarchies and time series.Also, to make data easier to digest, you'll tackle how to use aggregations to summarize information. You will also use granularity to ensure accurate calculations.In order to begin visualizing data, you'll cover how to create various charts, maps, scatterplots, and interactive dashboards for each of your projects.You'll even learn how to join multiple data sources into one in order to combine diverse sources of information in one analytical solution.Finally, you'll cover some of the latest and most advanced custom visualizations in Microsoft Power BI, where you will create histograms, brick charts, and more.By the time you complete this course, you'll be a highly proficient Power BI user. You will be using your skills as a data scientist to extract knowledge from data so you can analyze and visualize complex questions with ease.You'll be fully prepared to collect, examine, and present data for any purpose, whether you're working with scientific data or you want to make forecasts about buying trends to increase profits.

Overview

Section 1: GETTING STARTED !

Lecture 1 INTRODUCTION-UNDERSTANDING POWER BI

Lecture 2 INSTALLATION OF POWER BI DESKTOP

Lecture 3 UNDERSTANDING THE INTERFACE - POWER BI DESKTOP

Lecture 4 GETTING STARTED WITH POWER BI WITH A SHIPPING DETAILS DATASET

Lecture 5 RESOURCES

Section 2: DATA UNDERSTANDING & DATA TRANSFORMATION TECHNIQUES

Lecture 6 Congratulations & Welcome - Getting Started

Lecture 7 Manage Columns - ( Choose Columns & Go To Columns )

Lecture 8 Manage Columns - ( Remove Columns )

Lecture 9 Replaces Column Values & its purpose

Lecture 10 Keep Rows & Remove Rows | Sorting Columns

Lecture 11 Transpose Ribbon - More Data Shaping Functionalities

Lecture 12 Transpose Ribbon - Group By Functionality

Lecture 13 Transpose Ribbon - Formatting Functionality

Lecture 14 Split Columns & Merge Columns

Lecture 15 Enter Data Functionality & Quick Review on Transpose Data

Section 3: VISUALIZATIONS - ( FINANCE DATA ) & STANDARD DATE TABLE CREATION

Lecture 16 Welcome To Visualizations ( 3 Important principles )

Lecture 17 Standard Date Table Creation ( 2 Methods)

Lecture 18 Clustered Column Chart & Clustered Bar Chart

Lecture 19 Pie Chart, Donut Chart & Treemap

Lecture 20 KPI Visuals - ( Card, Multi Row Card, Gauge & KPI )

Lecture 21 Types of maps ( Regular map & Filled Map)

Lecture 22 Trends ( Slicers, Line chart, Area Chart & Stacked Area Chart)

Lecture 23 ( Stacked Bar & Column Chart | 100 % Stacked bar & Column Chart )

Lecture 24 Line & Stacked | Line & Clustered Charts

Lecture 25 Funnel Chart / Ribbon Chart / Waterfall Chart

Section 4: REAL TIME SCENARIO - DATA MODELING

Lecture 26 Requirements for Report Development

Lecture 27 Data Collection & Data Understanding

Lecture 28 Understanding Of Dimension table & Fact table

Lecture 29 Types of cardinality

Lecture 30 Creating a data Model ( Star schema )

Section 5: DAX Functions ( Aggregators, Iterators, Time Intelligence and Other )

Lecture 31 Filter Context & Row Context

Lecture 32 Aggregator Functions - SUM()

Lecture 33 Aggregator Functions - COUNT() & COUNTA()

Lecture 34 Aggregator Functions - AVERAGE()

Lecture 35 Aggregator Functions - DISTINCTCOUNT()

Lecture 36 Aggregator Functions - MIN () & MAX()

Lecture 37 Access Specifier - CALCULATE()

Lecture 38 Iterator Functions - SUMX() & RELATED()

Lecture 39 Iterator Functions - COUNTAX()

Lecture 40 Iterator Functions - AVERAGEX()

Lecture 41 Iterator Functions - COUNTROWS()

Lecture 42 Iterator Functions - MINX() & MAXX()

Lecture 43 FILTER() Function

Lecture 44 ALL() Function & its Purpose | DIVIDE() Function

Lecture 45 Year To date ( YTD Functions) - TOTALYTD() and DATESYTD()

Lecture 46 Quarter To Date ( QTD Functions) - TOTALQTD() and DATESQTD()

Lecture 47 Month To Date ( MTD Functions) - DATESMTD and TOTALMTD()

Lecture 48 DATEADD() Function

Lecture 49 SAMEPERIODLASTYEAR() Function

Section 6: Creating a Report ( Design , Visualizations , bookmarks & Selection Pane)

Lecture 50 Report Visualization creation (End to End)

Beginners, Users with other tech background, aspiring data analyst & anyone who are willing to learn !!!,Anyone that has never used Power BI before and is looking for a hands-on approach to learn it Anyone working with data and get professional working with Power BI Anyone that wants to pursue a career as a data analyst, data scientist or BI consultant