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 Modelling in the top ribbon 2. Choose New Table 3. Add this to your DAX formula: Calendar = CALENDAR("1/1/2022","12/31/2023") 4. There tables should connect automatically. If not, just go to modelling and build the relationship by connecting the two tables by date. 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:31 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/blob/master/Data%20Analysis%20Project%20November%202024%20-%20Copy.zip You can get the dataset files: https://absentdata.com/data-analysis/end-to-end-data-analysis-project/ See other End-to-End Projects here: https://www.youtube.com/playlist?list=PLi5spBcf0UMXfbMt1X2bHQkk7mHXkTUhs Try Stratascratch to practice SQL interview question from top companies https://stratascratch.com/?via=absentdata Learn SQL at LearnSQL.com with great course for Data Analyst https://learnsql.com/?ref=nmm1zdj