Скачать с ютуб Data Analysis End to End | Project Analytics | Beginner Friendly в хорошем качестве

Data Analysis End to End | Project Analytics | Beginner Friendly

End-to-End Data Analysis Project from start to finish using Excel, SQL Server, and Power BI, we’ll build a Product Analytics Dashboard that tracks revenue, profits, and trends. You’ll learn how to break down management request, build a database, write SQL queries, and create executive level dashboard. Whether you’re just starting out or want to sharpen your skills, this is a great way to dive into real-world data analysis. What is Covered in the Analysis 1. Build a Database 2. Develop SQL 2. Connect to Power BI 3. Create a Dashboard ***To create a Date table**** 1. Click Modeling in the top ribbon 2. Choose New Table 3. Add this to you DAX formula: Calendar = CALENDAR("1/1/2022","12/31/2023") Timestamps ----------------------------------------------------------------------------------------- 0:45 Management Request 1:54 Company Overview 2:15 Dashboard Preview 3:36 Installing SQL Server and SQL Server Studio 7:25 Building your Database 14:20 Exploring the Database Tables 17:35 Developing SQL Queries 28:51 Connecting Database to Power BI 31:30 Building the Dashboard Structure 36:08 Image Slicer 38:46 Animated Image 44:28 Bar Charts (Revenue by Country and Over Time) 52:40 Pie Charts 54:47 Add Column and Profit Calculation 1:00:03 Year on Year Calculation ( see table calculation above) 1:04:17 Visual Card 1:15:08 Toolttip Page Creation 1:24:29 Cleaning up the Dashboard You can get the zip files here on Github: https://github.com/Gaelim/youtube/blo... You can get the dataset files: https://absentdata.com/data-analysis/... See other End-to-End Projects here:    • Data Analyst End-to-End Projects   Try Stratascratch to practice SQL interview question from top companies https://stratascratch.com/?via=absent... Learn SQL at LearnSQL.com with great course for Data Analyst https://learnsql.com/?ref=nmm1zdj