Download and Learn Data Analysis and Visualization with Microsoft Power BI Udacity Nanodegree Course 2023 for free with google drive download link.
Meet the growing demand for data analysis and visualization professionals by gaining the Power BI skills that top companies want.
What You’ll Learn in Data Analysis and Visualization with Microsoft Power BI Nanodegree
Data Analysis and Visualization with Microsoft Power BI
Estimated 3 months to complete
You’ll master the in-demand skills necessary to become a successful data analyst like data pre-processing, visualization and analysis using Microsoft Power BI as the primary tool.
Data Analysis and Visualization with Microsoft Power BI Intro Video:
A well-prepared learner is already able to:
- Use Microsoft Excel to organize and analyze data, including the use of basic functions (SUM, DIVIDE, AVERAGE, etc.) and creating basic formulae (a + b = c, for example)
- Create a table in Microsoft Excel, including filtering using column headers
- (Optional but beneficial) Create and use basic pivot tables in Microsoft Excel for data analysis
Introduction to Preparing and Modeling Data
Where do you even start when the data you need for a single report lives in a bunch of different files and software systems? This is where preparing and modeling data becomes essential! This course is a crucial step in Power BI for anyone who needs to mash together multiple data sources, clean them, restructure them, and harmonize them into a single and efficient data model to support reporting. We’ll cover Power BI’s built-in Extract-Transform-Load (ETL) tool, Power Query, learn foundational data modeling principles, cover some introductory DAX (Data Analytics Expressions), and touch on troubleshooting and optimization.
Project – Build a Data Model for Seven Sages Brewing Company
Your mission is to tame the datasets and create an efficient data model for a small brewing company that will help them better understand what products are popular — and profitable — so they can mark smart decisions about what products to prioritize as the company continues to grow. Students will demonstrate an understanding of core data modeling principles, including the ability to clean, organize and structure data in Power Query, to make a date table, to build a data model with the appropriate relationships and filters, and to create a simple report using common visualizations and DAX measures.
Creating Visualizations with Power BI
In this course, students will learn how to carry Power BI beyond mere bar charts and transform their reports into data exploration & storytelling tools that companies can use to better understand their data. Students will start by learning about a variety of common and more advanced data visualizations. Then, students will learn how to design reports around these data visuals in order to focus user attention on key insights, help users navigate different features and report pages and enable accessibility options for diverse audiences. Next, the student will learn how to use filters and slicers. Finally, students will deliver a couple of advanced features capable of elevating how users navigate and engage with visuals and the report itself.
Project – Building a Power BI report for Waggle
Waggle is a hot new start-up that produces smart devices for pets. Their leading product, the Lapdog collar, has been so successful, that the company is considering releasing a similar product for cats called Lapcat and has been testing hundreds of prototypes in the field for the past several months. Now, the data from those tests has been compiled and Waggle leadership has requested a Power BI report that summarizes key insights comparing Lapcat and Lapdog devices that can be presented to the CEO. By the end of the project, students will have designed a detailed Power BI report with many data visuals that tell the story of how the new Lapcat devices compared to Lapdog collars.
Advanced Data Analysis
In this course, students will focus on the techniques and skills needed for data analysis in Power BI. The course is centered around building a strong foundation and intuition of analytics so that students can take their skills beyond simply aggregating data in Power BI and into the realm of statistics, forecasting and strategy. We first start with an introduction to data analysis looking at different terms and techniques such as descriptive and inferential statistics, histograms, linear regression and an introduction to the concepts of correlation and probability. After taking the introductory lessons on data analytics, the course then moves to M, the language of Power Query, and learning to build custom formulas as part of the data transformation process. The overarching goal of the course is to help students become effective at the process of retrieving, analyzing and visualizing data in order to answer questions and draw conclusions.
Project – Market Analysis Report for National Clothing Chain
An online national clothing chain needs your help creating a targeted marketing campaign. Sales have been flat and they want to lure lost customers back. In this project, you will use population statistics from the US Census Bureau to determine where the greatest income exists around the country and whether there is a correlation between sales and income. Through this project, you will demonstrate the ability to use custom M code to import, clean, format, and organize data in Power Query and use custom DAX code to analyze data in Power BI. You will also conduct statistical analysis to understand relationships and probabilities of the data sources, including linear regression, histogram, and standard deviation, and create advanced visualizations to present conclusions and recommendations that are driven by the statistical analysis.
According to ZipRecruiter, the average annual pay for a Power BI data analyst in the United States is $94,627 a year.
Data Analysis and Visualization with Microsoft Power BI Nanodegree Free Download Link: