15 days of Power BI Complete Microsoft Power BI Bootcamp
What you’ll learn
Learn Power BI from scratch
Build Reports
Use DAX
Create Visualizations
Clean Data with PowerQuery
Connect to data sources
Requirements
Windows PC. You can’t natively install Power BI on Mac or Linux.
The course is designed to take people from beginner to pro in just 15 days. We start from the basics and have a step-by-step guided approach stretched over 15 days
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 Accordingly Connect Power BI to a Variety of Datasets Drill Down and Up in Your Visualization and Calculate Data Visualize Data in the Form of Various Charts, Plots, and Maps Convert Raw Data Into Compelling Data Visualizations Using Microsoft Power BI Each 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 Overview This 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: Day 1 – Beginner – Understanding the Basics
Lecture 1 Motivation & About this course
Lecture 2 Tips to get the most out of the course
Lecture 3 Goals Day 1
Lecture 4 Understanding Power BI
Lecture 5 Download & Install
Lecture 6 Quick note on the next lecture
Lecture 7 Get excited – Challenge!
Lecture 8 The 3 Views in Power BI
Lecture 9 Important: Initial Settings
Lecture 10 Our project & getting data
Lecture 11 Query Editor – Basic data cleaning
Lecture 12 Working with the attached project files
Lecture 13 Edit rows & columns
Lecture 14 Data Types
Lecture 15 Replacing values
Lecture 16 Summary of today
Section 2: Day 2 – Beginner – Data Prep & Data Model Fundamentals
Lecture 17 Goals Day 2
Lecture 18 Exctracting values
Lecture 19 Split columns
Lecture 20 Text operations
Lecture 21 Numerical operations
Lecture 22 Creating relationships (data model)
Lecture 23 Practice: Data Cleaning & Relationship
Lecture 24 Solution: Data Cleaning & Relationship
Lecture 25 Solution: Data Cleaning & Relationship
Lecture 26 Stacked column chart
Lecture 27 The Format tab
Lecture 28 Pie Chart – Guidelines
Lecture 29 Pie chart
Section 3: Day 3 – Intermediate – Data Prep & Visualization
Lecture 30 Goals Day 3
Lecture 31 Append Queries
Lecture 32 Merge & Group
Lecture 33 Dates & Hierarchies
Lecture 34 Line Chart
Lecture 35 Files from folder
Lecture 36 Fact-Dimension model
Lecture 37 Edit relationships & cardinality
Lecture 38 Activate & deactivate relationships
Lecture 39 Manage & autodetect relationships
Section 4: Day 4 – Intermediate – Data Transformations
Lecture 40 Goals Day 4
Lecture 41 Tables
Lecture 42 Customizing tables
Lecture 43 Conditional formatting
Lecture 44 Merging Queries
Lecture 45 Unpivot & Pivot
Lecture 46 Many-to-Many Relationship
Lecture 47 Filter Visual
Lecture 48 Edit page
Section 5: Day 5 – Intermediate – Interactive Visualizations
Lecture 49 Goals Day 5
Lecture 50 Filters Pane
Lecture 51 TopN Filter
Lecture 52 Sync Slicers
Lecture 53 Treemap Visuals
Lecture 54 Edit interactions
Lecture 55 Drillthroughs
Lecture 56 Keep filters with drillthroughs
Lecture 57 Tooltips
Lecture 58 Custom column
Lecture 59 Enable & Disable Load
Lecture 60 References vs. Duplicates
Lecture 61 Columns from example
Section 6: Day 6 – Advanced – Visualization
Lecture 62 Goals Day 6
Lecture 63 Visual Header & Sorting
Lecture 64 Conditional column
Lecture 65 Maps
Lecture 66 Filled Maps
Lecture 67 Forecasts
Lecture 68 Drillthrough with Button
Lecture 69 Bookmarks
Lecture 70 Challenge: Top Products
Lecture 71 Cards
Lecture 72 Multi-Row Cards
Section 7: Day 7 – Advanced – Templates, R scripts, Tooltips
Lecture 73 Goals Day 7
Lecture 74 Tooltips Page
Lecture 75 Working with templates
Lecture 76 Visualizing using R scripts
Lecture 77 R script for the next lecture
Lecture 78 Libraries & Get data using R
Lecture 79 Working with R to transform data
Lecture 80 Working with parameters
Section 8: Day 8 – Pro – Parameters & Functions
Lecture 81 Goals Day 8
Lecture 82 Parameters with lists & queries
Lecture 83 Get data from a web page
Lecture 84 Use parameters with web page
Lecture 85 Challenge (Solution)
Lecture 86 Invoking a custom function
Section 9: Day 9 – DAX – The Essentials
Lecture 87 Goals Day 9
Lecture 88 Understanding Calculated Columns
Lecture 89 Understanding Measures
Lecture 90 AVERAGE
Lecture 91 COUNT, DISTINCTCOUNT, COUNTROWS
Lecture 92 SUMX
Lecture 93 AVERAGEX & ROUND
Lecture 94 RELATED & Data Model
Lecture 95 CALCULATE
Lecture 96 Filter problems
Lecture 97 FILTER
Lecture 98 Logical operators
Lecture 99 Formatting & Commenting
Lecture 100 DAX Challenges
Lecture 101 Solutions
Section 10: Day 10 – DAX – Advanced
Lecture 102 Goals Day 10
Lecture 103 ALL
Lecture 104 ALL on columns
Lecture 105 ALLEXCEPT
Lecture 106 ALLSELECTED
Lecture 107 DATEADD
Lecture 108 Year-to-Date & Month-to-Date
Lecture 109 ROUNDING functions
Lecture 110 FORMAT
Lecture 111 Complete Date Table with features
Lecture 112 DAX Challenges
Lecture 113 DAX Solutions
Section 11: Day 11 – Publishing Reports & Power BI Service (Intermediate)
Lecture 114 Goals Day 11
Lecture 115 How to go on from here?
Lecture 116 Power BI Pro vs Free vs Premium
Lecture 117 Sign up for free
Lecture 118 Alternative method without work mail
Lecture 119 Quick Interface Tour
Lecture 120 My workspace
Lecture 121 Publishing reports
Lecture 122 Editing reports
Lecture 123 Updating reports with Power BI Desktop
Lecture 124 Creating & Exploring Workspaces
Section 12: Day 12- Scheduling, Data Gateway & Mobile App (Advanced)
Lecture 125 Goals Day 12
Lecture 126 Installing & using a Data Gateway
Lecture 127 Scheduled refresh
Lecture 128 Creating apps
Lecture 129 Creating Dashboards
Lecture 130 Get Quick Insights
Lecture 131 Using Mobile App
Lecture 132 Creating Mobile Layout
Section 13: Day 13 – Row-Level & Page-Level Security (Pro)
Lecture 133 Goals for Day 13
Lecture 134 Basic Row-Level Security
Lecture 135 Row-Level Security in the cloud
Lecture 136 Data Model & Row-Level Security
Lecture 137 Dynamic RLS
Lecture 138 Many-to-Many RLS
Lecture 139 Page-Level Security
Section 14: Day 14 – Python, Machine Learning & SQL (Pro)
Lecture 140 Goals for Day 14
Lecture 141 Plan of action
Lecture 142 Setting up Python for Power BI
Lecture 143 Transforming data using Python
Lecture 144 Python script I used in the next lecture
Lecture 145 Creating visualizations using Python
Lecture 146 Python script II used in the next lecture
Lecture 147 Violin plots, pair plots & ridge plots using Python
Lecture 148 Python script III used in the next lecture
Lecture 149 Machine learning (BayesTextAnalyzer) using Python
Lecture 150 Performance & Troubleshooting
Lecture 151 Loading data from web in JSON
Lecture 152 Setting up a MySQL database
Lecture 153 Loading data from SQL database
Section 15: Day 15 – M language Fundamentals (Pro)
Lecture 154 Goals for Day 15
Lecture 155 What is the M language?
Lecture 156 Basics about the advanced editor
Lecture 157 Values & Lists
Lecture 158 Table functions & transforming columns
Lecture 159 Quick Challenge 1
Lecture 160 Each & Table.AddColumns
Lecture 161 Quick Challenge 2
Lecture 162 More functions & Next steps
Section 16: Congratulations
Lecture 163 You made it!
Lecture 164 Bonus lecture
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
Course Information:
Udemy | English | 16h 47m | 6.58 GB
Created by: Nikolai Schuler
You Can See More Courses in the Business >> Greetings from CourseDown.com