Power BI: Basic to Advanced
-
Say Hello to Power BI Desktop
-
Connecting to and Preparing DataIntroduction To Data Connectors5m 24sLoading In A CSV File5m 48sThe Power Query Interface8m 41sRenaming Fields And Data Types6m 37sEDA Column Quality10mEDA Column Profile And Distribution5m 31sDropping Preserving Rows And Columns7m 57sSplit Columns7m 38sFormat Tool7m 55sMerge Columns5m 2sTransform Vs Add Column2m 49sExtract Tool5m 27sConditional Columns5m 10sDuplicating Columns And Adding Indexes3m 21sDate Tool9m 2sNumerical Tools8m 40sStatistics And Count Rows4m 8sAppend Queries7m 25sGroup By8m 1sData Source Settings3m 13sImportant Connecting To A Folder5m 54sBringing It All Together3m 41sEnabledisable Load3m 46s
-
Data ModelingWhat Is Normalization7m 53sPrimary Keys4m 44sForeign Keys5m 29sFact And Dimension Tables6m 35sStar Schema4m 49sWhats A Join14m 5sSnowflake Schema3m 37sMerge Queries8m 24sCardinality10m 43sConfiguring Our Data Model7m 42sConfiguring Our Data Model Contd9m 15sA Simple Enhancement To Our Data Model4m 41s
-
Visualizing Data Creating DashboardsImportant Settings1m 41sCreating A Matrix13m 23sCreating A Bar Chart8m 39sCreating Stacked Clustered Bar Charts5m 48sCreating A Line Chart18m 30sCreating Area Charts2m 16sTrick Formatting2m 26sLine And Stacked Column Chart5m 53sAdding Cards6m 36sAdding More Cards4m 28sPie Chart5m 48sDonut Chart4m 9sConditional Formatting A Matrix8m 56sFunnel Chart5m 22sTreemap5m 52sGauge Chart8m 37sKPIs10m 18sFiltering10m 11sSlicers5m 12sMap Visuals8m 17s
-
Assignments
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 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 Power BI
Because every module of this course is independent, you can start in whatever section you wish, and you can do as much or as little as you like.
Each section provides a new data set and 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.
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, 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.
brilliantbitslearning.com
Founder
4.5Instructor Rating123
Students17
Courses124
ReviewsWe are dedicated to provide the best quality yet affordable courses to the students.