
Create and customize bar charts from Excel grocery price data to visualize price variation over time with stacked bars, time frames, and color formatting.
Create a line chart in Power BI by placing date on the axis, price on values, and product on the legend, then adjust data labels and line style.
Learn to create and customize Power BI pie chart from a billing dataset, using product category as the category and order quantity as the measure, with label and color formatting.
Learn how drill down connects tables, matrices, and charts to reveal deeper data by selecting a row, column, country, or category and seeing real-time updates.
Create and use a slicer to filter visualizations by country and state with multi-select checkboxes, linking the slicer to charts for focused analysis across US and Canada.
Create a measure (calculated field) in Power BI to build gauge charts with a target line, using profit calculations and multiple chart types.
Learn to build a simple map in power with multiple map modes, using countries, states, and regions, adjust bubble sizes by order quantity, customize colors, tooltips, and map styles.
Master the Power Query replace values feature in Power BI to clean data by replacing column values, like United States of America with USA, and optimizing large spreadsheets.
Create and deploy a computer vision connected service on Azure, generate image descriptions and text in images, recognize celebrities and landmarks, and run operations with Python and the SDK.
Explore text analytics on Microsoft Azure, focusing on language detection and sentiment analysis through API scripts and sample outputs.
Explore text analytics to extract key phrases from sentences, compare sentiment analysis, and detect user intent to drive appropriate responses.
Welcome to this course on Data Science and Machine Learning with Microsoft Azure. You would learn various lessons for Data Visualization, Data Cleaning and Data Analysis using Microsoft Power BI. It is a powerful Business Intelligence software that can be used for various domains ranging from creating Analytics dashboard and Business Intelligence reports to fetching information from wide range of data sources. You could also perform various types of data cleaning operations using Power Query. Moreover, if you want to create some advanced types of Analytics charts you can write a few lines of code in python using frameworks such as Matplotlib and Seaborn. And if you want to modify the dataset either by creating derived values based on certain mathematical formula or specified conditions you could perform various Data Modelling operations as well by using creating Calculated fields and by using Power Query editor. In this course you would learn various such concepts with completely practical examples on Power BI Desktop, that can be applied in the similar way on azure cloud.
After you have learned various lessons on Power BI, you would be learning Azure Machine learning in the later sections of this course. Here you would learn to analyze an image using Computer Vision. And you would also learn to perform language detection, sentiment analysis, key phrase extraction and entity recognition using Azure Text Analytics.
Here in this course you will learn following lessons on Data Science using Microsoft Power BI-
Creating Visualization charts such as Bar chart
Pie chart
Donut or Ring chart
Treemap chart
Interactive charts and Drill down
Table and Matrix
Date and other Slicers
Creating a calculated field
Gauge chart
Map chart and modes
Scatterplot and Animation Playback
Basics of Power Query
Row deletion and Column Split
Replacing Column Values
Creating Advanced reports using Python
Installing Python packages and defining path
Creating a Line chart with matplotlib
Putting labels and creating dashed scatterplot
Moreover you would also learn about Azure Machine Learning with lessons on-
Computer Vision- Create Service
Computer Vision- Analyze image , text in image and generate thumbnail
Text Analytics- Create Service
Text Analytics- Language Detection
Text Analytics- Sentiment Analysis
Text Analytics- Key Phrase Extraction
Text Analytics- Entity Recognition